none
Connection problems between azure service and azure sql RRS feed

  • Allgemeine Diskussion

  • Hello,

    i have a problem with a connection between azure service and azure sql. i deployed an asp.net webfrontend (one webrole) in azure, also i deployed a sql databank (i use T-SQL script) in sql azure. I can connect to sql azure via SSMS.

    the confusing thing is that the connection works when i debug the project in VB2010(i mean the connection to azure sql). Once the project is deployed in azure there's a error message when i try to connect( i use a text box to enter the database name and password):

    "Error reading security modules list: "A network-related or instance-specific
    error occurred while establishing a connection to SQL Server. The server was not
    found or was not accessible. Verify that the instance name is correct and that
    SQL Server is configured to allow remote connections. (provider: SQL Network
    Interfaces, error: 26 - Error Locating Server/Instance Specified)".

    Some more information for you:

    connection string in web.config:

    <connectionStrings>

    <addname="SQLAzureConnection"connectionString="Server=tcp:rxxxxp.database.windows.net,1433;Database=Cxxect;User ID=axxx@rxxxp;Password=xxxxxx; Trusted_ Connection=False; Encrypt=True; Connection Timeout=30;

    providerName="System.Data.SqlClient"/>

    </connectionStrings>

    Thanks for help

    Mittwoch, 24. Oktober 2012 07:42

Alle Antworten