You are here: Re: DTSRUN privileges? « MsSQL Server « IT news, forums, messages
Re: DTSRUN privileges?

Posted by Brian Peasland on 05/05/06 05:30

DickChristoph wrote:
> Hi Brian.
>
> The fact that it says:
>> DTSRun: Loading...
>> DTSRun: Executing...
>
> indicates your user can run DTSRUN. What is more likely is that user cannot
> connect to the servers and databases named in the package.
>
> Try going into Query analyzer and connect to the server as that user and see
> if you can connect to the database and select from some of its tables.
>

The user can connect to the database and query tables just fine with QA.
This is not a Windows user, but rather one that is authenticated in the
database.


Thanks,
Brian

--
===================================================================

Brian Peasland
oracle_dba@nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown

 

Navigation:

[Reply to this message]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация