Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2005 Forums  SQL Server Administration (2005)  using a sql server 2005 express dbase app on a LAN

Author  Topic  eugee Starting Member 1 Post Posted - 2012-03-22 : 08:44:42 Hello, i've been looking around for a solution to my issue but to no avail ! Here is the scenario: I am using Visual C# 2005 Express Edition and SQL 2005 Express Edition. I wrote a little C# windows application that is using a sql database. I tested it and published it locally and my application works locally, on, in my PC. Now, what i want is to be able to take this application (with all its related files to make it work after publishing) and put it (literally) in a another PC running Server 2003 so that people in my office can use this application from their PC through the LAN. The steps (that come from my readings in various online forums) i have done for that are: - i created a folder on a central PC (the one running Server 2003) and shared it so that users can access the .exe file and the related .mdf file along with the other linked files. - using SQL Server Management Studio Express (SSMSE) 2005, i changed my SQL instance (on that central PC) to allow remote connections and to allow for both SQL server and Windows authentication mode - i created a user account, on the central PC, through SSMSE -> Security -> Logins - i created a user: SQLServer2005SQLBrowserUser$SERVERNAME, through MY Computer -> Manage -> Local User Groups and Groups option - this is the connection string (took from the .config file): <connectionStrings> <add name="WFP_Contacts.Properties.Settings.WFP_ContactsConnectionString" connectionString="Data Source=CMRWDOM02P\SQLEXPRESS;AttachDbFilename=P:\Public\WFPContacts\WFP_Contacts.mdf;Integrated Security=True;Connect Timeout=30;User Instance=True" providerName="System.Data.SqlClient" /> I guess that this connection string has to be changed (among other things) for my application to work on a LAN, would you mind helping me and show me the EXACT steps to carry out in order for my app to work on a LAN, PLEASE ? Thx a million !