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/mic...b0966be28f835e
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