Cannot Start SQLEXPRESS when it runs as NT Authority\NetworkService

Category: sql server setup

Question

Oseun on Wed, 10 Apr 2013 17:21:27


I have successfully installed an instance of SQL Express Database on the Windows Server 2008, and I'm trying to start the service logging on as NT Authority\NetworkService but it won't start, but the service will start if run as NT Authority\System or NT Authority\Local, what could be the problem, I have tried to re-install the SQL Server, but still the same issue.

Please Help

Replies

Oseun on Wed, 10 Apr 2013 17:41:59


I have successfully installed an instance of SQL Express Database on the Windows Server 2008, and I'm trying to start the service logging on as NT Authority\NetworkService but it won't start, but the service will start if run as NT Authority\System or NT Authority\Local, what could be the problem, I have tried to re-install the SQL Server, but still the same issue.

Please Help

Alberto Morillo on Wed, 10 Apr 2013 17:44:30


 

Hello,

 

Please make sure the NT Authority\NetworkService account has Full Control access to the C:\Program Files\Microsoft SQL Server folder and subfolders, including the Data folder where the system and user databases are located by default.

Hope this helps.

Regards,

Alberto Morillo
SQLCoffee.com

Oseun on Wed, 10 Apr 2013 20:49:25


Hi Alberto,

Thanks for your reply.

I should state that, against the recommendation of Microsoft, I installed the SQL Server on a domain controller, since NT Authority\NetworkService is not allowed on a domain, I used the administrator account and password, I am installing the SQL server because I want to install an application on the server, where other computer can connect to the system, but they still cannot connect to the SQL instance on the server, and for your explanation above, where can I grant such FUll Control Access? I don't seem to get it.

I appreciate all the help I can get.

Thanks

Alberto Morillo on Wed, 10 Apr 2013 23:03:01


Hello,
Please let me know if the SQL Server service cannot be started. If that is the case use the following resources to provide appropriate permissions.

http://techstrick.blogspot.com/2012/05/take-ownership-grant-full-control.html

To access the SQL Server instance for remote computers, please configure Windows Firewall properly or disable it. Please read the following article for more information:

http://technet.microsoft.com/en-us/library/cc646023(v=SQL.105).aspx

Please note is not recommended to install SQL Server on a Domain Controller.

Hope this helps.

Regards,

Alberto Morillo
SQLCoffee.com

Oseun on Thu, 11 Apr 2013 09:14:41


Hi Alberto,

Thanks for the hint, I was unable to access the SQL Server instance on the remote PCs, but I am able to do that now, but when I'm trying to use the remote computers to access the Database Name, I get the following error  

"Unable to connect to server "PastelServer\SQLEXPRESS". Reason:[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.

I don't know what else that could be the problem.

Please Assist, thanks.

Alberto Morillo on Thu, 11 Apr 2013 11:29:32


Hello,

Please enable TCP/IP and Named Pipes protocols. Use the following article:

http://msdn.microsoft.com/en-us/library/hh231672.aspx

Use SQL Server Configuration manager to start SQL Server Browser service. The following article may be useful:

http://msdn.microsoft.com/en-us/library/ms189093(v=SQL.105).aspx

Possible causes of this error could be found on the following article:

http://support.microsoft.com/kb/328306

Hope this helps.

Regards,

Alberto Morillo
SQLCoffee.com