|
 Data Masker Home
The Data Masker software home page.
 Site Map
A complete map of everything on this web site.
 Download Data Masker
A 30 day fully functional evaluation of the Data Masker software.
 Net 2000 Ltd. Home
The home page of the authors of Data Masker and other useful software products.
 Contact Us
How to email / phone / fax us.
|
A Note on Using Visual Studio 2005 to Connect to SQL Servers by Name
Anthony Z. sends us this information regarding a feature you may run
across when connecting to SQL Servers out of the .NET 2005 development environment.
We have not tested this yet - but thought we would pass on the advice.
Regardless of the fact that .NET 2005 development environment shows SQL Servers by name
one needs to use an IP address and port number of a computer where SQL
Server 2005 Express is installed to get connected to the server
The connection string should be created in the following way:
string connString = "server=192.168.0.36, 1030; Integrated
Security=True; Initial Catalog=my_data_base; User ID=my_user_id;
Password=my_pwd"
Notes:
Integrated Security=True
- This is a must since we need to let SQL Server know that we use Windows authentication
server=192.168.0.36, 1030
- Port number (in the example below it is 1030) should be retrived from the properties of TCP/IP protocol
(see example of the TCP properties where the port is 1066).
- It should also be noted that the port number can be set to be randomly assigned by a Browser service when it gets started.
[ <<<Main Page >>> ]
|
