Web Wiz - Green Windows Web Hosting
Web Wiz Homepage Search Web Wiz

  New Posts New Posts RSS Feed - Installation Problems
  FAQ FAQ  Forum Search   Events   Register Register  Login Login

Installation Problems
 Post Reply Post Reply Page  12>
Author
  Topic Search Topic Search  Topic Options Topic Options
testuser View Drop Down
Newbie
Newbie


Joined: 16 March 2003
Status: Offline
Points: 3 		Post Options Post Options   Thanks (0) Thanks(0)   Quote testuser Quote  Post ReplyReply Direct Link To This Post Topic: Installation Problems
    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.
Back to Top
MadDog View Drop Down
Mod Builder Group
Mod Builder Group
Avatar

Joined: 01 January 2002
Status: Offline
Points: 3008 		Post Options Post Options   Thanks (0) Thanks(0)   Quote MadDog Quote  Post ReplyReply Direct Link To This Post Posted: 19 March 2003 at 10:37pm
make sure you read the docs that come with the forum.
Back to Top
testuser View Drop Down
Newbie
Newbie


Joined: 16 March 2003
Status: Offline
Points: 3 		Post Options Post Options   Thanks (0) Thanks(0)   Quote testuser Quote  Post ReplyReply Direct Link To This Post Posted: 20 March 2003 at 12:37am
Read all the documents that came in the zip package...anything else i can do.
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844 		Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post 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.
Web Wiz Forums Hosting
ASP.NET Web Hosting
Back to Top
NextDoorKid View Drop Down
Newbie
Newbie
Avatar

Joined: 18 March 2003
Location: United Kingdom
Status: Offline
Points: 8 		Post Options Post Options   Thanks (0) Thanks(0)   Quote NextDoorKid Quote  Post ReplyReply Direct Link To This Post 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.
Back to Top
WebWiz-Bruce View Drop Down
Admin Group
Admin Group
Avatar
Web Wiz Developer

Joined: 03 September 2001
Location: Bournemouth
Status: Offline
Points: 9844 		Post Options Post Options   Thanks (0) Thanks(0)   Quote WebWiz-Bruce Quote  Post ReplyReply Direct Link To This Post 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.



Edited by -boRg-
Web Wiz Forums Hosting
ASP.NET Web Hosting
Back to Top
NextDoorKid View Drop Down
Newbie
Newbie
Avatar

Joined: 18 March 2003
Location: United Kingdom
Status: Offline
Points: 8 		Post Options Post Options   Thanks (0) Thanks(0)   Quote NextDoorKid Quote  Post ReplyReply Direct Link To This Post Posted: 20 March 2003 at 5:43am

Ok, I see. Makes perfect sense to me.

Thanks.
Back to Top
michael View Drop Down
Senior Member
Senior Member
Avatar

Joined: 08 April 2002
Location: United States
Status: Offline
Points: 4670 		Post Options Post Options   Thanks (0) Thanks(0)   Quote michael Quote  Post ReplyReply Direct Link To This Post 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.
Back to Top
 Post Reply Post Reply Page  12>

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 12.08
Copyright ©2001-2026 Web Wiz Ltd.

Become a Fan on Facebook Follow us on X Connect with us on LinkedIn Web Wiz Blogs
About Web Wiz | Contact Web Wiz | Terms & Conditions | Cookies | Privacy Notice

Web Wiz is the trading name of Web Wiz Ltd. Company registration No. 05977755. Registered in England and Wales.
Registered office: Web Wiz Ltd, Unit 18, The Glenmore Centre, Fancy Road, Poole, Dorset, BH12 4FB, UK.

Prices exclude VAT at 20% unless otherwise stated. VAT No. GB988999105 - $, € prices shown as a guideline only.

Copyright ©2001-2026 Web Wiz Ltd. All rights reserved.