| Author |
Access denied on mapped drive.
|
|
| Bartee 2002-08-13, 3:23 pm |
| Trying to access a file on a mapped drive to do buld
insert.
Drive W: has been mapped. Any attemp at accessing this
results in Access Denied.
I am in a multi server / domain controlled environment.
The System user has been full permissions on the shared
directory.
I think the question is what user does MSSQLSERVER service
run under?
We tried to change the service startup user. We selected
a user from the list provided in the dialog. When we try
to restart the service with the selected user we get "the
account is invalid or does not exist."
Any ideas would be appreciated.
Bartee Lamar
Atlanta GA USA
| |
|
| Use a UNC (\\server\share\filename), drive letter mappings happen when users
log on.
"Bartee" <bartee@enterpriseenergy.com> wrote in message
news:1b8301c24307$86d25ac0$9ee
62ecf@tkmsftngxa05...
> Trying to access a file on a mapped drive to do buld
> insert.
>
> Drive W: has been mapped. Any attemp at accessing this
> results in Access Denied.
>
> I am in a multi server / domain controlled environment.
>
> The System user has been full permissions on the shared
> directory.
>
> I think the question is what user does MSSQLSERVER service
> run under?
>
> We tried to change the service startup user. We selected
> a user from the list provided in the dialog. When we try
> to restart the service with the selected user we get "the
> account is invalid or does not exist."
>
> Any ideas would be appreciated.
>
> Bartee Lamar
> Atlanta GA USA
| |
| Bartee Lamar 2002-08-13, 6:23 pm |
|
So,
Iris is the web server.
Athena is the SQL Server
I need to read a file on Iris D:\web\myfile.csv from athena
In SQL stored proc on athean I would use
//iris/web/myfile.csv ???
Thx for your help.....
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
| |
|
| If the web folder is shared with the share name 'web' (the default) then it
would be \\iris\web\myfile.csv .
The SQL Server service account would also need permissions to that
directory.
"Bartee Lamar" <bartee@enterpriseenergy.com> wrote in message
news:O$3LBayQCHA.2692@tkmsftngp08...
>
> So,
>
> Iris is the web server.
> Athena is the SQL Server
>
> I need to read a file on Iris D:\web\myfile.csv from athena
>
> In SQL stored proc on athean I would use
>
> //iris/web/myfile.csv ???
>
> Thx for your help.....
>
>
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!
| |
| Bartee Lamar 2002-08-14, 7:23 am |
| Al, sorry to keep bothering you but,
the SQL service account is a big question????
I understand it must have permissions.
Note in my first message we tried to start the service under a different
account and it could not find the account even tho we selected it from
the system provided list.
What account does MSSQLSERVER service run under by default?
.... I am getting ready to leave to go to client's office....
Thank you ... bartee...
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
| |
| Tibor Karaszi 2002-08-14, 9:23 am |
| > What account does MSSQLSERVER service run under by default?
Depends on what you specified at install time.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=...ublic.sqlserver
"Bartee Lamar" <bartee@enterpriseenergy.com> wrote in message
news:#naYSA5QCHA.1648@tkmsftngp08...
> Al, sorry to keep bothering you but,
>
> the SQL service account is a big question????
>
> I understand it must have permissions.
>
> Note in my first message we tried to start the service under a different
> account and it could not find the account even tho we selected it from
> the system provided list.
>
> What account does MSSQLSERVER service run under by default?
>
> ... I am getting ready to leave to go to client's office....
>
>
> Thank you ... bartee...
>
>
>
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!
| |
|
| I don't have access to a server right here, but..
In Enterprise Manager, Right click the MSSQL Server on Athena. Select
properties.
On one of the tabs (like I said, no server handy, can't recall which one) it
will show the login being used. It will either be Local System or a domain
user in the form of DomainName\Username. If it is a DomainName\Username,
that is who needs permissions to the directory. If is is Local System, you
won't be able to access the remote share. You will need to change it to at
domain account.
If the Web server doesn't belong to a domain (often the case), create a
local login on the web server that matches the one you use on SQL Server
with the same password. Give it permissions to the shared directory.
"Bartee Lamar" <bartee@enterpriseenergy.com> wrote in message
news:#naYSA5QCHA.1648@tkmsftngp08...
> Al, sorry to keep bothering you but,
>
> the SQL service account is a big question????
>
> I understand it must have permissions.
>
> Note in my first message we tried to start the service under a different
> account and it could not find the account even tho we selected it from
> the system provided list.
>
> What account does MSSQLSERVER service run under by default?
>
> ... I am getting ready to leave to go to client's office....
>
>
> Thank you ... bartee...
>
>
>
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!
|
|
|
|