Unanswered: SQLCMD Can not connect to SQLExpress 2005
I have installed SQL Express 2005 on a machine and I am trying to run a script file via SQLCMD from my application. I keep getting an error stating that SQLCMD can not connect to the server. Remote connections are enabled for both tcp/ip and named pipes. Sql Browser Service is enabled and running.
This is the error message
HResult 0x2, Level 16, State 1
Named Pipes Provider: Could not open a connection to SQL Server .
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.
I can open Management studio and run the script and it works perfectly so I don't really know what is going on. Thanks for any help.
No, I am connecting from the machine that it is installed on, and yes it is XP SP2, but I don't see why a firewall would prevent a connection on the local machine. I will check out those links and do some testing when I get back to the office on Friday, thanks.