Sunday, March 11, 2012

Access to table blocked signature is not valid

I created sqlexpress database and .net app, everything was fine on my local machine.

When I moved the app to my server, I detached the database with SMSS express, moved the MDF file over along with the app files and I attached to the database with SSMS to make sure everything went over ok but when I try to open a table I get the error,

SQL Execution Error
Executed statement: Select x, x, x, x,x from tblFile
Error source: .Net SqlClient Data Provider
Error Message: Access to table dbl.tblFile is blocked because the signature is not valid.

I can open the stored procedures fine by choosing modify from the context menu.

Any ideas here?
This post was moved to the sql server express data category however to be clear the problem is not happening within sql server express.

I have windows 2003 server running sql server 2005 I cannot open tables to the database I've attached to sql server 2005 which I originally created on my local machine using visual studio 2005 and the bundled sql express. My problem is happening sql server 2005 not sqlexpress.

No comments:

Post a Comment