У меня проблема с использованием SQL Server 2008 R2.
Недавно у меня возникла проблема с моим компьютером, и поэтому мне пришлось перезагружать окна и предоставлять разрешение от одного пользователя другому пользователю (используя функцию безопасности в свойствах). При выдаче разрешения изначально, хотя, через сообщение «Отказано в доступе».
После долгих исследований он прекратил эту ошибку (пользователь, которому я должен был предоставить разрешение тоже не был доступен), что вызвало еще одну проблему, но на этот раз в SQL Server. Он создает это сообщение;
База данных [dbName] недоступна. (ObjectExplorer)
Эта ошибка возникает, когда я пытаюсь выбрать опцию выпадающего списка, чтобы увидеть список таблиц и хранимых процедур базы данных в SQL Server. Я нашел объяснение этому по следующей ссылке:
И затем я попытался реализовать так:
Используя script, я создал (к счастью, до того, как эта проблема возникла) через множество сообщений;
Msg 15151, уровень 16, состояние 1, строка 1 Невозможно найти имя пользователя DBName\MyName, потому что оно не существует или у вас нет разрешения. Msg 262, уровень 14, состояние 1, строка 2 CREATE DATABASE разрешено в базе данных «master». Msg 5011, уровень 14, состояние 9, строка 1 У пользователя нет разрешения на изменение базы данных «DBName», база данных не существует или база данных не находится в состоянии, которое позволяет проверять доступ. Msg 5069, уровень 16, состояние 1, строка 1.
После этой кучи ошибок я стал отклеиваться и поэтому был бы очень благодарен, если бы кто-нибудь мог дать мне некоторые отзывы о том, что я могу сделать, чтобы решить эту проблему. Приветствия.
ОТВЕТЫ
Ответ 1
Как правило, это плохая идея предоставить разрешения для входа в систему. Вы должны создать объекты ролей в базе данных, и все разрешения в базе данных должны быть назначены ролям.
Ответ 2
Ответ 3
Кажется, что база данных, к которой вы пытаетесь получить доступ, не имеет прав администратора. Закройте SSMS и откройте его, выполнив команду «Администратор».
The database is not accessible objectexplorer что делать
Вопрос
The database AAAAA is not accessible. (ObjectExplorer)
at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.DatabaseNavigableItem.get_CanGetChildren() at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItem.RequestChildren(IGetChildrenRequest request) at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ExplorerHierarchyNode.BuildChildren(WaitHandle quitEvent)
Ответы
Working for solution as well.
Все ответы
Good Luck! Please Mark This As Answer if it solved your issue. Please Vote This As Helpful if it helps to solve your issue
Make sure you have permission to access this database. The login you have used to connect to the Instance does not have permission to use this database. Something like this will be needed:
Good Luck! Please Mark This As Answer if it solved your issue. Please Vote This As Helpful if it helps to solve your issue
Getting below error:- Msg 15023, Level 16, State 1, Line 1 User, group, or role ‘test’ already exists in the current database.
Its same user where its show the above mention error.
I feel the user you are using is Orphan user, can you execute this query & post result:
(Login with sysadmin, connect to the database & execute this one )
If the above query does NOT show your user as Orphan then execute this query in your database & try again:
(Login with sysadmin, connect to the database & execute this one )
Good Luck! Please Mark This As Answer if it solved your issue. Please Vote This As Helpful if it helps to solve your issue
Tried, The user name was not showing before.
Good Luck! Please Mark This As Answer if it solved your issue. Please Vote This As Helpful if it helps to solve your issue
Can you post the output of this query:
Good Luck! Please Mark This As Answer if it solved your issue. Please Vote This As Helpful if it helps to solve your issue
Please find the below given output, abcd is the user which I want to grant read and write access,
The database is not accessible objectexplorer что делать
This forum has migrated to Microsoft Q&A. Visit Microsoft Q&A to post new questions.
Answered by:
Question
The database AAAAA is not accessible. (ObjectExplorer)
at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.DatabaseNavigableItem.get_CanGetChildren() at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItem.RequestChildren(IGetChildrenRequest request) at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ExplorerHierarchyNode.BuildChildren(WaitHandle quitEvent)
Answers
Working for solution as well.
All replies
Good Luck! Please Mark This As Answer if it solved your issue. Please Vote This As Helpful if it helps to solve your issue
Make sure you have permission to access this database. The login you have used to connect to the Instance does not have permission to use this database. Something like this will be needed:
Good Luck! Please Mark This As Answer if it solved your issue. Please Vote This As Helpful if it helps to solve your issue
Getting below error:- Msg 15023, Level 16, State 1, Line 1 User, group, or role ‘test’ already exists in the current database.
Its same user where its show the above mention error.
I feel the user you are using is Orphan user, can you execute this query & post result:
(Login with sysadmin, connect to the database & execute this one )
If the above query does NOT show your user as Orphan then execute this query in your database & try again:
(Login with sysadmin, connect to the database & execute this one )
Good Luck! Please Mark This As Answer if it solved your issue. Please Vote This As Helpful if it helps to solve your issue
Tried, The user name was not showing before.
Good Luck! Please Mark This As Answer if it solved your issue. Please Vote This As Helpful if it helps to solve your issue
Can you post the output of this query:
Good Luck! Please Mark This As Answer if it solved your issue. Please Vote This As Helpful if it helps to solve your issue
Please find the below given output, abcd is the user which I want to grant read and write access,
The users within a particular domain group are having trouble accessing all the appropriate databases via their SQL Server Management Studio client. They receive the error message, “The database is not accessible. (Object Explorer).
Am I lacking some permissions. All the related databases are in a Multi_User mode, Normal Status.
I’m using SQL Server 2005 Mgmt Studio.
Thanks in advance for all the fwd solutions.
March 19, 2008 at 6:54 am
There should be some error code, severity state.. Please check them. Check SQL Server log files and application log.
. and your only reply is slàinte mhath
March 19, 2008 at 7:21 am
at Microsoft.SqlServer.Management.UI.VSIntegration.AppIDPackage.ListViewVirtualStorage.CopyItems(ISummaryView summaryView)
at Microsoft.SqlServer.Management.UI.VSIntegration.AppIDPackage.ListViewVirtualStorage..ctor(ISummaryView summaryView, List`1 columnDescriptors)
March 19, 2008 at 7:33 am
Are there any errors in the sQL error log from around the same time?
does that domain group have access to the DB in question?
Gail Shaw Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci) SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
March 19, 2008 at 8:18 am
Do they have any SSMS plugins installed? They also tend to screw things sometimes.
. and your only reply is slàinte mhath
March 19, 2008 at 8:53 am
The domain has all the relevent access to the related Dbs.
March 19, 2008 at 10:39 am
I had this once where you could not view the tables when someone was running a hugh update statement and then i could not view the tables. Is any process running that is active.
March 19, 2008 at 11:13 am
I think that your problem is as follow, someone as revoke the view existing databases to your user or from public.
revoke view any database from public
You could try one of the following command to try to revert the situation.
grant view any database to
grant view any database to public.
Hope this can help you.
December 1, 2010 at 10:57 am
I just had this occur with all user databases on one of our SQL 2005 servers. It turned out to be the database owner. The DBA’s domain account was the owner of two of the databases and there was no owner for several others. I changed the owner on these databases to ‘sa’ and access was once again granted for our developers.
I figure the original post has been long corrected, but this may help someone else in the future.
April 19, 2012 at 4:39 am
Recently had this issue.
Shrank the problem database log.
June 14, 2012 at 1:18 pm
Here’s something else to try, if you’ve come here looking for suggestions:
1. Log into SSMS as the user for whom the DB in question isn’t accessible.
2. Right-click on the inaccessible DB
3. Click ‘Properties’
If you see an error message indicating that a ‘Server Principal’ does not have access to the DB, re-login as ‘sa’ and give that ‘Server Principal’ access to the DB in question ( Logins->->Properties->User Mapping ).
This should open up the DB in question for the user who is getting the ‘inaccessible’ message.
Программы для автоматизации торговли, автоматизации ресторанов и кафе
Часовой пояс: UTC + 2 часа
MSSQL нет доступа к базе
Зарегистрирован: Чт май 10, 2012 11:34 am Сообщения: 996 Откуда (Город): Рязань Автоматизатор
Ошибка при попытке любых манипуляций через менеджмент студио:
The database BAR3 is not accessible. (ObjectExplorer)
at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.DatabaseNavigableItem.get_CanGetChildren() at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.NavigableItem.RequestChildren(IGetChildrenRequest request) at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.ExplorerHierarchyNode.BuildChildren(WaitHandle quitEvent)
See the end of this message for details on invoking just-in-time (JIT) debugging instead of this dialog box.
************** Exception Text ************** Microsoft.SqlServer.Management.Smo.PropertyCannotBeRetrievedException: Property IsManagementDataWarehouse is not available for Database ‘[BAR3]’. This property may not exist for this object, or may not be retrievable due to insufficient access rights. at Microsoft.SqlServer.Management.Smo.PropertyCollection.HandleNullValue(Int32 index) at Microsoft.SqlServer.Management.Smo.PropertyCollection.GetValueWithNullReplacement(String propertyName, Boolean throwOnNullValue, Boolean useDefaultOnMissingValue) at Microsoft.SqlServer.Management.Smo.PropertyCollection.GetValueWithNullReplacement(String propertyName) at Microsoft.SqlServer.Management.Smo.Database.get_IsManagementDataWarehouse() at Microsoft.SqlServer.Management.Reports.ReportContext.ProcessConnection() at Microsoft.SqlServer.Management.Reports.ReportContext.get_Version() at Microsoft.SqlServer.Management.Reports.ReportsManager.OnReportsDropDownOpening(Object sender, EventArgs e) at System.Windows.Forms.ToolStripDropDownItem.OnDropDownShow(EventArgs e) at System.Windows.Forms.ToolStripMenuItem.OnDropDownShow(EventArgs e) at System.Windows.Forms.ToolStripDropDownItem.ShowDropDownInternal() at System.Windows.Forms.ToolStripDropDownItem.ShowDropDown(Boolean mousePush) at System.Windows.Forms.ToolStripMenuItem.OnMenuAutoExpand() at System.Windows.Forms.MenuTimer.OnTick(Object sender, EventArgs e) at System.Windows.Forms.Timer.OnTick(EventArgs e) at System.Windows.Forms.Timer.TimerNativeWindow.WndProc(Message& m) at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
When JIT debugging is enabled, any unhandled exception will be sent to the JIT debugger registered on the computer rather than be handled by this dialog box.
