Windows Authentification not possosible after changing Domain - 02-18-2012 , 06:29 AM
I have changed the DC at my network and moved my SQL VM to the new
domain. Now the windows authentification did'nt work, only the SQL-
Server-adminaccount "sa" works.
What I have to do, to fix the, so that the new windows user can
authentificate against the SQL Server?
Wich roles I have to put on the new active directory?
thx for the hint
Re: Windows Authentification not possosible after changing Domain - 02-18-2012 , 09:00 AM
Kai Apel (mail (AT) kaiapel (DOT) de) writes:
enter the same entries for the new domain?
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se
Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
Re: Windows Authentification not possosible after changing Domain - 02-18-2012 , 11:47 AM
I have add the new domain/db user to the sql server with sysadmin
role, now it's function.
thx for the fast answer!