permission denied error

I have tried installing SQL Server version 7.5. I currently run 7.01 Access version. I upsized the current Access tables, then ran the SQL setup script. Everything seemed to install fine on SQL Server, except I had 2 of every table, so I deleted all the empty duplicate tables.

The objects created by WWF have an owner of dbo. My upsized tables have the owner as my username. When I try to run any forum pages I get the following error:

EXECUTE permission denied on object 'wwfSpSelectConfiguration', database 'myDBname', owner 'dbo'.
/forums/common.asp, line 264

I have no previous SQL Server experience. Do I need to change the owner of all the objects listed as dbo?  If I do, I can't seem to find an option to do that with the Enterprise Manager.

Thanks for any assistance.

-boRg- wrote: There is no migration tool, but you can use the upsize wizard in Access to upsize your database to SQL server, then run the SQL server serup file found in the SQL server version to create the stored procedures. You will get a few errors come up when running this file as most of the tables will be cerated by the upsize process, but just ingnore these. Also you may find that extra admin and guest accounts and groups are cerated that you will need to delete from the admin area.

Thanks for the reply, God_Struth. However, I don't know if that is correct advise or not, as I followed the directions in borg's post to get where I am.  I may try it anyway if no one has any other suggestions, just in case.

OK, after some more trial and error, I seemed to have fixed the problem. I deleted all the SQL Server objects, then upsized my Access forum again. Then I changed the reference of [dbo] in the setup page to my own username. Everthing appears to be working now. No duplicate tables were created this time.

Only took me about 4 hours of experimenting to get it to work. At least now I know a little bit about SQL Server, not a lot, but more than the zero I started with.