Saturday, February 25, 2012

cannot install samples

hi to all,

i just installed sql server 2005 express edition. I also downloaded and run the "Northwind and pubs Sample Databases" and i have problem installing them

In the line of the guide that i have to run
sqlcmd -s .\SQLExpress -i instnwnd.sql

i get the following error:

HResult 0x2, Level 16, State 1
Named Pipes provider: could not open a connection to Sql Server [2].
Sqlcmd: Error: Microsoft SQL Native Client : An error has occured while establishing a connection to the server. When connecting to the Sql Server 2005, this failuremay be caused by the fact that under the default setting Sql Server does not allow remote connections..
SqlCmd: Error: Microsoft Sql Native Client : Login timeout expired
I also cannot connect through C# express and take the same error. SqlServer and SqlBrowser are up and running...

Can anyone help me please ?

Thanks in advance

AnthonyHi.

Make sure TCP/IP access is enabled in Configuration Manager.|||I already have tcp/ip enabled...But except from that, i suppose that is not needed for local connections, isn't it ?

Still, not working...|||You need to use sqlcmd -S that's capital S. small s is a different parameter

No comments:

Post a Comment