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 |
|
william_lee78
Yak Posting Veteran
53 Posts |
 Posted - 2005-07-06 : 07:14:40
|
| Hi,I encountered a permission denied problem when running the following script: 'Create empty MDB sConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & sFilename Set oCatalog = CreateObject("ADOX.Catalog") oCatalog.Create sConnectionString Set oCatalog = Nothing 'Get reference to Access Connection and set new filename Set oConn = DTSGlobalVariables.Parent.Connections("MS Access File") oConn.DataSource = sFileName Set oConn = NothingBasically, I try to create a blank MDB file in a remote machine. I already check the share folder permission, the user is able to create file in the remote machien share folder. Can anyone help me to explain why is it happen? And please guide me how to resolve this problem.Thank youRegards,William |
|
|
timmy
Master Smack Fu Yak Hacker
1242 Posts |
Posted - 2005-07-12 : 21:42:31
|
| How are you running this package?If it's running as a job it will be running in the security context of the user specified in the job. |
 |
|
|
william_lee78
Yak Posting Veteran
53 Posts |
Posted - 2005-07-12 : 22:20:31
|
| Hi Timmy,I'm running the package as a job. May I know what are the permission that I need to run a DTS package? My package contains the following things:1. FileSystemObject2. Transformation Task3. ADOX.Catalog object4. SQL StatementThank you. |
|
|
|
timmy
Master Smack Fu Yak Hacker
1242 Posts |
Posted - 2005-07-12 : 22:52:35
|
| Not sure of the exact permissions, but you'll need to check whether the account that runs the job (specified in the job detail) has the necessary permissions to the remote machine. Generally the account that's used to run SQL jobs is a local machine account and therefore wouldn't have network permissions. |
|
|
|
|
|
|
Permission Denied Create Object