Difficulty connecting to SQL Server

  • Hi all,

    I'm putting this question in the SQL Server 2014 forum, though I expect that the problem is not specific to SQL Server 2014.

    I'm running a Windows 8.1 laptop, and have Visual Studio Ultimate 2013 as well as SQL Server Management Studio 2014 and SQL Server Express 2014. I also have a Windows Azure SQL Server 2014 database server.

    I set up all of this while living in North America - Quebec to be exact. While working from there, I had no trouble connecting to my database server, through Visual Studio or through SSMS.

    I'm now living in France, and am having an extremely hard time accessing my databases. While connecting through SSMS or Visual Studio, it takes 10-20 minutes of waiting before the connection is established with the server. This is true for both the Windows Azure database server AND the SQL Server Express edition installed on the same laptop!

    It makes absolutely no sense - how could it take so long to connect to a server installed on the *same* machine as the applications? What's even more strange, once the connection is established, all other actions happen instantly. There is no delay in communicating with the server once the connection is set up - it seems like the problem is specifically with connecting to the server.

    I tried disabling my Windows Firewall, and that seems to have fixed the problem with SSMS connecting to the servers, however, Visual Studio still has the same problem.

    Can anyone help me with finding out why this is happening? Thanks!

    * Update - if I use the IP address of my machine instead of localhost, SSMS connects with the firewall being on. Visual Studio, however, still doesn't work ...

  • Is the connection issue to Azure? That could be network latency because you're going out to the cloud.

    If it's just local... I'm not sure. I'd suggest using standard troubleshooting approaches, capture wait statistics, capture connection actions through extended events, that sort of thing.

    ----------------------------------------------------
    The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore Roosevelt
    The Scary DBA
    Author of: SQL Server 2022 Query Performance Tuning, 6th Edition and SQL Server Execution Plans, 3rd Edition
    Product Evangelist for Red Gate Software

  • Well, I have no idea why, but it appears as though if I launch SSMS or Visual Studio as Administrator, it solves the problem! Go figure ...

  • That sounds like some sort of multi-hop problem within active directory. Weird.

    ----------------------------------------------------
    The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore Roosevelt
    The Scary DBA
    Author of: SQL Server 2022 Query Performance Tuning, 6th Edition and SQL Server Execution Plans, 3rd Edition
    Product Evangelist for Red Gate Software

Viewing 4 posts - 1 through 3 (of 3 total)

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