Actual Sql Server Name

Question

Post reply

Actual Sql Server Name

dpkngm

SSC Journeyman

Points: 84
More actions
January 13, 2009 at 2:52 am

#129456

Hi Friends,
how may i know the actual name of my sql server 2005.
Please help me...
Deepak Nigam

Viewing 14 posts - 1 through 13 (of 13 total)

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

Adi Cohn-120898 SSC-Dedicated Points: 33944 More actions · Answer 1

select @@servername

Adi

--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

stephen.christie SSC Eights! Points: 895 More actions · Answer 2

Hi,

In MS SQL Server Management Studio, right click on the server and click on Properties.

This will bring up a new window and you will see "Name"

Regards

Stephen

dpkngm SSC Journeyman Points: 84 More actions · Answer 3

Actually i am trying to replicate database from one server to another server. When i click on the replication->Configuration Distribution m receiving an error saying SQL Server replication requires the actual server name to make a connection to the server. Connections through a server alias, IP address, or any other alternate name are not supported. Specify the actual server name, 'TUTORBEN-F3D7EB'. (Replication.Utilities)

Now what to do next please help me........

Deepak Nigam

v.bhatt-929112 SSC Journeyman Points: 79 More actions · Answer 4

have a look at the link below.

http://support.microsoft.com/kb/818334

This may give you right directions.

Vibz

K. Brian Kelley SSC Guru Points: 114532 More actions · Answer 5

dpkngm (1/13/2009)
Actually i am trying to replicate database from one server to another server. When i click on the replication->Configuration Distribution m receiving an error saying SQL Server replication requires the actual server name to make a connection to the server. Connections through a server alias, IP address, or any other alternate name are not supported. Specify the actual server name, 'TUTORBEN-F3D7EB'. (Replication.Utilities)
Now what to do next please help me........
Deepak Nigam

If it's an alias, you'll see that by using SQL Server Configuration Manager on the server where your first SQL Server is installed. Expand SQL Native Client Configuration and click on Aliases. That will tell you what the alias (if it exists) actually points to.

One thing you can do real quick is go to a command prompt and try to ping the name. For instance:

ping TUTORBEN-F3D7EB

If that comes back with an IP address, then execute the following command:

nbtstat -a *IP ADDRESS*

You should see the real name of the server beside the <00> entry.

K. Brian Kelley
@kbriankelley

Luke79 SSCrazy Points: 2538 More actions · Answer 6

Did you change server names at any point and time?

GabyYYZ SSCertifiable Points: 7913 More actions · Answer 7

dpkngm (1/13/2009)
Hi Friends,
how may i know the actual name of my sql server 2005.
Please help me...
Deepak Nigam

Try select serverproperty('ServerName')

Sometimes select @@version doesn't give the true server\instance name.

Cheers.

Gaby A.

Gaby
________________________________________________________________
"In theory, theory and practice are the same. In practice, they are not."
- Albert Einstein

Jonathan Mallia SSCertifiable Points: 5192 More actions · Answer 8

Jonathan Mallia

SSCertifiable

Points: 5192

January 14, 2009 at 8:23 am

#926600

select @@servername, @@servicename

🙂

GabyYYZ SSCertifiable Points: 7913 More actions · Answer 9

Jonathan Mallia (1/14/2009)
select @@servername, @@servicename
🙂

Heh heh... That works too.

😀

Gaby

Gaby
________________________________________________________________
"In theory, theory and practice are the same. In practice, they are not."
- Albert Einstein

Carlton Leach SSCarpal Tunnel Points: 4202 More actions · Answer 10

FROM BOL:

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

Although the @@SERVERNAME function and the SERVERNAME property of SERVERPROPERTY function may return strings with similar formats, the information can be different. The SERVERNAME property automatically reports changes in the network name of the computer.

In contrast, @@SERVERNAME does not report such changes. @@SERVERNAME reports changes made to the local server name using the sp_addserver or sp_dropserver stored procedure.

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

- @@SERVERNAME will give you the original host name under which SQL server was installed.

- serverproperty('servername') will give you the actual servername.

This is how to find out what SQL thinks it is, however I like Brians answer above too.

Carlton..

Marc-480748 Grasshopper Points: 18 More actions · Answer 11

The more correct way would be sp_helpserver.

If that isn't the correct alias that you want (perhaps being on a Veritas Cluster) you can change it with sp_dropserver(oldname)

GO

sp_addserver(correctalias)

GO

aali_online SSC Veteran Points: 221 More actions · Answer 12

Isn't it necessary to supply the local parameter? As in:

sp_dropserver 'old_server_name'

GO

sp_addserver 'new_server_name', local

GO

Or is that only for a non-clustered server?

Carlton Leach SSCarpal Tunnel Points: 4202 More actions · Answer 13

I disagree that sp_helpserver is "more correct".

sp_helpserver gives your more info but in this case we are only after the server name.

Carlton..