[HELP]Database Install

[Banana007]

Hello. When I open Microsoft sql servers management studio and press on New query i choose for server type: database engine, then on server name: localhost and on anthetication i add windows anthetication, then I click the connect button and i get the following error:

 

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)

 

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=2&LinkId=20476

 

------------------------------

BUTTONS:

 

OK

------------------------------

How can i fix it?

[Sighed]

Maybe database engine service is stopped.

[Banana007]

i stopped the remote connection and i started it again but nothing..

[mcbigmac]

enable named pipes, just like the error tells you.

[Banana007]

i have already enable the pipes..

[dreambot]

well .. when you installed msql maybe you didnt enabled or allowed remote connection?

 

reinstall and enable from the start.?

 

[Banana007]

I have already reinstall the database and I saw that there was an error with asp.net. Is that the problem? If yes how can i solve it. I searched a bit but i didn't find any way to solve this thing. And someting else, when i open cmd and type net start mssqlserver it gives an error: "System Error 1060 has occurred. The specified service does not exist as an installed service" Does it means that mssql is not installed correctly?

[TheLioner]

first of all , you have to uninstall all current configures and files of, navicat or mysql server, then clean the ports you was using for sql, and just reinstall all sql files from the very begining :) i hope of helping you,

[Banana007]

I ain't use both navicat and mysql, i use microsoft sql server 2005 and mssql...