Unable to Connect to Local Server

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

SQL Server 2005 Forums

SQL Server Administration (2005)

Unable to Connect to Local Server

Author

Topic

rcr69er
Constraint Violating Yak Guru

327 Posts

Posted - 2007-11-08 : 18:42:45

Hi

I had Sql Server 2005 installed on a machine of mine and was able to connect to the local, however I had to unistall it. Recently I put it back on the machine and found that I was no longer able to connect to the local server.

Does anyone know why this has happened and how it can be resolved?
Thanks

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-11-08 : 18:54:31

Providing the error is always helpful.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

rcr69er
Constraint Violating Yak Guru

327 Posts

Posted - 2007-11-08 : 19:19:38

I get a message stating that sql server does not allow remote connections with an error 26.

Hope that helps.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2007-11-08 : 19:28:16

Have you verified that the SQL Server service is running? Are you sure that you installed the database server and not just client tools? Have you tried connecting with ServerName,PortNumber or ServerName\InstanceName,PortNumber?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

rcr69er
Constraint Violating Yak Guru

327 Posts

Posted - 2007-11-09 : 02:23:22

Hi

I installed al the options that it provided me with.

ratheeshknair
Posting Yak Master

129 Posts

Posted - 2007-11-09 : 04:55:30

Are you having SQL Server Express Edition.If so connect using server_name\sqlexpress.

RKNAIR

rcr69er
Constraint Violating Yak Guru

327 Posts

Posted - 2007-11-09 : 05:51:56

Hi

No I am using the standard edition