Could not open database; Login Failed

Asked By Jorge Millicent 10 points N/A Posted on - 01/10/2012

Hello! As we are working on a project, we are experiencing some difficulties working on mdf database. We used Visual Studio 2008 Pro Edition in building our website that is created by C# Programming.

We made a database through Server ExplorerData connectionsCreate New SQL Server Database and insert localhostSQLEXPRESS and named the database as Event_Companio_Database. And then I moved the database mdf and ldf file from the primary location to App_Data folder.

But I could not rebuild connection with this error

Microsoft Visual Studio

Cannot open database “Event_Companion_Database” requested by the login. The login failed. Login failed for the user ‘Compal_FrancisInferno FS’.

Help me on this please.

• Status: Open
• Question Views: 1203
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS SQL Server

Answered By Mathew Stone 0 points N/A #120225

Could not open database; Login Failed

Are you using the right login credentials to access the database? From the error message above it seems that the error is caused by the login credentials that you are using. The issue is probably:

• You have forgotten the login credentials that you need to use to access the database. You should try using the default system login username and password and see if that will help you gain access to the database.
• .The SQL server may be experiencing some sort of problem, and therefore you will need to restart it, and also restart the computer and see if that will help resolve the issue.

-Mathew Stone

About Mathew Stone

Questions
0

Answers
99

Best Answers
15

• Vote Up 0 Vote Down

• Posted on - 01/10/2012
• Question Category: MS SQL Server