Thursday 7 November 2013

SQL Server 2012 installation error "'ExecuteWorkflowAction' is not valid for the WorkflowIdentity element"

While installing SQL server 2012 we get the error :

"The action type 'ExecuteWorkflowAction' is not valid for the WorkflowIdentity element. The only valid action type is ExecuteWorkflowAction"

This is caused because setup file is unable to execute certain workflow identity stored under the installation files. 
Simple and best workaround to solve this issue is to extract the installation files and run the setup file. You will not get this error again and installation will be completed without problem.

Website Panel error "Login failed for user 'sa'."

Some times while accessing website panel, you get the below error :

Server Error in '/' Application.
Client found response content type of 'text/html; charset=utf-8', but expected 'text/xml'.
The request failed with the error message:
--
<html>
<head>
<title>Login failed for user 'sa'.</title>
<style>

This error is usually caused by incorrect password.

Inorder to resolve this issue, you need to correct/update the password in web.config file. Follow the steps given below to resolve this issue:

1. Login to your windows server
2. Open IIS and locate the 'Enterprise server'.
3. Explore it and edit the web.config file in "Enterprise server" directory of website panel installation.
4. In web.config you will see the below lines :

<add name="EnterpriseServer" connectionString="server=(local);database=WebsiteP anel;uid=sa;pwd=PASSWORD;" providerName="System.Data.SqlClient" />

5.Check the password, if the password is incorrect and you are not sure of the correct password. Reset the  'sa' password and update the web.config file with correct password.

This will resolve your website panel issue.