Home > The Database > The Database Is Not Accessible After Restore

The Database Is Not Accessible After Restore

Contents

Check SQL Server log files and application log.Piotr ...and your only reply is slĂ inte mhath Post #471537 Ambuj MathurAmbuj Mathur Posted Wednesday, March 19, 2008 7:21 AM SSC Rookie Group: General Can an aspect be active without being invoked/compeled? You cannot edit other events. You cannot post events. this content

SQL Server Forums Profile | ActiveTopics | Members | Search | ForumFAQ Register Now and get your question answered! Report Abuse. If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site.Would you like to participate? Before I leave my company, should I delete software I wrote during my free time? http://stackoverflow.com/questions/26200697/sql-server-login-success-but-the-database-dbname-is-not-accessible-object

The Database Is Not Accessible After Restore

Plus if somebody accidentally creates an object, at least it's in a throwaway database instead of something like Master or Sales. Sign in to make your opinion count. The database is not accessible(ObjectExplorer) The database ABC is not accessible. (ObjectExplorer) ------------------------------ Program Location: at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.DatabaseNavigableItem.get_CanGetChildren() at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItem.GetChildren(IGetChildrenRequest request) at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ExplorerHierarchyNode.BuildChildren(WaitHandle quitEvent) I am not Join them; it only takes a minute: Sign up Here's how it works: Anybody can ask a question Anybody can answer The best answers are voted up and rise to the

So I tried to drop the LOGIN, which is followed by the above error. –Manoj Maximum Oct 5 '14 at 8:17 So if you have a login IRON\Manoj_2 with You cannot send private messages. Logos, company names used here if any are only for reference purposes and they may be respective owner's right or trademarks. | 10/30/2016 8:57:29 AM current community blog chat Server Fault Sql Server The Database Is Not Accessible Single User Is gasoline an effective restoration material to use?

Group: General Forum Members Last Login: Friday, March 6, 2015 8:16 AM Points: 800, Visits: 1,761 There should be some error code, severity state.. Lynda.com 136,333 views 9:12 How to allow remote connections to SQL Server Express - Duration: 6:25. Seems this is the error you get when it is just starting up. http://www.sqlservercentral.com/Forums/Topic471503-146-1.aspx Our new SQL Server Forums are live!

Solutions? The Database Is Not Accessible Windows Authentication share|improve this answer edited Oct 5 '14 at 8:32 answered Oct 5 '14 at 7:55 Avinash Babu 4,0231718 Tried to re-add the user and I got the error, while more stack exchange communities company blog Stack Exchange Inbox Reputation and Badges sign up log in tour help Tour Start here for a quick overview of the site Help Center Detailed asked 2 years ago viewed 69211 times active 1 month ago Related 1678Add a column, with a default value, to an existing table in SQL Server116Checking if a SQL Server login

The Database Is Not Accessible. (object Explorer) Restoring

Join them; it only takes a minute: Sign up SQL Server : login success but “The database [dbName] is not accessible. (ObjectExplorer)” up vote 15 down vote favorite 2 I am What are the exact error messages listed for this database?Are the SAN drives available? The Database Is Not Accessible After Restore You cannot delete other events. Sql Server Management Studio 2012 The Database Is Not Accessible During investigation i have found that if user given sysadmin rights then user access to it and no such error but not as db_owner.

kudvenkat 211,502 views 16:49 SESSION: 10 Query Tuning Techniques Every SQL Programmer Should Know (Kevin Kline, Aaron Bertrand) - Duration: 1:34:44. http://linuxprofilm.com/the-database/the-database-function-48-reported-error-820e.html You cannot post new polls. Urg! –user1019042 Apr 15 at 16:23 Why the downvote ? techsapphire 1,155 views 2:32 Loading more suggestions... One Or More Databases Are Inaccessible And Will Not Be Displayed In List

You cannot edit your own events. Shrank another ldf on that drive to free a bit of space, bounced SQL - db came online. Loading... have a peek at these guys Working...

But the system took the new account as "Manoj_2". The Database Is Not Accessible Sql Server 2014 Your name or email address: Do you already have an account? Is any process running that is active.

Notify me of new posts via email. « [FIX] "Microsoft.Silverlight.Csharp.Targets" was not found error in VisualStudio Disable Network Manager Service in CENTOS6 » Recent Posts [FIX]Outlook 2010 Error: "Cannot start Microsoft

So I logged in with the other user(you can create a new one) and checked the ckeck box 'sysadmin' from: Security --> Logins --> Right ckick on your SQL user name Post #471626 TRACEY-320982TRACEY-320982 Posted Wednesday, March 19, 2008 10:39 AM Right there with Babe Group: General Forum Members Last Login: Friday, June 5, 2015 2:42 PM Points: 725, Visits: 1,006 I When is remote start unsafe? The Database Dbname Is Not Accessible. (object Explorer) GilaMonster Flowing Fount of Yak Knowledge South Africa 4507 Posts Posted-03/08/2012: 06:20:43 Look in the SQL error log.

If he/she could, then there is something different at the user's machine setting and not in the database. –NoChance Aug 1 '12 at 14:55 I had him log in Is it dangerous to use default router admin passwords if only trusted users are allowed on the network? current community blog chat Database Administrators Database Administrators Meta your communities Sign up or log in to customize your list. http://linuxprofilm.com/the-database/the-database-function-61-reported-error-c042.html SQL server - Duration: 2:32.

But still the problem persists. This feature is not available right now. You cannot delete your own topics. You cannot rate topics.

Was able to login as the user after readding the user after the restore. For example, say I set you up a login in the Sales database, and then I right-click on your login in SSMS and change your default database to master - but share|improve this answer answered Apr 8 '11 at 7:34 Sankar Reddy 1,29477 add a comment| up vote 0 down vote accepted Update Well, after restarting my computer, it all started working Sign in 2 Loading...

Number sets symbols in LaTeX Is gasoline an effective restoration material to use? The database ABC is not accessible. (ObjectExplorer) [Resolved] Posted by Sunil446 under Sql Server on 10/24/2011 | Points: 10 | Views : 34622 | Status : [Member] | Replies : 4 What is way to eat rice with hands in front of westerners such that it doesn't appear to be yucky? either with OS or with SQL Server sql-server login share|improve this question edited Oct 5 '14 at 8:08 marc_s 455k938711033 asked Oct 5 '14 at 7:50 Manoj Maximum 1241110

You cannot post HTML code. SQLugSWE 35,461 views 1:06:09 SQL Server Query Plan Analysis: The 5 Culprits That Cause 95% of Your Performance Headaches - Duration: 1:12:39. All rights reserved.Terms of Use|Trademarks|Privacy Statement|Site Feedback Log in :: Register :: Not logged in Home Tags Articles Editorials Stairways Forums Scripts Videos Blogs QotD Books Ask SSC Starting SQL Server in single-user mode enables any member of the computer's local Administrators group to connect to the instance of SQL Server as a member of the sysadmin fixed server

I used to create new login in SQL Server for "Manoj_2", with default DB as "master". Try this from a query window: use ; exec sp_changedbowner 'sa'; It should then allow you to browse the DB in the SSMS explorer.