Hi NG,

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

ka

Kai Apel (mail (AT) kaiapel (DOT) de) writes:
What entries do you have sys.server_principals currently? Don't you need to
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

I have add the new domain/db user to the sql server with sysadmin
role, now it's function.
thx for the fast answer!
K