Failed to generate a user instance of SQL server due to a failure in starting the process for the user instance.
I've been trying to log onto my database for 3 days, but keep getting an error after another the above being the latest.
I think the error could be within my connection string in my app config file:
the server is local, login in using windows authentification, it takes in a user name ray-pc-ray with no password. I'm connecting with entity framework meta data files, ssdl, csdl etc.
<add name="videoRentalEntities1" connectionString="metadata=res://*/VideoRentalModel.csdl|res://*/VideoRentalModel.ssdl|res://*/VideoRentalModel.msl;provider=System.Data.SqlClient;provider connection string='Data Source=.\SQLEXPRESS;AttachDbFilename=C:\Users\ray\Desktop\mini projects\NewVideoRental\Data_Access_Layer\videoRental.mdf; Integrated Security = true; connect timeout=30;user instance=false;multipleactiveresultsets=True;App=EntityFramework'" providerName="System.Data.EntityClient" />
if this is ok then, I just followed this post click here, but Microsoft sql server data folder doesn't exist in my file system.
any ides on dealing this problem.
This post has been edited by modi123_1: 03 April 2013 - 05:40 AM