Sql Server 2005 doesn't connect for windows xp SP3

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server Newbies » Sql Server 2005 doesn't connect for windows...

Sql Server 2005 doesn't connect for windows xp SP3

Rate Topic

Display Mode

Topic Options

Author

Message

Rauf Miah

Posted Monday, December 17, 2012 8:53 PM

SSC Rookie

Group: General Forum Members
Last Login: Wednesday, May 15, 2013 2:37 AM
Points: 34, Visits: 63

I have installed sql server 2005 in Windows XP SP3. Installed successfully but

a) server didn't connect gave error message ;

TITLE: Connect to Server
------------------------------

Cannot connect to localhost.

------------------------------
ADDITIONAL INFORMATION:

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)

again tried with computer name gave same message.
b) Service is not listed in the windows service list (should have service name mssqlserver)
c) Version information Sql Server 2005 :

Microsoft SQL Server Management Studio 9.00.1399.00
Microsoft Analysis Services Client Tools 2005.090.1399.00
Microsoft Data Access Components (MDAC) 2000.085.1132.00 (xpsp.080413-0852)
Microsoft MSXML 2.6 3.0 5.0 6.0
Microsoft Internet Explorer 6.0.2900.5512
Microsoft .NET Framework 2.0.50727.42
Operating System 5.1.2600

Can anyone help me to run sql Server 2005 in windows xp sp3?

Post #1397528

eklavu

Posted Wednesday, December 19, 2012 11:09 PM

Valued Member

Group: General Forum Members
Last Login: 2 days ago @ 1:38 AM
Points: 53, Visits: 150

Have you encountered any issues during the installation? try to uninstall and install the application

Post #1398783

SQLRNNR

Posted Wednesday, December 19, 2012 11:41 PM

SSCoach

Group: General Forum Members
Last Login: Today @ 10:25 AM
Points: 18,754, Visits: 12,337

When you say windows service list, are you referring to the Services control panel?

In the Services Control panel you will want to look for SQL Server as the name and not mssqlserver.

When you installed SQL Server, did you install as default instance or as a named instance?

Do you have the SQL Browser running?

Do you have windows (or any other) firewall running?

Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server 2008

SQL RNNR

Posting Performance Based Questions - Gail Shaw
Posting Data Etiquette - Jeff Moden
Hidden RBAR - Jeff Moden
VLFs and the Tran Log - Kimberly Tripp

Post #1398792

Rauf Miah

Posted Thursday, December 20, 2012 7:39 PM

SSC Rookie

Group: General Forum Members
Last Login: Wednesday, May 15, 2013 2:37 AM
Points: 34, Visits: 63

Thanks.

Post #1399151

SQLRNNR

Posted Thursday, December 20, 2012 9:29 PM

SSCoach

Group: General Forum Members
Last Login: Today @ 10:25 AM
Points: 18,754, Visits: 12,337

Does that mean it is working now?

Post #1399172

Rauf Miah

Posted Saturday, December 22, 2012 8:22 PM

SSC Rookie

Group: General Forum Members
Last Login: Wednesday, May 15, 2013 2:37 AM
Points: 34, Visits: 63

Thanks It is working now.

Post #1399724

SQLRNNR

Posted Saturday, December 22, 2012 8:38 PM

SSCoach

Group: General Forum Members
Last Login: Today @ 10:25 AM
Points: 18,754, Visits: 12,337

Mind sharing what you did to get it working?

Post #1399726

Rauf Miah

Posted Wednesday, December 26, 2012 10:56 PM

SSC Rookie

Group: General Forum Members
Last Login: Wednesday, May 15, 2013 2:37 AM
Points: 34, Visits: 63

Actually downloaded express edition and installed.

Post #1400466

« Prev Topic | Next Topic »

Permissions