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

ID: Q142584

The information in this article applies to:

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.


For SQL Server 4.21a, the line looks like this: 

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

For SQL Server 6.0, it is: 

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

If SQL Server cannot successfully listen on the Banyan VINES net-library, there will be one or more error messages after the "using" message shown above. Please reference Knowledge Base article Q126262, "PRB: Resolving SQL Server Server-side Vines Connectivity Errors" to help you troubleshoot and correct the error. In addition, the operating system error message generated by the server side net-library for Banyan is equal to the VINES error number plus 10000. In other words, OS Error 11016 is the same as VINES error number 1016. You can then use the VNSERR program included with the VINES software to find out the VINES error text.

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.

Additional query words: sql6 Banyan network setup 


Keywords          : kbinterop kbnetwork SSrvLAN SSrvNet_Lib 
Version           : 4.21a 6.0
Platform          : WINDOWS 
Issue type        :

Last Reviewed: March 24, 1999