INF: Using Banyan VINES Common Login with SQL ServerID: Q143372
|
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.
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
\HKEY_LOCAL_MACHINE
\SYSTEM
\CurrentControlSet
\Services
\MSSQLServer
\HKEY_LOCAL_MACHINE
\SYSTEM
\CurrentControlSet
\Services
\SQLExecutive
Additional query words: sql6
Keywords : kb3rdparty kbinterop kbnetwork SSrvLAN
Version : 4.21a 6.0
Platform : NT WINDOWS
Issue type : kbhowto
Last Reviewed: March 24, 1999