|
Home > Archive > MS SQL Server New Users > December 2005 > SQL Express NT File Permissions
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
SQL Express NT File Permissions
|
|
| David Veeneman 2005-12-11, 1:23 pm |
| I'm just getting started with SQL Server, using SQL Server Express. One of
he first issues I ran into was SQL Server being denied access when I tried
to attach a database file.
I looked up SQL Server in Control Panel > Administrative Tools > Services
and saw that SQL Server was logged on as "Network Service". I used this name
to set file permissions on the target. The File Properties > Security Tab >
Select Users and Groups dialog found the name, but SQL Server was still
denied acces to the file.
I went to the SQL Server database files (in the ...\MSSQL\Data folder) to
see how permissions were set for those files. They had permissions for a
different account: SQLServer2005MSSQLUs
er$Laptop$SQLEXPRESS
. I set
permissions on my target file for this account, and SQL Server was given
access to the file.
Did I find the correct account, or should I not use the long-named account
for NT file permissions? Why didn't the "Network Service" account work? Can
you point me to an article or other resource on the user accounts that SQL
Server uses on Windows XP and how permissions should be set? Thanks
David Veeneman
Foresight Systems
| |
| Danijel Novak 2005-12-11, 8:24 pm |
| Hi,
Setting Up Windows Service Accounts article in BOL could help
--
Danijel Novak
"David Veeneman" <davidv@nospam.com> wrote in message
news:uhJ2zKo$FHA.3872@TK2MSFTNGP12.phx.gbl...
> I'm just getting started with SQL Server, using SQL Server Express. One of
> he first issues I ran into was SQL Server being denied access when I tried
> to attach a database file.
>
> I looked up SQL Server in Control Panel > Administrative Tools > Services
> and saw that SQL Server was logged on as "Network Service". I used this
> name to set file permissions on the target. The File Properties > Security
> Tab > Select Users and Groups dialog found the name, but SQL Server was
> still denied acces to the file.
>
> I went to the SQL Server database files (in the ...\MSSQL\Data folder) to
> see how permissions were set for those files. They had permissions for a
> different account: SQLServer2005MSSQLUs
er$Laptop$SQLEXPRESS
. I set
> permissions on my target file for this account, and SQL Server was given
> access to the file.
>
> Did I find the correct account, or should I not use the long-named account
> for NT file permissions? Why didn't the "Network Service" account work?
> Can you point me to an article or other resource on the user accounts that
> SQL Server uses on Windows XP and how permissions should be set? Thanks
>
> David Veeneman
> Foresight Systems
>
|
|
|
|
|