 | |
More Bizarre Permission Issues w/ DTSRUN
microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
More Bizarre Permission Issues w/ DTSRUN -
12-03-2003
, 01:23 PM
#2
| |||
| |||
|
|
I am getting a 'denied' select on a table but the user has appropiate permissions. I can log in as the user and execute the sql, but through the DTS Package run via DTSRUN I get permission denied. When I log on as this user via SQLEM, it works fine as well .. any ideas ? |
#3
| |||
| |||
|
|
Who does profiler tell you that you are ? -- -- Allan Mitchell (Microsoft SQL Server MVP) MCSE,MCDBA www.SQLDTS.com I support PASS - the definitive, global community for SQL Server professionals - http://www.sqlpass.org "Jeff Block" <jblock (AT) REMOVETHECAPSANDINVALIDfirstlook (DOT) biz.invalid> wrote in message news:%23zoQfLduDHA.1680 (AT) TK2MSFTNGP12 (DOT) phx.gbl... I am getting a 'denied' select on a table but the user has appropiate permissions. I can log in as the user and execute the sql, but through the DTS Package run via DTSRUN I get permission denied. When I log on as this user via SQLEM, it works fine as well .. any ideas ? |
#4
| |||
| |||
|
|
profiler and sp_who indicates a trusted connection .. I believe this has to do with the way in which the connections in DTS are set up, SSIP (trusted) in this case (and by default). "Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote in message news:uJbFKnduDHA.556 (AT) TK2MSFTNGP11 (DOT) phx.gbl... Who does profiler tell you that you are ? -- -- Allan Mitchell (Microsoft SQL Server MVP) MCSE,MCDBA www.SQLDTS.com I support PASS - the definitive, global community for SQL Server professionals - http://www.sqlpass.org "Jeff Block" <jblock (AT) REMOVETHECAPSANDINVALIDfirstlook (DOT) biz.invalid> wrote in message news:%23zoQfLduDHA.1680 (AT) TK2MSFTNGP12 (DOT) phx.gbl... I am getting a 'denied' select on a table but the user has appropiate permissions. I can log in as the user and execute the sql, but through the DTS Package run via DTSRUN I get permission denied. When I log on as this user via SQLEM, it works fine as well .. any ideas ? |
#5
| |||
| |||
|
|
You execute DTSRUN from the cmdline yeah ? You use the /E switch? What about logging in as the user and executing the package from designer? -- -- Allan Mitchell (Microsoft SQL Server MVP) MCSE,MCDBA www.SQLDTS.com I support PASS - the definitive, global community for SQL Server professionals - http://www.sqlpass.org "Jeff Block" <jblock (AT) REMOVETHECAPSANDINVALIDfirstlook (DOT) biz.invalid> wrote in message news:uxa4LxeuDHA.4056 (AT) TK2MSFTNGP11 (DOT) phx.gbl... profiler and sp_who indicates a trusted connection .. I believe this has to do with the way in which the connections in DTS are set up, SSIP (trusted) in this case (and by default). "Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote in message news:uJbFKnduDHA.556 (AT) TK2MSFTNGP11 (DOT) phx.gbl... Who does profiler tell you that you are ? -- -- Allan Mitchell (Microsoft SQL Server MVP) MCSE,MCDBA www.SQLDTS.com I support PASS - the definitive, global community for SQL Server professionals - http://www.sqlpass.org "Jeff Block" <jblock (AT) REMOVETHECAPSANDINVALIDfirstlook (DOT) biz.invalid wrote in message news:%23zoQfLduDHA.1680 (AT) TK2MSFTNGP12 (DOT) phx.gbl... I am getting a 'denied' select on a table but the user has appropiate permissions. I can log in as the user and execute the sql, but through the DTS Package run via DTSRUN I get permission denied. When I log on as this user via SQLEM, it works fine as well .. any ideas ? |
#6
| |||
| |||
|
|
not using the E switch .. logging in as the user , same issue .. I am guessing , this behavior happens becuause DTS uses stand alone connections "Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote in message news:eVZSmKjuDHA.2444 (AT) TK2MSFTNGP12 (DOT) phx.gbl... You execute DTSRUN from the cmdline yeah ? You use the /E switch? What about logging in as the user and executing the package from designer? -- -- Allan Mitchell (Microsoft SQL Server MVP) MCSE,MCDBA www.SQLDTS.com I support PASS - the definitive, global community for SQL Server professionals - http://www.sqlpass.org "Jeff Block" <jblock (AT) REMOVETHECAPSANDINVALIDfirstlook (DOT) biz.invalid> wrote in message news:uxa4LxeuDHA.4056 (AT) TK2MSFTNGP11 (DOT) phx.gbl... profiler and sp_who indicates a trusted connection .. I believe this has to do with the way in which the connections in DTS are set up, SSIP (trusted) in this case (and by default). "Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote in message news:uJbFKnduDHA.556 (AT) TK2MSFTNGP11 (DOT) phx.gbl... Who does profiler tell you that you are ? -- -- Allan Mitchell (Microsoft SQL Server MVP) MCSE,MCDBA www.SQLDTS.com I support PASS - the definitive, global community for SQL Server professionals - http://www.sqlpass.org "Jeff Block" <jblock (AT) REMOVETHECAPSANDINVALIDfirstlook (DOT) biz.invalid wrote in message news:%23zoQfLduDHA.1680 (AT) TK2MSFTNGP12 (DOT) phx.gbl... I am getting a 'denied' select on a table but the user has appropiate permissions. I can log in as the user and execute the sql, but through the DTS Package run via DTSRUN I get permission denied. When I log on as this user via SQLEM, it works fine as well .. any ideas ? |
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.