Web Wiz Support and Community Forums : msSQL_Server_Setup.asp https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Thu, 09 Apr 2026 07:48:17 +0000 Mon, 07 Aug 2006 20:00:32 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=20941 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[msSQL_Server_Setup.asp : The problem you have here is...]]> https://forums.webwiz.net/mssql-server-setup-asp_topic20941_post112274.html#112274 Author: WebWiz-Bruce
Subject: 20941
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.


Edited by -boRg- - 07 August 2006 at 8:01pm]]> Mon, 07 Aug 2006 20:00:32 +0000 https://forums.webwiz.net/mssql-server-setup-asp_topic20941_post112274.html#112274 <![CDATA[msSQL_Server_Setup.asp : I am having the same problem...]]> https://forums.webwiz.net/mssql-server-setup-asp_topic20941_post112266.html#112266 Author: charast
Subject: 20941
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 inmixed 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 populatedthis with the name of the SQL user I created with DBO rights

SQL server password:   (this is a blank field)  Ipopulated this with the password of the SQL user I created with DBOrights

SQL server username for creating tables:  (this field isPRE-populated with "DBO" ).  I have left this as DBO (does notwork). I have entered the  SQL server username I created with DBOrights (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 wecan get a bit of a better response as to what may be happening otherthan the canned one I have read on virtually every post regarding thisissue.

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

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



Edited by charast - 07 August 2006 at 4:35pm]]> Mon, 07 Aug 2006 16:05:24 +0000 https://forums.webwiz.net/mssql-server-setup-asp_topic20941_post112266.html#112266 <![CDATA[msSQL_Server_Setup.asp : perfect, good old server reboot...]]> https://forums.webwiz.net/mssql-server-setup-asp_topic20941_post112262.html#112262 Author: budgie69
Subject: 20941
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
]]> Mon, 07 Aug 2006 15:15:56 +0000 https://forums.webwiz.net/mssql-server-setup-asp_topic20941_post112262.html#112262 <![CDATA[msSQL_Server_Setup.asp : Make sure that the SQL Server...]]> https://forums.webwiz.net/mssql-server-setup-asp_topic20941_post112260.html#112260 Author: WebWiz-Bruce
Subject: 20941
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.
]]> Mon, 07 Aug 2006 14:56:28 +0000 https://forums.webwiz.net/mssql-server-setup-asp_topic20941_post112260.html#112260 <![CDATA[msSQL_Server_Setup.asp : Getting frustrated with the process: SQL...]]> https://forums.webwiz.net/mssql-server-setup-asp_topic20941_post112249.html#112249 Author: budgie69
Subject: 20941
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,
 
]]> Mon, 07 Aug 2006 10:42:31 +0000 https://forums.webwiz.net/mssql-server-setup-asp_topic20941_post112249.html#112249