hy,
I have deployed my package to an microsoft sql 2005 server, this is error free. but i can't connect to the server it gives an error "access is denied".
i have tried looking at the rights i have and normally it should do it.
if anybody has an idea what's the problem might be, shoot.
thanks in front,
jens
connection problem
weiminghu
I have tried the advise that was posted elsewhere (http://sqljunkies.com/WebLog/knight_reign/archive/2006/01/05/17769.aspx) gave myself all rights. still doesn't work.
Please if you have the slightest idea. post it. much oblidged
Jens
KayJHut
What kind of server are you trying to connect to SQL Server SSIS Server etc...
From where are you trying to connect to it From BIDS From SSMS From a remote app From the command-line etc...
How are you conencting to it SQL auth Windows auth
Provide more information and you might get more answers.
-Jamie