Microsoft KB Archive/142584

= How to set up SQL Server to listen on Banyan VINES Net-Library =

Article ID: 142584

Article Last Modified on 4/15/2004

-

APPLIES TO


 * Microsoft SQL Server 2000 Standard Edition
 * Microsoft SQL Server 4.21a Standard Edition
 * Microsoft SQL Server 6.0 Standard Edition
 * Microsoft SQL Server 6.5 Standard Edition
 * Microsoft SQL Server 7.0 Standard Edition

-



This article was previously published under Q142584



IN THIS TASK
 SUMMARY

Set Up SQL Server to Listen on Banyan VINES Server-side Net-libraryMORE INFORMATION

 REFERENCES



SUMMARY
This article describes how you set up SQL Server to listen on the Banyan VINES server-side NET-library.

Set Up SQL Server to Listen on Banyan VINES Server-side Net-library
Follow these steps to set up SQL Server to listen on Banyan VINES Server-side Net-library:
 * 1) Determine what Banyan StreetTalk group you want to use with SQL Server. This can be an existing group or a new group. For a new group, use the MGROUP program that is included with the VINES software to add a new group for your organization. For this example, you will 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. By default, servicename is the Microsoft Windows NT computer name when you set up SQL Server network support for the Banyan VINES Net-library. To create the service, use MSERVICE, which is included with the VINES software. For this example, you create this PC-based service:

MYSERVER@SQL@MICROSOFT
 * 1) Create a Banyan user login by using the MUSER program that is included with the VINES software. For this example, you create this Banyan login:

SQLUSER@SQL@MICROSOFT
 * 1) Use the MGROUP program that is included with the VINES software to manage the group "SQL", and put the login SQLUSER in the "AdminList" of this group. This gives the Banyan login SQLUSER administrative control over the MYSERVER@SQL@MICROSOFT PC-based service.
 * 2) Install "Banyan Enterprise Client for Window NT" (available from Banyan) on the Microsoft Windows NT server where SQL Server is installed, if you have not already done so.
 * 3) On the computer that is running Windows NT, where SQL Server is installed, run the SQL Server Setup program, and then click Change Network Support. Select the Banyan VINES Net-library. When you are prompted for the PC-based service name, type the name created in step 1. In this example, it is MYSERVER@SQL@MICROSOFT or just MYSERVER if SQL@MICROSOFT is in your Banyan default search group. Save the new configuration.
 * 4) Shut down SQL Server, if it is running.
 * 5) Log onto Banyan by using the Banyan login you created in step 2. SQL Server cannot listen on Banyan VINES Net-library if you have not already logged onto the Banyan Server before SQL Server starts.
 * 6) Start SQL Server.
 * 7) Verify whether SQL Server is listening on the Banyan Net-library correctly. Check the SQL Server error log to see if it contains a line that indicates which server-side Banyan Net-library DLL SQL Server is using.

For SQL Server 2000, the line looks similar to this:   Using 'SSMSVI70' version '2000.080.0096.00' to listen on 'MYSERVER' For SQL Server 7.0, the line looks similar to this:

  Using 'SSMSVI70' version '7.0.623' to listen on 'MYSERVER' For SQL Server 6.5, the line looks similar to this:

  Using 'SSMSVI60' version '6.5.0.0' to listen on 'MYSERVER' For SQL Server 6.0, the line looks similar to this:

  Using 'SSMSVI60' version '6.1.0.0' to listen on 'MYSERVER' For SQL Server 4.21a, the line looks similar to this:

  Using 'SSMSVINN' version '4.21.0.1' to listen on 'MYSERVER' If SQL Server cannot successfully listen on the Banyan VINES Net-library, you receive one, or more, error messages after the "using" message. 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 that is included with the VINES software to find out the VINES error text.

For example, if you type "VNSERR 1016", you receive this error message:

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.

back to the top

MORE INFORMATION
Pay attention to the "OS Error" number, because it gives you more specific information about why you cannot connect. Make sure that you are logged on to the Banyan server before you try to connect to SQL Server from a Banyan client. In this case, the Banyan login does not have to be in the AdminList of the group.

back to the top

