Weird problem.. with server name

Question

Viewing 10 posts - 1 through 9 (of 9 total)

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

Richard M. SSCertifiable Points: 7401 More actions · Answer 1

Did you recently change the actual servername (on the server, Windows)?

How did you come up trying to connect with the -be extension?

_______________________________________________________________________
For better assistance in answering your questions, click here[/url]

M&M SSC-Insane Points: 21700 More actions · Answer 2

Is there any way to check when this change happened.

In my knowledge, I never changed it.

M&M

GTR SSCrazy Eights Points: 8007 More actions · Answer 3

Check the windows events logs and SQL server logs.

EnjoY!

GTR SSCrazy Eights Points: 8007 More actions · Answer 4

Make sure both results are same when you run these statements, assuming default instance name.

select @@SERVERNAME

go

select serverproperty ('ComputerNamePhysicalNetBIOS')

EnjoY!

EnjoY!

M&M SSC-Insane Points: 21700 More actions · Answer 5

When I run this select serverproperty ('ComputerNamePhysicalNetBIOS')

it returns NULL.

Is this because the server I am referring to is SQL Server 2000.

M&M

GTR SSCrazy Eights Points: 8007 More actions · Answer 6

Try this!

select serverproperty ('MachineName')

EnjoY!

M&M SSC-Insane Points: 21700 More actions · Answer 7

I am getting same servername when I run below commands

select @@servername

select serverproperty ('MachineName')

But I am only able to register/connect with this name servername-BE,1433 and not

servername,1433

M&M

M&M SSC-Insane Points: 21700 More actions · Answer 8

One more point.

The IP addresses of servername and servername-BE are different.

I am able to ping both these server names.

But I am only able to register\connect to servername-BE

M&M

Richard M. SSCertifiable Points: 7401 More actions · Answer 9

Have you checked if you have more than one instance of SQL installed? Also, are both IP's on the same server or different ones?

_______________________________________________________________________
For better assistance in answering your questions, click here[/url]