How to code a connection string to a SQL 2000 database with user id using windows authentication

Hi,

need help.

how do I code a connection string in asp.net in visual basic to a SQL 2000 database with user id that is set up with windows authentication

the SQLConnection string requires a user id and password. According to the document, it is not necessary to login to the SQL server if the user

id is configured with windows authentication.

thanks...



Answer this question

How to code a connection string to a SQL 2000 database with user id using windows authentication

  • rjw

    in the connection string, add in below info:

    "database=xx;server=xx;Integrated Security=SSPI;"



  • How to code a connection string to a SQL 2000 database with user id using windows authentication