Browse by Tags

SQL Server 2005 Agent XPs disabled error - how to resolve this issue?

Published 6 February 8 2:38 AM | SSQA.net

When SQL Server 2005 Management Studio's Object Browser shows the SQL Server Agent service with a red down arrow and the text Agent XP's disabled , the service is not started or disabled. This used to be a problem prior to Service Pack 2 for SQL...

Filed under: sql server, profiler, security, services, sqlagent, sa, error log, msdtc, group policy

Database Mirroring sys.sp_dbmmonitorupdate stored procedure fails with error "Incorrect syntax near '-'"

Published 12 November 7 3:23 AM | SSQA.net

Recently got stuck with the stored procedure sys.sp_dbmmonitorupdate which is used to monitor the database mirroring session. As usual you could do using the GUI tool, but sometimes using TSQL methods is good enough to see what is happening on your system...

Filed under: sql server, security, bug, database mirroring, error log, 2005, stored procedure, monitoring, hyphen, connect site

Configure Reporting Services on a DMZ environment?

Published 2 October 7 11:29 AM | SSQA.net

Few things you need to consider before letting the users use Reporting Services within a DMZ environment where the Servers are exposed to the INternet and to safeguard the servers from hackers. In this case you must be aware that SQL Server uses TCP port...

Filed under: sql server, integration, security, error log, reporting services, internet, dmz, browser

Some or all SQL Server 2005 services are not listed in SQL Server Configuration Manager, or you receive a "No SQL Server 2005 components were found" error message when you perform operations in SQL Server 2005 Surface Area Configuration

Published 4 September 7 11:41 AM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition & SQL Server 2005 Standard Edition Notification Contents: New and Major Modifications Some or all SQL Server 2005 services are...

Filed under: sql server, security, kba, error log, surface, configuration, area, components, operations