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 Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How do I connect using Windows Authentication?

Status
Not open for further replies.

DiegoErnesto

Programmer
Nov 28, 2001
41
EC
Help, please;

I'm trying to connect using Windows Authentication but doesn't work in ASP.

Reference;

- IIS is setting like Basic authentication.
- SQL Server is setting like "SQL Server and Windows"
- IIS and SQL Server are on the same machine

and my string connection is:

strCon = "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=Northwind;Data Source=Localhost"

I test with this string and work.

strCon = "Provider=SQLOLEDB.1;Persist Security Info=True;" & "User ID=" & strUser & ";Password=" & strPwd & ";Initial Catalog=Northwind;Data Source=localhost"

any ideas...

Diego Ernesto
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top