March 4, 2009 at 9:30 am
I'm trying to connect to a remote server, default instance. The remote server instance is sql 2000 but I'm running the 2005 client.
I've enabled remote connections with sql server browser, have tcp and named pipes enabled on my local client. I have windows firewall disabled.
command: sqlcmd -s servername i- filename
error: [exec] Sqlcmd: Error: Microsoft SQL Native Client : An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections..
Sqlcmd: Error: Microsoft SQL Native Client : Login timeout expired.
March 4, 2009 at 9:36 am
I believe your issue is that you have a lower case "s" instead of an upper case "S"
try doing
sqlcmd -S servername i- filename
instead of
sqlcmd -s servername i- filename
-S is for Server
-s is column separator
March 4, 2009 at 9:38 am
Doh!
That was it. Thanks.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply