Hi,
I am just starting to use VS2005 and SQL Server Express 2005. One of the tutorials I've been looking at asks me to add a new Database Item by right clicking on my project and choosing Add Item, then SQL Database.
If I try and do this I get the following error:
Failed to generate a user instanceof SQL Server due to a failure in starting the process for the user instance. The Connection will be closed.
I have searched and found there is a similar problem down to trying to do this remotely, I have carried out their suggestions of changing the built in account to "Local System" in the SQL Server Express 2005 Properties. And also delete the folder SQL SERVER in the Microsoft folder in Application Data. But this hasn't worked and I still get the error.
If I try and create a new database in the Server explorer by right clicking and selecting "Create New SQL Server Database..." This works fine.
First of all, can anyone give me any suggestions to solve my problem? And secondly, can anyone tell me why I would use an .mdf file as opposed to creating a new SQL Server Database?
Thanks in advance...
JohnnyC
hi JohnnyC,
try having a look at http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=152338&SiteID=1 to see if helps..
regards
No comments:
Post a Comment