Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 New SQL Server Registration

Author  Topic 

tad
Starting Member

31 Posts

Posted - 2002-05-23 : 11:17:50
I get "cannot generate sspi context" when creating a "New
SQL Server Registration" on a SQL Server 2000 instance.

Note: there are three instances and I can connect to the
other two? The services for the instances were set to
start with a particular account and if I change the
problem instance startup account to the system account,
all is well.

I need to start all instances with a domain user, so that
I can set up SQL Mail, Query Analyzer Debugging, etc.

Thanks for your help.



chadmat
The Chadinator

1974 Posts

Posted - 2002-05-23 : 23:50:30
Are these instances local or remote? Are you connected to the network?

Make sure the Service account has:
act as part of OS

logon as a service

increase quotas

replace a process level token


-Chad

Go to Top of Page

tad
Starting Member

31 Posts

Posted - 2002-05-24 : 09:16:53
I'm on a workstation connect to a lan. There is a single SQL Server with three instances. All instances service were started with the same domain user.


Go to Top of Page
   

- Advertisement -