Web Wiz Support and Community Forums : Can't run msSQL_server

Web Wiz Support and Community Forums : Can't run msSQL_server_setup? https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Mon, 06 Apr 2026 15:48:08 +0000 Fri, 14 Sep 2007 14:46:09 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=24407 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[Can't run msSQL_server_setup? : To fix the problem I...]]> https://forums.webwiz.net/cant-run-mssql-server-setup_topic24407_post127610.html#127610 Author: cwhitmore
Subject: 24407
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.

]]> Fri, 14 Sep 2007 14:46:09 +0000 https://forums.webwiz.net/cant-run-mssql-server-setup_topic24407_post127610.html#127610 <![CDATA[Can't run msSQL_server_setup? : The login user you are using to...]]> https://forums.webwiz.net/cant-run-mssql-server-setup_topic24407_post127608.html#127608 Author: WebWiz-Bruce
Subject: 24407
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.
]]> Fri, 14 Sep 2007 14:44:04 +0000 https://forums.webwiz.net/cant-run-mssql-server-setup_topic24407_post127608.html#127608 <![CDATA[Can't run msSQL_server_setup? : Nick, I tried it with the default...]]> https://forums.webwiz.net/cant-run-mssql-server-setup_topic24407_post127606.html#127606 Author: cwhitmore
Subject: 24407
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.

]]> Fri, 14 Sep 2007 13:50:40 +0000 https://forums.webwiz.net/cant-run-mssql-server-setup_topic24407_post127606.html#127606 <![CDATA[Can't run msSQL_server_setup? : It sounds like the user you decided...]]> https://forums.webwiz.net/cant-run-mssql-server-setup_topic24407_post127602.html#127602 Author: Nick-V
Subject: 24407
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.]]> Fri, 14 Sep 2007 08:33:22 +0000 https://forums.webwiz.net/cant-run-mssql-server-setup_topic24407_post127602.html#127602 <![CDATA[Can't run msSQL_server_setup? : Okay, your suggestion about turning...]]> https://forums.webwiz.net/cant-run-mssql-server-setup_topic24407_post127596.html#127596 Author: cwhitmore
Subject: 24407
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!

]]> Fri, 14 Sep 2007 04:10:37 +0000 https://forums.webwiz.net/cant-run-mssql-server-setup_topic24407_post127596.html#127596 <![CDATA[Can't run msSQL_server_setup? : Another guess: are active server...]]> https://forums.webwiz.net/cant-run-mssql-server-setup_topic24407_post127591.html#127591 Author: Nick-V
Subject: 24407
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.

Edited by Nick-V - 13 September 2007 at 11:02pm]]> Thu, 13 Sep 2007 23:02:23 +0000 https://forums.webwiz.net/cant-run-mssql-server-setup_topic24407_post127591.html#127591 <![CDATA[Can't run msSQL_server_setup? : An idea... If it can't...]]> https://forums.webwiz.net/cant-run-mssql-server-setup_topic24407_post127590.html#127590 Author: Nick-V
Subject: 24407
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 !

]]> Thu, 13 Sep 2007 22:52:17 +0000 https://forums.webwiz.net/cant-run-mssql-server-setup_topic24407_post127590.html#127590 <![CDATA[Can't run msSQL_server_setup? : I'm running Windows 2003,...]]> https://forums.webwiz.net/cant-run-mssql-server-setup_topic24407_post127589.html#127589 Author: cwhitmore
Subject: 24407
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?

]]> Thu, 13 Sep 2007 22:21:02 +0000 https://forums.webwiz.net/cant-run-mssql-server-setup_topic24407_post127589.html#127589