Tell me more ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.
up vote 0 down vote favorite

I have user who is trying to access some tables from our Microsoft SQL Server 2008 R2 system (which very recently got moved to a brand new hardware/software stack) using Access 2007 via an ODBC connection, a method they've been using for years. Now they're getting 'Reserved Error (-7711); there is no message for this error.'

In my googling process I haven't been able to identify any relevant information that isn't related to 2003 versions of Sybase. I'm guessing there's some security of configuration setting I've forgotten to set on the new box but to me the error seems pretty obscure and I'm not sure where to go from here.

Any help you can provide would be greatly appreciated.

share|improve this question
Did the advent of the error coincide with the movement of the SQL Server to the new stack? – Robert Harvey Jan 17 '12 at 17:30
Yes it did; however, other users are able to connect correctly using Access 2003, in addition, existing connects seem to work find, it's on certain machines creating new connections. – nickrobison Jan 17 '12 at 17:34

migrated from stackoverflow.com Jan 17 '12 at 17:31

1 Answer

up vote 1 down vote accepted

Turns out the issue was with an assembly created with 'Unrestricted' permissions, when trying the ODBC connection under Excel I received a more verbose error related to a .NET error and this assembly, changing the 'Permission set' to 'Safe' seemed to solve the problem.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.