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.
| Author |
Topic |
|
amalafrida
Starting Member
2 Posts |
 Posted - 2008-11-25 : 15:18:28
|
| 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:03:58
|
| Want to tell us what you're trying to connect with. You told us (twice) that you can connect with Management Studio, but you didn't tell us what you cannot connect with. |
 |
|
|
darkdusky
Aged Yak Warrior
591 Posts |
Posted - 2008-12-02 : 10:44:50
|
| In Management Studio under Security check what permissions your login has and if it is a member of any Server Roles. Compare the login's rights on northwind and on the newly created tables. Make sure you open Management Studio with the same login as you are having problems with elsewhere. |
|
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2008-12-02 : 16:09:19
|
| Are you using Windows logon or SQL Server logon?Jack Vamvas--------------------http://www.ITjobfeed.com |
|
|
|
|
|
|
Login failed: cannot open database