Recently, to deploy my site, I changed my authentication from 'Windows' to 'SQL authentication'. Successfully added the user to ‘Security\Logins’. But having problem enabling database role membership as it returns error 15247. I believe error 15151 is also that of permission issues.
Here's an extra info in case it might help narrow down the problem scope, if i access my server it shows this error;
"Login failed for user 'kaneXtreme' ".
In my localhost,it shows this error;
"The SELECT permission was denied on the object, database, schema"
In my opinion, I think both error messages are pointing to a similar problem which is permission.
This problem has been remained unsolved for some time now.
If anyone have come across this problem before I really hope to get a few input to work around on this.
Thank you in advance.
commented on Jan 7 2012 6:51AM