Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

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

Trouble setting permissions in SQL Server 2005 Express

I am running Windows Vista, and SQL Server 2005 Express came preinstalled from DELL.  I have downloaded and installed the SQL Management Studio.  

My windows account does not have permission as sysadmin, and cannot grant that permission to itself.

I tried to log in as SQL Server account "sa", but it says that it is not associated with a trusted connection (I'm not sure what the password would be anyway).

The windows account I am logged in as has Windows administrator permissions.

How can I setup accounts to have sysadmin permissions on this system?

Thanks.
0
Sym73
Asked:
Sym73
  • 2
  • 2
1 Solution
 
imran_fastCommented:
You can sqlcmd command prompt utility to grant your user access
check this article for using sqlmd
http://www.databasejournal.com/features/mssql/article.php/3566401

connect to sqlcmd using sa sql user and then you have to run this sql command from sqlcmd utility
EXEC sp_addsrvrolemember 'yourdomain\youruser', 'sysadmin'
0
 
Sym73Author Commented:
When I try to open SQLCMD.exe, it opens a command line window, the cursor flashes a time or two, then it closes.

Do you know how to open this so that it doesn't automatically close?

How do I connect as th 'sa' user using the sqlcmd?

Thanks.
0
 
imran_fastCommented:
0
 
Sym73Author Commented:
It turns out I had to start the enterprise manager, I need to do so by right clicking and selecting "run as administrator".

Thanks.
0

Featured Post

Become an Android App Developer

Ready to kick start your career in 2018? Learn how to build an Android app in January’s Course of the Month and open the door to new opportunities.

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