Web Wiz Support and Community Forums : Can't configure for MSSQL

Web Wiz Support and Community Forums : Can't configure for MSSQL https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Tue, 07 Apr 2026 11:12:19 +0000 Wed, 13 Jun 2007 04:06:51 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=23513 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[Can't configure for MSSQL : Doh! Fixed my own incompetence....]]> https://forums.webwiz.net/cant-configure-for-mssql_topic23513_post123591.html#123591 Author: jkiester
Subject: 23513
Posted: 13 June 2007 at 4:06am

Doh! Fixed my own incompetence. It was a reading problem. The entries on the msSQL_server_setup.asp page that worked are:

SQL Server Username: sa
SQL Server Password: **********
SQL Server Username for creating tables: DBO

Once I got this right, it completed with no further problem.

Double Doh!

]]> Wed, 13 Jun 2007 04:06:51 +0000 https://forums.webwiz.net/cant-configure-for-mssql_topic23513_post123591.html#123591 <![CDATA[Can't configure for MSSQL : I'm trying to test WWF with...]]> https://forums.webwiz.net/cant-configure-for-mssql_topic23513_post123590.html#123590 Author: jkiester
Subject: 23513
Posted: 13 June 2007 at 3:58am

I'm trying to test WWF with MSSQL 2000 and am not able to complete the msSQL_server_setup.asp setup. All I get is an error (just like the others in this forum). When I run the page, 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 'database_connection.asp' found in the 'database' directory.

Here's my entries from the database_connection.asp modification:

strSQLServerName = "10.1.1.11" 'Holds the name of the SQL Server (This is the name/location or IP address of the SQL Server)
strSQLDBUserName = "sa" 'Holds the user name (for SQL Server Authentication)
strSQLDBPassword = "**********" 'Holds the SA password (for SQL Server Authentication)
strSQLDBName = "rokforums" 'Holds the name of the database

I can connect to the blank MSSQL database "rokforums" via Query Analyzer with the above credentials so MSSQL is running in mixed authentication mode. (BTW, IIS 5, my website, and MSSQL 2000 are all running on this same testbed server)

Here's my entries from msSQL_server_setup.asp:

SQL Server Username: 10.1.1.11
SQL Server Password: **********
SQL Server Username for creating tables: sa

I've triple checked all my entries and fat fingers is not the issue. I've confirmed that sa is dbo on the "rokforums" database.

This all seems pretty straight forward and not unfamiliar to me, so any help would be appreciated. If I can't get this working on the test bed, I will have to find some other forum software to test and roll-out.

Thanks in advance,

John

]]> Wed, 13 Jun 2007 03:58:56 +0000 https://forums.webwiz.net/cant-configure-for-mssql_topic23513_post123590.html#123590