admin issues - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

Transact-SQL (2008)

admin issues

Author

Topic

Arun.G
Yak Posting Veteran

81 Posts

Posted - 2010-07-13 : 05:39:39

in front-end:
I am getting error at dynamic XML creation for Menu navigation. After login into application

Exception Details:-
“The SQL Server Service Broker for the current database is not enabled, and as a result query notifications are not supported. Please enable the Service Broker for this database if you wish to use notifications.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.InvalidOperationException: The SQL Server Service Broker for the current database is not enabled, and as a result query notifications are not supported.
Please enable the Service Broker for this database if you wish to use notifications.”

so i used the following statements to fix this issues:

ALTER DATABASE dbname SET NEW_BROKER WITH ROLLBACK IMMEDIATE;
ALTER DATABASE dbname SET ENABLE_BROKER;
SELECT is_broker_enabled FROM sys.databases WHERE name = 'dbname'

after issuing this staement, the front end is working fine.

but after some time ,again its throwing same error as mentioned above.

how to fix this?

yosiasz
Master Smack Fu Yak Hacker

1635 Posts

Posted - 2010-07-13 : 12:57:50

is there some other policy from ops (or are you ops yourself) sys admin, dba that is resetting those changes? also are you dealing with more than one database?

<><><><><><><><><><><><><><><><><><><><><><><><><>
If you don't have the passion to help people, you have no passion

Arun.G
Yak Posting Veteran

81 Posts

Posted - 2010-07-14 : 00:12:04

im the dbadmin and i restored the database for testing as same as my production db,

in testbuild db only its giving this error:for aspdev login, they dont have admin privilieges

if i give sysadmin privilege to aspdev means, its working fine

but if i revoke sysadmin privilege from aspdev means its giving the problem,

but as per company policy none other than dba nobody cant have sysadmin privilege

what to do?

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources