I have finished a program using sql server and visual studio using c# language . I want to put the database on pc and the program that connected to that database on other PCs
I'm using this connection string in App.config : <connectionStrings> <add name="MWEConnectionString" connectionString ="integrated security=yes;initial catalog=MWDB;data source=.\sqlexpress"/> </connectionStrings>
Should I change server name by pc external ip address??or what?? I don't know how to do it
Can any body help me with steps ,please? thanks in advance
Do those two things and see if you are able to connect from a remote box to the server as a user who has administrative privileges. That is just to make sure that you are ABLE to connect.
Recommended practice is that users have only limited privileges - enough to do what they need to do. So once you have established that you are able to connect from remote computers, create users and grant them privileges on the database that they need to access. There are step by step instructions here: http://msdn.microsoft.com/en-us/library/aa337562.aspx Also look at the links at the bottom of that page.
I need a help in connecting to remote database
Posted - 12/27/2011 : 05:00:50
