April 9, 2004 at 9:52 am
Is it possible for a user to run a DTS package stored in SQL Server 2000 via his local EM that connects to server in SQL mode (no Windows account on server)? MSKB 269074 indicates that the package will run on the local workstation with a security context of the Windows account used to log in to that computer, so is that "end of story"?
Thanks,
Dave
April 12, 2004 at 8:00 am
This was removed by the editor as SPAM
April 12, 2004 at 9:18 am
Hi,
You should create a dts user in you sql server box and set permissions for this user to run a dts pkg.
Regards
JFB
April 12, 2004 at 11:17 am
After connecting with EM using the sa account, when I try to run the package, I get the following error message "[DBNETLIB][ConnectionOpen (Connect().] SQL Server does not exist or access denied." I'd expect that use of the sa account would cover the permissions angle.
The error message appears to be consistent with access permissions of the local user (i.e no Windows account access) when trying to execute the package locally.
Let me know if you see anything I'm missing here...
Thanks,
Dave
April 12, 2004 at 1:11 pm
Follow this steps and let me know if it works?
1.Create a new user in sql server 2000 (dtsUser) and password
2.Set this user for msdb database
3.Create a sample DTS package and set dtsUser as logging authentication.
4.Using EM from client box login to sqlserver box using dtsUser.
5.You should see only the sample package, nothing else.
JFB
April 12, 2004 at 5:16 pm
Following your steps, it worked. Why it didn't using the sa account is a mystery to me.
As dtsUser, I was able to see all DTS packages.
Thanks for your help!
Dave
April 13, 2004 at 7:06 am
1. sa is a special account for sql server. It should be a reason why??, I dont know because I never use sa.
2. You need to delete guest user from msdb database and dtsUser should see only the dtsUser packages.
Regards
JFB
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply