Kerberos Double Hop - Installing SQL

Article
1/17/2024

Installing SQL

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

http://4.bp.blogspot.com/_pL7qVUWvLsU/TSBkU1QeAyI/AAAAAAAABaU/alD90OfAiNQ/s640/Win2k3-SQL-2010-12-28-17-32-07.PNG

http://2.bp.blogspot.com/_pL7qVUWvLsU/TSBkV39ftZI/AAAAAAAABaY/5owjAJGHgQU/s640/Win2k3-SQL-2010-12-28-17-32-20.PNG

http://1.bp.blogspot.com/_pL7qVUWvLsU/TSBkWv1RDOI/AAAAAAAABac/h9HqjYLw3uc/s640/Win2k3-SQL-2010-12-28-17-32-33.PNG

http://1.bp.blogspot.com/_pL7qVUWvLsU/TSBkXolD_nI/AAAAAAAABag/3z06t4PvHwI/s640/Win2k3-SQL-2010-12-28-17-32-38.PNG

http://1.bp.blogspot.com/_pL7qVUWvLsU/TSBkYY122YI/AAAAAAAABak/e9uCaDc0w_U/s640/Win2k3-SQL-2010-12-28-17-36-56.PNG

http://4.bp.blogspot.com/_pL7qVUWvLsU/TSBkZCxB77I/AAAAAAAABao/7pcTeZmH3FU/s640/Win2k3-SQL-2010-12-28-17-37-05.PNG

http://4.bp.blogspot.com/_pL7qVUWvLsU/TSBkaMbHhSI/AAAAAAAABas/bnJp9kPF9sU/s640/Win2k3-SQL-2010-12-28-17-37-24.PNG

http://1.bp.blogspot.com/_pL7qVUWvLsU/TSBkbFA0nOI/AAAAAAAABaw/sNT0qyaZk8o/s640/Win2k3-SQL-2010-12-28-17-37-33.PNG

http://2.bp.blogspot.com/_pL7qVUWvLsU/TSBkcHU2-II/AAAAAAAABa0/7L9nx3UwviM/s640/Win2k3-SQL-2010-12-28-17-37-54.PNG

http://3.bp.blogspot.com/_pL7qVUWvLsU/TSBkc69HqtI/AAAAAAAABa4/nePj44PQ1Yw/s640/Win2k3-SQL-2010-12-28-17-38-11.PNG

Choose only the "SQL Server Database Services"...

http://1.bp.blogspot.com/_pL7qVUWvLsU/TSBkdxIag4I/AAAAAAAABa8/wsJEueSxcmQ/s640/Win2k3-SQL-2010-12-28-17-38-23.PNG

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

http://3.bp.blogspot.com/_pL7qVUWvLsU/TSBkeeYIDII/AAAAAAAABbA/WCHmRggu2ac/s640/Win2k3-SQL-2010-12-28-17-38-37.PNG

http://1.bp.blogspot.com/_pL7qVUWvLsU/TSBkfY3gWLI/AAAAAAAABbE/hKnH4DD_2Bk/s640/Win2k3-SQL-2010-12-28-17-38-42.PNG

http://4.bp.blogspot.com/_pL7qVUWvLsU/TSBkgJn_M1I/AAAAAAAABbI/HBLugr5GzCE/s640/Win2k3-SQL-2010-12-28-17-39-05.PNG

http://1.bp.blogspot.com/_pL7qVUWvLsU/TSBkhOa7syI/AAAAAAAABbM/x7j2vGkJv9w/s640/Win2k3-SQL-2010-12-28-17-39-11.PNG

http://1.bp.blogspot.com/_pL7qVUWvLsU/TSBkia5A6vI/AAAAAAAABbQ/sKY7G8LLFIs/s640/Win2k3-SQL-2010-12-28-17-39-38.PNG

http://2.bp.blogspot.com/_pL7qVUWvLsU/TSBkjNN--vI/AAAAAAAABbU/8yVtLVT1OvQ/s640/Win2k3-SQL-2010-12-28-17-39-48.PNG

http://3.bp.blogspot.com/_pL7qVUWvLsU/TSBkjwRaCZI/AAAAAAAABbY/uuSH21tjax4/s640/Win2k3-SQL-2010-12-28-17-39-53.PNG

