Common #SQLServer Ports

Below is the most common ports for SQL Server services that may yon need

Description Port
SQL Server default instance port 1433
Dedicated Admin Connection port 1434
SQL Server Service Broker port 4022
Transact-SQL Debugger/RPC 135
Endpoint port communication AlwaysOn port 5022
AlwaysOn Listener port 60173
SQL Server Analysis Services 2383
SQL Server Browser Services 1434 [UDP]

Virtualizing SQL Server in SharePoint 2010 Farm is not Recommended

The database server is responsible for storing, maintaining, and fetching data for other server components and services.

Virtualization of the database server is not recommended. Reasons to avoid virtualizing the database server are as follows:

  • Virtualization introduces latency downstream in the application and UI server components of a SharePoint farm. If every data request takes more time, the scenario quickly becomes a challenge, especially when a single transaction needs multiple round trips for completion.
  • The database server experiences heavy CPU, memory, disk I/O, and NIC usage.
  • If overall performance evaluation or virtual machines are not adequately specified, end users may experience slower response times and, in background processes, slower performance of long-running operations, which can increase operation timeouts.

for more details, visit this link  [Page 24]

Error after Upgrading From SharePoint 2010 to SharePoint 2013 Preview

I followed the following steps to upgrad my SharePoint 2010 web application to SharePoint 2013 Preview:

  1. Backup SharePoint 2010 Content DB
  2. Restore it on SharePoint 2013 Preview SQL server 2012
  3. Run the command Mount-SPContentDatabase from PowerShell
  4. Browse my web application
  5. I found the following error

The context has expired and can no longer be used. (Exception from HRESULT: 0x80090317)



After that everything workfine.

Make SiteCollection ReadOnly

Some times you need to set your sitecollection(s) as read-only, for example, before backup.

Via Central Admin:

  1. Go to Centeral Admin
  2. Application Management
  3. Site Collection Quotas and Locks
  4. Read-only (blocks additions, updates, and deletions)

Solution 2:
Using SQL Server Database by setting the database as read-only.

  1. Open SQL Server Management Studio
  2. Right click on your site collection database and choose Properties
  3. Click on Options