sqlserver Windows Authentication Mode Problem

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

sqlserver Windows Authentication Mode Problem

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2006-06-07 : 11:25:08

Rishi writes "Dear Sir,

i am using sqlserver windows Authentication Mode, problem is ASP connection string not working.

My Code is :

Please help me.

Set con = server.createobject("ADODB.Connection")
con.open "PROVIDER=SQLOLEDB; DATA SOURCE=x.x.x.x; Integrated Security=SSPI; DATABASE=xxx"

Thanks & Regards
Rishi Sharma"

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2006-06-07 : 12:00:57

con.Open "Provider=sqloledb;Data Source=x.x.x.x;Initial Catalog=xxx;Integrated Security=SSPI"

Make sure you domain account is available in the SQL server.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources