topic Re: SQL Server Port Number required to Connect in Storage Software

SQL Server Port Number required to Connect

Martin J Kelly — Mon, 17 May 2010 18:35:41 GMT

I'm running 3.6.2 and am having a problem connecting to my SQL Server Instances unless I also hardcode the port number each is using. Any idea what I've done wrong?

Re: SQL Server Port Number required to Connect

macosta — Mon, 17 May 2010 22:15:07 GMT

Hi Martin,

I'm not sure what else you were expecting. SQL Server expects a host\instance or host,port# spec. If you want to use hostname (or IP) and instance name, you may need to enable the Polyserve SQL Browser.

If you run into further issues, it may be worth opening a case with support to determine is something else is causing an issue here.

Re: SQL Server Port Number required to Connect

Martin J Kelly — Tue, 18 May 2010 11:49:59 GMT

Here's what I have.
2 SQL 2000 Instances. One I can access via "Virtual SQL Server\Instance Name" and the other I can only access via "Virtual SQL Server\Instance Name, Port".

They are both on the same Host.

We've been using PolyServe for about 4 years now and to this point have not had to add the Port number. We're moving to 3.6.2 and both of these Instances are new.

Re: SQL Server Port Number required to Connect

Tammy Lawson — Thu, 27 May 2010 16:42:44 GMT

We have had a similar issue here that has started occurring for one of our developers - he can connect to some instances just fine without a port (ones that use an alias) but he has had to start specifying the port for others. I trained them early on to use the port for the apps so atleast I am okay there for now. Up until a month or so ago he did not have issues. We are currently at 3.6.1 but will be upgrading to 3.6.2 soon. The only other recent changes to our environment, was upgrading to HP support pack 8.3 from 8.2 (for our HP blades). I had my suspicions it was from that but I am unsure.

Re: SQL Server Port Number required to Connect

Emil Velez — Sat, 19 Jun 2010 00:57:19 GMT

are any of the instances using the default port number and some are not ?

Re: SQL Server Port Number required to Connect

Charlotte Bentley — Thu, 18 Nov 2010 21:31:36 GMT

I am having fits with this problem running 4.0. I can connect by instance name from some machines, but not others. Even the same machine will connect by name sometimes, but require the port # another time. I do have PolyServe Instance Aliasing service running. I have the same mess if I stop the PS IA service and run with MS SQL Server Browser service instead. Any suggestion for how to investigate this would be greatly appreciated.