How can I run my C# application having SQL database in another machine?

Question

I am using SQL Express for managing database in windows application programmed in C#. I am using the connection string Data Source=.\\SQLEXPRESS;Initial Catalog=caf;Integrated Security=True but it is not working in another machine. What can I do to make it work?

This could be caused by a whole lot of things. You connection string looks like it's connecting to a local database. Is the database on the other machine? What error message are you getting back? — Damon
– Damon, Commented Aug 1, 2013 at 18:08
Is SQL installed on the other machine as an instance named SQLEXPRESS? — Chris Bednarski
– Chris Bednarski, Commented Sep 8, 2013 at 21:28

MeTitus · Accepted Answer · 2013-08-01 18:12:06Z

6

You are missing the: Server=myServerAddress;

Connection Strings

"Server=myServerAddress;Database=myDataBase;User Id=myUsername; Password=myPassword;"

edited Aug 1, 2013 at 18:12

answered Aug 1, 2013 at 18:06

MeTitus

3,4382 gold badges29 silver badges50 bronze badges

Sign up to request clarification or add additional context in comments.

6 Comments

MeTitus Over a year ago

Firewall on the other machine maybe?

Kedar Over a year ago

thanku. if I give it my computer name then it will only work in my machine. Is there any way to get the user name of another machine in which it is to be installed

MeTitus Over a year ago

You need to set the server parameter in the configuration string to the ip or named pipe in where the SQL instance is running and make sure external connections to that machine are allowed,

MeTitus Over a year ago

Why would you add 127.0.0.1? You need to add the "external" ip not that localhost one.

Kedar Over a year ago

it gives an error. Error 26: error locating server/instance specified.

|

Collectives™ on Stack Overflow

How can I run my C# application having SQL database in another machine?

1 Answer 1

6 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Related