June 11, 2013

Opening a SQL Server Instance Port Using Windows Firewall


Opening a SQL Server Instance Port Using Windows Firewall If you attempt to connect to SQL Server from another machine now, the connection attempt will time out .

To connect to this instance, you must open the port . You can do so using Windows Firewall, as follows:

1. Open Windows Firewall and click Start | Control Panel | Windows Firewall.

2. Toward the top of the page, click Advanced Settings.

3. Select Inbound Rules from the left navigation pane .

4. Click New Rule from the right navigation pane.

5. On the Rule Type page, select the radio button labeled Port, and click Next.

6. Ensure that the radio button labeled TCP is selected and enter 1433 in the text box labeled Specific Local Ports. Click Next.

7. Select the Allow the Connection radio button and click Next. 8. In the text box labeled Name, type a descriptive name for your inbound rule. Click Finish. Now you should be able to connect to this instance of SQL Server using various client tools, which will be discussed later in this book .

May 16, 2013

Re-Associate the Workflow to a List - Errors

http://itrathnasekara.blogspot.com/2012/11/how-to-re-associate-list-workflows-with.html


Error 1:  form template (.xsn) file cannot be accessed. You may not have the required permissions to open the file
 
Error 2: This form cannot be opened in a Web browser. To open this form, use Microsoft InfoPath
 
Error 3: The XSN is null and its not a cross server issue. Most likely a permission issue
 
(Resolution For Future Reference: Re-Publish the InfoPath Form)

1.  Close any InfoPath form designers, if open

2.  Go to SPD > Open Site >Workflows > Workflow Name > Forms Section > Click on relevant InfoPath form name to open in InfoPath Form designer

3.  Switch back to SPD and delete the InfoPath form.

4.  Publish the  workflow to create native InfoPath form.

5.  Switch to IP form designer > File > Info > Click Quick Publish. (Verify the URL that it is pointing is correct). Save the form locally if asked for.

 
Resource:  http://social.technet.microsoft.com/Forums/sharepoint/en-US/cc4bc5dd-76ce-4bab-a51e-124cd5470886/a-form-template-xsn-file-cannot-be-accessed-you-may-not-have-the-required-permissions-to-open-the

SonarQube with Jenkins Setup using Docker Images

https://funnelgarden.com/sonarqube-jenkins-docker/  https://medium.com/@hakdogan/an-end-to-end-tutorial-to-continuous-integration-and-con...