dbTalk Databases Forums  

Error 916 When Connecting SQL Server 2008 Management Studio To SQL

Go Back dbTalk Databases Forums Databases microsoft.public.sqlserver.tools Error 916 When Connecting SQL Server 2008 Management Studio To SQL

microsoft.public.sqlserver.tools microsoft.public.sqlserver.tools


Discuss Error 916 When Connecting SQL Server 2008 Management Studio To SQL in the microsoft.public.sqlserver.tools forum.



Reply
Page 4 of 4 < 1 2 3 4
 
Thread Tools Display Modes
  #31  
Old   
Aaron Bertrand [SQL Server MVP]
 
Posts: n/a

Default Re: Error 916 When Connecting SQL Server 2008 Management Studio ToSQL - 09-23-2008 , 05:49 AM





Quote:
point, there is an object that has a contract to fulfil, which it cannot do
without querying the universe. I found the other day, that when you script a
database, the script wizard goes querying information for each database. And
if a datbase is offline because it's set to auto-close...
Yes, that one is pretty bad.

Quote:
Well, at least you are admin so that you can continue. If you are a customer
at a web host, you are slapped in the face badly, and is told to keep out.
Yes, and apart from Connect and the MVP group, I voiced my concern about
this quite loudly to my lead. Hopefully this gets some priority for SP1.



Reply With Quote
  #32  
Old   
Aaron Bertrand [SQL Server MVP]
 
Posts: n/a

Default Re: Error 916 When Connecting SQL Server 2008 Management Studio ToSQL - 09-23-2008 , 05:49 AM





Quote:
point, there is an object that has a contract to fulfil, which it cannot do
without querying the universe. I found the other day, that when you script a
database, the script wizard goes querying information for each database. And
if a datbase is offline because it's set to auto-close...
Yes, that one is pretty bad.

Quote:
Well, at least you are admin so that you can continue. If you are a customer
at a web host, you are slapped in the face badly, and is told to keep out.
Yes, and apart from Connect and the MVP group, I voiced my concern about
this quite loudly to my lead. Hopefully this gets some priority for SP1.



Reply With Quote
  #33  
Old   
Aaron Bertrand [SQL Server MVP]
 
Posts: n/a

Default Re: Error 916 When Connecting SQL Server 2008 Management Studio ToSQL - 09-23-2008 , 05:49 AM


Quote:
point, there is an object that has a contract to fulfil, which it cannot do
without querying the universe. I found the other day, that when you script a
database, the script wizard goes querying information for each database. And
if a datbase is offline because it's set to auto-close...
Yes, that one is pretty bad.

Quote:
Well, at least you are admin so that you can continue. If you are a customer
at a web host, you are slapped in the face badly, and is told to keep out.
Yes, and apart from Connect and the MVP group, I voiced my concern about
this quite loudly to my lead. Hopefully this gets some priority for SP1.



Reply With Quote
  #34  
Old   
Aaron Bertrand [SQL Server MVP]
 
Posts: n/a

Default Re: Error 916 When Connecting SQL Server 2008 Management Studio ToSQL - 09-23-2008 , 05:49 AM


Quote:
point, there is an object that has a contract to fulfil, which it cannot do
without querying the universe. I found the other day, that when you script a
database, the script wizard goes querying information for each database. And
if a datbase is offline because it's set to auto-close...
Yes, that one is pretty bad.

Quote:
Well, at least you are admin so that you can continue. If you are a customer
at a web host, you are slapped in the face badly, and is told to keep out.
Yes, and apart from Connect and the MVP group, I voiced my concern about
this quite loudly to my lead. Hopefully this gets some priority for SP1.



Reply With Quote
  #35  
Old   
Aaron Bertrand [SQL Server MVP]
 
Posts: n/a

Default Re: Error 916 When Connecting SQL Server 2008 Management Studio ToSQL - 09-23-2008 , 05:49 AM


Quote:
point, there is an object that has a contract to fulfil, which it cannot do
without querying the universe. I found the other day, that when you script a
database, the script wizard goes querying information for each database. And
if a datbase is offline because it's set to auto-close...
Yes, that one is pretty bad.

Quote:
Well, at least you are admin so that you can continue. If you are a customer
at a web host, you are slapped in the face badly, and is told to keep out.
Yes, and apart from Connect and the MVP group, I voiced my concern about
this quite loudly to my lead. Hopefully this gets some priority for SP1.



Reply With Quote
  #36  
Old   
Aaron Bertrand [SQL Server MVP]
 
Posts: n/a

Default Re: Error 916 When Connecting SQL Server 2008 Management Studio ToSQL - 09-23-2008 , 05:49 AM


Quote:
point, there is an object that has a contract to fulfil, which it cannot do
without querying the universe. I found the other day, that when you script a
database, the script wizard goes querying information for each database. And
if a datbase is offline because it's set to auto-close...
Yes, that one is pretty bad.

Quote:
Well, at least you are admin so that you can continue. If you are a customer
at a web host, you are slapped in the face badly, and is told to keep out.
Yes, and apart from Connect and the MVP group, I voiced my concern about
this quite loudly to my lead. Hopefully this gets some priority for SP1.



Reply With Quote
  #37  
Old   
Aaron Bertrand [SQL Server MVP]
 
Posts: n/a

Default Re: Error 916 When Connecting SQL Server 2008 Management Studio ToSQL - 09-23-2008 , 05:49 AM


Quote:
point, there is an object that has a contract to fulfil, which it cannot do
without querying the universe. I found the other day, that when you script a
database, the script wizard goes querying information for each database. And
if a datbase is offline because it's set to auto-close...
Yes, that one is pretty bad.

Quote:
Well, at least you are admin so that you can continue. If you are a customer
at a web host, you are slapped in the face badly, and is told to keep out.
Yes, and apart from Connect and the MVP group, I voiced my concern about
this quite loudly to my lead. Hopefully this gets some priority for SP1.



Reply With Quote
  #38  
Old   
Patil
 
Posts: n/a

Default RE: Error 916 When Connecting SQL Server 2008 Management Studio To SQL - 01-26-2009 , 08:29 PM


Try the following... it worked for me.

http://blog.cpugeni.com/archive/2008...error-916.aspx

"Sorin Dolha" wrote:

Quote:
I installed a SQL Server 2008 Express today on my local machine, and after a
successful local installation, I tried to connect (from the SQL Server 2008
Management Studio) to an instance of SQL Server 2005 Express on a network
server. It connected successfully but it failed when loading the databases
list (i.e. expanding the Databases node) with error 916, indicating that my
account didn't have permission on the Report Services Temp Database.

I resolved this by logging in with Administrator on the server and adding a
user mapping for all Domain Users to that database, keeping only Public as
permission, so not giving actually any new permissions for the database (my
account is a domain user). After that it loaded fine.

Anyway, other databases seemed to have the exact same configuration as the
temporary database of Reporting Services 2005 but didn't fail like that, so I
don't have an explanation for the issue, just the workaround above. To be
sure that this doesn't happen again I added the same user mapping on all
other databases on the server so that all domain users can browse the
databases themselves without having permission to read/write any tables.

I think this is a bug in the new SQL Server 2008 Management Studio as 2005
Management Studio didn't have this problem.

Update: I found out that the database with problems had a database state (in
Properties/Options) of NORMAL | SHUTDOWN. I found that when a database is in
SHUTDOWN state, the problem occurs. To temporarily resolve the issue you just
need to issue a query on the database and its state will become NORMAL
(without SHUTDOWN) and then SQL Server 2008 Management Studio will browse the
databases correctly. But it's probably only a matter of time until SHUTDOWN
state becomes applied again.

If anyone has a better understanding or resolution for this issue, please
let me (and all others) know.

Sorin Dolha, DlhSoft

Reply With Quote
  #39  
Old   
Aaron Bertrand [SQL Server MVP]
 
Posts: n/a

Default Re: Error 916 When Connecting SQL Server 2008 Management Studio ToSQL - 01-27-2009 , 05:38 PM


This is apparently fixed in CU3. See:

http://support.microsoft.com/kb/958760





On 1/26/09 9:29 PM, in article
5AF19E97-9A15-46C8-9DA9-7FD4E42CD24A...soft (DOT) com, "Patil"
<Patil (AT) discussions (DOT) microsoft.com> wrote:

Quote:
Try the following... it worked for me.

http://blog.cpugeni.com/archive/2008...management-stu
dio-2008-error-916.aspx


Reply With Quote
Reply
Page 4 of 4 < 1 2 3 4

« Previous Thread | Next Thread »



Thread Tools
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.


Contact Us - dbTalk Databases Forums - Archive - Top