transfering website project to another computer


I am trying to transfer a web site project in microsoft visual studio 2010 from one computer to anotherl  Both running Visual studio 2010 and SQL Express 2008.  
I copy and pase the website folder to the new computer and tryied restoring database on the new computer which doesn't work.
Also tried coying the .mdf and .log files to the sql data file and attaching the .mdf file.  This works in management studio but when running the web site and trying to log in give an error with user instances.

System.Data.SqlClient.SqlException: Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. The connection will be closed

Anyone know how to solve this or a good guide on how to transfer web site project to another computer.

Thank you
Who is Participating?
Claudiu10Connect With a Mentor Author Commented:
Hi, found a solution.  

delete data in folder under C:\Users\User\AppData\Local\Microsoft\Microsoft SQL Server Data\sqlexpress.

I don't know why nothing is straight foward with microsoft.
Backing up and Restoring a sql database to another server doesn't automatically get the security logins also.  Delete the user from the "Databases/YourDatabase/Security" folder under the database, then add it back again.  Make sure the user exists in the "Security/Logins" folder for the server first.
Claudiu10Author Commented:
well that didn't help now I can't even connect to sql express server with management stuido error 4064
Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Claudiu10Author Commented:
tried that and thought maybe if I cange the default database to the one i want may solve it but that maybe unable to connect to sql express at all through management studio
Claudiu10Author Commented:
Hi, so getting all kinds of errors now.  Have to un-install sql server and re-install it.  If someone knows a good complete guide to transfering web site project and database to another computer please post.  
Claudiu10Author Commented:
Because it works
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.