Q1: I saw this error (or an error similar to this):
Microsoft OLE DB Provider for SQL Server error '80040e21'
The requested properties cannot be supported.
Or
Microsoft OLE DB Provider for SQL Server error '80040e14'
Could not find stored procedure 'dbo.spFetchConfig'.
A: This happens when you set an incorrect value for the variable,
dbOwnerPrefix, inside your masterinclude.asp (ASP version) or web.config (ASP.NET version). If you are currently using the default value, "dbo." , then please replace it with " [your user name]."
For example, if you are using "hollywood" as your
dbUser variable, please use "hollywood." as your
dbOwnerPrefix. However, if "dbo." works just fine, then you don't need to change it.
Or, you can just leave the value for the dbownerprefix variable
blank.
Q2: I saw a similar error in
ini.asp, but the solution above didn't help?
A: You do not have sufficient permission on your database(a very rare situation). Please ask your ISP to set the correct permission for you: You will need " execute" permission on stored procedures,
or you can simply ask your ISP to add your login to the "db_owner" group.
Also, don' t forget to enable SQL authentication for your SQL server. If you wish to use "integrated security" authentication mode for the SQL server database, please read this message:
http://www.aspplayground.net/forum/tm.asp?m=375948
Q3: I got a
different error when I tried to set up the forum the first time. The following is the error description:
Microsoft OLE DB Provider for SQL Server (0x80004005)
Login failed for user 'windows admin' . Reason: Not associated with a trusted SQL Server connection.
A: This problem occurs because you did not connect to the MSDE or SQL 2000 with the same name as when you created the database.
E.g.
- you logged on as 'windows admin' (a username) to run the installation script.
- your IIS runs under "IUSR_<machine>" (default username for Internet Guests), which is different from your 'windows admin'
To resolve this issue, do one of the following:
- Eschew Windows authentication-> enable SQL server authentication for your MSDE 2000 or SQL 2000 database and use it.
- Continue to use Windows Authentication, but add IUSR_<machine> to your MSDE database as a member of the "db_owner" group, and then use the technique described in this thread: http://www.aspplayground.net/forum/tm.asp?m=375948
- db_owner privilege for the IUSR account is required to set up the database for the forum software, but it is not required to run the software after the initial installation. If you wish to tighten security, our software can run with db_datareader + db_datawriter privilege (BOTH, not either or). With this lesser security privilege, the only thing that will be hidden is the ability to shrink database via the admin control panel.
Q4: I got a
different error when I tried to set up the forum the first time. The following is the error description:
Error Type:
Microsoft OLE DB Provider for SQL Server (0x80004005)
Cannot open database requested in login ' ASPForum' . Login fails.
A: It says login fails -> which means the database, ASPForum, does not have a valid user whose name/password combination corresponds to what you supplied in masterinclude.asp. Double check with your Database admin and make sure you are entering the correct login info.
Q5: I use a DSN for the database but it is not working?
A: Please use our original connection string for native OLEDB provider support. We do not support OLEDB for ODBC.
Q6:I got stuck in the installation on the folowing error:
Error Type:
(0x8002801D)
Library not registered.
/ASPPforum/js/globalSessionFunction.asp, line 290
A: The Scripting engine on your server is corrupted. Please reinstall VBScript engine to fix the problem. You can download that file on
Microsofts site.
Q7:I got stuck in the installation on the folowing error:
ADODB.Stream error '800a0bbc'
Write to file failed.
/Forum/js/globalfunctions.asp, line 711
A: You need to grant write/delete/modify permission for the internet guest account on the folder
upfiles under your forum directory. This is required for versions 2.4.3 and up.
Q8:I got stuck in the installation on the folowing error:
Microsoft OLE DB Provider for SQL Server error '80004005'
[DBNMPNTW]ConnectionOpen (CreateFile()).
/forum/js/globalfunctions.asp
A: Please refer to this article:
http://support.microsoft.com/kb/q175671/
Q9:I tried installing the .NET version of the software, but all I get is an error message telling me to change the customError section in the web.config file to "off". The web.config file has the customError section set to off already.
A: The exact cause of the problem is unknown, but a user (Scott Swain) figured out this issue himself and shared the info with us:
Here is how for IIS 6 in case you want to post this somewhere:- Under APPLICATION POOLS: Create a new application pool for your new forum. Under the IDENTITY tab, be sure to select "Configurable" and put user name as "IWAM_[machine name]" and password.
- Under WEBSITES: Right click on the folder called "forum" or whatever you named the folder that has the ASP Playground forum in it. Choose NEW --> Virtual Directory.
- Under WEBSITES: Go into properties for this folder, DIRECTORY tab, near bottom for APPLICATION SETTINGS click "Create" button. Give the application a name. Select the application pool you created above.
Q10: I get the error below when first running the forum. I have set directory permissions as required.
For ASP version:
Microsoft OLE DB Provider for SQL Server error '80004005'
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.
For ASP.NET version:
System.Data.SqlClient.SqlException: SQL Server does not exist or access denied.
A: this error tells you that you got the wrong login info for your SQL server. Either the IP address is wrong, or the login/pass combo is wrong. For security reasons the error message only tells you this much. Double check to make sure everything you set is correct in masterinclude.asp(x).
It is also possible that the SQL server is down at the moment.
Q11: What should the UUID be for referencing ADO constants in
64-bit Windows 2003? I am using the ASP version. I keep getting the following error:
Active Server Pages error 'ASP 0223'
TypeLib Not Found
/masterinclude.asp, line 3
METADATA tag contains a Type Library specification that does not match any Registry entry.
A: Thanks to Gun, as he found out the answer the hard way. The UUID for 64-bit Win 2003 server should be 2A75196C-D9EB-4129-B803-931327F72D5C, so the declaration should look like
<!-- METADATA TYPE="typelib" UUID="2A75196C-D9EB-4129-B803-931327F72D5C" -->
keyword: Not associated with a trusted SQL Server connection, The requested properties cannot be supported, ini.asp, set up, Write to file failed, SQL Server does not exist or access denied.
<message edited by Samuel on Thu. Jul 3, '08 7:25 PM>