Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Connecting to a remote SQL Server
Message
Information générale
Forum:
ASP.NET
Catégorie:
Bases de données
Divers
Thread ID:
01301357
Message ID:
01301673
Vues:
8
>>I have SQL Express installed on my development laptop.
>>I want to simulate connecting to a remote SQL Server by using the IP address instead of localhost in the connection string. First question: Is this a good simulation of a remote connection?
>>When I try to use my IP instead of localhost in the connection string I can not connect. I did configure the SQL Server inctance to allow remote connections (using this article http://support.microsoft.com/kb/914277), but that didn't help.
>>I am sure it is something in my connection string. What could I be missing?
>>
>>If anyone has any information to share it would be great.
>
>
>After starting the SQL Server Browser service I was able to connect using my machine's IP address in the connection string.

I guess that's because SQL is using dynamic port addressing. I think that can be disabled but just running the browser service is simpler....
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform