PDA

View Full Version : SQL Server 2005 Express Issues



aidanmaz
20-07-2009, 07:53 PM
TITLE: Microsoft SQL Server Management Studio Express
------------------------------

After installing a Pawn Broker software called PawnMaster, by Dataage, I installed SQL EE 2005, now when trying to view the databases in SMEE, i get the below error, what is missing?

Failed to retrieve data for this request. (Microsoft.SqlServer.Express.SmoEnum)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476

------------------------------
ADDITIONAL INFORMATION:

Device activation error. The physical file name 'C:\Program Files\Microsoft SQL Server\MSSQL$DATAAGE\Data\AUDIT.mdf' may be incorrect. (Microsoft SQL Server, Error: 5105)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=08.00.0760&EvtSrc=MSSQLServer&EvtID=5105&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------

pctek
21-07-2009, 12:02 PM
One or more files do not match the primary file of the database. If you are attempting to attach a database, retry the operation with the correct files. If this is an existing database, the file may be corrupted and should be restored from a backup.