Conference amcucs::ms-sqlsvr

332.0. "SQL Server database alias ???" by ZPOVC::CSNAQS () Wed Jan 29 1997 17:33

    Hi,
    
    Currently I have my NT Cluster running fine with NT 4.0 and Cluster
    V1.1Beta and SQL Server 6.5. I have applied the NT 4.0 Service pack 2
    and SQL Server service pack 2.
    
    As I am not very familiar with SQL Server, in the Cluster Admin guide 
    for V1.1, it say for client conections using named pipes:
    
        1.  Type the SQL Server database alias
        2.  Type DLL name for the named pipes Net-Library
        3.  Connection String box,use this syntax:
            \\ClusterName\pipe\ObjectName\query
    
    My current configuration is:
    
        I have two Server , one called A2100 and the other A1000
        NT Cluster Alias: NT_Cluster1
        On A2100, I created an SQL Failover Object called SQLfailoverobj1
        Using SQL Enterprise Manager, I created Database Device called HR,
    	and Database called Salary.
    
        On A1000, I created an SQL Failover Object called SQLfailoverobj2
        I created Database Device called Tech and Database called Support.
    
        With the above info, I was not too sure what to type for the SQL
    	Server database alias but guess that it could be the database Salary.
        Therefore I inputed the info as follow but could not get it
    	connected.
    	1.  In Server box, I type : Salary
        2.  DLL named pipes Net-Library, I type: DBNMP3.DLL
        3.  Connection string: \\NT_Cluster1\pipe\SQLfailoverobj1\query
    
        I have tried to change the Server box with the following names
    	A2100 and NT_Cluster1 but it will give the same errors :
    
        Unable to connect: SQL Server is unavailable or does not exist.
        Access denied
    
        But if I do not use the advanced option, I just simply use the
    	default which I need only to key in the NT_Cluster1 and the login name 
     	sa followed by the passswd , I could get connected to the cluster. Is
        there any input which I have not done properly when trying to use
    	the Advance option to login to the Cluster ?
    
    	Could anyone able to tell me what is SQL Server database alias and
    	what should I input in the Server box on the SQL Client ?
    
    	I have posted this question in note conference,
    	24.850::WINNT-CLUSTERS, notes 577
    
    	Urgently needed help as I am setting up the demo for customers.
    
    	Thanks