sqlcmd error

  • Hi All

    Can someone verified me, what is wrong with this syntax :

    sqlcmd -S\\.\pipe\$$\SQLCLUSTER\sql\query -E -i"Y:\SQLBackupScript\dbp_db.sql"

    I try to run those line from RUN utility. But it giving me below error :

    Msg 18456, Level 14, State 1, Server SQLCLUSTER, Line 1

    Login failed for user 'DBPMAIN\clusteradmin'.

    Then, when i run this syntax :

    sqlcmd -S\\.\pipe\sql\query -E -i"Y:\SQLBackupScript\dbp_db.sql"

    i receive this error :

    HResult 0x2, Level 16, State 1

    Named Pipes Provider: Could not open a connection to SQL Server [2].

    Sqlcmd: Error: Microsoft SQL Server Native Client 10.0 : A network-related or in

    stance-specific error has occurred while establishing a connection to SQL Server

    . Server is not found or not accessible. Check if instance name is correct and i

    f SQL Server is configured to allow remote connections. For more information see

    SQL Server Books Online..

    Sqlcmd: Error: Microsoft SQL Server Native Client 10.0 : Login timeout expired.

    Can somebody advice me on this?? This is MS SQL Server 08 (2 nodes) in cluster environment

  • why do you connect via NP ?

    looks lige you are running the script on the server locally ?

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply