by Damiaan Peeters
7. April 2009 18:27
Problem
Today I launched the aspnet_regsql.exe. Unfortunately I received the following error:
EXECUTE permission denied on object 'aspnet_CheckSchemaVersion', database 'myDB', schema 'dbo'.
Solution
Take the properties of the “NT Autority\Network Service” user. Select the myDB database and add all the necessary Roles like aspnet_Membership_FullAccess to the user.

In the screenshot are all the databaseroles added.
by Damiaan Peeters
12. April 2008 14:38
Today, I couldn't attach a database of my previous pc to my new MSSQL Server installation.
I got this strange error message in Microsoft SQL Server Management Studio.
[more]
I got this error message:
Attach database failed for Server 'STELLA'. (Microsoft.SqlServer.Smo)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.3042.00&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 "E:\MSSQL\InfoBase.mdf". Operating system error 5: "5(error not found)". (Microsoft SQL Server, Error: 5120)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.3054&EvtSrc=MSSQLServer&EvtID=5120&LinkId=20476
Solution
The solution was very easy. Launch Microsoft SQL Server Management Studio as Administrator.