Dave
Perch
I am trying to install the SQL Server version of the forum that I use on my site (which currently runs on MS Access). The forum includes an asp file that creates the tables and stored procedures, etc. I used the MS Access upsize wizard to upsize the tables to SQL Server, then ran the ASP page that creates the rest. All of my upsized table show my account (or username) as the owner, but for everything created by the script has an owner of "dbo". When I try to run the forum I get this error:
EXECUTE permission denied on object 'wwfSpSelectConfiguration', database 'mydbname', owner 'dbo'.
I'm not sure, but it looks like because I log in with a username other than dbo that I don't have permission to access this object.
Do I need to somehow change the owner to my username (which I don't know how to do), or is there some other problem?
Thanks for any assistance. By the way, I'm trying to install WebWizGuide Forums. Maybe someone else here has the SQL Server version running?
EXECUTE permission denied on object 'wwfSpSelectConfiguration', database 'mydbname', owner 'dbo'.
I'm not sure, but it looks like because I log in with a username other than dbo that I don't have permission to access this object.
Do I need to somehow change the owner to my username (which I don't know how to do), or is there some other problem?
Thanks for any assistance. By the way, I'm trying to install WebWizGuide Forums. Maybe someone else here has the SQL Server version running?