MS SQL Database Connection

I'm trying to create a connection to an MS SQL database from ASP. I'm trying to make this connection without using DSN. This is what I have right now:

strconn="Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=;Data Source=;"
set conntemp=server.createobject("adodb.connection")
conntemp.open strconn

I am trying to use Windows integrated security to log onto the server, as opposed to providing a username 'n password. However, the error I keep getting is:

Error Type:
Microsoft OLE DB Provider for SQL Server (0x80040E4D)
Login failed for user '\'.

It continues to fail on the line where the connection is opened (conntemp.open strconn). Microsoft's knowledgebase says that error message "indicates problem with the SQL Server configuration for Windows NT authentication".

Any ideas on why that would be? BTW, I am using SQL Server Enterprise Manager to access my db.

"Initial Catalog" should be the name of the database you are trying to connected to.

The connection is to the DBMS, so you should specify which database you actually want to talk to as there could possibly be many to choose from.

This may or may not be your problem, but you should fill it in and find out.

also try making a file name test.udl on your desktop and double clicking on the icon/shortcut. you should be able to make your connection string there.