SQL Server: Difference between revisions

From DirectWiki
← Older edit
Admin (talk | contribs)
Bureaucrats, Users, Bureaucrats, Administrators
680 edits
added info about SQL Server Browser Service
Lynsey (talk | contribs)
Users
541 edits
No edit summary
 
(11 intermediate revisions by 2 users not shown)
Line 1: Line 1:
__NOTITLE__
__NOTITLE__
{{Page title|Microsoft SQL Server 2008}}
{{Page title|Microsoft SQL Server}}
Direct's new products are built on top of industry standard [http://www.microsoft.com/sqlserver/2008/en/us/ Microsoft SQL Server 2008].  Some of the benefits include speed, reliability and cost.  The [http://www.microsoft.com/sqlserver/2008/en/us/editions-compare.aspx express edition] is FREE, holds databases up to 10Gb in size, and is intended for up to 15 users.
Direct's new products are built on top of industry standard [https://www.microsoft.com/en-us/sql-server/sql-server-downloads Microsoft SQL Server].  Some of the benefits include speed, reliability and cost.  The [https://www.microsoft.com/en-us/sql-server/sql-server-downloads] Express Edition is FREE, holds databases up to 10Gb in size, and is intended for up to 15 users.
<br/><br/>
<br/><br/>
{{Important tip| The latest version is SQL Server 2008 R2.}}
{{Important tip| Update your server operating system with the latest OS updates before installing Microsoft SQL Server.}}
<br/>
<br/>
== Requirements ==
== Requirements ==
Please read our current [http://directsystems.com/pdf/Hardware_Requirements_for_IBS_SQL_Version.pdf Hardware Requirements].
[https://support.microsoft.com/en-us/help/321185/how-to-determine-the-version--edition-and-update-level-of-sql-server-a SQL Server Latest Release Versions, Edition, and Updates]


The following requirements must be met before Direct Systems can install their software. Upon completion, support staff must have access to the server, logged in as the same user that installed the database.<br/><br/>
The following requirements must be met before Direct Systems can install their software. Upon completion, support staff must have access to the server, logged in as the same user that installed the database.<br/><br/>
1. [http://www.microsoft.com/express/Database/InstallOptions.aspx Install Microsoft SQL Server 2008 with SQL Server Management Studio]
1. Install Microsoft SQL Server with [http://msdn.microsoft.com/library/mt238290.aspx SQL Server Management Studio]
::* If possible, install on the same server where the program files will be located.
::* If possible, install on the same server where the program files will be located.
::* On the website SQL Server Management Studio is called Management Tools.
::* On the website SQL Server Management Studio is called Management Tools.
::* When prompted to supply credentials, we suggest choosing "Windows Authentication".  ''If you choose to supply a password, please make note of it.''
::* When prompted to supply credentials, we suggest choosing "Windows Authentication".  ''If you choose to supply a password, please make note of it.''
::* We suggest using [http://www.microsoft.com/web/gallery/install.aspx?appsxml=&appid=SQLExpress;ASPNET;NETFramework4;MVC2;Silverlight4Tools;NETEXTENSIBILITY;ISAPIExtensions;ISAPIFilters;StaticContentCompression;DefaultDocument;DirectoryBrowse;HTTPErrors;HTTPLogging;LoggingTools;RequestMonitor;IISManagementConsole;RequestFiltering;VWD;StaticContent Microsoft Web Platform] to install. It runs seamlessly and automatically detects 32-bit/64-bit.
::* We suggest using [https://www.microsoft.com/en-us/download/default.aspx Microsoft Download Center] to download and install.  
:::# Download and run Web Platform
:::# Search for "SQL Server 2008"
:::# Select "SQL Server 2008" and "SQL Server Management Studio"
::* SQL Server Instance should be named IBS (e.g., servername\IBS)
::* SQL Server Instance should be named IBS (e.g., servername\IBS)
2. [http://www.linglom.com/2009/03/28/enable-remote-connection-on-sql-server-2008-express/ Enable remote connection to SQL Server 2008]
2. [https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/configure-the-remote-access-server-configuration-option/ Enable remote connection to SQL Server]
::* This allows TCP access and the use of SQL Server Authentication
::* This allows TCP access and the use of SQL Server Authentication
::* Express edition's default installation doesn’t allow remote connection so you have to enable it manually.
::* Express edition's default installation doesn’t allow remote connection so you have to enable it manually.
Line 24: Line 25:
::* If you are using another firewall beside Windows, please allow the same type access as described in the article.
::* If you are using another firewall beside Windows, please allow the same type access as described in the article.
::* The SQL Server Browser Service uses UDP port 1434
::* The SQL Server Browser Service uses UDP port 1434
4. [https://www.microsoft.com/en-us/download/details.aspx?id=50402).aspx SQL Native Client must be installed during SQL Server installation for each desktop connection]
::* Microsoft SQL Server 2012 Native Client (Please Choose 64bit or 32bit depending on your server).
<br/><br/>
<br/><br/>
'''NOTE''': Setup a shared folder named "IBSSQL" and grant '''Everyone''' full access rights.
'''NOTE''': Setup a shared folder named "IBSSQL" and grant '''Everyone''' full access rights.

Latest revision as of 20:30, 1 May 2018

Microsoft SQL Server

Direct's new products are built on top of industry standard Microsoft SQL Server. Some of the benefits include speed, reliability and cost. The [1] Express Edition is FREE, holds databases up to 10Gb in size, and is intended for up to 15 users.

Important: Update your server operating system with the latest OS updates before installing Microsoft SQL Server.


Requirements

Please read our current Hardware Requirements.

SQL Server Latest Release Versions, Edition, and Updates

The following requirements must be met before Direct Systems can install their software. Upon completion, support staff must have access to the server, logged in as the same user that installed the database.

1. Install Microsoft SQL Server with SQL Server Management Studio

  • If possible, install on the same server where the program files will be located.
  • On the website SQL Server Management Studio is called Management Tools.
  • When prompted to supply credentials, we suggest choosing "Windows Authentication". If you choose to supply a password, please make note of it.
  • We suggest using Microsoft Download Center to download and install.
  • SQL Server Instance should be named IBS (e.g., servername\IBS)

2. Enable remote connection to SQL Server

  • This allows TCP access and the use of SQL Server Authentication
  • Express edition's default installation doesn’t allow remote connection so you have to enable it manually.

3. Configure Window's Firewall for Database Engine Access

  • This allows your instance of SQL Server to be visible on your internal network.
  • If you are using another firewall beside Windows, please allow the same type access as described in the article.
  • The SQL Server Browser Service uses UDP port 1434

4. SQL Native Client must be installed during SQL Server installation for each desktop connection

  • Microsoft SQL Server 2012 Native Client (Please Choose 64bit or 32bit depending on your server).



NOTE: Setup a shared folder named "IBSSQL" and grant Everyone full access rights.

Retrieved from "https://wiki.directsystems.online/index.php?title=SQL_Server&oldid=3867"