|
|
Posted by Erland Sommarskog on 08/31/06 21:43
(goyal.mayank@gmail.com) writes:
> For hardware upgratdation we have to move our database server(MSSQL
> 2000) from a P3(Window 2003) machine to a p4(Windows 2003) machine. We
> have replicated the data from P3 machine to P4 machine.
>
> the replication was success full.
>
> After this we have changed the name of the p4 machine to tha of p3
> machine.
>
> now when we try to connect to the new p4 machine using the windows
> authentication we are not getting errror "Cannot generate SSPI
> Context."
You are not getting error? Or should that "not" not be there?
> for solving it we have tried to change the name of the sqlserver.
Your posting is a bit unclear, but to comlete an operation as the one
you described, you need to do
EXEC sp_dropserver P4
EXEC sp_addserver P3, 'local'
and then restart SQL Server. Once you are done, verify that @@servername
has the correct value.
--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
Navigation:
[Reply to this message]
|