Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
DTS VB.net SQL login issue
Correction, I have the problem fixed, I simply had to grant access to the user for the default database. duh. I can't believe I missed that , I feel terribly ashamed and I will revoke my IT license.- jediaka
- Post #2
- Forum: Microsoft SQL Server: Data Transformation Services
-
DTS VB.net SQL login issue
Hi, I have a DTS pack on my sql server. I am trying to execute it from a vb.net webapp using SQL server security. but I keep getting : "Cannot open user default database. Login failed. at DTS.Package2Class.LoadFromSQLServer(..." Do I have to set permission so that my sql server user ( not...- jediaka
- Thread
- Replies: 1
- Forum: Microsoft SQL Server: Data Transformation Services
