I am newbie to SQL I am facing the problem while installing SQLServer7.0.My NT4.0 work station is already running with PWS and IIS. Right now i am using Access database for ASP.Now we are moving to SQL. Let me know the initial procedure for installing SQL7.0.. thanks lot rams

-- Anonymous, October 27, 1999

Answers

Rams,

I have provided these notes from SQL Server Books Online. (Naturally, I don't expect you to have access to these notes until you have SQL Server 7.0 installed.)

Before Installing: Checklist

Considerations Before Running SQL Server Setup

Back up your Microsoft. SQL Server version 6.x installation if you are installing SQL Server 7.0 on the same computer.

Shut down all services dependent on SQL Server. This includes any service that is using ODBC, such as Microsoft Internet Information Services (IIS).

Shut down Microsoft Windows NT. Event Viewer and Regedt32.exe.

Review the hardware and software requirements for installing SQL Server. [PLEASE NOTE: SQL Server 7.0 requirements state that it must be installed on NT Server 4.0 with Service Pack 4 installed. SQL Server installation on NT Workstation IS NOT SUPPORTED. I recommend that you do not attempt to install SQL Server on NT Workstation and I will not answer any questions that result from that attempt.]

Create a domain user account to assign to the MSSQLServer, SQLServerAgent, and MSDTC services if you are installing SQL Server on Windows NT and plan to perform any server-to-server activities. For more information about domain accounts, see SQL Server Services Logon Accounts.

Log on to the system under a user account that has local administrative privileges.

Considerations Before Running a Custom Installation

Select a character set, sort order, and Unicode collation. If you need to change any of these later, you must rebuild the databases and reload the data. It is recommended that you develop a standard within your organization for these options. Many server-to-server activities may fail if the character set, sort order, and Unicode collation are not consistent across servers.

Review all other SQL Server installation options and be prepared to make the appropriate selections when you run the Setup program.

Hope this helps,

Eric

-- Anonymous, October 27, 1999