Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: General / Classic ASP versions(v3.4.XX)
 Migrating to a new server - IIS & MS-SQL
 New Topic  Topic Locked
 Printer Friendly
Author Previous Topic Topic Next Topic  

tonykrij
Starting Member

Netherlands
8 Posts

Posted - 27 August 2007 :  16:33:19  Show Profile  Visit tonykrij's Homepage
Hey All,

I had my forum working perfect on my old SBS Server with MS-SQL Server.
I copied all the ASP files from the old server and placed them on the new SBS server 2003 R2 Premium in the INETPUB folder.
I also have restored my website back to the server and that is up and running.
I've restored the Forums database to my MS-SQL Server 2005 Standard edt. and created (and tested) the System DSN and changed this in the config.asp. So far so good but when I try to open my forum (website/forum) I only get 404's - page not found, also with the setup file.
Also tried to download the forum's latest version and same result so I guess I'm missing an essential step on IIS to get ASP going.
I've been going through the many forum posts here but I'm just missing a "How to setup your forum on IIS" page which I think would help a lot :-)

So my questions:
1) Does someone have a step-by-step "Get Snitz on IIS" post/doc? Just some quick guidance would work for me.
2) Is there anything I need to change in order to use the old SQL database? The server name has changed, but the DSN has been restored and I guess Snitz just use that?.

Thanks all for your help!

Tony Krijnen.

Podge
Support Moderator

Ireland
3776 Posts

Posted - 27 August 2007 :  16:36:44  Show Profile  Send Podge an ICQ Message  Send Podge a Yahoo! Message
In W2003 you have to explicitly allow .asp in Web Service Extensions in IIS otherwise you will just get a 404 for every .asp page you try to view.

Podge.

The Hunger Site - Click to donate free food | My Blog | Snitz 3.4.05 AutoInstall (Beta!)

My Mods: CAPTCHA Mod | GateKeeper Mod
Tutorial: Enable subscriptions on your board

Warning: The post above or below may contain nuts.
Go to Top of Page

tonykrij
Starting Member

Netherlands
8 Posts

Posted - 27 August 2007 :  17:48:10  Show Profile  Visit tonykrij's Homepage
Ok, I checked IIS | Server | Web Service Extensions and "Active Server Pages" is "Allowed". Still the 404 error..

Any other place I should look?
Go to Top of Page

Podge
Support Moderator

Ireland
3776 Posts

Posted - 27 August 2007 :  18:18:52  Show Profile  Send Podge an ICQ Message  Send Podge a Yahoo! Message
Are you sure that you mapped the asp extension to C:\windows\system32\inetsrv\asp.dll in web service extensions?
And also in your web application i.e. website >> properties >> Home Directory tab >> Configuration. asp should be listed and mapped to asp.dll

Podge.

The Hunger Site - Click to donate free food | My Blog | Snitz 3.4.05 AutoInstall (Beta!)

My Mods: CAPTCHA Mod | GateKeeper Mod
Tutorial: Enable subscriptions on your board

Warning: The post above or below may contain nuts.
Go to Top of Page

tonykrij
Starting Member

Netherlands
8 Posts

Posted - 27 August 2007 :  19:16:45  Show Profile  Visit tonykrij's Homepage
Hey Podge!

Thanks for your quick replies!

I've checked the paths and all seems correct. I also checked that IUSR_Server has access to the folders and files (although I am Administrator and that also doesn't work).

I have two IP addresses (192.168.16.2 and 192.168.16.5) assigned to the internal NIC. I've used HTTPCFG to enable IPLISTEN on both and this works as http://192.168.16.5 shows me my website. I have a virtual folder called FORUM under that IIS Site (.5) and this points to C:\Inetpub\Forumtony.

I registered ASP.DLL to be sure and restarted IIS - no change, 404.

I also tried http://192.168.16.5/forum/forum.jpg to see if it was a filename extension thing but this also gives me the 404.

I'll try to get it started with a new ip address and website, but if you have any more suggestions where to look please keep 'm coming :-)

Thanks, Tony. A
Go to Top of Page

Podge
Support Moderator

Ireland
3776 Posts

Posted - 27 August 2007 :  19:23:44  Show Profile  Send Podge an ICQ Message  Send Podge a Yahoo! Message
I tried to connect to your i.p. (I assume you are using IIS on the computer you are posting with) and got a 403 error
quote:
Error Code: 403 Forbidden. The server denied the specified Uniform Resource Locator (URL). Contact the server administrator. (12202)


