Web Wiz Forums - Can't run msSQL_server

Print Page | Close Window

Can't run msSQL_server_setup?

Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=24407
Printed Date: 06 April 2026 at 3:46pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Can't run msSQL_server_setup?

Posted By: cwhitmore
Subject: Can't run msSQL_server_setup?
Date Posted: 13 September 2007 at 10:21pm

I'm running Windows 2003, IIS 6.0 and SQL 2000. I've created the directory c:\inetpub\wwwroot\DDforum and gave read/write permissions to IUSR_servername, but when I try to run the asp script it says it can't find it. This server is also a domain controller so maybe that has something to do with it? I created a directory called "test" and I'm able to pull up http:\\servername\test\iisstart.htm

Any ideas?

Replies:

Posted By: Nick-V
Date Posted: 13 September 2007 at 10:52pm

An idea...

If it can't find it (rather than wrong permissions) you might be typing the wrong URL (folder name wrong).

Remember the forum files are usually under a folder called \forum. If instead you have called it DDforum you use URL1 or if you put \forum under \DDforum use URL2:

URL1: http:\\servername\DDforum\msSQL_server_setup.asp

URL2: http:\\servername\DDforum\forum\msSQL_server_setup.asp

Just a guess !

Posted By: Nick-V
Date Posted: 13 September 2007 at 11:02pm

Another guess: are active server pages (asp) switched on? In IIS Manager look at the Web Service Extensions tree.

Try your test file in the forum folder too.

Posted By: cwhitmore
Date Posted: 14 September 2007 at 4:10am

Okay, your suggestion about turning on ASP worked, but now I'm getting the following error when I run the script msSQL_server_setup.asp:

Error entering default values in the Table tblGroup
INSERT permission denied on object 'tblGroup', database 'DADSForum', owner 'dbo'.

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

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

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

Error entering default values in the Table tblSmut
INSERT permission denied on object 'tblSmut', database 'DADSForum', owner 'dbo'.

INSERT permission denied on object 'tblSmut', database 'DADSForum', owner 'dbo'.
SQL Server database is set up, but with Error!

Posted By: Nick-V
Date Posted: 14 September 2007 at 8:33am

It sounds like the user you decided upon to create the tables (and set up default values on fields) does not have owner permissions.

Posted By: cwhitmore
Date Posted: 14 September 2007 at 1:50pm

Nick,

I tried it with the default 'dbo' and with the user I created 'dadsforum'. The account I created has all rights to the database.

Posted By: WebWiz-Bruce
Date Posted: 14 September 2007 at 2:44pm

The login user you are using to login into the database doesn't have sufficient rights on the database to write to the database.

It looks like the tables etc. have been created but the error comes when entering data into the database.

Make sure that the user you are logging into the database with has DBO permissions on the database, and you have not accidentally selected the permissions db_denydatareader, and db_denydatawriter for this user, as this would mean you won't be able to read and write to the database.

-------------
https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting
https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting

Posted By: cwhitmore
Date Posted: 14 September 2007 at 2:46pm

To fix the problem I replaced '127.0.0.1' in the database setup file with the actual name of the server. Now it works.

thanks.