• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 355
  • Last Modified:

Im trying to access the default database of Sql Server 2005. When i try to access the database, it shows error the as being mentioned above.

Can anyone provide me the steps to allow authorization for the database.
The database AdventureWorksDW is not accessible. (ObjectExplorer)
 
------------------------------
Program Location:
 
   at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.DatabaseNavigableItem.GetChildren()
   at Microsoft.SqlServer.Management.UI.VSIntegration.ObjectExplorer.SummaryView.get_Items()
   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)
   at Microsoft.SqlServer.Management.UI.VSIntegration.AppIDPackage.RightPaneListViewer.PopulateView()

Open in new window

0
premnathgingan
Asked:
premnathgingan
2 Solutions
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
is the database actually there?
is it online?
does the login you have permissions to that database?
0
 
premnathginganAuthor Commented:
Hi..finally i managed to solve the problem.
Actually, it is related to the authorization problem.
Thanks for the input.
0

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now