Browse by Tags

SQL Server 2008 crashes when the Sqlservr.exe program is configured to use large pages

Published 31 July 8 3:10 AM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2008 Enterprise Notification Contents: New and Major Modifications SQL Server 2008 crashes when the Sqlservr.exe program is configured to use large pages...

Filed under: sql server, error, kba, 2008, configuration, setup, crash

How to troubleshoot SQL Server 2008 Setup issues

Published 30 July 8 3:9 AM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2008 Enterprise Notification Contents: New and Major Modifications How to troubleshoot SQL Server 2008 Setup issues http://support.microsoft.com/kb/955396...

Filed under: sql server, kba, 2008, setup

SQL Server Cumulative Update uninstallation fiasco. Dude, can I remove SQL Server setup files?

Published 28 May 8 3:10 AM | SSQA.net

We have been struggling to uninstall the Cumulative Update package 7 on a development SQL Server! As it is an important aspect of installation to rollback or to have a backout plan tested if you are performing any kind of installation against your Production...

Filed under: sql server, kba, best practices, setup, cumulative update, installallation

SQL Server Clustering get pre-installation information and choose the best practices for your environment

Published 27 March 8 3:40 AM | SSQA.net

Before installing the SQL Server cluster there must be a checklist in order to ensure you haven't compromised on any hardcore requirement. In this regard Microsoft suggests the hardward that must be listed on this Windows Catalog and Hardware Compatibility...

Filed under: sql server, backup, services, windows, i/o, best practices, cluster, san, raid, setup, hcl, binaries, checklist

Transactional Replication Snapshot Issues - useful resources to resolve

Published 16 January 8 1:8 AM | SSQA.net

When you have problems with SQL Server replication where the transactional replication is common case in setting up, eventually you will have problems when the data is growing up and any sudden changes in the ETL will also have affect on replication process...

Filed under: sql server, microsoft, security, replication, merge, transactional, tips, setup, links

Settings to Cluster service domain account and the SQL Server service domain account

Published 10 January 8 2:56 AM | SSQA.net

When you are setting up SQL Server cluster you should think about security privileges that is required for the Cluster Administrator account and SQL Server services account. Do not attempt to use same account for both the serivces, as it will be single...

Filed under: sql server, authentication, account, active/passive, setup, bypass, spn, clusters, domain, cluadmin

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

SQL Server Database Mirroring error with TCP port numbers, firewall involvement

Published 13 September 7 10:35 AM | SSQA.net

Lately we have been getting complaints that database mirroring setup on few of our client's site were failing with TCP related errors. For more information these sites are involved within the firewall setup and active directory too. Initial workaround...

Filed under: sql server, database mirroring, error log, tcp, network, firewall, wan, failed, endpoint, setup