Windows: Open file - Security warning

Symptom

When you run a script, batch file or an executable directly from a network share, the Open file - Security warning dialog may appear as shown in the figure.

To prevent this prompt from appearing, use one of the methods listed in this article.

Resolution

Method 1

Enable the Include all network paths (UNCs) setting in Internet Options applet.

• Click Start, Run and type INETCPL.CPL
• Select the Security tab, Local intranet
• Click Sites button
• Put a checkmark near the following option:

Include all network paths (UNCs)

Here is a description of the above setting:

Network paths (for example, \\local\file.txt) are typically used for local network content that should be included in the Local Intranet zone. If there are network paths that should not be in the Local Intranet zone, you should clear this option and use other options to designate files that are assigned to the Local Intranet zone.

Note: If you've installed Internet Explorer 7 Beta, you may need to first uncheck the option Automatically detect intranet network option in Local intranet zone settings.

Method 2

Add the IP or the FQDN of the network computer to your Local Intranet or Trusted sites zone in Internet Explorer.

• Click Start, Run and type INETCPL.CPL
• Select the Security tab, Trusted sites
• Click Sites button
• Add the IP address / FQDN of the remote computer to the list
  (You can also add the network shares to the Local Intranet zone.)
• Uncheck Require server verification (https:) for all sites in this zone and click Close
• Click OK, OK and close the dialog

Source: Ramesh's Site

Trend Micro: The message Your Security Server session has timed out when logging in to the Security Dashboard

You got message "Your Secutiy Server session has timed out. Please login again" in your first attempt to Trend Micro Security Dashboard for Client Server Messaging Security for SMB 3.0

Problem
An IUSR_ account that does not exist in the ..|PCCSRV|Temp folder or no modify permission.

Workaround
Give Modify permission to the account

Go to Trend Micro solution ID 1031798 for more detail.

Error 8114: Error converting data type int to tinyint.

You face problem with Microsoft SQL-DMO(ODBC SQLState:42000) with error message "Error 8114: Error converting data type int to tinyint."

Problem
The problem happen when you try to edit maintenance plan

Workaround
1. Add BackupDirectory registry value for the instance SQL Server
Example:
HKLM\SOFTWARE\Microsoft\Microsoft SQL Server\\MSSQLServer

2. The string value is "BackupDirectory" and the data value is"C:\Program Files\Microsoft SQL Server\MSSQL$nameinstance\BACKUP"

3. Other way is to delete existing plan