Error when connecting to SQL Express

Hi - can anyone please help?

I am using SQL Express 2005 - and have an asp (yes legacy asp) site running locally. It works ok, until I try and connect to the server from another PC.

The error message I get is:

******

Microsoft OLE DB Provider for SQL Servererror '80004005'

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

/fixitnew/fixit_login.asp, line 30

******

Line 30, is where I open the connection to the database.

My connection string is:

myConn = "Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=fixit;Data Source=misinvaknb01\sqlexpress;"

Can anyone please help?

Thanks in advance,

Mark

Hi

Default user has no permission to access fixit database . Follow those steps:

In Management Studio choose Security->Logins ->WindowsUserName->right click choose property->UserMapping -->Checkfixit database

Hope it helps.