 and install your software successfully. This is not a SQL Server specific error so you can get it while installing any software/tool on SUSE Linux.
Before going ahead, you need to have a SUSE Linux server with SQL Server vNext installed on that machine. Now let's start the SQL Server tools installation on SUSE Linux box.
I connected to the target SUSE Linux server using PuTTY as shown in the below screen shot. I entered the login name as manvendra followed by the password to make a successful connection.
You can see that I have made a successful connection to this SUSE Linux server where I installed SQL Server. Now let's check and verify the SQL Server installation on this machine. Run the below command to check the mssql-server service. Now I will check and validate whether SQL Server is installed on this Linux machine or not by checking this service. We can see the service status is shown as enabled and active (i.e. running) which is highlighted in green which means SQL Server is installed and running fine on this server.
Next we will install the SQL Server tools on this server. Before going ahead we can verify whether the tools are installed on this machine or not. You can type sqlcmd and press enter, if you will get details about this utility that means this tool is already on the server. I did this and you can see sqlcmd is not recognized by SUSE Linux, so the next step is to install it on this machine.
You can see that the command has been executed successfully. Now execute the below command to refresh the keys.
Now our next step is to install the SQL Server tools with the unixODBC developer package on this box by using this zypper command.
Once execution has started, it will read the package list followed by checking the dependencies. It will display the name of target packages which will be installed along with this installation. Now it will ask you to choose yes or no to proceed with the installation. Type y to choose yes. Once you enter y and press enter the download process for all required packages should begin. Unfortunately, we received the error below after entering y as shown in the below picture.
The prompt suggests you insert the correct medium for the given repository and type y to proceed or n to cancel. I typed n to cancel this setup because the installation medium is already in the package repository as we have checked in the above steps. Once you enter no to cancel the operation you will be get the below error details.
I researched this issue and found the solution. The solution is to disable the given repository "SLES12-SP2-12.2-0". We can see its status is shown as "Enabled" in the 4th image of step 3. We need to open the software repositories window on the SUSE Linux server to get this done.
I logged into the SUSE Linux server locally in GUI mode and clicked on "Applications" as shown in the below screenshot. Once you click on the "Applications" button you will get a number of options to choose. Click on the "Terminal" option to launch the Administrator settings window.
Once you click on the "Terminal" option, it will ask you to enter the root password. Enter the root password and press the Continue button to proceed.
Once your root password is authenticated, the "Administrator Settings" window will appear on your screen as shown in the below image. You can see there is shortcut for software repositories in first row of this window. Click on this option to launch the software repositories.
Once you click on "Software Repositories", a window name "YaST2" will appear on your screen as shown in the below image. YaST is a powerful installation and configuration tool for SUSE Linux. You can see all the software devices and their details in this window.
Now click on 3rd line as shown in the above image. This is where we are getting the error about the CD. If you look at the error image it is saying to insert medium for "SLES12-SP2-12.2-0" and the error details contain the same path and device details which is highlighted in the red box below.
You can see this repository/device is marked as enabled in the above image. This has to be unchecked and disabled to fix this issue. Please uncheck the "Enabled" as shown below to proceed.
Click the OK button to apply this change and close this window. If you do not click on the OK button then you will get the below error while installing the SQL Server tools.
System management is locked by the application with pid 50217 (/usr/lib/YaST2/bin/y2base).
Now go ahead and install the SQL Server Tools again. This time you will be able to install it successfully as shown in the below image.
Once the SQL Server Tools are installed you can validate the installation by running sqlcmd in at the command prompt. If sqlcmd displays the details for the utility that means this has been installed successfully.
We can see that now sqlcmd command is recognized by the SUSE Linux server and the output of this command shows that sqlcmd is installed and ready for use.
Go ahead and make database connections on SUSE Linux server and get more exposure on this new product of SQL Server.
Check out all of the SQL Server on Linux Tips.Two more agencies have joined the effort to sort out who controls the county liquor board.
For the first time, the county Office of Law has been asked to step in, and the state Comptroller's Office will ask the attorney general for help to resolve the growing dispute.
Board Administrator Judy Hagner and board attorney Harry Blumenthal appeared before the County Council Tuesday to discuss its budget proposal.
Most of the testimony revolved around an increase in the board's fees for contractual attorney Sara Arthur, which could more than double to $120,000 by June 30 if the council approves an extra $70,000 for her work.
Blumenthal, who has been the board's part time staff attorney for decades, said this was the first time he has ever appeared before the council on a budget matter.
Blumenthal said between approval from the state Comptroller's Office and recent requests from the County Council and County Executive Steve Schuh it is unclear who has final say over the board's budget.
"We're not quite certain who really tells us what we should be doing and how we should be doing it," Blumenthal told the panel.
Jeffrey Kelly, who approves the liquor board's budget for the comptroller as the director of the field enforcement, said he received a request from the board for clarification on language in his letters approving the budget that it is "subject to available funding."
Kelly said the reason for the language is because the county ultimately appropriates the funds. Kelly said the board's latest reqeust to clarify the language would be sent to the state attorney general this week.
Getting the Office of Law involved would present issues over conflicts of interest, Blumenthal said, because the office also advises the council and county executive, considered competing county agencies.
But County Attorney Nancy Duden has provided a legal opinion to county officials that determined the board is not allowed under state law to pay for services outside what the county can provide.
Blumenthal said the board was not given the memo because it was considered covered by attorney-client privilege.
Duden wrote the memo at the request of County Auditor Teresa Sutherland, who said at the meeting Duden wrote the board could not bill for services outside what the county could provide under the state's liquor laws. The board has had contractual attorneys from as far back as 2002.
Sutherland said the only one who requested that memo was Arthur. Had she asked Sutherland, the county auditor said, she would have provided it. Sutherland ended up giving a copy of the memo to Blumenthal during the meeting.
The board's testimony came after several hours of testimony on the budget of 10 other county agencies that stretched to nearly 6 hours.
When Council Chairman Jerry Walker saw the liquor board was last on the schedule, he said he "flinched."
"I gotta wonder, are we getting charged for her presence here today?" Walker asked as Arthur sat in the crowd.
Councilman Michael Peroutka, a retired lawyer, said he agreed the county Office of Law could not represent all of agencies because of conflicted interests.
"As an attorney, I can't be for you and against you at the same time," Peroutka said.
Duden said in an interview after the meeting the office has a policy of not revealing requests between the executive and legislative branches and that attorney-client privilege applies even if a county agency requests an opinion that is rendered specifically to it but was requested by someone outside that agency.
Duden said the office would have no issue taking on the liquor board's legal work. She said she received an email from Arthur asking for the memo but could not disclose it to the contractual attorney because only Sutherland, as the client, has the power to release the information.
Duden said this is the first time the county's law office has been asked to step in regarding the liquor board.
The complete details of Arthur's legal fees are unclear. Some of her charges include litigation in Circuit Court for appeals of liquor licenses the board has denied, according to a document drawn up by Sutherland.
Other charges included $2,800 for her work on an ethics commission investigation into the board, $3,500 labeled "legislation" from June 2013 to December 2014 and $1,700 for "newspaper inquiries" made over three months in early 2014.
Arthur told the council previously that she charges the board $200 per hour. The board has not revealed details of her services.