Need someone to help me get sql installed and running-Collection of common programming errors

Hi Sboney,

>>the error message ” An instance with the same name is already installed on this computer. To proceed with SQL Server Setup, provide a unique instance name”.

This error launched might be related to two issues as below. 1.  An instance with the same name already exists. This could be either a default or named instance. Please try to check any default instance or any named SQL Server instance with the same name as you tried to install,  that has been already installed in your system. if so, you need to uninstall the default instance first or rename the new instance you want to install.

If the default server instance existed, you can try to uninstall first, and then try to install SQL Server 2005 default again. Please go>> Control Panel\System and Security\Administrative Tools\Services, you will see as below if you have installed the default server instance already.

To uninstall instance you can follow the steps as below:  Start menu, click Control Panel, and then double-click Add or Remove Programs.

1. Select the SQL Server component to uninstall, and then click Change/Remove. This will start the SQL Server Installation Wizard. 2. Setup Support Rules will run to verify your computer configuration. To continue, click Ok. 3. On the Select Instance page, use the drop-down box to specify an instance of SQL Server to remove, or specify the option to remove only the SQL Server shared features and management tools. To continue, click Next. 4. On the Select Features page, specify the features to remove from the specified instance of SQL Server. To continue. 5. Removal rules will run to verify that the operation can complete successfully. 6. On the Ready to Uninstall page, review the list of components and features that will be uninstalled. 7. The Setup Progress page will display Setup status. 8. On the Completing Setup page, click Close to exit the Installation Wizard.

2. When you try to install an instance of Microsoft SQL Server 2005 on a computer that has an instance of Microsoft SQL Server 2008 already installed. More information, please read this Article: 955500: http://support.microsoft.com/default.aspx?scid=kb;EN-US;955500