May 28, 2009 at 8:59 pm
Hi,
The following is the error i am facing while i am trying to open my site as well as while connecting to data base and the error number is 4064.What are the steps to be followed to fix this problem.
Cannot open database "xxxx" requested by the login. The login failed. Login failed for user 'xxxxxx'.
I have found this query inorder to get back the data base to online, Where should this query run
ALTER DATABASE database-name SET ONLINE
Thanks for the quick respones,
Narendra.
May 28, 2009 at 9:21 pm
Hello,
Do you have SSMS (SQL Server Management Studio) installed on the Database Server? If so you can execute your SQL Statement from a Query Window within SSMS. You can also right click on the DB in the Object Explorer Window of SSMS and select the "Tasks...", “Bring Online” option.
BTW - Are you sure the problem is that the DB is Offline? What was the full Error Message that you get, including Level and State?
Regards,
John Marsh
www.sql.lu
SQL Server Luxembourg User Group
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply