February 26, 2002 at 8:31 am
I have an active/active cluster setup. The virtual server name is called Vwtersvsql1v. When I try to connect to that virtual server name through Access creating an ODBC connection I receive the error message Specified SQL server not found. I can ping this virtual name ok. Anyone have any thoughts. I am in a 2000 domain.
Thanks.
February 26, 2002 at 8:35 am
MDAC 2.6 and higher is required to access Virtual Instances without resorting to creating aliases or specifically configuring port configurations in the ODBC settings. MDAC 2.5 is what is standard on Windows 2000 without a SQL Server install.
If you're not on MDAC 2.6, you have the option of upgrading, but be sure to read the manifests, as there are some issues with clustered instances of SQL 7.
If you aren't on MDAC 2.6 and don't want to upgrade the clients at this time, check the Server Network Utility to find the TCP port the Named Instance is listening on. Then configure the ODBC client connection to use TCP/IP and specify the port. That should get you connected.
K. Brian Kelley
http://www.sqlservercentral.com/columnists/bkelley/
K. Brian Kelley
@kbriankelley
February 26, 2002 at 8:50 am
Does it matter whether I use tcpip or named pipes to connect? The tcpip worked but here is the second part of my problem.
We have in house applications that create a registry entry for the virtual server name. I will need to figure out what name it's using. In SQL it looks like Vwtersvsql1v\Instance1. Any other thoughts?
Thanks for the help.
February 26, 2002 at 9:04 am
It looks like you're probably going to have to upgrade to MDAC 2.6 or MDAC 2.7. The work arounds given by Microsoft are to use aliasing:
http://support.microsoft.com/default.aspx?scid=kb;en-us;Q274383
Since you've got the additional problem of having hard-coded registry settings, upgrading MDAC is probably the easiest way to get things up and running as expected. However, read the release manifests carefully for both MDAC 2.6 and MDAC 2.7 before going that route.
K. Brian Kelley
http://www.sqlservercentral.com/columnists/bkelley/
K. Brian Kelley
@kbriankelley
February 26, 2002 at 9:24 am
Thank you for the article. I'm in and working!! Thank you very much....
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply