Had three databases connected to SQL server 2012, unfortunately, now I can't see any of them under the Databases part of the tree in SQL Server Management Studio. The files (.mdf) are still on the disk, but when I try to reconnect them, I get this error once I click on the mdf file,
Failed to retreive data for this request (Microsoft.SqlServer.Management.Sdk.Sfc) Additional information An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo) The server principal "IESVE\user" is not able to access the database "model" under the current security context (Microsoft SQL Server, Error: 916)
I thought this might be a problem with the management studio, but when I try to connect via ADO, I get this error, [DBNETLIB][ConnectionOpen(Invalid Instance())] Invalid Connection
All of this worked before and the only thing I can think of is a recent windows update.
If anyone's got any ideas on how to fix/diagnose this, I would be very grateful, Thanks James
Edit; Running as administrator gets me a bit closer to reattaching the databases, but now I have this error . I'm wondering if my SQL server version has been downgraded, judging by that error message.