1
Vote

Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance.

description

I'm trying to use the mdf in VS2010 and when I try to add the adventureworksLT.mdf to ADO.Net I get the above error. I've gone into SQL Server Management Studio and have renamed the instance of adventureworkslt to a different name - but still no joy. When I try to attach the mdf file (I don't have the log file so I remove it from the installation) I get the following error. (The mdf file is from the Visual Studio 2010 and .Net Framework 4 Training Kit - June)
 
 

TITLE: Microsoft SQL Server Management Studio

 
Attach database failed for Server 'CGREANEY-HOME\SQLEXPRESS'. (Microsoft.SqlServer.Smo)
 
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.0.4064.0+((Katmai_SP2_GDR).110225-1353+)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Attach+database+Server&LinkId=20476

 

ADDITIONAL INFORMATION:
 
An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

 

 
Unable to open the physical file "G:\VS2010TrainingKit\Labs\ADONetDataServices\Source\Setup\Assets\AdventureWorksLT.mdf". Operating system error 5: "5(failed to retrieve text for this error. Reason: 15105)". (Microsoft SQL Server, Error: 5120)
 
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=10.00.4064&EvtSrc=MSSQLServer&EvtID=5120&LinkId=20476

 

BUTTONS:
 

OK

comments