Showing posts with label standard. Show all posts
Showing posts with label standard. Show all posts

Monday, March 26, 2012

Problem with Install of MSSQL 2005 Standard x64 on two node cluster

Hi:
I'm trying to install MS SQL 2005 Standard x64 to a two node Windows Server
2003 R2 SP2 cluster.
I've setup the cluster as per MS requirements and tested failover, The
cluster seems to be working well.
When I go through the Install and select failover clustering for the
Database and Analysis services, all seems to go well until it gets to the
end, I get a failure on the second (passive) node.
On the passive node I find that there is a Task Scheduler job set, SQL
Server Remote Setup.job that is reporting this error:
"SQL Server Remote Setup .job" (setup.exe) 12/4/2007 12:40:14 PM ** ERROR
**
Unable to start task.
The specific error is:
0x80070005: Access is denied.
Try using the Task page Browse button to locate the application.
The only MS info, I've found is not to be in RDP on the second node. I've
tried that and even did an install from the console on the first node (No
Remote Desktop sessions at all). Same error.
I've made sure that the account used is part of the local administrators
group on both nodes and has the following rights:
Act as part of operating system
Logon as a batch job
Logon as a Service
I have been going around on this for several days and cannot come to a
solution.
Is it that the second node doesn't have access to the setup files? I tried
installing from the DVD on the primary node and copied the files to a
directory on the primary and shared it. Same error.
Thanks
Usually, the last thing you tried, moving the setup files, fixes this type
of issue.
Have you tried running the cluster install but only for the first node, then
adding the node via add/remove programs? I sometimes find mirroring the
regular cluster setup logic (build a single-node cluster and add on) helps.
Geoff N. Hiten
Senior SQL Infrastructure Consultant
Microsoft SQL Server MVP
"Paul Hons" <Paul.Hons@.unt.edu> wrote in message
news:4755520A.B695.00E7.0@.unt.edu...
> Hi:
> I'm trying to install MS SQL 2005 Standard x64 to a two node Windows
> Server
> 2003 R2 SP2 cluster.
> I've setup the cluster as per MS requirements and tested failover, The
> cluster seems to be working well.
> When I go through the Install and select failover clustering for the
> Database and Analysis services, all seems to go well until it gets to the
> end, I get a failure on the second (passive) node.
> On the passive node I find that there is a Task Scheduler job set, SQL
> Server Remote Setup.job that is reporting this error:
> "SQL Server Remote Setup .job" (setup.exe) 12/4/2007 12:40:14 PM ** ERROR
> **
> Unable to start task.
> The specific error is:
> 0x80070005: Access is denied.
> Try using the Task page Browse button to locate the application.
> The only MS info, I've found is not to be in RDP on the second node. I've
> tried that and even did an install from the console on the first node (No
> Remote Desktop sessions at all). Same error.
> I've made sure that the account used is part of the local administrators
> group on both nodes and has the following rights:
> Act as part of operating system
> Logon as a batch job
> Logon as a Service
> I have been going around on this for several days and cannot come to a
> solution.
> Is it that the second node doesn't have access to the setup files? I tried
> installing from the DVD on the primary node and copied the files to a
> directory on the primary and shared it. Same error.
> Thanks
>
>
|||Geoff N. Hiten wrote:
> Usually, the last thing you tried, moving the setup files, fixes this
> type of issue.
> Have you tried running the cluster install but only for the first
> node, then adding the node via add/remove programs? I sometimes find
> mirroring the regular cluster setup logic (build a single-node cluster
> and add on) helps.
>
One other thing to try - which I had to do to get around this issue.
Have you logged into both systems with the service account that you will
be using to run SQL Server? If not, make sure you log into both
machines with that account to create the user profile. For whatever
reason - without the user profile the task scheduler jobs cannot be started.
At least that is what worked for me.
BTW - before you restart your install make sure you uninstall the setup
files or you will get another error.
Jeff

Monday, March 12, 2012

Problem with extended procedure

Hi all,
i have MS SQL Server 2000 Standard with my own extended procedure. I run
extended procedurec, and this procedure make sepparate session and run stored
procedure (asynchronous). But the extended procedure failed with error:
Server user 'domain\xxx' is not a valid user in database 'db'.
Database 'db' was restore from backup from another server, but user's SID is
the same as login, there is no orphanes , or somethink like that. (to be on
the safe said)I drop the user and the login and create new login and user .
But no change.
User domain\xxx is the local admin, and MS SQL Server and ServerAgent start
with this account.
Any suggestion?
Thanks Honza
Run the query below to verify the login is a sysadmin role member. Also,
verify that you are connecting to the correct SQL Server instance from your
extended proc. A Profiler trace may help.
SELECT IS_SRVROLEMEMBER ('sysadmin' , 'domain\xxx')
Hope this helps.
Dan Guzman
SQL Server MVP
"Jan Schustr" <Jan Schustr@.discussions.microsoft.com> wrote in message
news:10A5175F-50C8-4C0E-B503-47CD5B08D4C5@.microsoft.com...
> Hi all,
> i have MS SQL Server 2000 Standard with my own extended procedure. I run
> extended procedurec, and this procedure make sepparate session and run
> stored
> procedure (asynchronous). But the extended procedure failed with error:
> Server user 'domain\xxx' is not a valid user in database 'db'.
> Database 'db' was restore from backup from another server, but user's SID
> is
> the same as login, there is no orphanes , or somethink like that. (to be
> on
> the safe said)I drop the user and the login and create new login and user
> .
> But no change.
> User domain\xxx is the local admin, and MS SQL Server and ServerAgent
> start
> with this account.
> Any suggestion?
> Thanks Honza

Problem with extended procedure

Hi all,
i have MS SQL Server 2000 Standard with my own extended procedure. I run
extended procedurec, and this procedure make sepparate session and run stored
procedure (asynchronous). But the extended procedure failed with error:
Server user 'domain\xxx' is not a valid user in database 'db'.
Database 'db' was restore from backup from another server, but user's SID is
the same as login, there is no orphanes , or somethink like that. (to be on
the safe said)I drop the user and the login and create new login and user .
But no change.
User domain\xxx is the local admin, and MS SQL Server and ServerAgent start
with this account.
Any suggestion?
Thanks HonzaRun the query below to verify the login is a sysadmin role member. Also,
verify that you are connecting to the correct SQL Server instance from your
extended proc. A Profiler trace may help.
SELECT IS_SRVROLEMEMBER ('sysadmin' , 'domain\xxx')
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Jan Schustr" <Jan Schustr@.discussions.microsoft.com> wrote in message
news:10A5175F-50C8-4C0E-B503-47CD5B08D4C5@.microsoft.com...
> Hi all,
> i have MS SQL Server 2000 Standard with my own extended procedure. I run
> extended procedurec, and this procedure make sepparate session and run
> stored
> procedure (asynchronous). But the extended procedure failed with error:
> Server user 'domain\xxx' is not a valid user in database 'db'.
> Database 'db' was restore from backup from another server, but user's SID
> is
> the same as login, there is no orphanes , or somethink like that. (to be
> on
> the safe said)I drop the user and the login and create new login and user
> .
> But no change.
> User domain\xxx is the local admin, and MS SQL Server and ServerAgent
> start
> with this account.
> Any suggestion?
> Thanks Honza

Problem with extended procedure

Hi all,
i have MS SQL Server 2000 Standard with my own extended procedure. I run
extended procedurec, and this procedure make sepparate session and run store
d
procedure (asynchronous). But the extended procedure failed with error:
Server user 'domain\xxx' is not a valid user in database 'db'.
Database 'db' was restore from backup from another server, but user's SID is
the same as login, there is no orphanes , or somethink like that. (to be on
the safe said)I drop the user and the login and create new login and user .
But no change.
User domain\xxx is the local admin, and MS SQL Server and ServerAgent start
with this account.
Any suggestion?
Thanks HonzaRun the query below to verify the login is a sysadmin role member. Also,
verify that you are connecting to the correct SQL Server instance from your
extended proc. A Profiler trace may help.
SELECT IS_SRVROLEMEMBER ('sysadmin' , 'domain\xxx')
Hope this helps.
Dan Guzman
SQL Server MVP
"Jan Schustr" <Jan Schustr@.discussions.microsoft.com> wrote in message
news:10A5175F-50C8-4C0E-B503-47CD5B08D4C5@.microsoft.com...
> Hi all,
> i have MS SQL Server 2000 Standard with my own extended procedure. I run
> extended procedurec, and this procedure make sepparate session and run
> stored
> procedure (asynchronous). But the extended procedure failed with error:
> Server user 'domain\xxx' is not a valid user in database 'db'.
> Database 'db' was restore from backup from another server, but user's SID
> is
> the same as login, there is no orphanes , or somethink like that. (to be
> on
> the safe said)I drop the user and the login and create new login and user
> .
> But no change.
> User domain\xxx is the local admin, and MS SQL Server and ServerAgent
> start
> with this account.
> Any suggestion?
> Thanks Honza

Friday, March 9, 2012

problem with enterprise manager

I have a problem with SQL Server 7 Standard edition, when i select a database in Enterprise Manager and i want to see the content of tables, i can't see anything: I can see all tables but when i choice "Open Table " and "Return all rows", i see only the menu bar on the top, and all page is blank. :confused:
This problem is on all database, and on all tables, include the system database (as Master).
If i use query analyzer i can work without probems.

Thank in advance

FrancescoSounds like you need to do a reinstal of the client tools.

Why not so a trace for the crack using sqltrace(profiler)?

something is busted though.