Cannot Connect To Server - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

Cannot Connect To Server

Author

Topic

Hejime
Starting Member

3 Posts

Posted - 2008-09-02 : 10:22:53

hi there...

i'm kinda new to SQL Server 2005 and now im having problems with it

previously SQL Server 2005 worked fine for me without problems until im forced to reformat my computer due to sudden window crashing problems.

i did not to a clean format thus sql server 2005 is still in my computer

i tried reinstalling sql server 2005 and they said that most of the components are already installed.

problem now is that im unable to connect to sql server using my old server name HEJIME\SQLEXPRESS.

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

Cannot connect to HEJIME\SQLEXPRESS.

------------------------------
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: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1)

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

------------------------------
BUTTONS:

OK
------------------------------

afrika
Master Smack Fu Yak Hacker

2706 Posts

Posted - 2008-09-02 : 12:30:52

Check your security settings and allow remote connections using surface area scan

afrika
Master Smack Fu Yak Hacker

2706 Posts

Posted - 2008-09-02 : 12:49:04

check this out
http://msdn.microsoft.com/en-us/library/cc281850.aspx

Hejime
Starting Member

3 Posts

Posted - 2008-09-02 : 21:16:47

quote:
Originally posted by afrika

Check your security settings and allow remote connections using surface area scan

erm... may i ask how can i that?

im not using sql server 2008.. im using sql server 2005

EDIT:

i tried enabling remote connection (TCP/IP)

then they said to run the database engine again...

problem is i cannot run the SQL Server (SQLEXPRESS) service at all

i tried adding the new administrator in the sql server user provisioning but i get an error

TITLE: .Net SqlClient Data Provider
------------------------------

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: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

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

------------------------------
BUTTONS:

OK
------------------------------

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources