SQL Permission Error

[andrewsmd]

I had a site that was working fine with an sql server backend. I had to migrate mysql data into the sql server database so I truncated the tables and inserted all of the data. Now whenever I try to access the tables I get this error
Server Error in '/' Application.
The EXECUTE permission was denied on the object 'aspnet_CheckSchemaVersion', database 'Associated_Staffing', schema 'dbo'.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: The EXECUTE permission was denied on the object 'aspnet_CheckSchemaVersion', database 'Associated_Staffing', schema 'dbo'.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

The funny thing is that only happens when I run my search function. My homepage has two dropdowns that are populated from the database and they still work fine. Any ideas?

[marcel]

Did you also truncate the 'aspnet_' tables? You may need to rebuild them with the ASP.NET SQL Server Registration Tool.

You can find that in:
[drive:]\%windir%\Microsoft.NET\Framework\<version folder>

[andrewsmd]

no i only truncated the tables i manually created

[andrewsmd]

Just in case anyone is wondering. I did a bunch of research but in the end I just dropped the database and recreated it and it worked fine. Typical microsoft stuff. I miss my php.