MSDE MSSQL Authentication
Posted on 2003-03-18
I am running XP Pro.
I have installed MSDE from the Office XP CD, this includes SQL Server for development, but not the full version.
I have setup user and system DSN's in ODBC for SQL Server, and tested the connections in ODBC, which are successful.
Trying to connect from an asp page (IIS 5.1) using either connection string or dsn, I get a logon failed message from SQL. Using either the 'Windows NT Authentication' or 'SQL Server Authentication', the problem is the same.
My question is:
How (where) can I specify login name? Is there a default login for SQL Server?
here is my connection string:
strSQLServer = "localserver"
strDatabase = "c:\MSSQL\DATA\mydata.mdf"
strUserID = "windowsuser"
strPassword = "windowspassword"
strConn = "Provider=SQLOLEDB;" & _
"Data Source=" & strSQLServer & ";" & _
"Initial Catalog=" & strDatabase & ";" & _
"User ID=" & strUserID & ";" & _
"Password=" & strPassword & ";" & _
"Persist Security Info=False;"
However, I am fairly sure that the connection string itself is fine,
I just need the correct username/password, or a way to set SQL Server to accept a username/password combination.