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?
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!