Greetings,

I have a local environment on my Windows 7/SQL Express 2008/IIS 7 laptop. I am working on getting some asp code with vb script to work.

I am working on a project from work and need to setup a test/development area.

Here is the error and part of the code:

Error:
Microsoft OLE DB Provider for SQL Server error '80004005'

Cannot open database "DBName" requested by the login. The login failed.

/servermgmt/framelist.asp, line 51

Code:
<%@ Language=VBScript %>
<%
Dim sConnection, objConn , objRS

sConnection = "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=DBName;Data Source=LAPTOP1\SQLEXPRESS;"


Set objConn = Server.CreateObject("ADODB.Connection")  "****** Line 51 ******"

objConn.Open(sConnection)
Set objRS = objConn.Execute("SELECT SERVER_NAME, Primary_IP, STATUS,  FROM server WHERE STATUS <> 'Decommissioned' ORDER BY SERVER_NAME")

additional code....
%>
Let me know if more information is needed.

The page name is serverlist.asp.