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 |
|
heze
Posting Yak Master
192 Posts |
 Posted - 2006-10-05 : 16:40:32
|
| hi When I execute the following script from the command prompt DTSRun /S CIERPSRVSQL00 /E /N myDTSmyDTS package executes correctlywhereas if I executeEXEC master..xp_cmdshell 'DTSRun /S CIERPSRVSQL00 /E /N myDTS'the error is the follwoing Error string: The Microsoft Jet database engine cannot open the file '\\myServer\myShare\myPath\myAccessDatabase.mdb'. It is already opened exclusively by another user, or you need permission to view its data. ---I want to wrap the DTS call within a stored proc so that the execution can be controlled via a web page.Thenks for the help |
|
|
Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)
7020 Posts |
Posted - 2006-10-05 : 16:49:58
|
| More than likely, the SQL Server service or proxy account does not have access to that share, directory, or file.CODO ERGO SUM |
 |
|
|
heze
Posting Yak Master
192 Posts |
Posted - 2006-10-05 : 18:19:04
|
| thanks MVJ,I have tried adding the users:sql service and sql reporting service as well as sql admins and sql users and give read permissions in the Access file I want sql server to read but the error is the same, do you know how can I get hold of the user name of the sql process trying to read the Access file?thank you |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-10-05 : 18:37:26
|
| The account that needs the access is the one that is being used for the SQL service. It not only needs access to the mdb file but also to the share.Tara Kizer |
|
|
|
|
|
|
Can not execute DTS from query analyzer