Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
frank2
Starting Member
35 Posts |
 Posted - 2005-11-09 : 15:02:58
|
| I am brand new to SQL Server. I have created a server on our server box and another on my local machine. I am frequently having problems when working local such as:Trying to use the debugger it shows no results but does not show any error messages. “The local system account does not have network access rights”…. But does that mean that I can’t use the debugger?Trying to copy a database, I get the error “Your SQL Server Service is running under the local account. You need to change your SQL Server Service account to have rights to copy over the net work”. I have read “The local system account does not have network access rights….” Does this mean that I can’t grant those rights to a local account?Should I not use a local account and only work from the server?These seem to be admin issues. Is there a straight-forward site or book that talks in plain English to the beginner and explains setting up accounts running services under local or network accounts etc..? Using a debugger and copying tables to make test data is basic stuff. Is there no where to get beginner info?Thanks |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-11-09 : 16:43:44
|
| It is recommended that the SQL services do not use the Local System Account. Typically, you create a domain account and have the services use that. It used to be the recommendation that this domain account had local admin privileges, although I don't think this is the recommendation anymore, although that's what we do here.Tara Kizer |
 |
|
|
|
|
|
Need beginner info