Results 1 to 5 of 5

Thread: Connecting to Azure SQL Database

  1. #1
    Join Date
    Feb 2009
    Location
    Pine Island, Forida
    Posts
    2,076

    Default Connecting to Azure SQL Database

    We are connecting to a SAAS SQL database on Azure. To connect you have to pass the SERVER, ID, PW and DATABASE. This works using INT files but does not work in DBBldr as in the database login function you cannot pass the database name. The SQL INT Repair function tries to login to the SQL server prior to entry of the database name so that also does not work. I tried passing the database name as part of the server with server... ;database=xxx and server....;xxx
    Frank Valcarcel
    Cove Systems, Inc.
    Pine Island, Florida USA
    fv@covesys.com
    (239) 823-7976

  2. #2
    Join Date
    Feb 2009
    Location
    Brazil
    Posts
    5,445

    Default Re: Connecting to Azure SQL Database

    what df version ?
    Using managed connections or not ?

    Remember that for managed connections, DF tools uses a different entry for Password than connections made by your app. you need both of them in the .ini file if you want the tools to connect
    Samuel Pizarro

  3. #3
    Join Date
    Feb 2009
    Location
    Pine Island, Forida
    Posts
    2,076

    Default Re: Connecting to Azure SQL Database

    DF 19.0, non_managed connections.
    DBBuilder connects properly if the INT file is there. Just cant use the rebuild INTs option as it wants the DB with the login.
    fv
    Frank Valcarcel
    Cove Systems, Inc.
    Pine Island, Florida USA
    fv@covesys.com
    (239) 823-7976

  4. #4
    Join Date
    Nov 2008
    Location
    Round Rock, TX
    Posts
    8,849

    Default Re: Connecting to Azure SQL Database

    Frank,

    in the SQL Connect/Repair wizard, if you choose non-Managed Connection, you can specify the database name.

    Click image for larger version. 

Name:	SQLConnectRepairWizardDB.png 
Views:	43 
Size:	9.4 KB 
ID:	14621

  5. #5
    Join Date
    Feb 2009
    Location
    Pine Island, Forida
    Posts
    2,076

    Default Re: Connecting to Azure SQL Database

    Wont work as the builder tries to login to the SQL server before you can enter the DB name.
    Frank Valcarcel
    Cove Systems, Inc.
    Pine Island, Florida USA
    fv@covesys.com
    (239) 823-7976

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •