Wednesday, March 28, 2012

Having problem with my server

I just currently installed Microsoft studio express which includes SQL server and i get this error Server Error in '/WebSite1' Application. it also states "Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding" I am wondering do i have to have IIS on to run SQL server 2005 express adition.Sad

I am also having problem with SQL Express installation. After installing it, and configuring with SQL surface area for also remote access via tcp or pipe I still get the message:

>sqlcmd

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 occurred while establi
shing a connection to the server. When connecting to SQL Server 2005, this failu
re 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.

|||Make sure you have followed all of the steps at http://blogs.msdn.com/sqlexpress/archive/2005/05/05/415084.aspx in order to enable remote connectivity.

No comments:

Post a Comment