How Do I Solve the Incompatibility of SQL Servers in Vista?

Vista can install only SQL Server 2005 SP2 or later. When installing SQL Server 2005, it will prompt that it is incompatible, but you can continue to install, and go to Microsoft's official website after installation** SQL Server 2005 Service Pack 2 Patch Package, and you can use it after you put it on.

In addition, Vista can only install the Express version and Developer version of SQL Server, and nothing else. The Express version needs to go to the official website ** SQL Server Management Studio Express management tools, which are free.

What version of SQL Server is there?

When you install it again, it prompts that it is not compatible, what does the original text say?

First of all, it is estimated that you have sql2005 installed, and 2000 should not be installed.

Second, in SQL 2005, only the Express Free Edition and the Developer Development Edition can be installed under Vista, but the Enterprise Edition cannot be installed.

Again, 2005 had to install a patch above SP2 to fix the compatibility issue, and the latest one is currently the SP3 patch.

Finally, let me tell you, it's okay to not install patches above sp2. As long as I can put it on, it's fine, I've done it.

Which version is SQL2000 or SQL2005

The former needs to install SP4 and the latter needs to install SP2 or higher.

Of course, it will prompt incompatibility when installing, and it will not affect the use after patching.

Hehe,I don't know how to get it.,It's possible to run under the server.。

The Vista design is inherently incompatible, but many people who study operating systems use a lot of methods to make SQL 2000 work perfectly.

Look at this.

I won't send the cutmap for you, 1, install msde2000 first

.b/chs_

MSDE2000 installation method.

1) Unzip 2) Enter the DOS environment Command Prompt.

Click "Start" - "Programs" - "Accessories" - "Command Prompt", enter:

d: The disk on which the directory is entered.

cd 3) into the unzipped directory.

cd d: msde click "enter".

4) Type: setup sapwd="sa"securitymode=sql disablenetworkprotocols=0 and press enter.

The parameter sapwd refers to the password of the SA, which is used in the "administrator password" of the "install database" step of Excel server 2006, which can be set by the user.

So MSDE2000 is installed!

2. Install sql2000 and install it directly (choose to modify or uninstall the installation when installing, install management tools and others.)

3'Hit the sp4 patch.

Installation successful!

When installing, turn off the UAC and turn it on when it's ready.

Start - Settings - Control Panel - User Accounts - Turn on and off User Account Control Go in and tick that off.

Install and run in compatibility mode.

SQL Server 2005 SP2 patch is required to be compatible with Vista.

SQL Server 2005 is a server-side application, while Vista is a client operating system and can only install its client version. The server-side version can only be installed on win2003 and the upcoming win2008 operating system. If you want to install its server-side version, you need to install the virtual machine software, such as virtual PC2007, and then install win2003 in the virtual machine, win2008 has too high hardware requirements, you may not be able to install it in the virtual machine, and then install the server-side version of SQL Server 2005 in the win2003 of the virtual machine.

Do you have to run the scaleback imitation sql2000 under vista?

Turn off Vista UAC

Install SQL2000 Personal Edition.

Install the SQL Server 2000 SP4 patch, but because the missing fiber is Vista, it is clearly stated that it does not support the width of SQL 2000.

One more thing is that other software doesn't support Vista and it's not that Vista doesn't support what other software you need to figure out the priority.

What I know is that you can't do it, only street basketball doesn't work, and everything else is easy to solve.

Vista is a 64-bit system, so 32-bit programs cannot run.

1) Change XP

2) Change to a higher version of SQL Server

3) Install a virtual computer.

Install Windows Server 2003

Neither Vista nor XP can install SQL Server2000 servers, only clients.

Change the XP system, you can definitely change it, and you can definitely change it, but the system can't be changed too often.

There is no other way but to change the system. XP is better and more stable than Vista.

1.Close UAC!!

2.Use program compatibility.

When installing, go directly to sqlserver2000 personal x86 setup and install it below, it will definitely be installed successfully, this is how I installed it, if the prompt says that the program hangs, you need to pendingfi the registry....Delete and restart the installation.

I've been working on this for a while, and the solution is like this:

Right-click under the Vista taskbar, select Task Manager, then select the Services tab, right-click on the "SQL Server (MSSQLSserver)" item in it and select Start, you can, this will work, because that's how I use it, if not, it is recommended to reinstall 2005, step by step and choose carefully.

It should be that your MS sql2005 version does not support Vista, and you can only install the client when you install it, not the server.

You cannot install the Enterprise Edition (only the client version after installation) and you can install the Development Edition and Express Edition. However, after installing the Development version under Windows Vista, you must also install the SP2 patch that you installed SQL2005 You install the SP2 patch of SQL2005 (that is: Microsoft SQL Server 2005 SP2 Chinese Simplified Chinese version), you cannot use SQL Server Management Studio after installation, and you must reinstall SQL 2005 again Development Edition.

There is an introduction on the Internet that you need to uninstall sql2005 and then install it again, after my verification, you can not uninstall it, and you can directly overwrite and install it again).

Don't be so troublesome.,Find the path to install SQL.,There's an enterprise manager in the file after installation.,And the server or something.,Select the server to open the SQL.,The service in the control panel is added after installation.,You can find it from the installation path.。

Let's change the version, I'll have no problem using the personal version.

It can be used in both the home and enterprise editions, but the Vista system disables the server function of Microsoft SQL Server 2005 due to the default security detection function of the system (the reason is that the server is a network service (both internal and external networks)).

The first thing you have to do is:

1 Open Microsoft SQL Server 2005 -- Configuration Tools -- > the Surface Area Configurator.

2 Select --> services and linked surface area configurator and feature peripheral reference configurator under Configure surface area to enable all the services in it.

3 Open the Configuration Tool -- > Configuration Manager and enable all the Microsoft SQL Server 2005 service items in this Other Items You can leave it alone (you are a stand-alone machine anyway).

Once you've done the above, you're ready to use it as a standalone!

If you still have problems, then it is recommended that you change to Vista Pro The home version is indeed not very easy to use...

It can be used in both the home and enterprise editions, but the Vista system disables the server function of Microsoft SQL Server 2005 due to the default security detection function of the system (the reason is that the server is a network service (both internal and external networks)).

The first thing you have to do is:

1 Open Microsoft SQL Server 2005 -- Configuration Tools -- > the Surface Area Configurator.

2 Select --> services and linked surface area configurator and feature peripheral reference configurator under Configure surface area to enable all the services in it.

3 Open the Configuration Tool -- > Configuration Manager and enable all the Microsoft SQL Server 2005 service items in this Other Items You can leave it alone (you are a stand-alone machine anyway).

Once you've done the above, you're ready to use it as a standalone!

If you still have problems, then it is recommended that you change to Vista Pro The home version is indeed not very easy to use...

I make Vista 03Your problem is the same as mine, it seems that Vista doesn't support sqlserver

1. SQL 2005 Server Edition should be installed on Server Edition, that is, it should be installed on Windows 2003 or Windows Server 2008 (Web version doesn't seem to work). I don't know if SQL 2005 has a desktop version.

2. When installing under Windows Server 2008, it will prompt that you need to install the SP2 patch of SQL 2005 to be compatible normally. The SP2 patch for SQL 2005 can be found by Microsoft, and the SP1 patch for Microsoft Visual Studio 2005 is also required, otherwise its SQL Server Management Studio will not work. Win2008 is the same core as Vista SP1, and the problem is estimated to be almost the same.