Try allowing anonymous users to connect to the website.

Podge.

The Hunger Site - Click to donate free food | My Blog | Snitz 3.4.05 AutoInstall (Beta!)

My Mods: CAPTCHA Mod | GateKeeper Mod
Tutorial: Enable subscriptions on your board

Warning: The post above or below may contain nuts.
Go to Top of Page

Podge
Support Moderator

Ireland
3776 Posts

Posted - 27 August 2007 :  19:30:04  Show Profile  Send Podge an ICQ Message  Send Podge a Yahoo! Message
There are 12 types of 403 error listed here - http://support.microsoft.com/?id=318380
Check through them. More than likely its a permissions issue on the forum folder or maybe the wwwroot folder.

Podge.

The Hunger Site - Click to donate free food | My Blog | Snitz 3.4.05 AutoInstall (Beta!)

My Mods: CAPTCHA Mod | GateKeeper Mod
Tutorial: Enable subscriptions on your board

Warning: The post above or below may contain nuts.
Go to Top of Page

Doug G
Support Moderator

USA
6493 Posts

Posted - 27 August 2007 :  19:30:39  Show Profile
192.168.x.x are private non-routable IP's so you can only visit your link from within your own LAN.


======
Doug G
======
Computer history and help at www.dougscode.com
Go to Top of Page

Podge
Support Moderator

Ireland
3776 Posts

Posted - 27 August 2007 :  19:34:08  Show Profile  Send Podge an ICQ Message  Send Podge a Yahoo! Message
His website can still be browsed externally if you know his i.p. address (and I do).

Podge.

The Hunger Site - Click to donate free food | My Blog | Snitz 3.4.05 AutoInstall (Beta!)

My Mods: CAPTCHA Mod | GateKeeper Mod
Tutorial: Enable subscriptions on your board

Warning: The post above or below may contain nuts.
Go to Top of Page

tonykrij
Starting Member

Netherlands
8 Posts

Posted - 27 August 2007 :  20:24:49  Show Profile  Visit tonykrij's Homepage
Hello Podge!

Thanks for trying! It's actually another address 195.35.166.163. ISA Server is only allowing the full name though which is www.tonykrijnen.com. I'm trying to get /forum to work on that.

I think I got a lot closer now. It turns out that Windows SharePoint Services registers its ISAPI filter on my default website. This filter blocks custom ASP pages by default unless you create an "exclude path" in the Sharepoint administration pages.

I'll paste it here so I can find it next time :-)..
1.Click Start, point to All Programs, point to Administrative Tools, and then click SharePoint Central Administration.

2.On the Central Administration page, under Virtual Server Configuration, click Configure virtual server settings.

3.On the Virtual Server List page, select the virtual server you want to configure.

4.On the Virtual Server Settings page, under Virtual Server Management, click Define managed paths.

5.In the Add a New Path section, in the Path box, type the path to add.

6.Select Excluded path or Included path. If you select Included path, select a type (wildcard or explicit) in the Type box.

7.Click OK.

(From www.microsoft.com/resources/documentation/wss/2/all/adminguide/en-us/stsf05.mspx?mfr=true" target="_blank">www.microsoft.com/resources/documentation/wss/2/all/adminguide/en-us/stsf05.mspx?mfr=true" target="_blank">http://www.microsoft.com/resources/documentation/wss/2/all/adminguide/en-us/stsf05.mspx?mfr=true)

Now working on the next thing, my "Microsoft OLE DB Provider for ODBC Drivers error '80040e37' error...

Thanks, Tony!
Go to Top of Page

tonykrij
Starting Member

Netherlands
8 Posts

Posted - 27 August 2007 :  20:44:56  Show Profile  Visit tonykrij's Homepage
Hey all,

The ASP pages work but my database connection won't open the old database.

I've found the steps on http://forum.snitz.com/forum/topic.asp?ARCHIVE=true&TOPIC_ID=31144.

Step 4. states:
quote:
Use DTS to transfer the data from your Access database to your SQL Server database. You should make sure that for each table the DTS transform column is configured so that any existing table data is deleted and enable identity insert is checked


I'm using Microsoft SQL Server 2005 and DTS is no longer available as it was in 2000. Anyone an idea how to import the data from my old forum database into the new?

Thanks, Tony.

Edited by - tonykrij on 27 August 2007 20:45:35
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 1.42 seconds. Powered By: Snitz Forums 2000 Version 3.4.07