Browse by Tags

KBA: Articles on SQL Server 2005, 2000 & MSDE Installation issues

Published 12 June 8 10:2 PM | 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 SQL Server 2005 installers...

Filed under: sql server, instance, kba, installation, 2000, 2005, msde

How to install Analysis Cubes for Microsoft Dynamics GP

Published 23 December 7 4:33 PM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Analysis Cubes for Microsoft SQL Server 2005 Notification Contents: New and All Modifications How to install Analysis Cubes for Microsoft Dynamics GP http://support.microsoft...

Filed under: sql server, microsoft, olap, kba, installation, dynamics, gp, analysis cubes

Rename a SQL Server instance, a little catch

Published 14 December 7 4:4 AM | SSQA.net

Can I rename an instance of SQL Server after I have already installed it on the computer? Simple answer is Yes and you can change the name of an instance as long as the server is not clustered. There is a little catch between 2000 and 2005 version, by...

Filed under: sql server, msdn, technet, instance, read, best practices, installation, servers, rename, local

Unable to install SQL Server Express - Error SQL Server service failed to start?

Published 7 November 7 1:33 PM | SSQA.net

Imagine a simple installation of SQL Server Express 2005 edition fails with an error "SQL Server service failed to start?" Whether it may be on a X64 based operating system or on a simple desktop with XP PRO, as usual you would go with default...

Filed under: sql server, microsoft, services, error, sql express, installation, encryption, build, log file, 15029

You receive an error message when you try to uninstall the second named instance of SQL Server 2005

Published 31 October 7 9:4 AM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Standard Edition Notification Contents: New and All Modifications You receive an error message when you try to uninstall the second named instance of...

Filed under: sql server, error, kba, installation, uninstall, named instance

Rename a SQL Server instance, is it possible?

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

Another common question on the forums, may be not a frequently performed task and as a DBA you should discourage in performing such actions. Microsoft SQL development team has already documented the information over the KBA 303774 and for the server name...

Filed under: sql server, msdn, microsoft, instance, kba, installation, FAQ, developement, rename

A fatal error occurred while reading the input stream from the network. The session will be terminated. Error: 4014, Severity: 20, State: 2

Published 1 October 7 4:40 AM | SSQA.net

This is a typical error you would get when a SSIS package is executed that involves remote server connectivity. Basically on the error note it will clearly identified as a network related issue. Similar issue happened at our end whereas the SSIS package...

Filed under: sql server, performance, ssis, trace, update, error, kba, installation, instances, 4014, netmon

How to find who installed the SQL Server instance?

Published 25 September 7 7:18 AM | SSQA.net

So who installed the SQL Server, how can you find it? This was the question asked by an user when I was sitting in SQLPASS SQL Lounge to help the users. The question was obvious and interesting to answer. Until SQL Server version 2000 you could refer...

Filed under: sql server, installation, path, log file, who

SQL Server Express installation error: System Configuration Checker Fails with "Performance Monitor Counter Check Failed" Message

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

While installing SQL Server Express 2005 you might have come across the error: System Configuration Checker Fails with "Performance Monitor Counter Check Failed" Message As you have seen that one of the README file for SQL 2005 installation...

Filed under: sql server, security, read, sql express, installation, registry, perflib, everyone

How to install SQL Server 2005 Reporting Services on a Windows Vista-based computer

Published 5 September 7 4:9 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 How to install SQL Server 2005 Reporting Services on a Windows Vista-based...

Filed under: sql server, kba, vista, installation, reporting services

How to rebuild or move a MSDTC installation to be used with a SQL failover cluster

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

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise Edition Notification Contents: New and All Modifications How to rebuild or move a MSDTC installation...

Filed under: sql server, high availability, kba, installation, clustering, msdtc, failover

KBA:The service pack update or hotfix installation stops unexpectedly when you try to install either Microsoft SQL Server 2005 Service Pack 2 or a hotfix for SQL Server 2005 SP2

Published 10 July 7 4:48 PM | SSQA.net

Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition, SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise X64Edition Notification Contents: New and Major Modifications The service pack update or hotfix installation...

Filed under: sql server, sp2, kba, hotfix, installation

Error message when you install SQL Server 2005: "Beta components detected"

Published 11 June 7 4:32 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: "Beta components detected" http://support.microsoft.com/kb/919394/en...

Filed under: sql server, beta, kba, installation