Authentication problems since server change
-
Hi, One of our clients have recently had one of their two servers changed. The server that got changed contained Active Directory with all the permissions for all users. The other server has MS SQL Server 2005 installed. Since the server change, users cannot use the Management Studio from their client machines to log on to SQL Server using Windows Authentication. I'm presuming that this is because since the server change, there is some sort of security ID which has changed meaning that the SQL Server doesn't recognise it even though ther name of the new server is the same and the name of the domain is still the same. My question is this, what can I do about this?? Thanks in advance for any help.
-
Hi, One of our clients have recently had one of their two servers changed. The server that got changed contained Active Directory with all the permissions for all users. The other server has MS SQL Server 2005 installed. Since the server change, users cannot use the Management Studio from their client machines to log on to SQL Server using Windows Authentication. I'm presuming that this is because since the server change, there is some sort of security ID which has changed meaning that the SQL Server doesn't recognise it even though ther name of the new server is the same and the name of the domain is still the same. My question is this, what can I do about this?? Thanks in advance for any help.
-
Hi, One of our clients have recently had one of their two servers changed. The server that got changed contained Active Directory with all the permissions for all users. The other server has MS SQL Server 2005 installed. Since the server change, users cannot use the Management Studio from their client machines to log on to SQL Server using Windows Authentication. I'm presuming that this is because since the server change, there is some sort of security ID which has changed meaning that the SQL Server doesn't recognise it even though ther name of the new server is the same and the name of the domain is still the same. My question is this, what can I do about this?? Thanks in advance for any help.
Have been doing some research and it seems that I need to update the SIDs in the master database for each login to match those of the newly created users in Active Directory. If anyone knows of a way to do this then it would be appreciated. Thanks.
-
Hi, One of our clients have recently had one of their two servers changed. The server that got changed contained Active Directory with all the permissions for all users. The other server has MS SQL Server 2005 installed. Since the server change, users cannot use the Management Studio from their client machines to log on to SQL Server using Windows Authentication. I'm presuming that this is because since the server change, there is some sort of security ID which has changed meaning that the SQL Server doesn't recognise it even though ther name of the new server is the same and the name of the domain is still the same. My question is this, what can I do about this?? Thanks in advance for any help.