Print Page | Close Window

2 days later and still no workie - SQL

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


Topic: 2 days later and still no workie - SQL
Posted By: tasforsale
Subject: 2 days later and still no workie - SQL
Date Posted: 14 September 2005 at 8:07pm
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 to get this dang forum up and running :(...do i have to go back into the common.asp files and rename the database to the same on that godaddy assigned to me when i set up the databases?  Or am i doing something else wrong...
 
~Confused in Charlotte


-------------
Loster than the people on Lost



Replies:
Posted By: WebWiz-Bruce
Date Posted: 15 September 2005 at 4:20am
To use the MS SQL Server version make sure you have downloaded the MS SQL Server version and then follow the install instructions that come with it.

So that the forum connects to the SQL Server database the only file you need to edit is the SQL_server_connection.asp file found in the admin area entering your sql server database details.

Also check that your SQL Server database is setup properly and you can log into it (Godady should be able to hlp you further with this part).

Also if you are still having problems if you could let us know the exact error message it should help further track down your exact problem.


-------------
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: tasforsale
Date Posted: 15 September 2005 at 12:34pm
thanks borg
 
I'll try it all over again...and just wipe the slate clean and start all over...question...
 
is it easier to install it with mySQL or MS SQL because i have the option of using either...


-------------
Loster than the people on Lost


Posted By: tasforsale
Date Posted: 15 September 2005 at 1:39pm
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: DB_17542
Type: MS SQL
Status: Active
Host Name: <edit>
Size: 0mb
Server name : whsql-v03
Server version : Microsoft SQL Server 2000 - 8.00.2039 (Intel X86)
May 3 2005 23:18:38
Copyright (c) 1988-2003 Microsoft Corporation
Standard Edition on Windows NT 5.2 (Build 3790: )
Language : us_english
Now....i have not created my own database or modified anything other than the SQL_server_connection.asp page and then reloaded it up to my ftp, i simply used the one they assigned to me (DB_17542)...and put in the four things it required in between the green quotation marks...saved it...ran the page sql_server_connection.asp file on ie..and it said done...then tried to run the mssql_server_setup.asp file and got the following...
 
 
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.
 
Here is specifically what i put in the sql_server_connection.asp page..
 
strSQLServerName = "whsql-v03" 'Holds the name of the SQL Server
strSQLDBUserName = "username(same as godaddy to enter database tree)" 'Holds the user name (for SQL Server Authentication)
strSQLDBPassword = "password(same as godaddy to enter database tree)" 'Holds the password (for SQL Server Authentication)
strSQLDBName = "DB_17542"     '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 & ";"


-------------
Loster than the people on Lost


Posted By: dj air
Date Posted: 15 September 2005 at 1:54pm
you can not run this on a MySQL

the above is almost there

the strSQLServerName, should be (i think) what was in the part that i edited

that is the server server name/server


Posted By: tasforsale
Date Posted: 15 September 2005 at 2:31pm
I'll give it a shot and let you know dj...thanks...keep your fingers crossed!Dead

-------------
Loster than the people on Lost


Posted By: tasforsale
Date Posted: 15 September 2005 at 2:47pm
it works!!!!!!!
 
I deleted the SQL_server_connection.asp file from the site now for protection as described...so it should be pretty secure now correct?  Anything else i should look out for?
 
Thanks so much!  I almost gave up but now...
 


-------------
Loster than the people on Lost


Posted By: dj air
Date Posted: 15 September 2005 at 6:15pm
you should be ok as long as you :

dont have an easy password to guess and you keep up to date, with the updates


Posted By: arhunter
Date Posted: 16 September 2005 at 12:11am
I have a similar problem...after my database was set up and I try to go to my forum I get the following message.
 
 

Microsoft OLE DB Provider for SQL Server error '80040e4d'

Login failed for user 'admin'.

/forum/common.asp, line 260

I can login to the database and all the tables are there.



Posted By: dj air
Date Posted: 16 September 2005 at 9:16am
the username and password specified within the SQL connection file found in the admin folder, is the ones used to access the SQL server not the Forum.

please make sure these are correct as it sounds this is the issue


Posted By: arhunter
Date Posted: 16 September 2005 at 10:44am

I am sure that the user name and password are the ones for the data base....they are the same ones I use to access the data base through Enterprise Manager.



Posted By: clownfire
Date Posted: 24 December 2005 at 9:45am

Anyone have any ideas on importing my access db to sql on godaddy?  They don't use enterprise mangler.



Posted By: safetynut
Date Posted: 28 December 2005 at 9:34pm
Originally posted by dj air dj air wrote:

you can not run this on a MySQL

the above is almost there

the strSQLServerName, should be (i think) what was in the part that i edited

that is the server server name/server
 
Cn you provide me with the details that corrected this issue.  I'm having a similar issue with the same ISP and I believe your fix may be what I am needing.  I'm assuming it was a correction to the string for accessing the actual server.


Posted By: dj air
Date Posted: 29 December 2005 at 4:04pm
the host name should be a IP Address or a host name/ domain style.
 
what i edited is on page one, and was the strServername.



Print Page | Close Window

Forum Software by Web Wiz Forums® version 12.08 - https://www.webwizforums.com
Copyright ©2001-2026 Web Wiz Ltd. - https://www.webwiz.net