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

[831 byte] By [JamesCandy] at [2007-12-17]
# 1
James,

The problem you are hitting sounds to be a problem with local credentials and passwords not being replicated on another machine. Is the SQLExpress instance you are trying to connect to from "SERVER" located on "PTS" or is it installed on "SERVER"? Does Sql Authentication work?

Thanks,

Carl Perry
Program Manager ADO.NET
cperry@microsoft.com

CarlPerry-Microsoft at 2007-9-9 > top of Msdn Tech,.NET Development,.NET Framework Data Access and Storage...

.NET Development

Site Classified