Does SQL 2005 Express support two instances in different languages ?

  • Hello,

    I work in a software company and our product installs a local English instance of SQL 2005 Express as an option if the user does not have a full SQL server at their disposal. It is a typical named instance.

    We will also install a new named instance if SQL 2005 Express already exists with a default instance. In testing the software I ran across an issue that I cannot find a definitive answer to and the scenario is as follows:

    -A German OS Windows 2003 R2 Server with all SP's and patches.

    -A default instance of German SQL 2005 Express w/ SP1 is installed.

    -When I kick off our software it asks if I would like to install a named instance of SQL 2005 Express.

    -It starts to install and then fails with the following error.

    System.Exception: Unable to connect to database '':

    Fehler beim Herstellen einer Verbindung mit dem Server. Beim Herstellen einer Verbindung mit SQL Server 2005 kann dieser Fehler dadurch verursacht werden, dass unter den SQL Server-Standardeinstellungen Remoteverbindungen nicht zulässig sind. (provider: SQL-Netzwerkschnittstellen, error: 26 - Fehler beim Bestimmen des angegebenen Servers/der angegebenen Instanz).

    It seems to be trying to do a remote connection but everything is local.

    My question is .... If a German edition of SQL 2005 Express is installed on a German Win2K3R2 OS, is it possible to install a new instance in US English on the same machine ? English on English works like a charm. I am only having this issue when I try to install a second instance in a second language.

  • That's an interesting one, and you might need to contact MS on this. Express should do multiple instances without an issue, but I can see that the languages could be a place someone forgot to place a check.

    I'll ping a few people and see what they say.

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply