How to uninstall a named instance of SQL 2005 is already installed with the default instance

s sql 2005 dev all, run. Depending on the environment of the machine, you can choose whether to install x86 or x64. (You can also find the $CD directory SQL Server X86 Servers or SQL Server X64 Servers to install it directly.)

If you don't know, you can check it by "Check hardware and software requirements". After that, the installation process begins.

2.Installation component process. Directly click Next.

3.After clicking Next, the system configuration check will be automatically entered. Wait for the inspection to finish and move on to the next step.

If it fails, you need to check the specific information of the error and report it to Zxpos Marketing support.

4.Select the components you want to install.

For the bureau and network planning users, except for the first and last items, other items can be omitted; The developers recommend selecting them all.

After the settings are complete, go to the "Advanced" option to modify the installation path settings.

5.Installation path settings.

Try to avoid installing it on the C drive, and choose another disk with plenty of space in the washing disk for installation.

6.Select Default Instance for instance name.

7.Select "Use built-in system account" - Local System. At the end of the installation, select SQL Server as the service to proceed to the next step.

8.Select the authentication mode. Select Mixed Mode and create a password for the established username (required).

Note: The username and password created by the user here must use the default password of the pre-agreed version. If the settings are not consistent, the version cannot be linked and started when the software is used.

9.Collation settings. Take the default settings and go straight to the next step.

10.For other processes, click Next directly until the installation is completed.

Back up the database first, then uninstall both, reinstall another one, and restore the database.

If it's your first time installing, you can select the default instance name. If you have other versions of SQL on your computer, you need to add an instance name to distinguish between the two versions. Here's how it works:

1. First, open the installer and select "New SQL Server Standalone Installation or Add Features to Existing Installation";

2. Then check "I accept the license terms";

3. Then check the functions that need to be installed, or click "Select All" to install all the functions;

4. Then set the instance name, if it is the first time to install SQL Server, you can choose "Default Instance", if there are other versions of SQL installed in the computer, then select "Name Instance", the name can be set at will, mainly to distinguish the instance installed for the first time;

5. Then click "Use the same account for all SQL Server services";

6. Click "Add Current User";

7. Then select the installed configuration, generally use the default configuration;

8. Then enter the installation rules to start the installation;

9. Wait for the installation to complete.

If you're installing it for the first time, just select Default.

If you have other versions of SQL on your machine, add your own instance name to distinguish between the two versions.

The instance name (server name) installed on my machine is the same as the computer name, and the 2000 installed later, after entering the instance name, it becomes: computer name The instance name entered.

1.The instance name is the name of an SQL Server service, which can be blank or any name (English characters), and the instance name cannot be duplicated.

2.If the instance name is kept being written during installation, there is an SQL Server instance with a default name, and the default empty name is used.

3.An instance is a single SQL Server service. If you have installed a SQL Server instance with a specified sale, you can see the service name of the instance in the Windows service list.

4.When you connect to a database, you must indicate the name of the database instance. For example, if you install a SQL Server with the default configuration, its instance name will be empty. We can connect to SQL Server (ADO syntax for ASP) as follows:

connstr="driver=;server=;database=db1;uid=sa;pwd=password"；

5.If you run the SQL Server installer again, it will not prompt that SQL Server has been installed, but ask the user to specify a new instance name when setting the instance name, for example, if you write "testinstance2". If you want to connect to the SQL server, you need the following method (ADO syntax of ASP):

connstr="driver=;server=;database=db1;uid=sa;pwd=password"；

6.When you uninstall SQL Server, you can choose to unmount an instance of SQL Server.

Can you take a screenshot and take a look?

Intentionally add my hi number 0615179

1. Stop the SQL service, which is in the service in the control panel. 2. Delete the SQL Server component in the local security group. In the Control Panel--- Local Security Policy - User Rights Assignment, delete the content that contains SQL subkeys, for example:

If you log in as a service and contain SQL content, you can delete the SQL content. 3. In the Control Panel, add or remove programs to uninstall the SQL content, note that the Microsoft SQL Server 2008 installation support file should be removed first. 4. Delete the contents in the instance folder.

5. Delete the other sections. If you can't delete it in the process of deleting, or something is missing, an abnormality occurs, etc., you can try to use the installer to fix it, and then try 1-5 steps, this is how my machine was successfully deleted.

You go to SQL Server Configuration Manager to get here.

Find the SQL Native Client and create a new alias It seems that you can't delete the default named instance Create a new named instance you want!

MSDN can be seen in several ways.

When installing SQL SERVE 2000, the instance name cannot be selected by default because the setting error is caused

1. This operation method uses SQL Server 2008 as an example.

2. First, open your computer's start menu and select "Control Panel".

3. In the Control Panel tab, select Administrative Tools.

4. In the Administrative Tools tab, select Services.

5. Double-click to open "Service".

6. In "Services", find the service name that starts with SQL.

7. The "SQL Server (MSSQLSserver)" service suffix"mssqlserver"is the instance name of the database.

I have not uninstalled it before, 1Uninstall something in the registry that contains SQL.

2.Delete all SQL files in the previous SQL installation directory3Restart your computer.

4.Reinstall the SQL

If you didn't have any of the 2000, 2005, or 2008 installed before installing sql2000, then choose the default instance installation, or choose the named instance, unless you want to upgrade to an older version.

You have installed sqlserver2000 before, and you did not uninstall it cleanly.

It should be that the SQL primary key installation is incomplete, and some components are not installed.

Don't understand what you're trying to do?

In the table before the note, the penitant deleted the corresponding service.

You go to sqlserver

configuration

manager

Go here.

Found it. sql

native

client

creates a new alias from .

It seems that it is not possible to delete the named instance of the default number of keys.

Create a new named instance from the bar you want, and the bar is dressed up for years!