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



Martin,

you could create an Alias on each Node in the Client Network Utility with
name (local) and then the real name to point at the SQL Virtual Name

Andy.
"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: Login failed for user NT AUTHORITYLOCAL SERVICE.
    ... The error message did indicate that the login user doesn't have sufficient ... permission access the target database, and since you mentioned the error ... so thats SQL Server Engine I think? ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Event 1000 Windows SharePoint Services 2.0 Error
    ... First off what exact error message do you get? ... I've not seen Exchange pop connector get mangled by removing SQL so lets debug that separately. ... I had all SQL server instances to a complete stop. ... And this morning when I came to work, I discovered that when I try to access http://companyweb/, I receive the "Cannot connect to the configuration database." ...
    (microsoft.public.windows.server.sbs)
  • RE: Fulltext failure on a 2 node cluster
    ... Server full-text search resource online: "SQL Cluster Resource 'Full Text' ...
    (microsoft.public.sqlserver.clustering)
  • Re: HELP PLEASE ~ ???
    ... You mentioned that it went ahead and added a SQL ... SQL Server 2000 database for all my data. ... find the connectionString in the newly recreated SQLExpress database. ... The connection string specifies a local Sql Server Express instance ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Multi-Channel Raid VS SAN Storage
    ... A 5~6 years old server is a very old server. ... As I mentioned, the server is one node in a cluster environment, and SQL is ... We actually are running RAID 1+0 and our aplication is definately more ... needs it's own SAN device, or at least a dedicated IO channel on the SAN. ...
    (microsoft.public.sqlserver.setup)