SharePoint 2010: Remove solution wsp from Central Administration

To deploy a solution by using Central Administration


1.On the Central Administration Home page, click System Settings.

2.In the Farm Management section, click Manage farm solutions.

3.On the Solution Management page, click the solution that you want to deploy.

4.On the Solution Properties page, click Deploy Solution.

5.On the Deploy Solution page, in the Deploy When section, select one of the following:

admin.aspx Failed to generate a user instance of SQL server due to failure in retrieving the user's local application data path app_data When move SQL server Express to SQL Server

When moving from SQL Server EXPRESS to SQL Server and then  go to admin.aspx, the error happened:
Failed to generate a user instance of SQL server due to failure in retrieving the user's local application data path app_data

SOLUTION:

• Go to IIS 7.
• Click on the site.
• Double click on Connection Strings. Change the SocalSqlServerr value to new one.

Windows server 2008: the password does not meet the password policy requirements

To disable password policy:
Administrative tools ==> Local Security Policy
==> Account policies ==> Password Policy ==> disable the password complexity check.

Login failed for user 'IIS APPPOOL\ASP.NET v4.0'

Web site connection fail on trying to open a connection to SQL Server.

Add a login to SQL Server for IIS APPPOOL\ASP.NET v4.0 and grant permissions to the database.

In SSMS, under the server, expand Security, then right click Logins and select "New Login...".

In the New Login dialog, enter the app pool as the login name and click "OK".

You can then right click the login for the app pool, select Properties and select "User Mapping". Check the appropriate database, and the appropriate roles. I think you could just select db_datareader anddb_datawriter, but I think you would still need to grant permissions to execute stored procedures if you do that through EF.

From http://stackoverflow.com/questions/7698286/login-failed-for-user-iis-apppool-asp-net-v4-0

Oracle: Run Stored procedure with parameter and output

On SQL Developer:

SET serveroutput on;
variable f NUMBER;
execute user.package_name.procedure_name('parameter1', parameter2, :f);
print :f;