Connecting to SQLexpress 2008R2

ITSMEPJB
ITSMEPJB used Ask the Experts™
on
I have an Ms SQL express 2008R2 server running on a server 2008R2 virtual box.

I can connect to the server via server managment studio using a domain administrator account. However I do not have suitable permissions to make any changes (e.g. password changes)

How can I give the domain admin account the correct permission?

I'm pretty sure I have never given the sa account a new password but I am unable to logon using "sa" and a blank password.

Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Kevin CrossChief Technology Officer
Most Valuable Expert 2011

Commented:
What account did you use to install SQL Server with in the first place? If you don't recall setting an sa password, it is likely logging in using SQL credentials or specifically the sa Login was left disabled and the original installation account (e.g., Local Administrator) was made the sysadmin. Try that. As for granting additional permissions to domain administrator or other accounts, you can just add them to proper roles or use GRANT specific rights.

Author

Commented:
OK, I can't log on using any of the in built users ie "incorrect password".

I would only have used a local or the domain admin to install.

Where do I change the windows credentials to logon? The area to change the windows username is greyed out so I can't change from domain to local admin credentials?
Chief Technology Officer
Most Valuable Expert 2011
Commented:
You have to Login with those credentials OR try launching SSMS using RunAs. It is a digest of credentials so you can't change manually.
Guy Hengel [angelIII / a3]Billing Engineer
Most Valuable Expert 2014
Top Expert 2009

Commented:
you may want to read this article to start troubleshooting :
http://www.experts-exchange.com/A_1881.html

Author

Commented:
Cool, "run as" learned it! Thanks, im in to the databases with the right credentials.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial