how to set the network string

Question

2.00/5 (1 vote)

See more:

Hi,

i want to access the database from another system (like client-server ).
i am using the following string at this time.(which is used in local system)

string connstr = @"Server=.\SQLEXPRESS ;Initial Catalog=DB;Integrated Security=True; Max Pool Size=100";

Please tell me what is the change will be added in my string.

Posted 17-Sep-13 3:52am

indiancodinglove

Add a Solution

Comments

[no name] 17-Sep-13 10:00am

www.connectionstrings.com

Zubair Alie 17-Sep-13 10:04am

Check Fredrik's solution. + NAME_OF_YOUR_SERVER_HERE = the IP or the URI. i.e. 192.158.0.123

4 solutions

Solution 2

As Fredrik has stated, you replace the . before the \SQLEXPRESS with the name of the server you are connecting to. The . is a shorthand way of referring to your local machine. Note

Posted 17-Sep-13 4:01am

Pete O'Hanlon

Solution 3

try

string con = @"Server=serverip(127.0.0.1)(for local)\SQLEXPRESS ;Initial Catalog=DB;Integrated Security=True; Max Pool Size=100";

Posted 17-Sep-13 4:16am

sreeprakash248

Solution 4

Just in case, some more issues related to SQL Server Express remote accesses are covered here:
http://stackoverflow.com/questions/9138172/enable-tcp-ip-remote-connections-to-sql-server-express-already-installed-databas[^]
and here:
http://social.msdn.microsoft.com/Forums/sqlserver/en-US/97a0ddf7-d23e-4723-b49f-463943180172/how-to-configure-remote-connections-to-sql-server-2008-r2-express[^]

Posted 17-Sep-13 4:21am

V.Lorz

Comments

indiancodinglove 18-Sep-13 0:29am

thanks all
its working but one problem.

when i am off the firewall option then the connectivity is working fine data can be retrieve from the database if firewall option on (adding with port tcp=1433) then it show an error.

"An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)"

V.Lorz 18-Sep-13 1:11am

Perhaps that depends on more firewall configuration parameters, not only the port and where it is located (in the local computer that attemps the connection, the remote server, or one physical device in between.

indiancodinglove 18-Sep-13 1:40am

remote server

V.Lorz 18-Sep-13 2:04am

Ok, if it already works with the firewall disabled then you have most of your work done and something to play with.

indiancodinglove 18-Sep-13 2:15am

only for my knowledge. i think why it is not working with the firewall option enable so i am trying.

indiancodinglove 18-Sep-13 2:29am

Finally i have find the solution that UDP Port must be add with the TCP port.

Like TCP=1433,UDP=1434

http://blog.sqlauthority.com/2009/05/21/sql-server-fix-error-provider-named-pipes-provider-error-40-could-not-open-a-connection-to-sql-server-microsoft-sql-server-error/

http://blogs.msdn.com/b/sql_protocols/archive/2007/05/13/sql-network-interfaces-error-26-error-locating-server-instance-specified.aspx

V.Lorz 18-Sep-13 3:47am

Great!

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Fredrik Bornander · Accepted Answer · 2013-09-17T03:56:00

Solution 1

Change it to;

string connstr = @"Server=NAME_OF_YOUR_SERVER_HERE\SQLEXPRESS ;Initial Catalog=DB;Integrated Security=True; Max Pool Size=100";

Hope this helps,
Fredrik

Posted 17-Sep-13 3:56am

Fredrik Bornander