Connecting to SQLExpress Database.
I have an app on a development machine whose machine name is "PTS" that has connects to the SQLExpress ProfitPlus database with this connection string...
"Data Source=localhost\SQLEXPRESS;Initial Catalog=ProfitPlus;Integrated Security=True;Pooling=False;Workstation ID=PTS"
When I install the app on another machine whose machine name is "SERVER" using the "Owner" login (standard for WINXP Home) I get the error message
"Cannot open the database "ProfitPlus" requested by the login. The login failed for user "SERVER\Owner".
I've tried changing the settings in the app.exe.config file but can't seem to get the right syntax.
Anyone know how to set my connection string so that I can access the data on the SERVER\Owner machine?
Thanks

