INF: Using Banyan VINES Common Login with SQL Server

ID: Q143372

The information in this article applies to:

Microsoft SQL Server versions 4.2x, 6.0

SUMMARY

In order to use the Banyan network library with SQL Server, you must login to the Banyan VINES network before you start SQL Server. One of the ways to start SQL Server as a Windows NT service and use the Banyan net-library is to use the Banyan Common Login feature.

MORE INFORMATION

The Banyan Common Login is configured using the Workstation icon under the VINES setup group on the Windows NT server. When you double-click the Workstation icon, the "VINES Workstation Configuration" window is started. To use the Banyan Common Login, under the label Login Options, make sure that the "Use Windows NT Logon for VINES (common login)" check box is selected (refer to VINES documentation for details on how to configure the Banyan Enterprise Client for Windows NT).

Once you have configured the VINES software to use the Common Login feature, you must have a Windows NT user account that matches the Banyan login that is used to login to the Banyan network. If you have created the Banyan login SQLUSER@SQL@MICROSOFT, then you must have a Windows NT (domain or local server) user account with the name SQLUSER. In addition, the Banyan login must have the same password as the corresponding Windows NT account and the VINES login search list must have SQL@MICROSOFT specified. You also need to make sure that the Windows NT user account belongs to the Local Administrator group of the local Windows NT server.

By default, SQL Server is set up to run as a Windows NT service under the computer's LocalSystem account. To login to the Banyan VINES network automatically when SQL Server starts as a Windows NT service, you must assign the Common Login account (in our example, this would be SQLUSER) to be used with SQL Server service instead of the LocalSystem account. For SQL Server 4.21a, SQL Server's service name is SQLServer; for SQL Server 6.0, SQL Server's service name is MSSQLServer.

After you have changed the SQL Server service to use the Common login, you should change the SQL Server service to depend on the VinesWorkstation service so that the SQL Server service will not start until the VINES network services are running. To setup this dependency, use the Regedt32.exe program to add the DependOnService (type REG_MULTI_SZ) entry with the value VinesWorkstation to the followng Registry location:

For SQL Server 4.21a:


   \HKEY_LOCAL_MACHINE
           \SYSTEM
                \CurrentControlSet
                        \Services
                             \SQLServer

For SQL Server 6.0:


   \HKEY_LOCAL_MACHINE
           \SYSTEM
              \CurrentControlSet
                      \Services
                           \MSSQLServer


    \HKEY_LOCAL_MACHINE
           \SYSTEM
               \CurrentControlSet
                      \Services
                           \SQLExecutive

You can use the same Common Login to start SQLMonitor service for SQL Server 4.21a or the SQLExecutive service for SQL Server 6.0. Because the SQLMonitor service already depends on the SQLServer service, there is no need to add the DependOnService entry for the SQLMonitor service.

You can find additional information on assigning service accounts to SQL Server and SQL Executive in the Microsoft SQL Server "Administrator's Companion" for SQL Server 6.0.

Additional query words: sql6

Keywords : kb3rdparty kbinterop kbnetwork SSrvLAN
Version : 4.21a 6.0
Platform : NT WINDOWS
Issue type : kbhowto