00197712-01_IM_SUPPORT_MEDIA_2.0_EN.pdf - 第30页
Support Media 2.0 12/2014 Edition 30 We don’t recom mend trying uninstalling exi sting Microsoft SQL v ersions - Mi crosoft SQL Setups may lea ve share d components w hen uninstalling, which can cause subse q uent Micros…
Support Media 2.0 12/2014 Edition
29
1) Customers:
The first question you have to answer is:
Where does my Microsoft SQL Server license and installation come from?
If you got your Microsoft SQL Server installation and license by SIPLACE, we will also
have an internal version of Support Media which includes Microsoft SQL Server service
pack updates and use this version of Support Media to upgrade the Microsoft SQL Server
Installation to the latest supported by your purchased SIPLACE Products.
If you have an own Microsoft SQL Server license and installation, you have the
responsibility to install and maintain your Microsoft SQL Server by yourself. In this case,
use Prerequisite Analyzer from Support Media on your already installed Microsoft SQL
Server, select the SIPLACE Products you plan to use and Prerequisite Analyzer will show
you if it requires upgrading your Microsoft SQL Server installation to a newer version.
Unfortunately, in cases where upgrades are required, we are not allowed to deliver the
updates for your SQL Server directly. So, in this case, Prerequisite Analyzer will show you
the required Microsoft SQL service pack version but abort installation with an “Unavailable
Installation Packages” message as answered in the question above. You may contact
SIPLACE support if you have problems retrieving or installation the required Microsoft
SQL Server update. After you updated your Microsoft SQL Server to the required version,
you may continue preparing your computer for the SIPLACE Products you purchased.
2) SIPLACE personnel preparing computer with SQL license sold by SIPLACE:
First, you should install SQL Server Prerequisites using Prerequisite Analyzer from
Support Media with the appropriate “SQL Server Prerequisites” profile in the Profile Group
“SIPLACE Net”. Then, install the Microsoft SQL Server Edition we sell to the customer. At
last, use Prerequisite Analyzer to complete the preparation for your SIPLACE Line
Software. In the last step, Prerequisite Analyzer will detect already installed Microsoft SQL
Server and not try to install Microsoft SQL Express. Additionally, if you use our internal
variant of Support Media including all packages, Prerequisite Analyzer will upgrade the
Microsoft SQL Server installation to the latest service pack compatible with chosen
product versions.
You should read our documentation on the Support Media for manual installation of the
Microsoft SQL Server version. It describes how to prepare for and install Microsoft SQL
Server using the settings required for SIPLACE Products.
3) SIPLACE personnel supporting computer with Microsoft SQL license from the
customer:
In this case, the customer (or his IT) is responsible for maintaining his Microsoft SQL
Server installation. You may use Prerequisite Analyzer from Support Media to find out if
upgrading to a newer Microsoft SQL Service Pack is required. Since we are not allowed to
distribute the Microsoft SQL Service Pack for this license, the customer has to
download/install the required Microsoft SQL Service Pack by himself – maybe with our
help.
I’ve already used Support Media Prerequisite Analyzer and accidently installed
Microsoft SQL Express, but I want to install Microsoft SQL Server. What should I
do?
If it is affordable, we recommend performing a fresh setup of your computer with a new
operating system installation and then beginning with Microsoft SQL Server installation as
documented. If this would be too time-consuming, we recommend additionally installing
Microsoft SQL Server using the appropriate documentation on Support Media and then re-
applying Prerequisite Analyzer to upgrade to the latest compatible service pack.
Support Media 2.0 12/2014 Edition
30
We don’t recommend trying uninstalling existing Microsoft SQL versions - Microsoft SQL
Setups may leave shared components when uninstalling, which can cause subsequent
Microsoft SQL setups to fail.
Support Media 2.0 12/2014 Edition
31
5 Appendix
5.1 Firewall Rules
This chapter contains the firewall rules configured by the SIPLACE Line Level Software products.
All documented rules are listing the ports for informational purpose. These are not part of the firewall rules which will be created, except the rules which are
marked with “Port” in the first column.
Additionally, only inbound rules will be created in Product Setups.
5.1.1 SIPLACE Support Media
Depending of the product which will be installed, the Support Media will activate the appropriate Microsoft Windows features and corresponding firewall rules.
When the name resolution of NetBIOS is required in a workgroup mode, the file and printer sharing will be activated.
Rules
Name Of The Rule
Path
Service
Name
Direction
Protocol(s)
Ports
Purpose
Message Queuing
Built-in rule
Message Queuing
TCP Inbound
%SYSTEMROOT%
\SYSTEM32\mqsvc
.exe
N/A
Inbound
TCP
All
Message Queuing TCP Inbound
Message Queuing
Built-in rule
Message Queuing
UDP Inbound
%SYSTEMROOT%
\SYSTEM32\mqsvc
.exe
N/A
Inbound
UDP
All
Message Queuing UDP Inbound
Message Queuing
Built-in rule
Message Queuing
TCP Outbound
%SYSTEMROOT%
\SYSTEM32\mqsvc
.exe
N/A
Outbound
TCP
All
Message Queuing TCP Outbound
Message Queuing
Built-in rule
Message Queuing
UDP Inbound
%SYSTEMROOT%
\SYSTEM32\mqsvc
.exe
N/A
Outbound
UDP
All
Message Queuing UDP Outbound
Built-in rule
File and Printer
Sharing (Echo
Request - ICMPv4-In)
N/A
N/A
N/A
N/A
N/A
Built-in rule for File and Printer
Sharing and NetBIOS name
resolution