Web Wiz Forums - msSQL_Server

msSQL_Server_Setup.asp

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=20941
Printed Date: 09 April 2026 at 7:45am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: msSQL_Server_Setup.asp

Posted By: budgie69
Subject: msSQL_Server_Setup.asp
Date Posted: 07 August 2006 at 10:42am

Getting frustrated with the process:

SQL is installed, and MDAC 2.8

Edited the dbase connection.asp

When Running the msSQL_Server_Setup.asp and keep getting:

----

Error Connecting to database on SQL Server
Check the following is set up and correct:-
SQL Server User Name
SQL Server Password
Name of the SQL Server
Database name set up by you on the server
Empty Database set up by you on the SQL Server
Check also that you have entered the correct details in the file 'database_connection.asp' found in the 'database' directory.

-----

What is the DBO ?

I am putting the following details in;

USERNAME (tried both NT Logon and SQL SA)

Password (tried SA and NT logon)

DBO Field, not sure what is required here, tried SQL Server & SQL Dbase Name.

Cant get any further than this.

Thanks for you help,

Replies:

Posted By: WebWiz-Bruce
Date Posted: 07 August 2006 at 2:56pm

Make sure that the SQL Server is running in mixed mode allowing TCP/IP connections.

Also check that your SQL Server login details are correct and that you have created a user account on the SQL Server for the database and given that user account DBO (Database Owner) rights on the database.

-------------
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

Posted By: budgie69
Date Posted: 07 August 2006 at 3:15pm

perfect, good old server reboot did the trick, change sql permissions to use both NT and SA authentication...... back to the testing !

Thanks boRg

Posted By: charast
Date Posted: 07 August 2006 at 4:05pm

I am having the same problem as Budgie69 (and quite a few other people after a seach for this issue).

I have SQL2000 installed. a blank database created. I am running SQL in mixed mode. I have a SQL user created which has DBO rights.

I have modified the database_connection.asp file as follows:
servername is localhost (i am running my own webserver, i am NOT using a Webhosting provider)
username is the user I created with DBO rights
password is the password to the above user
dbname is the name of the empty database I created

when I run the msSQL_server_setup.asp it prompts for 3 pieces of input:

SQL server username: (this is a blank field) I populated this with the name of the SQL user I created with DBO rights

SQL server password: (this is a blank field) I populated this with the password of the SQL user I created with DBO rights

SQL server username for creating tables: (this field is PRE-populated with "DBO" ). I have left this as DBO (does not work). I have entered the SQL server username I created with DBO rights (this does not work). I have entered "sa" (also does not work).

all attempts have ended up with the same basic message:

Error Connecting to database on SQL Server
Check the following is set up and correct:-
SQL Server User Name
SQL Server Password
Name of the SQL Server
Database name set up by you on the server
Empty Database set up by you on the SQL Server
Check also that you have entered the correct details in the file 'database_connection.asp' found in the 'database' directory.

I have the database_connection.asp

I am hoping that we can get a bit of a better response as to what may be happening other than the canned one I have read on virtually every post regarding this issue.

what EXACTLY should be contained in the "SQL server username for creating tables" field??

any additional information would be EXTEMELY helpful :) thank you!!

Posted By: WebWiz-Bruce
Date Posted: 07 August 2006 at 8:00pm

The problem you have here is connecting to the database not with the "SQL server username for creating tables" field. If this field was filled in incorrectly you would have problems latter on when the tool trys to create a table on the database and you would see an error that tables could not be created. As you have given your SQL Sever user DBO rights you just leave the field as DBO.

This is why whenever the connection error pops up I don't mention this field as at this point it has no relavents to the connection error that you get.

As the error message you get comes up when it attempts to connect to the database the issue you have is with one of the other fields, and that the database can not be connected to.

Make sure your database is running in mixed mode, allows TCP/IP connections, and the connection details you have entered are correct.

Also, make sure your firewall is not blocking port 1433 which is used for TCP/IP connections to the SQL Server.

-------------
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