By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,843 Members | 2,324 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,843 IT Pros & Developers. It's quick & easy.

LoadFromSQLServer won't work......

P: n/a
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.

Jul 23 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
Hi,

What OS are you using on servers?

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

Danijel

<jd*****@idealconsulting.com> wrote in message
news:11*********************@z14g2000cwz.googlegro ups.com...
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.

Jul 23 '05 #2

P: n/a
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.

Jul 23 '05 #3

P: n/a
In message <11**********************@z14g2000cwz.googlegroups .com>,
jd*****@idealconsulting.com writes
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

Jul 23 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.