msSQL_Server_Setup.asp

Post Reply

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
budgie69 Members Profile Find Members Posts Newbie Joined: 07 August 2006 Status: Offline Points: 2	Post Options Post Reply Quote budgie69 Report Post Thanks(0) Quote Reply Topic: msSQL_Server_Setup.asp 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,

WebWiz-Bruce Members Profile Find Members Posts Admin Group Web Wiz Developer Joined: 03 September 2001 Location: Bournemouth Status: Offline Points: 9844	Post Options Post Reply Quote WebWiz-Bruce Report Post Thanks(0) Quote Reply 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.
	Web Wiz Forums Hosting ASP.NET Web Hosting

budgie69 Members Profile Find Members Posts Newbie Joined: 07 August 2006 Status: Offline Points: 2	Post Options Post Reply Quote budgie69 Report Post Thanks(0) Quote Reply 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

charast Members Profile Find Members Posts Newbie Joined: 07 August 2006 Status: Offline Points: 1	Post Options Post Reply Quote charast Report Post Thanks(0) Quote Reply 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!! Edited by charast - 07 August 2006 at 4:35pm

WebWiz-Bruce Members Profile Find Members Posts Admin Group Web Wiz Developer Joined: 03 September 2001 Location: Bournemouth Status: Offline Points: 9844	Post Options Post Reply Quote WebWiz-Bruce Report Post Thanks(0) Quote Reply 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
	Web Wiz Forums Hosting ASP.NET Web Hosting

Post Reply

Forum Jump

Forum Permissions View Drop Down

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum