July 11, 2012 at 1:50 pm
I'm getting this error now when I'm installing an ASP.NET MVC application with a built-in installer (that I built), and I've gotten it in the past and I'd really like to know what this means and why it occurs?
If I know this, then I can figure out how to prevent it (hopefully) in the future.
And before you want to know about my installer, my installer is not the reason for this problem, it's SQL Server 2008.
BE VERY CLEAR, this is not a restore!!! It's a brand new database!
Also, I'm a web developer and I have over 20 databases on my local machine created without issues for my clients sites, and then I get this error. The process I go through to create the database and install my Membership system and client database schema is the same every time. So why did it occur this time?
The big weird thing about this is that the database that is displays in the error message, is NOT the database I'm trying to install to. It does exist on my server, but it's a completely different database, which should not be showing up here.
So my question is, what does this error mean, and why does it occur?
Any help with this is appreciated.
July 12, 2012 at 2:39 am
Its someone trying to impersonate someone.
Maybe a DDL trigger of some sorts.
Investigate the database in the error message for any objects using EXECUTE AS
July 12, 2012 at 3:33 am
I'd follow Anthony's advice. This is definitely a security issue of some sort. I suspect your installer is somehow running into either incorrect rights, or some impersonation issue.
July 12, 2012 at 12:57 pm
anthony.green (7/12/2012)
Its someone trying to impersonate someone.Maybe a DDL trigger of some sorts.
Investigate the database in the error message for any objects using EXECUTE AS
Anthony - nope, no impersonation issues since I'm the only person on this computer and the only one building applications. I build all my applications the same way.
Re: DDL trigger - I don't know what this is, so I'm pretty sure I'm not using them.
Re: Execute As - again, not sure what this is, but I'm not putting this expression in any of my C# code in my applications.
July 12, 2012 at 1:04 pm
Steve Jones - SSC Editor (7/12/2012)
I'd follow Anthony's advice. This is definitely a security issue of some sort. I suspect your installer is somehow running into either incorrect rights, or some impersonation issue.
Steve - I'm not sure why this particular application would be a security issue on my development machine any more than any other applciation I'm building.
Re: installer - I can't see how my installer would be getting incorrect rights. The web.config for this application has nothing to do with any other application.
Again, the really weird thing about this error is the database name that it says the db user doesn't have access to.
The database I'm trying to install to is 'Rapper', and the database in the error message is 'GPS'.
I ran SQL Profiler during the installation attempt and it was pointing successfully to the database I wanted to install the ASP.NET Membership system, but when it came time to adding Users and Roles, it failed because it suddenly pointed to the other database out of nowhere.
I was not able to trace where that's coming from.
???
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply