Connect to local sql server in asp.net

Question

1.00/5 (1 vote)

See more:

, +

Hi
I need small help . It is possible An ASP.Net hosted application connect to local SQLServer which is running on my machine.

~~pls~~ Please give me some idea how I can achieve this .

~~pls~~ Please help

Thanks

Posted 17-Jun-13 21:12pm

manoj12.shrivastava

Updated 18-Jun-13 1:29am

Shahin Khorshidnia

v2

Add a Solution

Comments

Mahesh Bailwal 18-Jun-13 3:17am

Is Asp.Net application and SQLServer are on same machine?

manoj12.shrivastava 18-Jun-13 3:49am

No my asp.net application hosted on some domain address suppose
www.xyz.com
and my sqlserver is running on my machine ...

VICK 18-Jun-13 3:22am

Where is your application hosted???

On some domain OR on IIS ????

manoj12.shrivastava 18-Jun-13 3:50am

no both are individual
application hosted on xyz.com
and sqlserver is running on my machine

Osman24 18-Jun-13 4:01am

What kind of Internet Connection do you use? It is important because to able to show your computer to your website domain you will probably need port forwarding. If you have not access to your routers you can not, if you have, yes you can achieve this.

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)

**VICK** · Answer 1 · 2013-06-18T01:35:00

to achieve this.. you should be having access to your local machine via some network.. ie.. your machine should be on some public network (having publicly accessed WAN IP)... and than through that Wan IP along with credentials of your local SQL in "web.config"... connectivity would be easy...

KarthickSubramanian25 · Answer 2 · 2013-06-18T01:40:00

Solution 2

Create a ConfigurationString which is xml file in that you have to provide the Sql authentication through that you can able to connect your front end with the sql.

Posted 18-Jun-13 1:40am

KarthickSubramanian25