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:
01301688
Vues:
13
>>>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....

Does that mean that the SQL Server is using a different port for each instance, and that the port might not be the same every time?
I have read that the browser service is using UDP on port 1434. Is the SQL server still using port 1433.

Is it correct to specify the instance name after the IP address (123.123.123.123/MyInstance)? Could I also specify the port after this (123.123.123.123/MyInstance,1433) and not need the browser service?
Semper ubi sub ubi.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform