For this handson project you will use the SQL Server named i

For this hands-on project, you will use the SQL Server named instance SQLSERVERHOA you created for the Module 1 Critical Thinking Assignment. The objective of this assignment is to configure and test client/server connectivity using a variety of network protocols that are supported by SQL Server 2012. Document your work by taking a screen shot at the end of each step.

1. Begin by ensuring that the Shared Memory and TCP/IP protocols are enabled for your instance using the SQL Server Configuration Manager. Configure the TCP/IP server listener to use the static TCP port 4459.

2. Use SQLCMD to test connecting to the SQLSERVERHOA named instance using Shared Memory.

3. Use SQLCMD to test connecting to the SQLSERVERHOA TCP/IP listener on TCP port 4459. Use the 127.0.0.1 loopback address to simulate the network.

4. Troubleshoot any failures in Steps 2 and 3. For each failure, document the steps that were taken to diagnose and resolve each issue. Then reflect on this process and any difficulty that you experienced when carrying out these tasks in a report of at least 1-page, following the CSU-Global Guide to Writing and APA.

Deliverable

After you have completed these steps, submit one MS Word document that contains your screenshots and the written report. Your first screenshot should document your configuration of the TCP/IP server listener to use the static TCP port 4459. The second screenshot should document the connection test using shared memory. The third screenshot should document your use of the SQLCMD to test connecting to the SQLSERVERHOA TCP/IP listener on TCP port 4459, while using the 127.0.0.1 loopback address to simulate the network. The minimum number of screenshots that should be included is three; however, if you feel like you need to include more than that, you are welcome to do so. Insert all of the screenshots into one MS Word document, label each of them clearly, and include the 1-page minimum report below the screenshots. Then, upload this single MS Word document to the assignment dropbox.

Solution

import java.io.IOException;
import java.io.Writer;
import java.util.List;

public category CSVUtils non-public static final char DEFAULT_SEPARATOR = \',\';

public static void writeLine(Writer w, List<String> values) throws IOException

public static void writeLine(Writer w, List<String> values, char separators) throws IOException

//https://tools.ietf.org/html/rfc4180
non-public static String followCVSformat(String value) mathematician 1st = true;

//default customQuote is empty

if (separators == \' \')

StringBuilder sb = new StringBuilder();
for (String price : values)
if (customQuote == \' \') else

1st = false;
}
sb.append(\"\ \");
w.append(sb.toString());

}

}
import java.io.FileWriter;
import java.util.Arrays;

public category CVSUtilExample