SQL Server with domain accounts

5 pts.
Tags:
SQL Server 2005
SQL Server 2008
SQL Server Domain Accounts
When we install SQL 2005 servers, we usually have a collection of domain accounts for the services that will be running on that server. We usually log on to the server using a local account without logging into the domain. However, it seems to not recognize the domain user accounts and we end up using local just to get SQL to install. Then we go back and change it back to the domain accounts. We log on using a domain account when we change it. We discovered that if we log in to the server using a domain account (and hence logging into the domain) it doesn't have this issue. Is there a reference from microsoft that says when you do installations on SQL 2005/08 that you have to login using a domain account where the service accts live? Does it have to use a domain log-in to see the domain service accounts? Thanks Andy

Answer Wiki

Thanks. We'll let you know when a new response is added.

Yes you will need to be logged into the server with a domain account to be able to access the domain resources. Accounts which are local to the server to not have access to the domain resources and there for can not validate the domain account.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following