Tag / SQL Server Alias



SharePoint 2010 Installation Part 2 - Install SQL

Date: 10 Feb 2010 | 4 Comments | Tags: ,,,,, | 2008,2008 R2,SharePoint 2010,SQL,SQL 2008,Windows Server | 
4

http://www.sharepointassist.com/2010/02/04/sharepoint-2010-installation-part-1-server-build/ http://www.sharepointassist.com/2010/02/10/sharepoint-2010-installation-part-2-install-sql/ (YOU ARE HERE) http://www.sharepointassist.com/2010/02/11/sharepoint-2010-installation-part-3-install-sharepoint/ This article describes the installation process for a SQL server on an all-in-one SharePoint 2010 development server. If you didn't follow Part 1 of the SharePoint 2010 Installation series you'll need to create a SQL service account to support the SQL Server 2008. While there are many...



Configure a SQL Server Alias for Sharepoint (SQL Server 2008)

Date: 02 Feb 2010 | 9 Comments | Tags: ,,,,,, | 2008,MOSS,SharePoint 2010,SQL,Windows Server | 
9

A SQL Server alias is a tidy way to protect yourself from configuration changes in a SharePoint farm. Anybody who works with SharePoint on a regular basis knows that it is very difficult to move SharePoint to a different SQL Server. When disaster strikes wouldn't it be nice if you could simply change SQL Server that SharePoint references? To do so, install the SQL client access tools on each server and create a SQL Alias in SQL Server Configuration Manager, from there your SharePoint Server can be re-homed with little effort. Note, there are two methods to create a SQL Server alias, one for machines...