Internal Error
File:../libdbapi/odbc2.c
Line:610
In Fcn.:sql_exec_direct
Called Fcn.:SQLExecDirect() returned -1
Description:42000: [Microsoft][ODBC SQL Server Driver][SQL Server]The transaction log for database 'MSI_SupportKB' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases

SQL Error SQL Error
File:../libapi/stats.c
Line:79
In Fcn.:stats_increment
SQL Fcn.:sql_exec_direct() returned -1
SQL Stmt.:INSERT INTO stats (stat_date, hits, searches, assists, email_assists, smarts, sessions, ans_viewed, interface_id) VALUES ('2010-09-07 00:00:00', 0, 0, 0, 0, 0, 1, 0, 1)
SQL Error:42000: [Microsoft][ODBC SQL Server Driver][SQL Server]The transaction log for database 'MSI_SupportKB' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases

Internal Error Internal Error
File:../libdbapi/odbc2.c
Line:610
In Fcn.:sql_exec_direct
Called Fcn.:SQLExecDirect() returned -1
Description:42000: [Microsoft][ODBC SQL Server Driver][SQL Server]The transaction log for database 'MSI_SupportKB' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases

SQL Error SQL Error
File:../libapi/stats.c
Line:79
In Fcn.:stats_increment
SQL Fcn.:sql_exec_direct() returned -1
SQL Stmt.:INSERT INTO stats (stat_date, hits, searches, assists, email_assists, smarts, sessions, ans_viewed, interface_id) VALUES ('2010-09-07 00:00:00', 1, 0, 0, 0, 0, 0, 1, 1)
SQL Error:42000: [Microsoft][ODBC SQL Server Driver][SQL Server]The transaction log for database 'MSI_SupportKB' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases

Internal Error Internal Error
File:../libdbapi/odbc2.c
Line:610
In Fcn.:sql_exec_direct
Called Fcn.:SQLExecDirect() returned -1
Description:42000: [Microsoft][ODBC SQL Server Driver][SQL Server]The transaction log for database 'MSI_SupportKB' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases

SQL Error SQL Error
File:../libapi/stats.c
Line:189
In Fcn.:stats_update_faq
SQL Fcn.:sql_exec_direct() returned -1
SQL Stmt.:INSERT INTO incident_stats (ref_no, faq_date, faq_hits, interface_id) VALUES ('090804-000001', '2010-09-07 00:00:00', 1, 1)
SQL Error:42000: [Microsoft][ODBC SQL Server Driver][SQL Server]The transaction log for database 'MSI_SupportKB' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases

Internal Error Internal Error
File:../libdbapi/odbc2.c
Line:610
In Fcn.:sql_exec_direct
Called Fcn.:SQLExecDirect() returned -1
Description:42000: [Microsoft][ODBC SQL Server Driver][SQL Server]The transaction log for database 'MSI_SupportKB' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases

SQL Error SQL Error
File:solved.c
Line:68
In Fcn.:solved_increment
SQL Fcn.:sql_exec_direct() returned -1
SQL Stmt.:UPDATE incidents SET solved_count = solved_count + 2, access_time = '2010-09-07 12:10:14' WHERE ref_no = '090804-000001'
SQL Error:42000: [Microsoft][ODBC SQL Server Driver][SQL Server]The transaction log for database 'MSI_SupportKB' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases

Internal Error Internal Error
File:../libdbapi/odbc2.c
Line:573
In Fcn.:sql_execute
Called Fcn.:SQLExecute() returned -1
Description:42000: [Microsoft][ODBC SQL Server Driver][SQL Server]The transaction log for database 'MSI_SupportKB' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases

Answer
 
Maximizer > Support > Knowledge Base Search New - Searching Tips Disclaimer
 Answers 
   
  Help  
Search Results
Related Answers
Product

   
Category

     
Search Text (optional) Search Tips? 
   
Search by      Sort by

Powered by RightNow Web
  Reference #  
090804-000001
  Product  
Maximizer
  All Articles
  Category  
Configuration
  Date Updated  
01/26/2010 09:06 AM

 Print  Print Answer 		  
  Setting Up Windows Authentication for Web Access in Windows Server 2008
  Question
 

Setting Up Windows Authentication for Web Access in Windows Server 2008

In addition to specifying Windows Authentication as the means of user authentication during the installation, you must also do the following steps to set up Windows Authentication for Web Access in Windows 2008.
  Answer
 

Setting up Windows Authentication for Web Access in SQL

  1. Right click on the SQL Server and select properties. On the Security tab of the SQL server properties, select Windows Only as the type of authentication.

  2. Under databases, expand MaConfig tables. Right Click the MaConfig table and select open. Find each row where eKey = USE_NT_AUTHENCATION and set the eValue to yes.

Configuring the Web.config files for Windows Authentication for Web Access

Maximizer Web Access, Maximizer Web Access Administrator, and Wireless Access

  1. Set the authentication setting to true as follows:

    2. <authentication mode="Windows"/> <identity impersonate="true">

Customer Access and Partner Accesss

  1. In the Web.config file for Customer Access and Partner Access, set the authentication setting to true as follows:

    2. <identity impersonate="true">

  2. You must also append the authentication setting with the IUSR machine name and password as follows:

    3. <identity impersonate="true" userName="IUSR_MachineName" password="IUSR_password">

    The username and password are for a user to run under the external site/estore login. This user needs SQL permission equal to WEBUSER, and file permissions equal to NETWORK SERVICE. File permissions apply to the portal (web access site) folder, and to the following folder:

    C:\WINDOWS\Microsoft.Net\Framework\v2.0.50727\Temporary ASP.NET Files.

Downloading Documents

To allow users to download documents, users must be able to access the IIS metabase and other directories used by ASP.NET.

  • Create a group on the IIS machine.
  • Add the domain users or domain groups to the group on the IIS machine.
  • Run the following command in the command line. The command is located in the c:\Windows\Microsoft.NET\Framework\v2.0.50727\ folder. Replace group_name with the name of the group you created.

    • aspnet_regiis -ga “group_name”

Configuring IIS for Windows Authentication for Web Access

The following steps need to be applied to Maximizer Web Access, Maximizer Web Access Administrator, and Wireless Access, and also to the Admin subfolder for Customer Access and Partner Access.

  1. Double-click Authenticaion. Verify that Windows Authentication and ASP.NET Impersonation are enabled. All other options must be disabled.

    2. If the Windows Authentication and ASP.NET Impersonation options are not available, go to Control Panel > Programs and Features. Select the Turn Windows features on or off option. Expand Roles and select Web Server (IIS). Click Add Role Services and enable Windows Authentication.

  2. Select Advanced Settings. Change the Application Pool to Classic .NET AppPool.

  3. Restart the IIS service.


At 01/26/2010 09:03 AM we wrote - typo
 
  How well did this answer your question?
 
100% 0%   
Back
  Back to Search Results