SQL Server Performance Forum – Threads Archive

security problem

actually i installed sqlserver before changeing the servername(Test32bit). so there are user group got created Test32bitSQLServer2005MSFTEUser$Test32bit$MSSQLSERVER Test32bitSQLServer2005MSSQLUser$Test32bit$MSSQLSERVER Test32bitSQLServer2005SQLAgentUser$Test32bit$MSSQLSERVER now after changing the server name , still those above groups exists. I don’t know how to change these name to reflect the new servername(Test64bit) and also in the event log we are getting the error message like FailureAudit : Login failed for user ”. The user is not associated with a trusted SQL Server connection. [CLIENT: serverIP Address] Error <img src=’/community/emoticons/emotion-7.gif’ alt=’:S’ />SPI handshake failed with error code 0x8009030c while establishing a connection with integrated security; the connection has been closed. [CLIENT: serverIP Address] I am not sure why we are getting this error messges Thanks in advance for the help

You have to drop that user grup and recreate in the changed server.
http://blogs.msdn.com/sql_protocols…a-workgroup-using-windows-authentication.aspx on that SSPI issue, and here is a KBA about ithttp://support.microsoft.com/kb/247931/en-us too.
Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.

so i can’t recreate the group without dropping the existing group because whenever i try to create the new group it’s giving me an error
the windows NT or usergroup not found

Yes, you have to drop and re-create. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.

yes i dropped the old name user group , and try to recreate witht the new name
still getting error. Windows NT user or group ‘Test64BitSQLServer2005MSFTEUser$Test64Bit$MSSQLSERVER’ not found. Check the name again.
if we look into the user and group under computer management , it’s still showing the old name group now i am in trouble, not able to creae the old one also…

Can you see the domain Test64Bit in this case from this server? Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.

thanks sathya, i got this fixed

]]>