Web Wiz - Green Windows Web Hosting
Web Wiz Homepage Search Web Wiz

  New Posts New Posts RSS Feed - Troubleshoot Forum Install
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Troubleshoot Forum Install
 Post Reply Post Reply Page  12>
Author
  Topic Search Topic Search  Topic Options Topic Options
loopedup View Drop Down
Newbie
Newbie
Avatar

Joined: 02 February 2004
Location: United States
Status: Offline
Points: 10 		Post Options Post Options   Thanks (0) Thanks(0)   Quote loopedup Quote  Post ReplyReply Direct Link To This Post Topic: Troubleshoot Forum Install
    Posted: 01 June 2004 at 4:52pm

Hello,

I have installed Web Wiz Forum for IIS/SQL server about 3 months ago but have not used it due to other pressing issues. Now I am trying to revisit this project and I am lost. I seem to recall being able to install the software successfully but am not sure.

Can someone help me troubleshoot to see where I am with this? I see that the databases are created and when I try to run msqSQL_server_setup.asp, I get error messages saying that files already exsist. Where do I go from here? I can't seem to get to the default page to login into the forum either.

Thanks in advance
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: 02 June 2004 at 3:27am
The SQL server setup files should only be run once, if you run it more than once then you will need to delete the database and start over, this is why you are getting errors.

Once you have recreated the database, using the setup file try running the defaut page, if you get an error post what the error is here if it is not already covered in another posts or the documentation.
Web Wiz Forums Hosting
ASP.NET Web Hosting
Back to Top
loopedup View Drop Down
Newbie
Newbie
Avatar

Joined: 02 February 2004
Location: United States
Status: Offline
Points: 10 		Post Options Post Options   Thanks (0) Thanks(0)   Quote loopedup Quote  Post ReplyReply Direct Link To This Post Posted: 02 June 2004 at 12:38pm

Should I delete everything, including the website in IIS and start over or do I just delete the DB?

 
Back to Top
loopedup View Drop Down
Newbie
Newbie
Avatar

Joined: 02 February 2004
Location: United States
Status: Offline
Points: 10 		Post Options Post Options   Thanks (0) Thanks(0)   Quote loopedup Quote  Post ReplyReply Direct Link To This Post Posted: 02 June 2004 at 3:20pm

Okay, I recreated the database and rerun the msSQL_server_setup.asp.

I get a Congratulations your database have been created message :)

or something to that effect.

I now try to open the default.asp page located in the forum folder but I get this message when doing so.

Microsoft OLE DB Provider for SQL Server error '80040e4d'

Login failed for user 'Administrator'.

/COForum/Web/forum/common.asp, line 232

 

What do I do now?

 
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: 03 June 2004 at 5:30am
This looks like the details enterd into the file admin/SQL_server_connection.asp are incorrect so the file is failing to connect to the SQL server database.
Web Wiz Forums Hosting
ASP.NET Web Hosting
Back to Top
Mart View Drop Down
Senior Member
Senior Member
Avatar

Joined: 30 November 2002
Status: Offline
Points: 2304 		Post Options Post Options   Thanks (0) Thanks(0)   Quote Mart Quote  Post ReplyReply Direct Link To This Post Posted: 03 June 2004 at 5:33am
Or maybe you selected Windows NT Security instead of the built in SQL Security
Back to Top
loopedup View Drop Down
Newbie
Newbie
Avatar

Joined: 02 February 2004
Location: United States
Status: Offline
Points: 10 		Post Options Post Options   Thanks (0) Thanks(0)   Quote loopedup Quote  Post ReplyReply Direct Link To This Post Posted: 03 June 2004 at 10:29am

... but, but, but... it said CONGRATULATIONS!

Okay, for the server name, naturally I put the server name. For the username and password, I entered the Windows admin usersname and password. The database name is the database I created for my forum.

I created the database in \Program Files\Microsoft SQL Server\MSSQL\Data, is that okay?

If it is because I used NT Security, where do I change it so I am using SQL Security?

Thanks for the help guys.

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: 03 June 2004 at 10:34am
If the database was setup successfully then you can ignore what Mart said.

The problem is as I mentioned in my last post is that you have incorrect details in your admin/SQL_server_connection.asp file, so you are getting an error because the application can not log into the SQL Server.

You need to open the file admin/SQL_server_connection.asp and check that all the login details for your SQL Server are correct and there are no miss spellings.

Edited by -boRg-
Web Wiz Forums Hosting
ASP.NET Web Hosting
Back to Top
 Post Reply Post Reply Page  12>

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.