August 6, 2009 at 1:00 am
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
August 6, 2009 at 5:10 am
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