I have SQL Server 2000 SP3 server running on W2003 SP1 Std that is setup to
run under a domain account with local admin privileges. The server and user
account are in the same domain.
When I then try to register the SQL Server instance via SQLEM, running with
my privileges and I also have local admin to the SQL Server server and have
the same setup for other servers already in place, I get an error saying
"Cannot generate SSPI context"
Does anyone have any ideas on how I can correct this?
Cheers,
JohnTake a look into the article.
http://support.microsoft.com/defaul...kb;en-us;811889
Thanks
Hari
SQL Server MVP
"John" <John@.discussions.microsoft.com> wrote in message
news:BAB33841-7C8F-4873-85A4-AA4D727C8DE9@.microsoft.com...
>I have SQL Server 2000 SP3 server running on W2003 SP1 Std that is setup to
> run under a domain account with local admin privileges. The server and
> user
> account are in the same domain.
> When I then try to register the SQL Server instance via SQLEM, running
> with
> my privileges and I also have local admin to the SQL Server server and
> have
> the same setup for other servers already in place, I get an error saying
> "Cannot generate SSPI context"
> Does anyone have any ideas on how I can correct this?
> Cheers,
> John|||I went through this document and the only new thing in it for me was the SPN
creation. However, I have never needed to do this in the past so I am not
convinced this is the problem. I am also reluctant to start making that sor
t
of change when it has not been necessary in the past and start deviating fro
m
our standard install process.
Do you have any other suggestions?
"Hari Prasad" wrote:
> Take a look into the article.
> http://support.microsoft.com/defaul...kb;en-us;811889
> Thanks
> Hari
> SQL Server MVP
> "John" <John@.discussions.microsoft.com> wrote in message
> news:BAB33841-7C8F-4873-85A4-AA4D727C8DE9@.microsoft.com...
>
>|||Can you please try to register using a SQL Server Login.If it fails try to
change the SQL Server service account to
Local system and then stop and start the service and try registering.
Thanks
Hari
SQL Server MVP
"John" <John@.discussions.microsoft.com> wrote in message
news:C5C0A894-3142-434D-A1A8-51E2A6064C57@.microsoft.com...[vbcol=seagreen]
>I went through this document and the only new thing in it for me was the
>SPN
> creation. However, I have never needed to do this in the past so I am not
> convinced this is the problem. I am also reluctant to start making that
> sort
> of change when it has not been necessary in the past and start deviating
> from
> our standard install process.
> Do you have any other suggestions?
> "Hari Prasad" wrote:
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment