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: 210
sql-server-2008
|configuration
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