Technics:Microsoft SQL Server: Difference between revisions
From CoPlanner 11
Jump to navigationJump to search
No edit summary |
No edit summary |
||
| (9 intermediate revisions by the same user not shown) | |||
| Line 2: | Line 2: | ||
===General Information=== | ===General Information=== | ||
An overview about all SQL Server versions from 7.0 including service packs and other intermediate releases as well as download links is available at http://sqlserverbuilds.blogspot.com. | An overview about all SQL Server versions from 7.0 including service packs and other intermediate releases as well as download links is available at http://sqlserverbuilds.blogspot.com. The Microsoft SQL Server is required for the [[Technics:CoPlanner-Server|CoPlanner Server]]. | ||
===Enable xp_cmdshell=== | ===Enable xp_cmdshell=== | ||
| Line 19: | Line 19: | ||
More information at http://msdn.microsoft.com/en-us/library/ms175046.aspx. | More information at http://msdn.microsoft.com/en-us/library/ms175046.aspx. | ||
===Microsoft SQL Server | ===Microsoft SQL Server 2012 / 2014 / 2016 / 2017=== | ||
The ''xp_cmdshell'' option can be enabled via Facets (context menu on the SQL Server node in SQL Server Mangement Studio): | The ''xp_cmdshell'' option can be enabled via Facets (context menu on the SQL Server node in SQL Server Mangement Studio): | ||
| Line 47: | Line 41: | ||
</source> | </source> | ||
==Business Intelligence Development Studio | ==Business Intelligence Development Studio Installation== | ||
This chapter describes the installation of Business Intelligence Development Studio on the client computer and the majority of them are for a rewiring within the installation on the server. The Business Intelligence Development Studio belongs to the workstation components and will be installed with the SQL Server Setup. | |||
{| {{Bausteindesign1}} | {| {{Bausteindesign1}} | ||
|- | |- | ||
| <span style="color: darkblue;">''' | | <span style="color: darkblue;">'''Hint'''</span> After installing you have to install the right service pack. This is also responsible for the workstation components. | ||
|} | |} | ||
| Line 58: | Line 52: | ||
{| {{Bausteindesign1}} | {| {{Bausteindesign1}} | ||
|- | |- | ||
| <span style="color: darkblue;">''' | | <span style="color: darkblue;">'''Hint'''</span> The Business Intelligence Development Studio is an adapt Visual Studio. If necessary, Visual Studio update is a separate service pack. The SQL server service pack refreshes only the BI-components. | ||
|} | |} | ||
===Microsoft SQL Server | ===Microsoft SQL Server=== | ||
After confirming EULA, additional setup files will be installed. Afterwards setup scans the configuration of the computer. Confirm the welcome screen with next. You can ignore the warnings of the system configuration check, if they are important for a server installation. At components to install, please choose ''workstation components, online documentation and development tools''. | |||
[[Image:T_Auswahl der zu installierenden Komponenten (SQL Server 2005 Setup) .jpg|thumb|center|Technics, Selection of components to install (SQL Server 2005 Setup) ]] | |||
With the button ''extended'' xou can choose the components to install in detail. | |||
[[Image:T_Featureauswahl (SQL Server 2005 Setup).jpg|thumb|center|Technics, Selection(SQL Server 2005 Setup)]] | |||
You can drop the online documentation, because it is like the MSDN documentation. | |||
You will finish the setup with ''Next''. Please don't forget the service packs. | |||
__NOEDITSECTION__ | __NOEDITSECTION__ | ||
| Line 96: | Line 74: | ||
[[Category:Technics|Microsoft SQL Server]] | [[Category:Technics|Microsoft SQL Server]] | ||
[[de:Technik: | [[de:Technik:Microsoft_SQL_Server]] | ||
Latest revision as of 09:26, 10 July 2019
Microsoft SQL Server
General Information
An overview about all SQL Server versions from 7.0 including service packs and other intermediate releases as well as download links is available at http://sqlserverbuilds.blogspot.com. The Microsoft SQL Server is required for the CoPlanner Server.
Enable xp_cmdshell
The Windows process spawned by xp_cmdshell has the same security rights as the SQL Server service account.
When it is called by a user that is not a member of the sysadmin fixed server role, xp_cmdshell connects to Windows by using the account name and password stored in the credential named ##xp_cmdshell_proxy_account##. If this proxy credential does not exist, xp_cmdshell will fail.
The proxy account credential can be created by executing sp_xp_cmdshell_proxy_account:
EXEC sp_xp_cmdshell_proxy_account 'DOMAIN\UserName','password'This user must have the rights for executing xp_cmdshell:
GRANT EXECUTE on xp_cmdshell to [DOMAIN\UserName]More information at http://msdn.microsoft.com/en-us/library/ms175046.aspx.
Microsoft SQL Server 2012 / 2014 / 2016 / 2017
The xp_cmdshell option can be enabled via Facets (context menu on the SQL Server node in SQL Server Mangement Studio):
.jpg)
Using stored procedures
-- To allow advanced options to be changed.
EXEC sp_configure 'show advanced options', 1
GO
-- To update the currently configured value for advanced options.
RECONFIGURE
GO
-- To enable the feature.
EXEC sp_configure 'xp_cmdshell', 1
GO
-- To update the currently configured value for this feature.
RECONFIGURE
GOBusiness Intelligence Development Studio Installation
This chapter describes the installation of Business Intelligence Development Studio on the client computer and the majority of them are for a rewiring within the installation on the server. The Business Intelligence Development Studio belongs to the workstation components and will be installed with the SQL Server Setup.
| Hint After installing you have to install the right service pack. This is also responsible for the workstation components. |
| Hint The Business Intelligence Development Studio is an adapt Visual Studio. If necessary, Visual Studio update is a separate service pack. The SQL server service pack refreshes only the BI-components. |
Microsoft SQL Server
After confirming EULA, additional setup files will be installed. Afterwards setup scans the configuration of the computer. Confirm the welcome screen with next. You can ignore the warnings of the system configuration check, if they are important for a server installation. At components to install, please choose workstation components, online documentation and development tools.
_.jpg)
With the button extended xou can choose the components to install in detail.
.jpg)
You can drop the online documentation, because it is like the MSDN documentation.
You will finish the setup with Next. Please don't forget the service packs.
