Can't run msSQL_server_setup?

Post Reply

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
cwhitmore Members Profile Find Members Posts Newbie Joined: 13 September 2007 Location: United States Status: Offline Points: 10	Post Options Post Reply Quote cwhitmore Report Post Thanks(0) Quote Reply Topic: Can't run msSQL_server_setup? 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?

Nick-V Members Profile Find Members Posts Senior Member Joined: 26 October 2002 Location: United Kingdom Status: Offline Points: 319	Post Options Post Reply Quote Nick-V Report Post Thanks(0) Quote Reply 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 !

Nick-V Members Profile Find Members Posts Senior Member Joined: 26 October 2002 Location: United Kingdom Status: Offline Points: 319	Post Options Post Reply Quote Nick-V Report Post Thanks(0) Quote Reply 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

cwhitmore Members Profile Find Members Posts Newbie Joined: 13 September 2007 Location: United States Status: Offline Points: 10	Post Options Post Reply Quote cwhitmore Report Post Thanks(0) Quote Reply 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!

Nick-V Members Profile Find Members Posts Senior Member Joined: 26 October 2002 Location: United Kingdom Status: Offline Points: 319	Post Options Post Reply Quote Nick-V Report Post Thanks(0) Quote Reply 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.

cwhitmore Members Profile Find Members Posts Newbie Joined: 13 September 2007 Location: United States Status: Offline Points: 10	Post Options Post Reply Quote cwhitmore Report Post Thanks(0) Quote Reply 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.

WebWiz-Bruce Members Profile Find Members Posts Admin Group Web Wiz Developer Joined: 03 September 2001 Location: Bournemouth Status: Offline Points: 9844	Post Options Post Reply Quote WebWiz-Bruce Report Post Thanks(0) Quote Reply 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.
	Web Wiz Forums Hosting ASP.NET Web Hosting

cwhitmore Members Profile Find Members Posts Newbie Joined: 13 September 2007 Location: United States Status: Offline Points: 10	Post Options Post Reply Quote cwhitmore Report Post Thanks(0) Quote Reply 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.

Post Reply

Forum Jump

Forum Permissions View Drop Down

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum