Browse by Tags

SQL Server Lockdown - Step by Step procedure

Published 13 February 8 2:31 AM | SSQA.net

Do you want to lockdown your SQL Server environment? Hope you dont'! Though it is not a good practice or recommendation to perform, but will atleast prove how far your SQL Server environment has securit compliance as per the industry best practices...

Filed under: sql server, microsoft, security, tools, article, sa, procedure, best practice, downloads, bpa, lock down

SQL Server consolidation and virtualization - hot topic in the industry

Published 12 February 8 5:35 AM | SSQA.net

I have no doubt in stating that Virtualization has become hot topic in the industry now a days, that is leading to consolidate your Database platform using available technologies. The main interest in getting this up is that virtualization can lower overall...

Filed under: sql server, microsoft, security, environment, sa, 2000, 2005, virtual server, vmware, operating system, windows server, benefit, costing

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

SQL Server database upgrade - FAQs, How-to, Gotchas, links and blurb

Published 22 January 8 7:55 AM | SSQA.net

Upgrading a SQL Server database should be straight-forward, when you haven't got much of constraints on the application code. In this regard we have blogged previously such as UpgrageTags posts. Here in this post I would like to go with few FAQs that...

Filed under: sql server, database, upgrade, best practices, sa, clustering, database mail, data files, FAQ, gotchas, sqlmail

How to perform Replication within different domains?

Published 18 December 7 12:15 PM | SSQA.net

Got a question via email asking to configure Transactional Replication between two servers with in SQL Server 2005. By all means I would like to refer this KBA http://support.microsoft.com/kb/321822 for replication between HOW TO: Replicate Between Computers...

Filed under: sql server, security, replication, sa, transactional, impersonate, internet, different, domains

How to make unwanted access to SQL Server 2005 by an operating system administrator more difficult

Published 12 October 7 5:55 AM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition, SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise X64 Edition Notification Contents: New and Major Modifications...

Filed under: sql server, security, kba, access, sa, system administrator, operation system

How to run Reporting Services 2000 and 2005 on the same server?

Published 8 October 7 3:45 PM | SSQA.net

When I was installing SQL Server 2005 last weekend, one of the first things I wanted to find out was whether I could run SSRS 2000 and SSRS 2005 on the same computer. Nothing was carved on the Books Online stone for SQL 2005 or 2000 versions, but I presume...

Filed under: sql server, report builder, sa, 2000, 2005, repoting services, configuration, setup, rsconfig

FIX: The status of the shared schedule appears as Paused after you click Resume when you use Report Manager in SQL Server 2005 Reporting Services SP2

Published 8 October 7 2:48 PM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Reporting Services Notification Contents: New, All Modifications and Delete FIX: The status of the shared schedule appears as Paused after you click...

Filed under: sql server, sp2, report builder, kba, sa, reporting services, report manager, schedule

How to use Kerberos authentication in SQL Server

Published 8 September 7 4:19 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 How to use Kerberos authentication in SQL...

Filed under: sql server, kba, sa, authentication, kerberos

Disable SA account on a live SQL Server2005 instance, any drawbacks?

Published 13 August 7 4:3 AM | SSQA.net

Last week I have been delegated to finalize the security standards within a set of SQL 2005 instances that are used by a customer, though it is usual chores for me to apply industry best practices. On these SQL 2005 instances in particular I was more...

Filed under: sql server, management, microsoft, security, windows, login, sa, disable, authentication, mixed

Disaster Recovery: What to do when the SA account password is lost in SQL Server 2005

Published 24 July 7 6:21 AM | SSQA.net

As a DBA you might have come across this situation where you have forgotten the sa password for SQL Server - so what can you do? If you are experienced with such situation then definetly you might have an alternative solution to keep the passwords in...

Filed under: sql server, security, disaster recovery, sa, password, sysadmin, privilege

Error message when you install SQL Server 2005: "Cannot alter the login 'sa', because it does not exist or you do not have permission"

Published 12 June 7 12:36 PM | SSQA.net

Source: Knowledge Base Product: Microsoft SQL Server 2005 Standard Edition Notification Contents: New and All Modifications Error message when you install SQL Server 2005: "Cannot alter the login 'sa', because it does not exist or you do...

Filed under: sql server, security, login, kba, permission, sa