Solved

How to handle SQL server on new DC/AD domain

Posted on 2015-02-19
4
89 Views
Last Modified: 2015-02-21
I have SQL Server 2005 running on a Server 2008 Standard host. This host had been attached to a SBS 2008 domain. I removed the SQL Server host from the SBS 2008 domain and attached it to a new Samba4 DC/AD.

The same user ID is used to log onto the SQL Server on the new domain and that works ... for logging in. When I open the SQL Server Management Studio and attempt to log in via Windows Authentication, I get "Login failed for user HPRS\mark", which is the new, correct user.

Is there something I an do to permit the new domain user to log in via Windows Authentication?
0
Comment
Question by:jmarkfoley
  • 2
4 Comments
 
LVL 76

Expert Comment

by:arnold
Comment Utility
Within SSMS, you need to add the user into the server security folder with a Sysadmin role.
Login using sa, and after you add, you should be able to establish a second connection using windows authentication.
0
 
LVL 6

Accepted Solution

by:
Mandeep Singh earned 500 total points
Comment Utility
Hi,

To do so follow these stpes:

Connect to your SQL Server Instance.
Navigate >Security > Logins, right-click Logins, then choose New Login.
On Pop up window, click the Search button to browse for a local or domain login.
Search button opens the Select User or Group dialog box, search username.

Be sure windows authentication is selected. click on server roles and select sysadmin, be sure that public must also be checked. and click on OK.
You are done. you can now login.
0
 
LVL 1

Author Closing Comment

by:jmarkfoley
Comment Utility
That did the trick! Thanks
0
 
LVL 1

Author Comment

by:jmarkfoley
Comment Utility
Mandeep Singh: I know I closed this already, but as I went to 'drop user' for other users on databases I got the error

drop user hprs\joe

Msg 102, Level 15, State 1, Line 1
Incorrect syntax near '\'.

How can I do this?
0

Featured Post

Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

Join & Write a Comment

There are some very powerful Data Management Views (DMV's) introduced with SQL 2005. The two in particular that we are going to discuss are sys.dm_db_index_usage_stats and sys.dm_db_index_operational_stats.   Recently, I was involved in a discu…
by Mark Wills Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server...  So if you are the accidental DBA, or, simp…
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, Just open a new email message.  In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

6 Experts available now in Live!

Get 1:1 Help Now