INF: Setting Up SQL Srv to Listen on Banyan VINES Net-Library

• Microsoft SQL Server, versions 4.21a and 6.0

SUMMARY

This article details the steps required for setting up SQL Server to listen on Banyan VINES server-side net-library:

1. Determine what Banyan StreetTalk group you would like to use with SQL

       Server. This can be an existing group or a new group. For a new group,
       use the MGROUP program included with VINES software to add a new group
       for your organization. Let's say you have decided to use "SQL" as your
       group and the organization is "MICROSOFT."
   

2. Create a StreetTalk PC-Based Service on the Banyan server in the form

       of servicename@group@org (notice that servicename by default is the
       Windows NT computer name when setting up SQL Server network support for
       Banyan VINES net-library). This can be done by using MSERVICE included
       with the VINES software. Let's say you have decided to create this PC-
       Based Service: MYSERVER@SQL@MICROSOFT.
   

3. Create a Banyan user login by using the MUSER program included with the

       VINES software. Let's say you have decided to create this Banyan login:
       SQLUSER@SQL@MICROSOFT.
   

4. Using the MGROUP program included with the VINES software, manage the

       group SQL and place the login SQLUSER in the "AdminList" of this group.
       This gives the Banyan login SQLUSER administrative control over the PC-
       Based Service MYSERVER@SQL@MICROSOFT.
   

5. Install "Banyan Enterprise Client for Window NT" (available from

       Banyan) on the Windows NT server where SQL Server is installed if you
       have not already done so.
   

6. On the Windows NT computer where SQL Server is installed, run the SQL

       Setup program and choose Change Network Support. Choose Banyan VINES
       net-library and when it asks for the PC-Based Service Name, enter the
       name created in step 1 (in our example, it would be
       MYSERVER@SQL@MICROSOFT or just simply MYSERVER if SQL@MICROSOFT is in
       your Banyan default search group). Save the new configuration.
   

7. Shut down SQL Server if it is running.

8. Log in to Banyan using the Banyan login created in step 2. SQL Server

       would not be able to listen on Banyan VINES net library if you have not
       already logged in to the Banyan Server before SQL Server starts.
   

9. Start SQL Server.

10. Verify whether SQL Server is listening on the Banyan net-library

        correctly. Check the SQL Server errorlog to see if it contains a line
        indicating the particular server-side Banyan net-library DLL SQL Server
        is using.
    

   Using 'SSMSVINN' version '4.21.0.1' to listen on 'MYSERVER'

   Using 'SSMSVI60' version '6.1.0.0' to listen on 'MYSERVER'

For example, if you type "VNSERR 1016", the follow message would be generated:

   STK1016 - NAME IS NOT A STREETTALK NAME.

   The name you specified is not a name that StreetTalk knows
   about.  Either you typed the name incorrectly or the name
   did not exist in the network.  Retype the name.

MORE INFORMATION

Once you have verified that SQL Server is listening on the Banyan VINES net- library correctly and you still have problems connecting to it using the client side Banyan VINES net-library, use Knowledge Base article Q126445 "INF: Resolving SQL Server Client-Side Vines Connectivity Errors" to help you troubleshoot the problem. You should pay attention to the "OS Error" number, because it will give you more specific information regarding why you are unable to connect. Please make sure that you are logged in to the Banyan server before you attempt to connect to SQL Server from a Banyan client. The Banyan login in this case does not have to be in the AdminList of the group.

You can find additional information on how to setup Banyan VINES clients from the SQL Server 4.21a Release Notes and the Microsoft SQL Server "Administrator's Companion" for SQL Server 6.0.

For additional information on how to use the VINES software MSERVICE, MUSER, VNSERR, and MGROUP, please refer to you VINES documentation. When appropriate, you may need to work with your Banyan network administrator to create the PC-Based service Name and the Banyan Login.