http://4.bp.blogspot.com/_pL7qVUWvLsU/TSBkk0qu1vI/AAAAAAAABbc/fdIZLl58o_w/s640/Win2k3-SQL-2010-12-28-17-39-59.PNG

http://4.bp.blogspot.com/_pL7qVUWvLsU/TSBkljk0_LI/AAAAAAAABbg/GtlgGENjqEI/s640/Win2k3-SQL-2010-12-28-17-40-05.PNG

http://3.bp.blogspot.com/_pL7qVUWvLsU/TSBkmnPxqNI/AAAAAAAABbk/NEed6RwFxgw/s640/Win2k3-SQL-2010-12-28-17-42-32.PNG

http://1.bp.blogspot.com/_pL7qVUWvLsU/TSBkni6Q4dI/AAAAAAAABbo/oZVMQw-InjI/s640/Win2k3-SQL-2010-12-28-17-42-40.PNG

http://2.bp.blogspot.com/_pL7qVUWvLsU/TSBkpHuLaZI/AAAAAAAABbs/M9505MZFG48/s640/Win2k3-SQL-2010-12-28-17-42-41.png

http://4.bp.blogspot.com/_pL7qVUWvLsU/TSBkqecrjZI/AAAAAAAABbw/qhp9aJqGmjw/s640/Win2k3-SQL-2010-12-28-17-44-00.PNG

SQL Services running with the SQL_Admin Account

Also, do note the name of the SQL Instance (default) - MSSQLSERVER

http://1.bp.blogspot.com/_pL7qVUWvLsU/TSBkriGEWXI/AAAAAAAABb0/5A8zNaHfsbI/s640/Win2k3-SQL-2010-12-28-17-44-30.PNG

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"

http://4.bp.blogspot.com/_pL7qVUWvLsU/TSBktLQnwgI/AAAAAAAABb4/beT4qiE9ALk/s640/Win2k3-SQL-2010-12-28-17-44-42.PNG

http://3.bp.blogspot.com/_pL7qVUWvLsU/TSBkueSCPyI/AAAAAAAABb8/FuUbPeD2b4w/s640/Win2k3-SQL-2010-12-28-17-45-10.PNG

http://3.bp.blogspot.com/_pL7qVUWvLsU/TSBkvS-nb2I/AAAAAAAABcA/25gGrsQ6Zvg/s640/Win2k3-SQL-2010-12-28-17-45-16.PNG

http://4.bp.blogspot.com/_pL7qVUWvLsU/TSBkw4XhMlI/AAAAAAAABcE/hOrQNCf6hYQ/s640/Win2k3-SQL-2010-12-28-17-45-29.PNG

http://2.bp.blogspot.com/_pL7qVUWvLsU/TSBkx9ojxeI/AAAAAAAABcI/XVxGPMNOTgU/s640/Win2k3-SQL-2010-12-28-17-45-40.PNG

http://3.bp.blogspot.com/_pL7qVUWvLsU/TSBky7f8OyI/AAAAAAAABcM/7wi5AoO209g/s640/Win2k3-SQL-2010-12-28-17-45-49.PNG

http://1.bp.blogspot.com/_pL7qVUWvLsU/TSBkz9gChbI/AAAAAAAABcQ/0bocI6M6bqE/s640/Win2k3-SQL-2010-12-28-17-46-37.PNG

http://4.bp.blogspot.com/_pL7qVUWvLsU/TSBk1GhIdHI/AAAAAAAABcU/ezdvIlD-yTs/s640/Win2k3-SQL-2010-12-28-17-46-38.png

http://3.bp.blogspot.com/_pL7qVUWvLsU/TSBk2d7TtnI/AAAAAAAABcY/SzcrQHjgXFs/s640/Win2k3-SQL-2010-12-28-17-47-56.PNG

http://1.bp.blogspot.com/_pL7qVUWvLsU/TSBk3usYmiI/AAAAAAAABcc/x49xiNtsDxA/s640/Win2k3-SQL-2010-12-28-17-48-44.PNG

Choose the "SQL_Admin" Account to connect to the SQL Server

http://2.bp.blogspot.com/_pL7qVUWvLsU/TSBk41DKtoI/AAAAAAAABcg/K55xw5aCIhQ/s640/Win2k3-SQL-2010-12-28-17-51-42.PNG