SharePoint is considered to be a Front End Server, It does not stores any data, It just fetches the data from SQL. SQL is a Back End Server which stores the SharePoint Database - Configuration and Content
While Installing SharePoint, we do have an option to Install the default "Embedded SQL Server 2005 Express" or you can install a full version of SQL and then connect the SharePoint to that SQL Server
In this lab, we will Install SQL Enterprise 2005
* Make sure you are logged on to a Windows 2003 Member Server (domain login) with "SQL_Admin" Account
Choose only the "SQL Server Database Services"...
Instance: A Name given to the SQL which will be used to connect to It. You can have multiple instances of SQL running on the same server. Different applications will use different instances to connect to the same SQL Server
SQL Services running with the SQL_Admin Account
Also, do note the name of the SQL Instance (default) - MSSQLSERVER
The SQL Installed above has only one Snap-In - SQL Server Configuration Manager. It can be used to do basic configuration of the SQL Server. To manage the SQL Server completely, we need to install the "SQL Server Management Studio Express"
Choose the "SQL_Admin" Account to connect to the SQL Server
Expanded View...
