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 |
|
ourspt
Starting Member
33 Posts |
 Posted - 2005-02-24 : 07:09:36
|
| Hi,I am working on a .NET application (VB.NET). We had to restore our SQL server database from yesterday's backup as we accidentally overwrote some tables. After restorign, we are able to log to the database alright from SQL Query analyzer and Enterprise manager but when we try to access it from the .NET application, it gives an error message "Cannot open database requested in login '****' login fails.Login failed for user '****'". What could be the reason and what would be the solution?Thanks in advance |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-02-24 : 13:36:05
|
| Did you unorphan the users? Did you check to make sure that the default databases are correct for all users?Tara |
 |
|
|
|
|
|
Conneting to DB after Restoration