Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Instance name specified is invalid

Status
Not open for further replies.

be1s

Programmer
Dec 8, 2003
59
0
0
US
Trying to do a db server installation of a third-party application on to our server (Windows 2000 Server) running SQL Server 2000. I keep getting the following error:
"Instance name specified is invalid"

Any reason why this may be happening?

Thanks in advance for your help.
 
This is from the BOL......

Instance Naming Rules

An instance name is not case-sensitive.

An instance name cannot be the terms Default or MSSQLServer.

Instance names must follow the rules for SQL Server identifiers and cannot be reserved keywords.

Instance names are limited to 16 characters.

The first character in the instance name must be a letter, an ampersand (&), an underscore (_), or a number sign (#). Acceptable letters are those defined by the Unicode Standard 2.0, which includes Latin characters a-z and A-Z, in addition to letter characters from other languages.

Subsequent characters can be:
Letters as defined in the Unicode Standard 2.0.

Decimal numbers from either Basic Latin or other national scripts.

The dollar sign ($), a number sign (#), or an underscore (_).

Embedded spaces or special characters are not allowed in instance names. Neither is the backslash (\), a comma (,), a colon :)), or the at sign (@).

Please refer to the BOL for more information on Instance Names.

-SQLBill

Posting advice: FAQ481-4875
 
Thanks.

It turns out that the third-party app is only compatible with MSDE and not SQL Server 2000.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top