SQL Server 2008 services error on account

Posted by TheDude on Server Fault See other posts from Server Fault or by TheDude
Published on 2010-12-15T12:49:55Z Indexed on 2011/06/21 8:24 UTC
Read the original article Hit count: 186

I installed SQL Server Enterprise, but can't get it to work. It is a stand alone, on a laptop for development purposes. No network is involved, no other users. The OS is windows 7.

Now, I keep receiving eventId 7000, which means that access is denied for the user (the user was Network Services). So, after reading up on it, I kind of got the idea that a user account should be created with minimal privileges. So, off I went and added a user, SQLservices. In the SQL Server Configuration Manager I right clicked SQL Server(MSSQLSERVER), and in the properties I added my new user.

Well, here's mister eventId 7000 again. I don't get what I am doing wrong. Also, this new user ends up on my start-up screen. I don't think I want that... I mean, it would be weird to have x number of users crowding up my start-up screen just because I created those for my windows services...

The error I get when I add the user in SQL Server Configuration Manager is as follows: Permission Denied. [0x80070005]

Helps!

© Server Fault or respective owner

Related posts about sql-server-2008

Related posts about configuration