Author |
Topic  |
|
tonykrij
Starting Member
Netherlands
8 Posts |
Posted - 27 August 2007 : 16:33:19
|
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 |
|
tonykrij
Starting Member
Netherlands
8 Posts |
Posted - 27 August 2007 : 17:48:10
|
Ok, I checked IIS | Server | Web Service Extensions and "Active Server Pages" is "Allowed". Still the 404 error..
Any other place I should look? |
 |
|
Podge
Support Moderator
    
Ireland
3776 Posts |
|
tonykrij
Starting Member
Netherlands
8 Posts |
Posted - 27 August 2007 : 19:16:45
|
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 |
 |
|
Podge
Support Moderator
    
Ireland
3776 Posts |
|
Podge
Support Moderator
    
Ireland
3776 Posts |
|
Doug G
Support Moderator
    
USA
6493 Posts |
Posted - 27 August 2007 : 19:30:39
|
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 |
 |
|
Podge
Support Moderator
    
Ireland
3776 Posts |
|
tonykrij
Starting Member
Netherlands
8 Posts |
Posted - 27 August 2007 : 20:24:49
|
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! |
 |
|
tonykrij
Starting Member
Netherlands
8 Posts |
Posted - 27 August 2007 : 20:44:56
|
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 |
 |
|
|
Topic  |
|