smithygreg
New member
- Joined
- Nov 5, 2004
- Messages
- 1
- Programming Experience
- 1-3
Hi all...
I am trying to run a DTS package on SQL Server 2000 from VB.Net
pkg.LoadFromSQLServer("TEST1/TESTBED", "sa", "password", , , , , strPackageName)
pkg.execute()
When the package tries to do anything, I get the error
"Login Failed for User TESTBED/GregJ"
GregJ is the name of the computer I am running the vb program from. I would assume that I was trying to log in as "sa", not "GregJ"...
Any help is appreciated.
Thanks All
Greg
I am trying to run a DTS package on SQL Server 2000 from VB.Net
pkg.LoadFromSQLServer("TEST1/TESTBED", "sa", "password", , , , , strPackageName)
pkg.execute()
When the package tries to do anything, I get the error
"Login Failed for User TESTBED/GregJ"
GregJ is the name of the computer I am running the vb program from. I would assume that I was trying to log in as "sa", not "GregJ"...
Any help is appreciated.
Thanks All
Greg
