Re: Requires Aliase Name Connect to Named Instance
From: Steve Schofield (steve_at_adminblogs.com)
Date: 03/12/04
- Next message: MS SQL Survey Admin.: "SQL Server Community Survey"
- Previous message: Dave: "Requires Aliase Name Connect to Named Instance"
- In reply to: Dave: "Requires Aliase Name Connect to Named Instance"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 12 Mar 2004 07:29:15 -0500
In my experience you have to put VirtualServerName\Instancename in SQL
Enterprise manager and connection strings for web pages. Do you have WINS
resolution at your place of work?
* ----------------------------------------- *
* Steve Schofield - MCP, CCA
* steve@adminblogs.com
*
* Microsoft MVP - ASP.NET
* http://www.adminblogs.com
* ----------------------------------------- *
"Dave" <anonymous@discussions.microsoft.com> wrote in message
news:b3e601c407c4$e8fb3c20$a301280a@phx.gbl...
>
> I have two Windows 2000 Advanced server cluster servers
> one for developement (DEV) and the other acceptance (ACC)
> servers. These cluster servers are set up as
> Active/Active. These servers are set up as a Primary
> Process server (Node A) and Secondary Process server (Node
> B). Several months ago something changed and we were
> unable to register the Node B server without set up an
> aliase in the Client Network Utlility using TCP/IP as the
> Network Library on SQL Server client connect to this
> server. We were able to connect to Node A without an
> aliase from a SQL Server client connection. I have
> several other SQL Servers that are set up as default name
> instances that do not require an aliase to connect these
> servers.
>
> I have MDAC 2.8 SP1 with SQL Server 2000 SP3A on the
> client computer.
>
> So my MDAC version should be current enough to resolve SQL
> Server named instances.
>
> Please help me resolve this issue.
>
> Thank You,
>
> Dave
>
>
- Next message: MS SQL Survey Admin.: "SQL Server Community Survey"
- Previous message: Dave: "Requires Aliase Name Connect to Named Instance"
- In reply to: Dave: "Requires Aliase Name Connect to Named Instance"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
