Geeks With Blogs

News

Locations of visitors to this page

View ► Sanjay Uttam [sanjay.uttam@gmail.com]'s profile on LinkedIn


Add to Google Reader or Homepage




Sanjay Uttam Predominantly .NET
Working on my first SQL 2K5 application here...and came across this error trying to implement the SqlNotificationService.  I read a lot on this error...However, I was able to avoid this error by simply making the current user of own the DB. 

1. Security > Users > [select the user your application is accessing the DB as]
2. Select properties (right click)
3. Find and check your DB schema in the list of "Owned Schemas"
4. Ensure "DB Owner" is checked off in the "Role Members" list

That's it... Posted on Tuesday, August 21, 2007 10:44 AM | Back to top

Copyright © Sanjay Uttam | Powered by: GeeksWithBlogs.net