Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Connecting to SQL SERVER
Message
 
 
To
11/03/2010 17:05:49
General information
Forum:
Microsoft SQL Server
Category:
Database management
Environment versions
SQL Server:
SQL Server 2008
Application:
Desktop
Miscellaneous
Thread ID:
01454042
Message ID:
01454043
Views:
45
>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
Previous
Reply
Map
View

Click here to load this message in the networking platform