Re: SSPI Context Error: Fails by computer name

From: Ben (dsfsdaf)
Date: 06/25/02 

From: "Ben" <dsfsdaf>
Date: Tue, 25 Jun 2002 06:48:26 -0500

Lind, I am sorry, I did mean the Virtual IP address setup. There is an
entry in DNS with a name that maps to the virtual cluster IP address.

Adding it to HOSTS corrects the problem, but does it cover a larger problem.
Could this be a problem with DNS or WINS specifically?

"linda deng[MS]" <lideng@online.microsoft.com> wrote in message
news:y2ScGMCHCHA.1560@cpmsftngxa07...
> Hi Ben,
>
> The name resolution may be the problem. Please try the steps below:
> 1. Disable the encryption.
> 2. Check the SQL Server alias to point the correct IP address.
> 3. Add the hosts or lmhosts entry on the client trying to connect to the
> server.
>
> There is additional information from Microsoft SQL Server Books Online.
> You must use the VIRTUAL_SERVER\Instance-name string to connect to a
> clustered instance of SQL Server 2000 running on a virtual server. You
> cannot access the instance of SQL Server 2000 by using the computer name
> that the clustered instance happens to reside on at any given time. SQL
> Server 2000 does not listen on the IP address of the local servers. It
> listens only on the clustered IP addresses created during the setup of a
> virtual server for SQL Server 2000.
>
> If anything is unclear, please let me know.
>
> Sincerely,
>
> Linda Deng
> Microsoft Support Engineer
>
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>

Relevant Pages

  • Re: Unable to Apply SP4 to SQL 2000 Cluster (new Node)
    ... Now, for the first problem, adding the 3rd node as a member of the cluster. ... You then installed a 2nd instance of SQL Server. ... DBC01 (Disks, SQL Server resources) ... Install RTM SS2K and designate the node membership. ...
    (microsoft.public.sqlserver.clustering)
  • Re: Cluster will not fail over.
    ... > As far as the TCP/IP issue goes, you had to rebuild the cluster and were ... > able to restore the master database. ... > a cluster installation you'll have to revisit. ... >> This worked bringing up the sql server in minimal mode. ...
    (microsoft.public.sqlserver.clustering)
  • Re: active/passive with multiple instances
    ... An Active/Passive cluster is always called that and never Passive/Active. ... There is only 1 SQL Server per instance:) Just so other don't get confused. ... It does matter about the hardware, to achieve true HA it needs to happen at ... a SQL Server DBA plain and simply doesn't care about it being ...
    (microsoft.public.sqlserver.clustering)
  • Re: High Availability
    ... The cluster uses heartbeat to detect whether a node is alive or not responding. ... You may want to research SQL Server Replication/ Log Shipping if you can have some latency. ... Typical Uses of Replication ... Introducing New Features in Microsoft SQL Server 2000 Transactional Replication ...
    (microsoft.public.sqlserver.clustering)
  • Re: Bad startup parameter on clustered instance
    ... you shouldn't directly edit the registry entries of a cluster-aware ... SQL Server resource to keep failing the startup. ... This is because the cluster service checkpoints its changes and basically ... Check the registry entries for the startup parameters on the node to make ...
    (microsoft.public.sqlserver.clustering)
Quantcast