VB.NET Application migrating from SQL Server 2005 to SQL Express
Posted on 2007-03-28
Hi, I am tring to migrate an application that I have written in VB.NET using VS2005, from using a SQL Server 2005 database to a SQL Express database.
Basically I have migrated the database into SQL Express and set up the relevant users, and am trying to use the same connection string with the data source being the only change.
However when running the application, I now get the error.
"Login failed for user 'APPUSER'. The user is not associated with a trusted SQL Server Connection.
The previous login string was
User ID=APPUSER;Password = xxx;Data Source="localhost";Provider="SQLOLEDB.1"
the new login string is
User ID=APPUSER;Password = xxx;Data Source=".\SQLEXPRESS";Provider="SQLOLEDB.1"
Any help to get me going again will be very much appreciated.