Web Wiz Support and Community Forums : can’t get msSQL_server_setup.asp to run https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Mon, 06 Apr 2026 10:26:44 +0000 Thu, 20 Nov 2003 14:52:11 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=7416 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[can’t get msSQL_server_setup.asp to run : boRg, Thanks again, it was the...]]> https://forums.webwiz.net/cant-get-mssql-server-setup-asp-to-run_topic7416_post37122.html#37122 Author: bryan
Subject: 7416
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

]]> Thu, 20 Nov 2003 14:52:11 +0000 https://forums.webwiz.net/cant-get-mssql-server-setup-asp-to-run_topic7416_post37122.html#37122 <![CDATA[can’t get msSQL_server_setup.asp to run : The database is managed by SQL...]]> https://forums.webwiz.net/cant-get-mssql-server-setup-asp-to-run_topic7416_post37114.html#37114 Author: michael
Subject: 7416
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]]> Thu, 20 Nov 2003 14:12:52 +0000 https://forums.webwiz.net/cant-get-mssql-server-setup-asp-to-run_topic7416_post37114.html#37114 <![CDATA[can’t get msSQL_server_setup.asp to run : boRg, You were right, the problem...]]> https://forums.webwiz.net/cant-get-mssql-server-setup-asp-to-run_topic7416_post37096.html#37096 Author: bryan
Subject: 7416
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

]]> Thu, 20 Nov 2003 12:37:35 +0000 https://forums.webwiz.net/cant-get-mssql-server-setup-asp-to-run_topic7416_post37096.html#37096 <![CDATA[can’t get msSQL_server_setup.asp to run : What errors do you get? Also...]]> https://forums.webwiz.net/cant-get-mssql-server-setup-asp-to-run_topic7416_post37032.html#37032 Author: WebWiz-Bruce
Subject: 7416
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.
]]> Thu, 20 Nov 2003 05:17:17 +0000 https://forums.webwiz.net/cant-get-mssql-server-setup-asp-to-run_topic7416_post37032.html#37032 <![CDATA[can’t get msSQL_server_setup.asp to run : I have downloaded version 7.6SQL...]]> https://forums.webwiz.net/cant-get-mssql-server-setup-asp-to-run_topic7416_post37029.html#37029 Author: bryan
Subject: 7416
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]]> Thu, 20 Nov 2003 04:03:42 +0000 https://forums.webwiz.net/cant-get-mssql-server-setup-asp-to-run_topic7416_post37029.html#37029