Hi, I have an SSIS project, has a connection to tempdb (local sql2k5 server),
3 tasks, creating a table, populating the table, then deleting the table. of
course when I test the connection i GET TEST Succesfull (I am using sa ...)

Whenever I run the package, all tasks become red colored, I get the
following error :
---------------------------------------------------------------------------------------------------------------------------
[Execute SQL Task] Error: Failed to acquire connection "tempdb".
connection may not be configured correctly or you may not have the right
permissions on this connection.vance
----------------------------------------------------------------------------------------------------------------------------
Any help would be appreciated. Thanks in advance

SalamElias wrote:
The obvious answer is that your connection to tempdb fails. If you are
running the package on the same machine and same user as when you tested
the connection then I'm not sure.

I would start by checking name resolution and basic connectivity. Check
the SQL error log for failed login events (you should be auditing these
by default in SQL2K5).


--
Darren
http://www.sqldts.com
http://www.sqlis.com

Thanks. I double checked, and found that the project is not saving the
password in spite ofthe fact that I check the option "save password".
Even I tried manually (entered t in the connection string property (user
id=;....Password=..., but it disappears

Any Idea

Best regards,
"Darren Green" wrote:

Hello,

Did you try to deploy ssis pkg into SQL server Or file system is using
Deployment utility from SSIS, and then test the siutation?

Best Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

================================================== ===



This posting is provided "AS IS" with no warranties, and confers no rights.


--------------------
-----------------------------------------------
------------------------------------------------

Thanks. As I said, it is a new sql server project I created in VS2005. I am
trying to test it for the moment. I havn't deployed aznything, just hitting
run to validate and debug and learn.
I repeat my question, whey password is not savec in your opinion, bug,
dysfun......oe anything else?

Tnanks again
salam

"Peter Yang [MSFT]" wrote:

Hi Salam,

Since Peter Yang is OOF, I am his backup.

Is it possible for you using AdventureWorks as Data Source to generate a
SSIS project sample for me, with which I could reproduce it on my side.

I understand the information may be sensitive to you, my direct email
address is v-mingqc (AT) ONLINEmicrosoft (DOT) com (make sure you have REMOVED ONLINE
before you click SEND), you may send the file to me directly and I will
keep secure.


Sincerely yours,

Michael Cheng
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
================================================== ===
This posting is provided "AS IS" with no warranties, and confers no rights.

We are having the same issue - what was the resolution?

"Michael Cheng [MSFT]" wrote: