Unable connect sql server databse

Saravanakumar's Avatar

Saravanakumar

06 Mar, 2018 08:39 AM

Hi,
I hosted my asp.net application and added sql server add-on to perform database actions.
I got a SQL server connection credentials. But, when i am unable to connect the database through the remote. Its quite urgent for me.
Kindly help me.

Thanks.

  1. Support Staff 1 Posted by rune on 06 Mar, 2018 08:58 AM

    rune's Avatar

    Hi,

    Seems like the database associated with your app is up and running just fine -- so it's likely a local computer, network or ISP-related issue. Some networks/ISPs don't allow traffic on the default SQL Server port (1433) and I suspect you won't be able to connect to other SQL server databases or services hosted elsewhere on that port.

    You can try and verify whether that's the issue by connecting from a different network. You might also want to try and connect from a different computer to rule out any local firewall/configuration issues.

    Best,
    Rune

  2. rune closed this discussion on 06 Mar, 2018 08:58 AM.

  3. Saravanakumar re-opened this discussion on 06 Mar, 2018 10:21 AM

  4. 2 Posted by Saravanakumar on 06 Mar, 2018 10:21 AM

    Saravanakumar's Avatar

    Hi,
    Thanks for your quick response. Yeah, i can able to connect the database through remote.
    But, when i tried to login from my application .I am getting exception as '↵Login failed for user 'cfbmotufqwdhfcbw'.'

    My connection string is ''

    Data Source=62eccc94-033f-47a4-975e-a89a00457698.sqlserver.sequelizer.com;Initial Catalog=db62eccc94033f47a4975ea89a00457698;User Id=cfbmotufqwdhfcbw;Password=xxxxx;integrated security=false.

    Plase help me.

    Thanks

  5. Support Staff 3 Posted by rune on 07 Mar, 2018 06:13 AM

    rune's Avatar

    Hi,

    Ah ok I thought you had trouble connecting to the server from your own machine. If you're still having trouble connecting from your application it's likely because the application isn't using the correct connection string. There are a number of way you can configure your application, and AppHarbor can also replace connection string based on the name/alias. You can read more about the options in this knowledge base article.

    Best,
    Rune

  6. rune closed this discussion on 07 Mar, 2018 06:13 AM.

Discussions are closed to public comments.
If you need help with AppHarbor please start a new discussion.

Keyboard shortcuts

Generic

? Show this help
ESC Blurs the current field

Comment Form

r Focus the comment reply box
^ + ↩ Submit the comment

You can use Command ⌘ instead of Control ^ on Mac