December 17, 2012 at 8:53 pm
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 Tools2005.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?
December 19, 2012 at 11:09 pm
Have you encountered any issues during the installation? try to uninstall and install the application
December 19, 2012 at 11:41 pm
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, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
December 20, 2012 at 7:39 pm
Thanks.
December 20, 2012 at 9:29 pm
Does that mean it is working now?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
December 22, 2012 at 8:22 pm
Thanks It is working now.
December 22, 2012 at 8:38 pm
Mind sharing what you did to get it working?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
December 26, 2012 at 10:56 pm
Actually downloaded express edition and installed.
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply