Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

What isthe max length of an SQL Server instance name? Expand / Collapse
Author
Message
Posted Wednesday, May 16, 2007 9:34 AM
UDP Broadcaster

UDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP Broadcaster

Group: General Forum Members
Last Login: Friday, April 5, 2013 4:43 PM
Points: 1,473, Visits: 1,314

Could anyone tell me what the maximum length of an SQL Server instance name is?

How about an SQL Server cluster?

Are there any difference in SQL Server 2000 and SQL Server 2005?

Where can we get the information?

Any input will be greatly appreciated.

Post #366423
Posted Friday, March 11, 2011 12:42 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, October 9, 2012 8:00 AM
Points: 9, Visits: 119
Hi
This composed name server\instance in old versions could arrive to 30 characters, limited by own SQL table in SQL 2000.

http://support.microsoft.com/kb/310639/en-us

Daniel
Post #1076682
Posted Wednesday, May 4, 2011 12:13 PM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 4:18 PM
Points: 4,234, Visits: 4,286
Please refer to the following links:

http://stackoverflow.com/questions/5260650/max-length-of-sql-server-instance-name

http://msdn.microsoft.com/en-us/library/ms143531.aspx


For better, quicker answers on T-SQL questions, click on the following...
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/

Post #1103395
Posted Wednesday, May 4, 2011 12:22 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Friday, June 27, 2014 12:43 PM
Points: 13,872, Visits: 9,596
Here's Microsoft's data on max-whatever in SQL Server. The one you want is the "Max Identifier Length", if I'm not mistaken.

http://msdn.microsoft.com/en-us/library/ms143432.aspx

I haven't tested instance-name length, but it should follow the rules here.


- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Post #1103401
Posted Wednesday, May 4, 2011 12:24 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Friday, June 27, 2014 12:43 PM
Points: 13,872, Visits: 9,596
I was wrong.

I just tried installing a new instance, and when I went to name the instance, it stopped letting me type when I got as far as "MyInstanceNameIs". That's SQL 2008 R2.


- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread

"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Post #1103405
Posted Wednesday, May 4, 2011 12:51 PM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 4:18 PM
Points: 4,234, Visits: 4,286
Browser continues to hang, sorry duplicate post.

For better, quicker answers on T-SQL questions, click on the following...
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/

Post #1103432
Posted Wednesday, May 4, 2011 12:58 PM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 4:18 PM
Points: 4,234, Visits: 4,286
You could test like GSquared did and you will find out.

I can't get to machine that I can test at the moment or I would do it.

Regards,
Welsh



For better, quicker answers on T-SQL questions, click on the following...
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/

Post #1103438
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse