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 |
|
giovi2002
Starting Member
46 Posts |
 Posted - 2005-06-14 : 15:01:43
|
| I login to my sql server with a 'sql server login'(it's not a windows login). Is it possible to grant write rights on the network to a sql server login ?The prob is i can't write a file when using sp_makewebtask |
|
|
Thrasymachus
Constraint Violating Yak Guru
483 Posts |
Posted - 2005-06-14 : 15:20:22
|
| I think it is the SQL Server Service account that needs the permissions to the folder location. Is it on the same server as the SQL Server? Is the startup account for the sql server service in the local administrators group?Sean RoussyPlease backup all of your databases including master, msdb and model on a regular basis. I am tired of telling people they are screwed. The job you save may be your own. |
 |
|
|
giovi2002
Starting Member
46 Posts |
Posted - 2005-06-14 : 17:01:38
|
| I can't answer this right now while the prob is at my work. It says the 'web assistant' has a problem to write the file. The odd thing is, I am able to import CSV files from my access adp which uses the same account. There should be a network map accessable for this account at least in the root of the sql server. When I refer to my sql server desktop root it still doesn't work (the server is at a server not at my client).Rationally thinking I would guess all specific SQL Server Authentication logins can't be granted network writing rights as they don't exist in the windows 2003 server. Maybe the web assistant is an existing account in the active directory. |
|
|
|
Thrasymachus
Constraint Violating Yak Guru
483 Posts |
Posted - 2005-06-14 : 19:14:43
|
When in doubt, look it up in SQL Server Books Online. From the transact sql reference article on sp_makewebtask"quote:
PermissionsThe user must have SELECT permissions to run the specified query and CREATE PROCEDURE permissions in the database in which the query will run. The SQL Server account must have permissions to write the generated HTML document to the specified location. Only the members of the sysadmin fixed server role can impersonate other users.
Sean RoussyPlease backup all of your databases including master, msdb and model on a regular basis. I am tired of telling people they are screwed. The job you save may be your own. |
|
|
|
|
|
|
Granting network rights to sql server login