DiegoErnesto
Programmer
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
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