INF: Resolving Server-Side Vines Connectivity Errors w/ SQL

• Microsoft SQL Server, versions 4.21 and 4.21a

SUMMARY

This article discusses some of the common server-side problems encountered when configuring Microsoft SQL Server to operate in a Banyan VINES network environment. It also gives detailed error messages recorded in the SQL Server errorlog and the Windows NT Event Viewer under Application Messages.

NOTE: In Event Viewer, the errors will have a Source of SQL Server and a Category of ODS.

MORE INFORMATION

Error

   17826, Severity 18, State 0
   Unable to set up ListenOn connection
   'my_pc_service@my_group@my_org'
   OS Error: 11016, (VnsFormatStName()).

Cause

There are two common causes for this problem:

1. The PC-based service that SQL Server has been configured to use is incorrect.

2. The PC-based service does not exist.

Workaround

1. You need to change the PC-based service name that SQL Server is attempting to use by using the SQL Server Setup program under "Network Support."

2. The Banyan Administrator needs to create the PC-based service using Banyan's Manage or MService tools.

Error

   17826, Severity 18, State 0
   Unable to set up ListenOn connection
   'my_pc_service@my_group@my_org'
   OS Error: 11033, (VnsSocketSend()).

Cause

This error indicates insufficient Banyan permissions. In order to register with a Banyan PC-based service, the Banyan Login must be a member of the Banyan AdminList for the group in which the PC-based service is a member.

Workaround

The Banyan login needs to be added to the group's AdminList by the Banyan Administrator.

Error

   17826, Severity 18, State 0
   Unable to set up ListenOn connection
   'my_pc_service@my_group@my_org'
   OS Error: 11801, (VnsFormatStName()).

Cause

There are two common causes for this error:

1. No Banyan login has been established prior to starting SQL Server.

2. The Banyan Vines workstation service has not been started.

Workaround

1. Make sure that the Banyan Vines Enterprise client software has been installed.

2. Start the Banyan Vines workstation service and log into the Banyan network prior to starting SQL Server.

Error

   17822, Severity 18, State 0
   Unable to load ListenOn Net-Library 'SSMSVINN'.
   OS Error: 126, The specified module could not be found.

Cause

The Banyan Vines Enterprise client software has not been installed or the Microsoft SQL Server Vines server-side network library (net-library) (SSMSVINN.DLL) could not be located.

Workaround

Make sure that the Banyan Vines Enterprise client software has been installed and the server-side net-library is located in the path.