Home Forums SQL Server 2008 SQL Server 2008 - General Cannot open database “” requested by the login. The login failed. Login failed for user 'sa' RE: Cannot open database “” requested by the login. The login failed. Login failed for user 'sa'

  • I see now, that entire path statement is your database name. You do not name the database as a path statement to a file. SQL does not work that way. You simply name the database a single, descriptive name. Like "Recipe" or "ClubMembers" The database name is only a name that you will refer too. Now, if you place that entire path statement name as the name of your database, in your connection string, you will be able to connect successfully. But I would be that you will have a time trying to use a path statement in the connection string, without some sort of escape character.

    Rename the database to a normal name.

    Andrew SQLDBA