Get connection string of non server machine( SQL) using c#

Question

I am working on windows forms application using c#.net. i have developed an application that uses sql database as backend. Using local server i am working.Now I need work on client machine who have server on the network(non server machine).How can i work with non server machine).

Please guide me.

Anuraj · Accepted Answer · 2012-08-04 03:55:03Z

1

Modify your connection string. Instead of localhost or "." or your machine name, use the server machine name and sqlinstance name. More about connection strings, check http://www.connectionstrings.com

answered Aug 4, 2012 at 3:55

Anuraj

19.6k7 gold badges61 silver badges84 bronze badges

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

1 Comment

Kiran Reddy Over a year ago

Thanks your reply..i dont know server machine name and sqlinstance name.can i use Remove Integrated Security=True

NG. · Accepted Answer · 2012-08-04 06:51:17Z

0

Suppose when you execute your application, its address comes as

    http://localhost/pagename.aspx/formname

So instead of this, you can access it by replacing localhost by ip address of the machine

http://10.123.4.56/pagename.aspx/formname

answered Aug 4, 2012 at 6:51

NG.

6,1233 gold badges21 silver badges31 bronze badges

2 Comments

Kiran Reddy Over a year ago

I am using windows application.

Kiran Reddy Over a year ago

This is local server connection string : string connection = "data source=localhost;initial catalog=TWO;integrated security=SSPI;persist security info=False;packet size=4096";

Collectives™ on Stack Overflow

Get connection string of non server machine( SQL) using c#

2 Answers 2

1 Comment

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related