After you have installed SQL Server, it is vital that you test the installation. First, verify that the SQL Service is starting using the SQL Service Manager tool or Enterprise Manager. Next, make sure that you have the server in Mixed Mode authentication.You can do this by launching Query Analyzer, and in the Connect using dialog box, click SQL Authentication and then log in using the SA account to verify connectivity to the server.
We can run some basic queries to verify that the installation was successful in creating all the default system objects.Verify that the master database is selected, and type SELECT * FROM INFORMATION_SCHEMA.SCHEMATA.You should see a list of the installed databases: master, tempdb, model, msdb, pubs, and northwind.
It is also vital that you make sure you are using at least Service Pack 2 for SQL Server 7.0. Use SELECT @@VERSION to verify that you have upgraded to SQL Server Service Pack 2, and Windows 2000 Service Pack 1.The following is the output you should receive:
Microsoft SQL Server 7.00 - 7.00.842 (Intel X86) Mar 2 2000 06:49:37
Copyright (c) 1988-1998 Microsoft Corporation
Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 1)
This will help you verify that you have at least build 842 of SQL 7.0, which is the SP2 build number, and at least build 2195: Service Pack 1 with Windows 2000 applied. If these numbers do not match, go back and make sure you installed the correct service packs.
Was this article helpful?