Article ID: 130745
Article Last Modified on 10/3/2003
APPLIES TO
- Microsoft SQL Server 4.21a Standard Edition
This article was previously published under Q130745
SUMMARY
You can always connect locally to a SQL Server on a standalone machine through Windows NT's local pipes using 32-bit SQL Server applications. However, you can not do the same from a 16-bit application unless network software is installed.
MORE INFORMATION
On a standalone machine, you can use 32-bit applications to connect to the local SQL Server by specifying server name as <local>, a period (.), or blank. This is possible because of Windows NT's local pipe support. However, the local pipe concept does not apply in Win16 (WOW) environment. To connect to SQL Server from a 16-bit application in WOW, you need to use named pipes, which is not available unless network software is installed.
You can install network software on a standalone machine without any network interface cards (NIC) installed. To do so, you need to install the MS Loopback Adaptor, which is a loopback adaptor driver that "simulates" a NIC. With this driver installed, you can install other network components as you normally do and start network related services as if a NIC is present.
To install the driver, start the Network applet in Control Panel, and select the Add Adaptors option. Select MS Loopback Adaptor from the list.
Additional query words: Windows NT local win16 WOW Connect
Keywords: kbenv KB130745
