July 20, 2011 at 10:00 am
When I do a select @@servername in SSMS I receive a different name then what the Object Tree shows. I had been logging into SSMS using the instance name that displays in Object Tree but then I tried using the @@servername from the select I did and it goes in but again it shows a different name in the Object Tree. I am confused by this. It is causing issues when I try and configure a Distributor on the instance. Stating that I can not connect using the name of the instance on the Object Tree and have to connect using @@servername. Any ideas why or how this could be?
Thanks,
Sean
A clever person solves a problem. A wise person avoids it. ~ Einstein
select cast (0x5365616E204465596F756E67 as varchar(128))
July 20, 2011 at 10:08 am
the object tree shows you the name as you registered it in your registered servers - if you connected using them.
Another reason could be you/someone declared a server alias at client level.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
July 21, 2011 at 1:02 am
What do you get when you run the following query?
select * from sys.servers
May be your server name was renamed.
May be use you can fix it using sp_dropserver and sp_addserver
July 21, 2011 at 3:00 pm
Hi Suresh,
The same comes up with your query as does when running the select @@Servername.
Thanks
A clever person solves a problem. A wise person avoids it. ~ Einstein
select cast (0x5365616E204465596F756E67 as varchar(128))
July 21, 2011 at 3:04 pm
I am thinking that it must be a alias of some sort. When I attempt to connect to the instance using what it is named through select @@servername then it just details to the other servername in the object tree. This is through an external IT company that installed/confiigured the server and sql server. They left it to me to configure our application on it. Thanks!
A clever person solves a problem. A wise person avoids it. ~ Einstein
select cast (0x5365616E204465596F756E67 as varchar(128))
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply