SQL Server with 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
Software/Hardware used:
Software/Hardware used:
ASKED:
March 20, 2009 3:39 PM
UPDATED:
March 21, 2009 9:12 PM
Answer Wiki:
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.
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
