There are several problems that have been becoming more prevalent with iMIS 10.x.NET and iMIS15 involving various security and connection issues. Below, is a list of common issues and solutions:

• 13: Type Mismatch Error when trying to log in through the desktop
• The login account 'sa' has been locked out
• The webpage is unavailable

These are becoming more common errors and are caused by several different possible problems:

• The User account has not been updated / synchronized with SQL security.
• The internet security settings on the local workstation are disabling cookies and/or blocking content from the intranet site.
• The 'sa' account has been locked out.

If this problem is restricted to one workstation, the problem is on the security settings for the workstation. Check the internet security settings:

1. Open Internet Explorer and go to Tools >>> Internet Options >>> Security tab
2. Change the highlighted "Zone" selection to "Intranet"
3. Click the "Sites" button and add "http://IIS-SERVER-Name" to the list (change "IIS-SERVER-NAME" to the actual server name for your application server
4. Once you've added this site to the list of "safe sites" be sure to double-check the actual security settings on the main screen
5. Since this is only for the "Local Intranet" zone, you can change the settings for this zone to "Default Level" and crank the security dial all the way down to "Low"
6. While you're messing around in the tools area, be sure to change the settings on pop-up blockers to allow pop-ups from the same site. This will prevent problems with IQA and other .NET-based items from happening before they start
7. Don't forget Google or MSN toolbars with built-in pop-up blockers!!

Try rebuilding the SQL security:

In 10.x.NET:

1. Log in as MANAGER!SA
2. Go to File >>> System Setup >>> User Passwords
3. Click on "Rebuild SQL Logins at the bottom of the screen. It's recommended to try this twice, since I've found there may often be some hangup on the first run that you never see.

In iMIS15:

1. Open the iMIS DB Repair Utility
2. Connect to the database through the SQL 'sa' password
3. Click "Prepare iMIS Database" at the bottom of the screen

Check / change the Login security setup for the 'sa' account (this is exclusively an issue in SQL Server 2005):

1. Open the SQL Studio
2. Connect to the SQL Server using "Windows Authentication"
3. Under the Object Explorer, expand the "Security Folder" and click on the "Logins" folder
4. Right-click on the 'sa' login and select "Properties"
5. On the Login Properties - sa pop-up window, on the "General" page, make sure that the checkbox for "Enforce password policy" is UNchecked
6. Switch to the "Status" page, and make sure the "Enabled" is selected under Login: and that the "Account is locked out" checkbox is UNchecked

It's also a good thing to make the following change in the Web.config file under the .NET website

Find the following line under the tag:

Change "false" to "true" so it now reads:

This will allow you to get the "Blue Screen of crazy code" whenever there's a website problem. It's actually much more useful than the standard custom error that pops up: "An error has occurred. Please contact your system administrator."

While you're in the web.config file, you might as well change one other tag:

Change the Max Results number on the PagedView list to 5000, 50000, or 500000, depending on the size of your database:

Change the number inside the quotes after value=:

This affects the limits put on all the screens in IQA results lists. This way, you can see the actual number of results from a query if that number is over 500. It quickly becomes annoying to run every query and keep getting "Showing 1-10 of 500" results, when in fact, there are 12,283 records returned by the query.

I'll add to this list as we come across more issues

-K
enSYNC Corp.
www.ensync-corp.com