How to install SQL Server 2005 in Vista

The following is an introduction to the detailed steps for you to install the SQL Server 2005 database system under Vista, which I hope will help you.

Vista systems support SQL Server Edition Express and SQL Server Developer Edition, but if you want to install a different version, you need the appropriate access rights. User Account Control (UAC) under the Vista operating system allows users to perform common tasks as non-administrator. Windows user accounts, which are members of the local Administrators group, can run most applications, as with standard user accounts, and SQL Server installs with the Builtinadministrators group as the default system administration group. By default, in Windows Vista, users who are members of the Windows Administrators Group are not automatically granted permissions to connect to SQL Server, and SQL Server administrator privileges are not automatically granted to those users. In Windows Vista, when a user attempts to connect to SQL Server, a message is returned stating that the account does not have permission to log on to SQL Server. (Windows users are granted connection permissions in SQL Server Express and developer Edition because the Builtinusers group is provided as a login.) So Vista systems support SQL Server, Express Edition and SQL Server Developer Edition).

For UAC you can go to Microsoft China to inquire about the relevant information.

The installation steps are as follows:
Install SQL Server Enterprise Edition without a system hint (such as a compatibility hint) to install.

Two, click the Start button, point to All Programs, click Microsoft SQL Server 2005, click Configure Tools, right-click the SQL Server 2005 perimeter configuration, click Run as Administrator, and then click Add New Administrator , and finally grant the right to the appropriate user.
Three, click the Start button, point to All Programs, click Microsoft SQL Server 2005, click Configure Tools, right-click the SQL Server 2005 perimeter configuration, click Run as Administrator, and then click Perimeter configuration for services and connections, choose local and remote connections, and select "Use TCP/IP and Named pipes (B)" At the same time. (Some computers may not have to choose this step).