hi,
I have a working solution, VS 2005 using C# where i save data through DataAdapters to MS SQL Server 2005 Full blown version. I needed to move my C# project into another machine with C# Express installed on it (the free edition by microsoft) and SQL Express 2005. now in machine1 (with the full version) everything is working great, with machine 2 i am having a hard time configuring the database to make it work with visual studio since the express edition uses a data file instead of the full .mdf database.
From my Data Explorer Tab (in C# Express version) i am trying to create a new Data Connection, I get the following error after providing the database file name:
Cannot open user default database. Login failed. Login failed for user 'WKDEV\Administrator'.
From SQL Express enterprise studio i was able to restore the database just fine. has anyone gone through this before?
Start Free Trial