Web Wiz Forums - Installation Problems

Print Page | Close Window

Installation Problems

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=1158
Printed Date: 30 March 2026 at 1:18am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Installation Problems

Posted By: testuser
Subject: Installation Problems
Date Posted: 19 March 2003 at 10:34pm

I am getting the following error (I have double checked everything as well as triple checked...and so on):

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 'SQL_server_connection.asp' found in the admin directory.

Replies:

Posted By: MadDog
Date Posted: 19 March 2003 at 10:37pm

make sure you read the docs that come with the forum.

-------------
http://www.iportalx.net" rel="nofollow">

Posted By: testuser
Date Posted: 20 March 2003 at 12:37am

Read all the documents that came in the zip package...anything else i can do.

Posted By: WebWiz-Bruce
Date Posted: 20 March 2003 at 2:22am

The error message you received tells you what you need to do and check:-

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 'SQL_server_connection.asp' found in the admin directory.

-------------
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: NextDoorKid
Date Posted: 20 March 2003 at 4:55am

No, This is a problem that I also came across.

If this error comes up when you are using the "msSQL_set.." setup script then this might be the remedy.
All you have to is login using the user_id and pass in the database itself.
This script does not read the ''SQL_server_connection.asp" script as it is supposed to. In other words it tries to connect to the DB using the user info you enter on the text boxes.

Cheers.

-------------
That's the kid.

Posted By: WebWiz-Bruce
Date Posted: 20 March 2003 at 5:35am

If you read the SQL setup page text properly it already tells you that you need to put in the username and password for the SQL server database. This it taken from the page:-

Enter a username and password in the box below that has table creation/modification rights at the SQL Server database you are using.

The reason for this is that the username and password used in the SQL_database_connection.asp file maybe diffirent to the username and password for a user that has table creation and modification rights on the SQL server.

Posted By: NextDoorKid
Date Posted: 20 March 2003 at 5:43am

Ok, I see. Makes perfect sense to me.

Thanks.

-------------
That's the kid.

Posted By: michael
Date Posted: 20 March 2003 at 10:03am

Nevertheless if you keep getting this error you might have installed SQL in Windows Authentication Mode. Go to EntMan, make a right click on the server, click on properties and check the security mode. Set it to mixed mode, restart service and it should remedy that problem.

Posted By: testuser
Date Posted: 20 March 2003 at 2:06pm

Thanks guyz...I will try what you said...if i have any other problems i will get back to this forum...Thanks