Connection problem in SQL server 2005

Question

Post reply

Connection problem in SQL server 2005

vefa

Mr or Mrs. 500

Points: 589
More actions
July 9, 2007 at 8:37 pm

#179684

Hi,
I am using SQL2005 Developer edition sp 2.
I can connect my local server using localhost but I can not connect using server name like c0001. It does not accept or recognize server name. It was working until yesterday.
Because of this situation, I cannot start SQL server Agent. SQL server agent's host name is c0001, it does not find host and it does not work.
Is there any idea about this?
Thanks in advance.
Vefa

Viewing 15 posts - 1 through 15 (of 16 total)

You must be logged in to reply to this topic. Login to reply

Sugesh Kumar One Orange Chip Points: 27311 More actions · Answer 1

When you login to the server using local. Check what is the server name using select @@servername

if this is not consistent then

use sp_dropserver and sp_addserver to add the server name and then use it.

Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com

vefa Mr or Mrs. 500 Points: 589 More actions · Answer 2

I checked. That is correct. I can see as 'c0001\SQL2005'.

It still continue same problem.

In addition, After connecting to the SSMS using localhost, I cannot expand SQL Server Logs. I am getting error like this:

TITLE: Microsoft SQL Server Management Studio

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

Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)

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

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

ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

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

A severe error occurred on the current command. The results, if any, should be discarded. (Microsoft SQL Server, Error: 0)

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

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

BUTTONS:

OK

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

Vefa

Sugesh Kumar One Orange Chip Points: 27311 More actions · Answer 3

If its a named instance then you have to specify servername\instancename to connecto to the server specifying only the server name will not help. You are having a named instance of SQL Server. Change the connection to 'c0001\SQL2005' instead of 'c0001'

Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com

vefa Mr or Mrs. 500 Points: 589 More actions · Answer 4

I am using instance name. I can connect localhost\SQL2005 but, not connect C0001\SQL2005.

Vefa

steve smith-401573 SSChampion Points: 10889 More actions · Answer 5

Did you check the Microsoft reference links you cited? when i went there, they specified that no further information was available!

(revised for clarity - the MS support posts indicated that no further information was available.)

vefa Mr or Mrs. 500 Points: 589 More actions · Answer 6

Hi Steve,

Sorry, I did not understand, What do you mean?

I am not using linked server. It is a local server.

Thanks

Sugesh Kumar One Orange Chip Points: 27311 More actions · Answer 7

What is the account in which your sql services run. try to run them under local system and see if this error occurs else then its a permissio problem given to the user starting the sql agent.

Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com

vefa Mr or Mrs. 500 Points: 589 More actions · Answer 8

SQL Services Account is local system. There is no any problem to run the service.

I tried to connect osql using command line. I got "Multi-protocol Connection" sql server does not exist or access denied" error.

I checked protocols and TCP/IP and Name pipes were enabled.

This problem is not only related to the SQL agent, and also I cannot connect SSMS using C0001\SQL2005.

Thanks.

Vefa

Rich Hansell SSCrazy Points: 2346 More actions · Answer 9

is this the only SQL instance on the machine? (the c0001\SQL2005 instance)

Gift Peddie SSC Guru Points: 73570 More actions · Answer 10

Actually the correct place to start all the services is not Management Studio but the configuration manager where you can turn on services or turn the services off. So go to SQL Server drop down in programs, then configuration tools then configuration manager. While you are at it also use the surface area configuration tool to configure your connection related serices. Hope this helps.

Kind regards,
Gift Peddie

vefa Mr or Mrs. 500 Points: 589 More actions · Answer 11

It is only instance in my local computer.

I know configuration settings and checked lots of time.

SQL services runs, there is no problem. My problem is only I cannot connect SQL services using machine name like C0001\SQL2005.

I can connect SQL services using Localhost\SQL2005.

Thanks

Sugesh Kumar One Orange Chip Points: 27311 More actions · Answer 12

Positively you should get this resolved by editing some registry keys. Check the folder Microsoft SQL Server to find the right key and get things solved.

Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com

Rich Hansell SSCrazy Points: 2346 More actions · Answer 13

I know this seems like a silly question.. but can you telnet to c0001 on port 1433? ie: Telnet c0001 1433

vefa Mr or Mrs. 500 Points: 589 More actions · Answer 14

Hi,

Thanks for your help.

I solved my problem, reinstalling SQL server 2005 as a new instance.

Thanks.

Vefa