Skip to main content
S
snowwis
Participant
May 5, 2006
Question

Breeze Server 5 setup/congifuration

  • May 5, 2006
  • 2 replies
  • 560 views
Is it possible to use a SQL2000 instance that is located on a remote server within the domain? I haven’t been able to find any documentation on this tier-ed set up. I'm getting a "java.sql.sqlexception: the requesting instance is invalid..." when setting up the application. using "servername\instance ort"

Have a great weekend! B
    This topic has been closed for replies.

    2 replies

    D
    Community Expert
    Dave WattsCommunity Expert
    Community Expert
    June 8, 2006
    To connect to a named instance, you will need the hostname and port of that named instance. You cannot specify the instance name like you would from ODBC using a slash. You will have to specify the port in custom.ini, if I recall correctly. I have set Breeze up a couple of times this way.

    Dave Watts, CTO, Fig Leaf Software
    Dave Watts, Eidolon LLC
    Q
    quig06107
    Participant
    June 21, 2006
    UPDATE: My mistake. I installed a fresh version of SQL 2000 and forgot the service pack...on MS Server 2003, you must be at SP2 or better in order to connect over 1433...

    Ok, maybe I'm missing something, so here's the process I'm using that isn't working...

    1. install named instance of SQL server
    2. Install Breeze
    3. Go through the configuration (fail on database)
    4. Edit custom.ini....restart services
    5. restart configuation tool...fail on database
    6. repeat...

    Where am I going wrong? Do I need to point breeze at an unnamed instance of SQL server initially, then change? I can't get through the initial configuration of the database. I've tried all kinds of variations in names for the Database Host, name, etc.

    Any help would be great.

    EDIT 1: "Database Host" - What does that mean? Does that mean the host name of the machine? Does it mean the instance name of the database? Ugh, this is frustrating....again any help would be greatly appreciated!
    A
    Anonymous
    May 22, 2006
    Snowwis,

    Have you tried using just the servername in your Database Configuration (custom.ini or breeze console)?

    For example, instead of DBHOST\instance try using just DBHOST (and restart Breeze)

    I would assume you are already using the correct port in your config.ini, or you'd be seeing a second error like "Error connecting to this database host"

    Hope that helps,
    Christopher
    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices