Web Wiz - Green Windows Web Hosting - Celebrating 25 Years!

  New Posts New Posts RSS Feed - installation errors
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

installation errors

 Post Reply Post Reply
Author
De-zypher View Drop Down
Newbie
Newbie


Joined: 22 May 2006
Status: Offline
Points: 7
Post Options Post Options   Thanks (0) Thanks(0)   Quote De-zypher Quote  Post ReplyReply Direct Link To This Post Topic: installation errors
    Posted: 22 May 2006 at 5:27pm
Hello all,
 
     I downloaded your forums and went to install / play with the installation.  I installed it on my test box (2k3 SP1 Windows server).  The test box is also running SQL 2005 ent.  I have the site setup through IIS and that works np there...but when i go to excute the msSQL_server_setup.asp file...I enter the SQL account that has full control for that database and give a password ...then i get the following:
 
 
Error entering default values in the Table tblGroup
INSERT permission denied on object 'tblGroup', database 'mh_forum', schema 'dbo'.

Error entering default values in the Table tblAuthor
INSERT permission denied on object 'tblAuthor', database 'mh_forum', schema 'dbo'.

Error entering default values in the Table tblConfiguration
INSERT permission denied on object 'tblConfiguration', database 'mh_forum', schema 'dbo'.

Error entering default values in the Table tblDateTimeFormat
INSERT permission denied on object 'tblDateTimeFormat', database 'mh_forum', schema 'dbo'.

Error entering default values in the Table tblSmut
INSERT permission denied on object 'tblSmut', database 'mh_forum', schema 'dbo'.
INSERT permission denied on object 'tblSmut', database 'mh_forum', schema 'dbo'.
SQL Server database is set up, but with Error! 
 
any ideas?
 
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844
Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post Posted: 22 May 2006 at 6:45pm
This is a permissions problem on the SQL Server.

The login details you are using to log into the SQL Server do not have permission to INSERT (write) data into the database.

You will need to delete the database and start again, this time making sure the login details you use also have permission to write data into the newly formed database.
Back to Top
De-zypher View Drop Down
Newbie
Newbie


Joined: 22 May 2006
Status: Offline
Points: 7
Post Options Post Options   Thanks (0) Thanks(0)   Quote De-zypher Quote  Post ReplyReply Direct Link To This Post Posted: 22 May 2006 at 7:32pm
db_denydatareader and db_denydatawriter were checked in the perimssions on the sql 2005 server.  these take precedence over the other settings. 
 
lol..just a little checking on my part and NP got it working....and running great
 
thanks
Back to Top
 Post Reply Post Reply

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.


Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.