Mensaje
De
11/03/2010 17:11:43
a
11/03/2010 17:05:49
General information
Foro:
Microsoft SQL Server
Category:
Mantenimiento de bases de datos
Título:
Environment versions
SQL Server:
SQL Server 2008
Application:
Desktop
Miscellaneous
ID de la conversación:
01454042
ID del mensaje:
01454043
Views:
47
>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.
>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.