Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 


 
     
Recent Posts
   
Popular Topics
Home   
Search
    Members    Calendar    Who's On

Home » Notification Services » Administration » What isthe max length of an SQL Server...
Add to briefcase

What isthe max length of an SQL Server instance name? Expand / Collapse
Rate Topic
Display Mode
Topic Options
Author
Message
SQL ORACLE
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 05, 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
Daniel Juvet
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 09, 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
Welsh Corgi
Posted Wednesday, May 04, 2011 12:13 PM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Wednesday, May 22, 2013 6:19 AM
Points: 3,833, Visits: 4,052
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
GSquared
Posted Wednesday, May 04, 2011 12:22 PM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Tuesday, May 21, 2013 1:55 PM
Points: 15,442, Visits: 9,571
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
GSquared
Posted Wednesday, May 04, 2011 12:24 PM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Tuesday, May 21, 2013 1:55 PM
Points: 15,442, Visits: 9,571
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
Welsh Corgi
Posted Wednesday, May 04, 2011 12:51 PM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Wednesday, May 22, 2013 6:19 AM
Points: 3,833, Visits: 4,052
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
Welsh Corgi
Posted Wednesday, May 04, 2011 12:58 PM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Wednesday, May 22, 2013 6:19 AM
Points: 3,833, Visits: 4,052
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

 
 
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.