Web Wiz - Green Windows Web Hosting

  New Posts New Posts RSS Feed - can’t get msSQL_server_setup.asp to run
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

can’t get msSQL_server_setup.asp to run

 Post Reply Post Reply
Author
bryan View Drop Down
Newbie
Newbie
Avatar

Joined: 19 November 2003
Location: United States
Status: Offline
Points: 3
Post Options Post Options   Thanks (0) Thanks(0)   Quote bryan Quote  Post ReplyReply Direct Link To This Post Topic: can’t get msSQL_server_setup.asp to run
    Posted: 20 November 2003 at 4:03am
I have downloaded version 7.6 SQL version to try it out in hopes it would work on a web site I am working on. On lines 6 & 7 in the documentation is says to edit the SQL_server_connection.asp file, I did that, and then to run the file msSQL_server_setup.asp file. This is where I have problems, I tryed to open the file in IE without any success. I even tried to run it from the "RUN" comand line still nothing. I copied the file into a folder that I already use for a web site I am doing that has other .asp files in it and and tried to open it again in IE still without success. Other .asp files in that folder open just fine so I wouldn't think it is a server issue, I have IIS and SQL both running on my machine. Any ideas as to what I may be doing wrong? Any help would be greatly appreciated. Thanks
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: 20 November 2003 at 5:17am
What errors do you get?

Also are you running the asp files through a web server, just clicking on them and opening them in IE won't run the ASP file.
Back to Top
bryan View Drop Down
Newbie
Newbie
Avatar

Joined: 19 November 2003
Location: United States
Status: Offline
Points: 3
Post Options Post Options   Thanks (0) Thanks(0)   Quote bryan Quote  Post ReplyReply Direct Link To This Post Posted: 20 November 2003 at 12:37pm

boRg,

You were right, the problem was my IIS server was not processing the asp page. I finally got it to run and typed in the username and password for the empty database I created in Enterprise Manager but when I run the page I get a whole page full of errors like this:

Error Creating the Table tblCategory (it may already exsist)

Error Creating the Table tblForum (it may already exsist)

Error Creating the Table tblTopic (it may already exsist)

Error Creating the Table tblThread (it may already exsist)

The last line on the page says: The SQL Database was setup but with errors.

Any Ideas as to what I am doing wrong now. I went back to Enterprise Manager and checked the database and no tables were created. Does the database need to be in the same root folder as the rest of the forum files? If so how do I find where SQL Server put the database when it was created? I can find the log and data files but have not been able to figure out where the databases are stored at.

Thanks for your time and trouble.
Bryan

Back to Top
michael View Drop Down
Senior Member
Senior Member
Avatar

Joined: 08 April 2002
Location: United States
Status: Offline
Points: 4670
Post Options Post Options   Thanks (0) Thanks(0)   Quote michael Quote  Post ReplyReply Direct Link To This Post Posted: 20 November 2003 at 2:12pm
The database is managed by SQL Server and you do not have to be concerened where SQL "saves" it. When you connect with ENtMan to the same SQL Server that you specified in the sql server connection.asp file and look at the same database as in the connection.asp file then you should see the tables IF they were created successfully. If you are sure that the connection information you provided is correct then you might want to take a look at the SQL log files if you have access to them. Also make sure that the user you specify has the appropriate rights to create tables and sp's
Back to Top
bryan View Drop Down
Newbie
Newbie
Avatar

Joined: 19 November 2003
Location: United States
Status: Offline
Points: 3
Post Options Post Options   Thanks (0) Thanks(0)   Quote bryan Quote  Post ReplyReply Direct Link To This Post Posted: 20 November 2003 at 2:52pm

 boRg,

Thanks again, it was the permissions to the database. This time it says everything was done successfully. I have not been fooling with SQL Server very long forget that you have to specify everything. Sorry for all the help calls. With a little help maybe you won't have to put up with any more stupid questions from me.

Thanks again for your time and trouble.
So far it looks like a great product.
Bryan

Back to Top
 Post Reply Post Reply

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.