SQL Connection

[mugun]

Hello pals, I need help in SQL Connection from ASP Page.

Dim conn

Set conn = Server.CreateObject("ADODB.Connection")

conn.ConnectionString = "Provider=SQLOLEDB;"_
& "User ID=dontknow;Password=dontknow;"_
& "Initial Catalog=PUBS;"_
& "Data Source=MUGUN"

conn.Open

The Problem is i am using Windows Authentication. So I didn't use SQL Server Authentication. How to solve this problem?

Should I use SQL Server Authentication?
Thank you in advanced.

[MAK]

http://msdn.microsoft.com/library/de...osqlserver.asp

[Frank]

Also keep thsi URL for all kinds of connections ->

http://www.connectionstrings.com/


FK