Information

Transfer logins and passwords to destination server (Server A) using scripts generated on source server (Server B) To create a script on the source Server, follow these steps: On server A, start SQL Server Management Studio, and then connect to the instance of SQL Server from which you moved the database. Open a new Query Editor window, and then run the following script. USE master GO IF OBJECT_ID ('sp_hexadecimal') IS NOT NULL DROP PROCEDURE sp_hexadecimal GO CREATE PROCEDURE sp_hexadecimal @binvalue varbinary(256), @hexvalue varchar (514) OUTPUT AS DECLARE @charvalue varchar (514) DECLARE @i int DECLARE @length int DECLARE @hexstring char(16) SELECT @charvalue = '0x' SELECT @i = 1 SELECT @length = DATALENGTH (@binvalue) SELECT @hexstring = '0123456789ABCDEF' WHILE (@i <= @length) BEGIN DECLARE @tempint int DECLARE @firstint int DECLARE @secondint int SELECT @tempint = CONVERT(int, SUBSTRING(@binvalue,@i,1)) SELECT @firstint = FLO...

AWS Amazon, Create Access Key and Secret Key Creating, Disabling, and Deleting Access Keys for Your AWS Account Root User Use your AWS account email address and password to sign in to the AWS Management Console as the AWS account root user.   Choose your account name in the navigation bar, and then choose My Security Credentials.   If you see a warning about accessing the security credentials for your AWS account, choose Continue to Security Credentials   Expand the Access keys (access key ID and secret access key) section.   Choose Create New Access Key. If this feature is disabled, then you must delete one of the existing access keys before you can create a new key. For more information, see IAM Entity Object Limits in the IAM User Guide.   A warning explains that you have only this one opportunity to view or download the secret access key. It cannot be retrieved later.   Choose Show Access Key to copy the access key ID and secret key from yo...

You need to start command prompt by typing cmd at the Run command and then execute the command prompt with Administrator rights by right clicking and choosing Run as administrator from the context menu.   Then on the command prompt you need to navigate to the Directory that has the aspnet_regiis.exe file for that you need to type   CD C:\Windows\Microsoft.NET\Framework64\v4.0.30319\   Then you need to type the following command and hit enter to register ASP.Net with IIS   aspnet_regiis -i  

IIS 8 error on windows server 2012 insufficient permission There was an error when trying to connect. Do you want to retype your credentials and try again? Details: Filename: \?\C:Windows\system32\inetsrv\config\redirection.config Error: Cannot read configuration file due to insufficient permissions screenshot: Solution: Steps to short out this issue: go to C:\Windows\Microsoft.Net\Framework64\v2.0.50727\CONFIG\machine.config here you got the redirection tag like the below <configurationredirection enabled="true" password="[enc:IISCngProvider:X0ObCWwZ4+PrTHiFVPtzFeCcL8u5P6KUOYfo1/0QrgZWATA5pKWqHvD8nL2crNJKyyqr4z/rBdLPjdRcaLxAMMj4l+lvp5EXXKSXueolvyGa34F4QZfbBVCM6oVNcq3M368TOTVjJv4POVFQWvu0MDVlGgReglXB+Lw5BRI4Htw=:enc]" path="C:\Windows\System32\inetsrv\config\import\" username="Administrator"> </configurationredirection"></li"> you need to change this to <configurationRedirection /> Th...

How to take Backup and Restore of Tortoise SVN on window? Back SVN Go to Run with Administrator privilege and then type cmd and open command prompt Run the following command svnadmin dump c:\Repositories\RepositoryName > c:\Repositories\svnbackup.dump Here c:\Repositories\RepositoryNam e is the source path of the repository c:\Repositories\ is the destination where the dump will create svnbackup.dump name of dump file Restore SVN Go to Run with Administrator privilege and then type cmd and open command prompt Run the following command svnadmin load c:\Repositories < c:\Repositories\svnbackup.dump Here c:\Repositories  is the destination path of the repository c:\Repositories\ svnbackup.dump  name of dump file that will be loaded

When we trying to add a DataTable (that is inside of a different DataSet) to new DataSet ds. If I add it directly, we will get the following error:                     DataTable already belongs to another DataSet. DataTable.Copy use DataTable.Copy to create a copy of your data table; then insert the copy into the target DataSet: dataSetX.Tables.Add( dataTableFromDataSetY.Table[0].Copy() ); DataSet.Merge You could also use DataSet.Merge for this: dataSetX.Merge(dataTableFromDataSetY); Note, however, that if you are going to use this method, you might want to make sure that your target DataSet doesn't already contain a table with the same name: If the target DataSet doesn't contain a table by the same name, a fresh copy of the table is created inside the data set; If a table by the same name is already in the target data set, then it will get merged with the one passed to Merge, and you end up with a mix of the two.

To use the RSA keys provided by AWS Account/Security in the .NET framework, you must convert the AWS-supplied .pem files to the XML format that the .NET framework uses. You can use below link to convert.   https://superdry.apphb.com/tools/online-rsa-key-converter

Error -  Message delivery to the remote domain 'gmail.com' failed for the following reason: The remote server did not respond to a connection attempt.  Amazon Web Services’  EC2  instances are throttled on port 25 by default as a spam prevention measure. This can cause connection issues when attempting to use SMTP to relay emails through Postmark in your EC2 instance. There are a couple ways to resolve this issue so that you do not receive connection errors when using Postmark in your EC2 instance.  How do I remove the throttle on port 25 from my EC2 instance? Issue I'm having trouble sending email over port 25 of my Amazon EC2 instance, or I'm getting frequent timeout errors. How do I remove the port 25 throttle on my EC2 instance? You can request Amazon Web Services to remove the throttling on port 25 using the Request to Remove Email Sending Limitations  form.  Note: you must sign in with your root account credentials . Amazon ...

AWS - Transfer the AWS EC2 Instances to ENA instances Tags – Transfer m4 to C5 family, Transfer m4 to m5 family, Transfer m4 to R4 family, transfer to ENA instances Steps are as follows: 1.     Install and configure the  AWS CLI  or the  AWS Tools for Windows PowerShell  on any computer you choose, preferably your local desktop or laptop. For more information, see  Accessing Amazon EC2 . Enhanced networking cannot be managed from the Amazon EC2 console. 2.     Configure the AWS Command Line Interface , use the  aws configure  command $ aws configure AWS Access Key ID [None]: AKIAIOSFODNN7EXAMPLE AWS Secret Access Key [None]: wJalrXUtnFEMI/K7MDENG/bPxRfiCYEXAMPLEKEY Default region name [None]: us-west-2 Default output format [None]: json 3.     Take an AMI of the Instance to have as a backup 4.     Install the driver to the instance 5.     Stop the In...

Many WordPress users struggle around this issue of WordPress line break not working. In this article, we discuss some of the possible ways to get around this issue. 1. Use empty classes in HTML Elements You can make WordPress assume that your HTML elements contain certain attributes. This can be done by Adding attributes to the HTML elements with the use of empty classes. For example: Avoid writing: <p> <br> <span> Instead, write: <p class=""> <br class=""> <span class=""> 2. Disable Autop formatting The  Autop() function  in WordPress auto formats the paragraphs. The WordPress line break not working is due to the presence of a filter called “wpautop”. The “wpautop” filter executes whenever the content of a blog post is rendered. We can easily use the  remove_filter function  to disable the  wpautop filter . In the functions.php file you need to add the following code: remove_filter ('the_conten...