tags:

views:

95

answers:

1
Q: 

Access denied when starting SQL Server Express from command line

Windows 7 computer running SQL Server Express 2008 (sp1).

When I try to run net start mssql$sqlexpress I receive an error:

System error 5 has occurred.
Access is denied

The SQL service is running under "Network Service" account

The service starts fine if I use the services window. Could somebody help me figure out why I am receiving this error?

A: 

Did you start the console in Administrator mode ?

kubal5003  2010-04-03 09:35:58
Not explicitly, I am an administrator, why would I need to?
Brettski  2010-04-03 15:16:54
It doesn't matter that you are logged on to Administator account or that your account is in Administators group. In Vista/Seven this is different than in xp. If you want to allow some application to do Administator stuff, you have to explicitly start it with administator privileges.
kubal5003  2010-04-04 08:35:51

related questions

Unable to restore SQL Server database - 'The file or filegroup <logfilename> cannot be selected for this operation.'
SQL Server Express: User Instance Issue
How do I release sql express database?
How do I insert Chinese characters into a SQLExpress text field?
How to move a sql server express mdf file to a different sql sever express server?
How do you upgrade a SQL Express Database to SQL Server Workgroup or Standard?
Installing sql server express: VS2008 sp1 problem
Silent Installation of SQl Express 2005
Inheritance question - retrieving data from Access database file and SQL Express
Deploy application with SQLExpress
How to get BIDS for Visual Studio 2008 SP1?
Connection Strings modification after the deployment
What services are required by SQL Express/SQL Server?
What are the limitations on using SSRS with SQL Server 2005 Express edition?
Will a database generated from SQL Server Express work with the main version of SQL ?
SQL Express for production?
SQL Server Service Broker Issue & Tutorials
SQL 2005 Express Edition - Install new instance
How can I determine installed SQL Server instances and their versions?
Windows 2008 VPS hosting experiences
SQL Server Express DB is 'in recovery' - how to detect / know when it is
sqlserver express database copy options
SqlServer Express slow performance
Using Windows XP as a SQL Server
[ADO.NET ERRROR]: CREATE DATABASE permission denied in database 'master'. An attempt to attach an auto-named database for file HelloWorld.mdf failed...