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 2012 Forums
 SQL Server Administration (2012)
 Server Name More Than 15 Characters

Author  Topic 

jbates99
Constraint Violating Yak Guru

396 Posts

Posted - 2014-11-17 : 18:16:24
Hi,
This new 2012 server has a name that's 19 chars long.
When I run SELECT @@serverNAME the last 4 chars dont show but in Management Studio, the full name shows.

This is a default instance, not named.
Should I be concerned, will this cause any issues down the road?
Thanks!

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2014-11-17 : 18:23:00
A quick google search indicates that yes you should be concerned. I searched on "@@SERVERNAME 15".

Here's one example: http://serverfault.com/questions/123343/is-the-netbios-limt-of-15-charactors-still-a-factor-when-naming-computers

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

jbates99
Constraint Violating Yak Guru

396 Posts

Posted - 2014-11-24 : 21:07:29
Thank you, Tara. I'll look into this further. It may not be a problem with Windows Server 2012 R2 and SQL Server 2012 though the fact that @@ServerName doesn't return more than 15 chars bothers me.
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2014-11-25 : 12:13:11
Well Windows/SQL 2012 support more, but NETBIOS doesn't. I remember we had an issue on Windows 2008 with a server name over 15 characters. I don't remember the issue, but I remember having to shorten the name. I think it was an issue with a software package though. I'm no longer at that job, otherwise I'd ask around if anyone remembers that issue.

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page
   

- Advertisement -