Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Connect to Default SQL Server Instance
Message
De
12/05/2016 19:34:47
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Client/serveur
Titre:
Connect to Default SQL Server Instance
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Network:
Windows Server 2012 R2
Database:
MS SQL Server
Application:
Desktop
Divers
Thread ID:
01636305
Message ID:
01636305
Vues:
64
When installing SQL Server, you have a choice to install either:

- a "default" instance, which nominally is called "MSSQLSERVER"
- or, a "named" instance which can be called anything else

If you use a named instance, you have to install the SQL Server Browser service, which I gather acts as a sort of DNS so that client computers can find the named instance on the network. The SQL Browser service does not need to be installed if the only instance on a given machine is the default instance.

Suppose a machine is named MyMachine:

Connect to Default instance, SQL Browser service not present
- You can just use the machine name MyMachine as the instance name in connection strings -> Works

Connect to a Named instance "MyInstance", SQL Browser service present
- You use an instance name of MyMachine\MyInstance in connection strings -> Works

Connect to Default instance, SQL Browser service not present
- Attempt to use instance name i.e. MyMachine\MSSQLSERVER -> Fails

My question is this: if, with just the default instance installed on a given machine, if the (not technically required) SQL Browser service is installed, is it possible to connect to the default instance using MyMachine\MyInstance, or is it still necessary to use just the machine name MyMachine?

i.e. Connect to Default instance, SQL Browser service present
- Attempt to use instance name MyMachine\MSSQLSERVER -> ???

All of my dev instances are named instances, I don't have a default instance installation to test. Does anyone know or can test the above scenario?
Regards. Al

"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov

Neither a despot, nor a doormat, be

Every app wants to be a database app when it grows up
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform