sql server connection strings

Question

0.00/5 (No votes)

See more:

hi there, am developing a windows database application, when i try to connect to my sql server 2005 database using my development computer where the server and database are installed, everything works out fine, but when i install my application on another computer on the same Local Area Network as my server, the application does not connect to the database, or Sql server. How can i go about this please?

Thanks in advance.
Yours faithfully
Martin

Posted 5-Oct-10 0:52am

katumbamartin

Add a Solution

6 solutions

Solution 4

Are you using Windows Authentication on your machine and the user on the other machine is not set up to access the SQL server?

Take a look at this

Posted 5-Oct-10 3:24am

Ryan McBeth

Solution 5

this web site will be useful to get all information about connection strings
http://connectionstrings.com/

Posted 5-Oct-10 3:25am

alrosan

Solution 6

you should verify if your database server has tcpip connection enabled in mssql configuration manager. This option is not a default setting.

Posted 5-Oct-10 9:07am

Alicia Ouellet

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)

Hiren solanki · Accepted Answer · 2010-10-05T00:58:00

Solution 1

You may have used localhost inside connectionstring for connecting, That's why it is connecting from your devlopement pc,
To use it from anywhere use IP address or ComputerName rather to be connected from anywhere,

Please vote and Accept Answer if it Helped.

Posted 5-Oct-10 0:58am

Hiren solanki

sankar guru · Accepted Answer · 2010-10-05T02:21:00

Solution 2

change DataSource name from "." or (local) to Server name where your database is stored.

Posted 5-Oct-10 2:21am

sankar guru

2gizzo · Accepted Answer · 2010-10-05T03:22:00

Another cause could be using integrated security instead of sql aunthentication so i suggest switching from integrated security to sql aunthentication and then connect using ip address/computer name as suggested. Also check to make sure that sql is enable for remote connections as it is usually disabled by default and if u are behind a firewall make sure to add rules so that it can connect remotely! Hope this helps