Can't connect to local instance

Hot Topic

Transmission of compressed snapshots
Post SP2 : Instance cannot be configured for Sharepoint Integration?
Multiple selects on PArameter drop down
Variable not getting updated and passed into data flow
dts & mail
multi step OLE DB error
Is this possible?
Dependant assemblies in CLR
ERROR - The row value(s) updated or deleted either do not make the row unique or they alter multiple rows.
Parameter isn't refreshing

SQL Server

SAP connection
can i restore only a table from a backup file?
CTE Error: Incorrect syntax near the keyword 'with'. If this statement is a common table expression or an xmlnamespaces clause,
Cannot see the SQL Express Instance on the Network Server list...
Error: 18456, Severity: 14, State: 11.
Full-text Index Question
API for creating user or group
Is it possible?
The process cannot access the file because it is being used by another process.
SQL SP1 build 2047 installation error

Can't connect to local instance

Hi,

  • SQL Server 2005 Developer edition
  • Windows XP Pro

This is a new install on this laptop. Trying to connect to the Database Engine using management studio using either TCP/IP or named pipes but getting errors regarding the server refusing connection. I've Googled these errors and as far as I can see I made all the adjustments that I need to.

TCP/IP
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. (provider: TCP Provider, error: 0 - No connection could be made because the target machine actively refused it.) (Microsoft SQL Server, Error: 10061)

Named Pipes
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. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 2)

I've opened up both protocols in the Configuration Manager and I've opened up local and remote connections to both protocols in surface area configurator. Even tried this with the windows firewall switched off.

Any suggestions anyone

Thanks
Dave

Answer this question

Can't connect to local instance

  • Roman T

    No I don't think as my laptop is with similar configuration and have no issues in connecting to the SQL instances.

    Make sure SQL Browser service is up and running. Refer to http://www.microsoft.com/technet/prodtechnol/sql/2005/msde2sqlexpress.mspx on Performing Configuration Changes topic.


    HTH

    york001 wrote:


    Is it an issue to have a DHCP assigned IP address when using SQL 2005

    Dave



  • igor1960

    After installation, did you check if the services are running

  • Per Salmi

    Yep, in fact I restarted most of them to be sure. This laptop briefly had SQL 2005 Express on it a while ago and even though that software has been removed the machine still thinks it has an instance installed.

    Is it an issue to have a DHCP assigned IP address when using SQL 2005

    Dave

  • Can't connect to local instance
Answer this question