SQL Server 2008 services error on account

0

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!

sql-server-2008
configuration
asked on Server Fault Dec 15, 2010 by TheDude

1 Answer

0

Does the account in which the service is running have rights to start a service and access the folders where the program and data files are? Did you do a plain Jane install, or custom data directories and such?

answered on Server Fault Dec 15, 2010 by Malnizzle

User contributions licensed under CC BY-SA 3.0