Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Login failed: cannot open database

Author  Topic 

amalafrida
Starting Member

2 Posts

Posted - 2008-11-25 : 15:04:07
I've programatically created a simple Sql server database. Added a table and a row or two of data. But cannot connect to it.

Receive error message: Cannot open database <database name> requested by the login. The login failed. Login failed for user ...>

I can examine the database with SqlServer Management Studio. The database is there. Table, ditto. Table data, same.

I tried creating a database in Management Studio. Created fine, but cannot open. Receive same error message. Northwind database opens with no problem.

Permissions problem likely. But what do?

Any suggestions?

Thanks in advance.

R. Mullin

snSQL
Master Smack Fu Yak Hacker

1837 Posts

Posted - 2008-11-25 : 23:09:22
Duplicate post - http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=115182
Go to Top of Page
   

- Advertisement -