VISUAL BASIC.NET CONNECTION

• bilko73

  SSC-Addicted

  Points: 407

  More actions

  September 13, 2002 at 8:02 am

  #78739

  I have a visual basic.net web applicatin with a connection to a sql server 2000 database using NT logon. It connects fine in design mode but when I run it I get the error: Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.

  Does anyone know why I am getting this???

  thanks

• Andy Warren

  SSC Guru

  Points: 119902

  More actions

  September 13, 2002 at 8:48 am

  #436503

  Can you post your connect string?

  Andy

  http://www.sqlservercentral.com/columnists/awarren/

  Andy
  Connect with me on LinkedIn

• bilko73

  SSC-Addicted

  Points: 407

  More actions

  September 13, 2002 at 8:50 am

  #436504

  I think I figured it out. Instead of the NT login, I used a specific login and password and had to allow password saving.

  thanks

• bilko73

  SSC-Addicted

  Points: 407

  More actions

  September 13, 2002 at 9:39 am

  #436507

  Andy, I would like to use integrated nt security though so I don't have to save the password. Here is my connect string:

  data source=DBSERV2;initial catalog=PELDMS;integrated security=SSPI;persist security info=False;workstation id=DTHOMPSON02;packet size=4096

• Andy Warren

  SSC Guru

  Points: 119902

  More actions

  September 13, 2002 at 11:56 am

  #436524

  Looks ok.

  Andy

  http://www.sqlservercentral.com/columnists/awarren/

  Andy
  Connect with me on LinkedIn