Re: (local) Alias does not function in an virtual sql server?

There is an Environment Variable you can use in order to run the SQLDIAG
utility on the active node. I'm not sure if it uses the (local) or the "."
designation, but it would be worth a shot.

Type set _CLUSTER_NETWORK_NAME_=SQL NETWORK NAME, and then press ENTER.

NOTE: The SQL NETWORK NAME is the SQL Server virtual name for a named
instance. This is only the first part of the name. For example, if the
instance name is VSQL2\INST2, the SQL NETWORK NAME is VSQL2.


INF: How To Run SQLDIAG On a Clustered/Virtual SQL Server
http://support.microsoft.com/kb/233332/EN-US/


Sincerely,


Anthony Thomas




--

"Martin Saalmann" <MartinSaalmann@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
message news:8CD4BBE4-7548-4BD5-BDF1-7B437D2A102E@xxxxxxxxxxxxxxxx
> When I try to connect to (local) server (in Query Analyzer for example) on
an
> virtual sql server, the application tries to connect to the active node
> instead, resulting in an error message (SQL Server does not exist or
access
> denied).
>
> Is it possible to configure this alias to connect to the virtual sql
server?
>
> Furthermore I recognized, that DTS-Packages with (local)-Data Sources
still
> work on the virtual server. On a second, similar installed server, this
> results in the same error message.
>
> Any thoughts?
>
> Martin Saalmann
>


.

Relevant Pages

  • Re: Adding Second Virtual SQL Server Instance to a Cluster.
    ... IP address and disk resources for another virtual ... you install the new instance like you installed ... Mike Epprecht, Microsoft SQL Server MVP ... > We consider implementing a Report Server by adding a second Virtual SQL ...
    (microsoft.public.sqlserver.clustering)
  • Re: Adding Second Virtual SQL Server Instance to a Cluster.
    ... At the moment the Virtual SQL Server uses a 133 GB ... There is no unused space on the SAN. ... shared disk for a new shared disk resource for the second Virtual SQL ...
    (microsoft.public.sqlserver.clustering)
  • RE: Backup and Restore of the Cluster
    ... restore a VIRTUAL SQL Server running on a cluster to another VIRTUAL SQL ... I am most interessed in how to restore the master and msdb database on the ...
    (microsoft.public.sqlserver.clustering)
  • Re: Differences in clustered system dbs vs standalone system dbs
    ... current install and the Virutual SQL Server will be a default instance. ... >> outside world IS the Virtual SQL Instance name. ... Again, copying the system databases, even if successful, won't fix ... >>> You may want to build a test cluster using cheap recycled SCSI hardware ...
    (microsoft.public.sqlserver.clustering)
  • Re: Dear Ekrem
    ... I do not think you know the difference between Two Active Nodes in a Cluster or only one active node. ... When you have only one active node in your cluster, then you will be able to use only one SQL Server server at one time. ... So they said that they want to keep a live copy of their databases on the second node that's why they wanted two active nodes. ...
    (microsoft.public.sqlserver.setup)
Loading