dbTalk Databases Forums  

Windows Authentification not possosible after changing Domain

microsoft.public.sqlserver.server microsoft.public.sqlserver.server


Discuss Windows Authentification not possosible after changing Domain in the microsoft.public.sqlserver.server forum.

Reply
 
Thread Tools Display Modes
  #1  
Old   
Kai Apel
 
Posts: n/a

Default Windows Authentification not possosible after changing Domain - 02-18-2012 , 05:29 AM






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


Reply With Quote
  #2  
Old   
Erland Sommarskog
 
Posts: n/a

Default Re: Windows Authentification not possosible after changing Domain - 02-18-2012 , 08:00 AM






Kai Apel (mail (AT) kaiapel (DOT) de) writes:
Quote:
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?
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

Reply With Quote
  #3  
Old   
Kai Apel
 
Posts: n/a

Default Re: Windows Authentification not possosible after changing Domain - 02-18-2012 , 10: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!
K

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.