How to set up SQL Server to listen on Banyan VINES Net-Library (142584)

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
3. 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
4. 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.
5. 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.
6. 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.
7. Shut down SQL Server, if it is running.
8. 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.
9. Start SQL Server.
10. 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:
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