SqlServer-QA.net

You may be thinking installing SQL Server 2008 Express Edition is easy, yes it is when you have simple terms of usage.  No issues for version 2005 though, just keep in mind about SQL Server 2008 installation when Visual Studio 2008 is/isn't present? issues to resolve. Just to talk in list of documentation, SQL Server Express makes ...

In continuation to the SQL2008-InstallationVows on Windows Server 2008 there was a brief notes on pre-requisite of Visual Studio 2008 Service Pack when you are trying to install the SQL setup. The release notes were bit confusing that you have got with setup files. To correct the confusion and make it more clear Microsoft released the ...

After I knew about the SQL 2008 RTM release news I have blogged SQL2008RTM-official here and as usual I have attempted to download the setup media from Technet which took a while (3 hours) to download the file, due to the obvious reasons of MSDN/TEchnet premium subscribers all over the world were attempting the same. Ok, I have got ...

The following pages were recently modified. Source: Knowledge BaseProduct: Microsoft SQL Server 2005 Enterprise Edition, SQL Server 2005 Standard Edition & SQL Server 2005 Enterprise X64 EditionNotification Contents: New SQL Server 2005 installers do not update an instance of the SQL Server service that is in a disabled ...

The following pages were recently modified. Source: Knowledge BaseProduct: Analysis Cubes for Microsoft SQL Server 2005Notification Contents: New and All Modifications How to install Analysis Cubes for Microsoft Dynamics GPhttp://support.microsoft.com/kb/945953/en-US

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 default when you change the name of the computer that is running SQL 2000 version, the ...

The following pages were recently modified. Source: Knowledge BaseProduct: Microsoft SQL Server 2005 Enterprise EditionNotification Contents: New and Major Modifications You cannot rebuild system databases if you run the Setup command from a location that is not the original installation location of SQL Server ...

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 install options. When the installation fais always best to check the error log for the reason ...

The following pages were recently modified. Source: Knowledge BaseProduct: Microsoft SQL Server 2005 Standard EditionNotification Contents: New and All Modifications You receive an error message when you try to uninstall the second named instance of SQL Server 2005http://support.microsoft.com/kb/915854/en-US

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 changes yes, you can change the name of an instance as long as the server is not ...