package is running ok with one user not for others

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.

All Forums

SQL Server 2005 Forums

SSIS and Import/Export (2005)

package is running ok with one user not for others

Author

Topic

dhani
Posting Yak Master

132 Posts

Posted - 2008-10-21 : 15:18:08

Hello All,

i deployed package on server (as file system)

and then connect to Sql Server Management Studio
then Server Type as Integration Services
it allows only authentication as windows authentication

when i login to server with my user, package is running fine (running in Sql server Mgmt studio--> SS integration service)
but when i login to server as other users the package is giving error

can any one please let me know
how to make it available to all users (whom ever it may login to server)

Thanks & Regards
asini

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2008-10-21 : 16:17:05

Do other users have access permission to the file system?
Make authenticated users have read access to the folder.

E 12°55'05.63"
N 56°04'39.26"

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-10-22 : 00:55:26

Check if you've valid login existing in sql for other peoples windows domain account. If not, add their logins and then try.

igorblackbelt
Constraint Violating Yak Guru

407 Posts

Posted - 2008-10-24 : 01:40:01

What error message do you get?
Seems like the other users don't have access to whatever network resources the package requires.
If granting access to all users isn't feasible, try granting access to the SQL Agent and schedule that package under the SQL Agent.

---
http://www.ssisdude.blogspot.com/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources