connection string

Question

0.00/5 (No votes)

See more:

Hi all,

I have created one small application.

It is working fine in local system, but I am going to configure my application to LAN, so I need to change my SQL connection string I think.

This is my connection string for connecting locally:

VB

con = New SqlConnection("Password=frogy@123;Persist Security Info=False;User ID=sa;Initial Catalog=frogy;Data Source=SAMEER-PC\SQLEXPRESS")

How do I have to modify my connection string to make it work in LAN environment?

Thank you!

Posted 12-Dec-10 4:05am

sameertm

Updated 13-Dec-10 0:08am

Dalek Dave

v3

Add a Solution

Comments

Dalek Dave 13-Dec-10 6:08am

Minor Edit for Grammar and Readability.

2 solutions

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)

Simon_Whale · Answer 1 · 2010-12-12T22:53:00

Solution 2

also look at Connection Strings[^]

Posted 12-Dec-10 22:53pm

Simon_Whale

Manfred Rudolf Bihy · Answer 2 · 2010-12-12T04:18:00

Solution 1

If you want to use SQLExpress in a LAN environment where the application is running on different server as where the database is running, you'll have to enable SQLExpress for remote access:

Read all about it here: http://blogs.msdn.com/b/sqlexpress/archive/2005/05/05/415084.aspx

If SAMEER-PC is the network name of the computer you intend to run the SQLExpress DB on, your connection string should be fine.

Cheers,

Manfred

Posted 12-Dec-10 4:18am

Manfred Rudolf Bihy

v2

Comments

sameertm 12-Dec-10 10:46am

My Server Pc name is SAMEER-PC only, then can u please tell me how should be the connection string

Manfred Rudolf Bihy 12-Dec-10 11:18am

As I wrote in my answer, your connection string is fine. Did you already follow the instructions behind my link to make your SQLExpress DB remotely accessible?