The database ABC is not accessible. (ObjectExplorer) [Resolved]

Posted by Sunil446 under Sql Server on 10/24/2011 | Points: 10 | Views : 37929 | Status : [Member] | Replies : 4
Hi,

I am facing this error after creation of database ABC in sql authentication mode login
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'm not able to view tables,etc. in sql authentication mode but in windows authentication mode.

Please Help
Thanks in Advance




Responses

Posted by: Sunil446 on: 10/25/2011 [Member] Starter | Points: 25

Up
0
Down

Resolved
Thanks,

i got admin permissions and I done with the things

Sunil446, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Yrajudba on: 10/25/2011 [Member] Starter | Points: 25

Up
0
Down
HI,

May be because of permissions...

Try to give full permissions and check the accessibility of database

Sunil446, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Sriramnandha on: 10/27/2011 [Member] Starter | Points: 25

Up
0
Down
U need to Give user Credentials on ABC DataBase

Right Click ABC Database on object Explorer select Properties and Give appropriate permission to the dataBase.

hope this will help

let me know any quesions...

Regards
Sriram,R

sriram

Sunil446, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Sriramnandha on: 10/27/2011 [Member] Starter | Points: 25

Up
0
Down
U need to Give user Credentials on ABC DataBase

Right Click ABC Database on object Explorer select Properties and Give appropriate permission to the dataBase.

hope this will help

let me know any quesions...

Regards
Sriram,R

sriram

Sunil446, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response