Web Wiz Forums - I need help setting up SQL on GoDaddy

Print Page | Close Window

I need help setting up SQL on GoDaddy

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=17770
Printed Date: 12 April 2026 at 12:51pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: I need help setting up SQL on GoDaddy

Posted By: justme
Subject: I need help setting up SQL on GoDaddy
Date Posted: 06 January 2006 at 5:57pm

I've got the SQL version and am really struggling getting this thing set up on godaddy.com

I've created my MS SQL database with them and gotten my username and password for the database and put it in the SQL_server_connection.asp

And I can never seem to get it to log me in.

Here is what my server is telling me, if any of this info is sensitive and can be used by hackers...please edit it out for me...but i withheld the username/password...i can log in through "open manager" option in my databases using this username/password to see the "tree" for my databases - so that works...but here is the information the server is giving me and i'm pluggin it into sql_server_connection.asp:

Database Name:

DBNAME

Host Name:

mysql85.secureserver.net

User Name

Same as DBNAME

Password

mypassword

This is what I put in into the sql_server_connection.asp

'Enter the details of your SQL server below
strSQLServerName = "mysql85.secureserver.net" 'Holds the name of the SQL Server
strSQLDBUserName = "DBNAME" 'Holds the user name (for SQL Server Authentication)
strSQLDBPassword = "mypassword" 'Holds the password (for SQL Server Authentication)
strSQLDBName = "DBNAME" 'Holds name of a database on the server

'Please note the forum has been optimised for the SQL OLE DB Driver using another driver
'or system DSN to connect to the SQL Server database will course errors in the forum and
'drastically reduce the performance of the forum!

'The SQLOLEDB driver offers the highest performance at this time for connecting to SQL Server databases from within ASP.

'MS SQL Server OLE Driver (If you change this string make sure you also change it in the msSQL_server_setup.asp file when creating the database)
strCon = "Provider=SQLOLEDB;Server=" & strSQLServerName & ";User ID=" & strSQLDBUserName & ";Password=" & strSQLDBPassword & ";Database=" & strSQLDBName & ";"

When I try to run the sql_server_connection.asp file, it first asks for a user name and password, I enter the same user name and password that allow me access to the Database through godaddy and then I get the following error:

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.

Any help is appreciated.

Replies:

Posted By: WebWiz-Bruce
Date Posted: 06 January 2006 at 6:05pm

Tgis may sound like a stupid question, but the parts where it says 'DBName' and 'myPassword' in the SQL_server_connection.asp' file you are actualy entering the your SQL server username, password, and database name?

Check with your host as to the correct database name as DBName just looks like a generic name, and not a unique database name.

-------------
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: justme
Date Posted: 06 January 2006 at 6:12pm

These are not the actual names, this is what I put down here to keep it confidential, I really think that I am doing this right. Can you please take a closer look?

Thanks,

Posted By: WebWiz-Bruce
Date Posted: 06 January 2006 at 6:27pm

I see the problem now, looking at the database name it says 'mysql85'

I guessing then that this is a mySQL database?

mySQL and SQL Server are completly different databases, mySQL being a free database system and SQL Server being a Micrsoft database system costing 1000's of dollars.

Web Wiz Forums 7.x only supports Access and SQL Server, if you want mySQL support you will need to wait for version 8 release on Web Wiz Forums.

-------------
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: justme
Date Posted: 06 January 2006 at 7:28pm

When would that be released?

Posted By: justme
Date Posted: 06 January 2006 at 7:42pm

I see it, it says:

Estimated time till version 8 beta 1 - Next week before Friday 13th January 2006

Thanks for your help,

Posted By: onslaught26
Date Posted: 06 April 2006 at 6:08pm

so i have same problem,
what can i write here mysql85.secureserver.net
i also use mySQL, but i dont know what is 85?
how can i learn it is 24 or 85? whatever else? please some one help me :)

Posted By: WebWiz-Bruce
Date Posted: 07 April 2006 at 12:08pm

You are posting in the version 7 forum and version 7 of web wiz forums doesn't support mySQL.

Make sure you are using the version 8 RC1.1 mySQL version (not SQL Server which is a different thing)

Also check that GoDaddy are using mySQL 4.1 or above.

The 85 part you mention is just the name given to the server and doesn't effect anything.