When a server installation or upgrade is complete, you can test the installation by connecting to it locally by running the isql utility from the server computer.
net start mssqlserver
isql /Usa /P
If isql connects, you'll see the following isql prompt:
1>
If isql cannot connect, you'll get a DB-Library error. (For help in identifying and correcting the problem, see Chapter 7, Installation Troubleshooting.)
select @@servername
go
The isql utility returns the server name, as shown in this example:
1> select @@servername 2> go ------------------------------- WOLFHOUND (1 row affected) 1>
select @@version
go
The isql utility returns the version information.
exit