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 |
|
carumuga
Posting Yak Master
174 Posts |
 Posted - 2009-05-18 : 06:44:11
|
| When i try to invoke the package from the sql box by using the following command, it throws me an error. If the connection is the local path rather than share drive it works fine (\\ShareDrive\test.txt ---> E:\test.txt). The package is deployed in the MSDB db.EXEC XP_CMDSHELL 'DTEXEC /DTS "\MSDB\PackageName" /SERVER xxx /DECRYPT xxx /CONNECTION "ServerName.dbname";"Data Source=servername;User ID=xxx;Pwd=xxx;Initial Catalog=dbname;Provider=SQLOLEDB.1;Persist Security Info=True;" /CONNECTION TabFileSource;"\\ShareDrive\test.txt" /MAXCONCURRENT " -1 " /CHECKPOINTING OFF /REPORTING V' Error Desc: Description: The file name "\\ShareDrive\test.txt" specified in the connection was not valid.Your help is highly appreciated |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2009-05-18 : 07:02:59
|
| Are you running the SQL Server service under the LocalSystem account? If so, it will have no network access. Even though the share may reference a local drive, it's still accessing it through the network, and it has separate permissions as well.You will have to change the SQL Server service to run under a domain account in order to access network components via UNC paths. |
 |
|
|
carumuga
Posting Yak Master
174 Posts |
Posted - 2009-05-18 : 08:13:19
|
| Right, it runs under the Local system account, do i go and change it in the configuration Mgr.What are the steps i need to do it over there. I changed to my domain account, i was not able to connect it via mgmt studio |
|
|
|
carumuga
Posting Yak Master
174 Posts |
Posted - 2009-05-18 : 08:31:32
|
| I given permission to the share dir for everyone access. This worked me.Thanks |
|
|
|
|
|
|
Hi