New Server Install
Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=22308
Printed Date: 08 April 2026 at 4:49am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: New Server Install
Posted By: windigo
Subject: New Server Install
Date Posted: 01 January 2007 at 7:17pm
|
I am in need of some help. I am changing to a new server, a win2003 server machine. The peson who set up the last machine is no longer with me. I downloaded the 8.03, liked it, had this other person install it, and registered it. Now, going to a new machine, I don't know what he did and I'm trying to do it by myself. There is no data on the other machine we need so I downloaded the new 8.05 and was going to install it on the new server. I have downloaded SQL Express and installed it. That seems to be working just fine, although I think that is where most of my problems begin. I changed the database_connection.asp script to:
Server = our IP of the server
Username = what the other person used (I remember him saying that was a generic name)
Password = (same rationale)
Database = meddir_forum
When trying to run the msSQL_server_setup.asp script, all I get is the text of the script in my browser. When I hit refresh, I get a page with a 3 field form to fill in with the last field being DBO. I put in the user name and password fields and hit enter but get an error message.
How do I get my tables setup so I can configure the forum.
Thanks
Terry
|
Replies:
Posted By: Mikey
Date Posted: 01 January 2007 at 7:32pm
|
You may wanna remove those details from your post, you never know how long data lasts on the net.
------------- Handyman man? |
Posted By: windigo
Date Posted: 01 January 2007 at 7:39pm
|
I didn't think I had given enough data to hurt myself, but just in case I am taking your advice.
Terry
|
Posted By: iSec
Date Posted: 01 January 2007 at 11:13pm
Did you install Active Server Pages (ASP) support on that machine?
How do you browse the database setup file? Did you just click on the file or did you try a real domain like http://localhost - http://localhost , or http://yourIP - http://yourIP , or http://www.yourdomain.com - www.yourdomain.com ?
|
windigo wrote:Posted By: windigo
Date Posted: 02 January 2007 at 1:37am
|
I'm using IE7 and I opened the browser, went to ->file ->open, and browsed to my file. I clicked on it and it loaded it into my browser. I expected it to run as any asp script would, but instead, I just got the text of the asp file. When I hit refresh, I was then presented with the asp file as I described in my original post. Yes asp, and asp.net 2.0 are installed and working fine because I have a bunch of asp forms that submit and I am also using persists aspemail and it is working fine on all of my pages where I use it.
Do I need to do something like http://localhost/path/database - http://localhost/path/database setup file?
|
Posted By: iSec
Date Posted: 02 January 2007 at 4:06am
| Yup... that\s the probelm.... because when you browse the file from File >> Open >> Browse, it doesn't go through the ASP engine and therefore the ASP code of that file doesn't get excuted. whereas when you browse it with a valid url like http://etc - http://etc .. it goes through the ASP engine in which the code of the file gets excuted. |
Posted By: windigo
Date Posted: 05 January 2007 at 3:01am
|
OK, now I think it is running the script because I get an error message back that says the script will not connect to the database, check userid, password, etc. I think I'm so close but it sounds like I have a user or permissions issue. Would someone famaliar with sqlexpress give me some tips on how to setup my config, so I can run the database script and get my tables configured? Thanks,
Terry
|
Posted By: jscano
Date Posted: 01 February 2007 at 8:46pm
|
Okay... I'm getting the same thing except when I navigate to the file http://www.mywebsite.com/forum/msSQL_server_setup.asp - http://www.mywebsite.com/forum/msSQL_server_setup.asp I'm getting an HTTP 500 error. Any suggestions?
I'm running ASP.Net 1.1. Should it be 2.0?
Thanks so much.
|
Posted By: windigo
Date Posted: 01 February 2007 at 8:58pm
|
I wish I could help you but afraid I can't. I got so frustrated I asked around for a sql/IIS person. Found one, and in less than 10 minutes he fixed my problem. It was as I suspected, a sqlexpress setting problem, something to do with IP. I gave him $100 bucks and moved on. It's working great now, but I know that doesn't help you any. I'm sorry.
Terry
|
Posted By: WebWiz-Bruce
Date Posted: 02 February 2007 at 8:19am
|
When using SQL Express you need to make sure it is installed in mixed mode, by default it has external connections disabled, so best to set it up on the same localhost server as your web site is on. By default SQL Express installed with the instance name SQLEXPRESS so if installed locally you would use the following to connect to SQL Express:- localhost/SQLEXPRESS Note the /SQLEXPRESS part, this is required as the default SQL Express install is installed with this instance name, also when connecting this often needs to be in capitals. ------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting |