Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Connecting to SQL SERVER
Message
 
 
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Maintenance bases de données
Versions des environnements
SQL Server:
SQL Server 2008
Application:
Desktop
Divers
Thread ID:
01454042
Message ID:
01454043
Vues:
46
>I want to ask how can i conecct to the slq server properly through visual basic net
>my pcname is PC1
>I have SQL SERVER 2000, SQL SERVER 2005, SQL SERVER EXPRESS 2008.
>when they ask me to enter the server name, what should i enter ? for example
>if it is sql server 2005
> .PC\SQLSERVER2005
>is that correct?
>Thank you in advance
>Luis

Go to SSMS, connect to the right server and do

select @@SERVERNAME

This is the name you need to use in the Connection String.

Another way to get connection string is to create a file with the extension of udl and double click it. After you make connection to your server, the information would be saved here.
If it's not broken, fix it until it is.


My Blog
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform