Posted by goyal.mayank on 08/31/06 15:41

Hi All,

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."

for solving it we have tried to change the name of the sqlserver.
REF:
http://groups.google.co.in/group/microsoft.public.sqlserver.server/browse_frm/thread/4da11a3c80dde041/90b0966be28f835e?lnk=st&q=SuperSocket+info%3A+(SpnRegister)+%3A+Error+1355.&rnum=10#90b0966be28f835e

while replication the database we have made the mssql service run under
a network account.
this could be a possible reason for not able to register with the ADS.
Later we have changed it to run under the local user account.

Any help will be highly appreciated.

Mayank

[Back to original message]