LoadFromSQLServer won't work......

[jdionne]

I have a VB.NEt Winform app deplyed on ServerA. I have a DTS package
on ServerB. When I try to load the package with:

package.LoadFromSQLServer(serverB, uid, pwd,
DTS.DTSSQLServerStorageFlags.DTSSQLStgFlag_Default, , , , packageName)

Where serverB, uid, pwd are variables set in the program and are valid,
I get this error

Description: [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not
exist or access denied.

Which makes no sense because I'm using SQL Authentication and I am
1000000000% sure the uid and pwd are correct. Am I missing something?
My VB app runs fine on the sql server but not anywhere else and I need
to run it elsewhere against the db.

 

[Danijel Novak]

Hi,

What OS are you using on servers?

If it is Win2003 try disabling Named Pipes as Win2003 doesn't have them
anymore.

Danijel

 

[jdionne]

Win2003. I made a mistake and it's not getting the error from the
loadPAckage, but this error is coming from the tasks in the DTS
Package. I have added ASPNET, IUSER_MACHINENAME, IWAM_MACHINENAME to
the database but it still doesn't work.

 

[Darren Green]

Win2003. I made a mistake and it's not getting the error from the
loadPAckage, but this error is coming from the tasks in the DTS
Package. I have added ASPNET, IUSER_MACHINENAME, IWAM_MACHINENAME to
the database but it still doesn't work.

If the error is when you execute the package it says that you are trying
to make use connection to a SQL server that cannot be made. Open the
package and see what connections you have and what the server is set to
in those connections

Remmeber the server and credentials you use to load the package
(LoadFromSQLServer) has absolutely no bearing on the connections inside
the package used at runtime.

Adding IIS accounts to your DB will not solve the problem, as you cannot
even find the server, or perhaps resolve the name, which must be done
before you can present credentials.

--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org