Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 299
  • Last Modified:

Connecting to SQLexpress 2008R2

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.

0
ITSMEPJB
Asked:
ITSMEPJB
  • 2
  • 2
1 Solution
 
Kevin CrossChief Technology OfficerCommented:
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.
0
 
ITSMEPJBAuthor 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?
0
 
Kevin CrossChief Technology OfficerCommented:
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.
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
you may want to read this article to start troubleshooting :
http://www.experts-exchange.com/A_1881.html
0
 
ITSMEPJBAuthor Commented:
Cool, "run as" learned it! Thanks, im in to the databases with the right credentials.
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now