Hot File

Connecting SQL Server 2012 Express from SharePoint 2013 Configuration Wizard

View: 871    Dowload: 0   Comment: 0   Post by: hanhga  
Author: none   Category: SQL Server   Fields: Computers - Technology

0 point/1 review File has been tested

This article is intended to provide resolution/suggestion in case you face problem while connecting to SQL Server 2012 Express edition (installed on Windows Server 2008 R2) either through SharePoint or SQL Server Management Tool (from other server) or Source Code or anywhere else. I want to emphasize here this problem may not be specific to any version (of OS, SQL, MOSS,...), so resolution suggested here could be generalized.

Introduction

Background

Recently I was installing SQL Server 2012 Express and SharePoint 2013 Preview on Windows Server 2008 R2. During configuration of new SharePoint farm, I supplied the SQL Server Name, SharePoint Config DB Name and Credential to connect the SQL Server and to proceed further. Somehow I was not able to connect SQL Server from SharePoint Configuration Wizard.

Resolution Steps

There could be multiple reasons why user may not be able to connect SQL Server from remote application(s). I have observed below are the common points could be possible reasons behind the connectivity issue:

  1. Check 'Windows Firewall' setting under Control Panel
  2. Check 'TCP/IP' status under SQL Server Configuration Manager
  3. Check 'Net Logon' status under Services Control

1. Check 'Windows Firewall' setting under Control Panel

Windows Firewall is a software component of Microsoft Windows that provides firewalling and packet filtering functions. It helps protect your network from hackers and malicious software.

Go to Control Panel and click on Windows Firewall. Check whether firewall is turned On or Off. You can turn Off the firewall to resolve the issue, but it can be suitable only for development purpose as firewall cannot be turned off in the production server.

So keep your firewall On and create an inbound rule to allow SQL port to be connected from remote applications. For this follow these steps:

  • Go to Advanced Settings of Windows Firewall
  • Select Inbound Rules from the left pane
  • Click on New Rule... from the right pane
  • Select Port under Rule Type step and click Next
  • Select TCP and give Specific local ports (under which your SQL instance is running, by default it will be 1433) under Protocol and Ports step and click Next
  • Select Allow the connection under Action step and click Next
  • Keep ALL check box selected under Profile step and click Next
  • Give Name and Description under Name step and click Finish

2. Check 'TCP/IP' status under SQL Server Configuration Manager

SQL Server 2012 Express and Developer Edition do not allow remote connections by default. TCP/IP should be enabled for remote connection. To do so, follow bellow steps:

  • Expand Configuration Tools from Microsoft SQL Server 2012
  • Open SQL Server Configuration Manager
  • Expand SQL Server Network Configuration
  • Click Protocols for <Instance Name>
  • Right-click TCP/IP and then click Enable from the right pane
  • The icon for the protocol will change to show that the protocol is enabled

3. Check 'Net Logon' status under Services Control

Net Logon maintains a secure channel between this computer and the domain controller for authenticating users and services. If this service is stopped, the computer may not authenticate users and services.

Go to Run command window and type services.msc. Look for Netlogon service. If the service is stopped, Start the service.

Connecting SQL Server 2012 Express from SharePoint 2013 Configuration Wizard

Connecting SQL Server 2012 Express from SharePoint 2013 Configuration Wizard Posted on 09-04-2014  This article is intended to provide resolution/suggestion in case you face problem while connecting to SQL Server 2012 Express edition (installed on Windows Server 2008 R2) either through SharePoint or SQL Server Management Tool (from other server) or Source Code or anywhere else. I want to emphasize here this problem may not be specific to any version (of OS, SQL, MOSS,...), so resolution suggested here could be generalized. 5/10 871

Comment:

To comment you must be logged in members.

Files with category

  • Insufficient access rights error when doing backup in SQL Server

    View: 321    Download: 0   Comment: 0   Author: none  

    Insufficient access rights error when doing backup in SQL Server

    Category: SQL Server
    Fields: none

    2.25/2 review
    All of sudden SQL Server Management studio gives me the following error message when I'm trying to browse for the backup file location.

  • Migrate MySQL to Microsoft SQL Server

    View: 2373    Download: 0   Comment: 0   Author: none  

    Migrate MySQL to Microsoft SQL Server

    Category: SQL Server
    Fields: none

    0/2 review
    This article describes a few simple steps in order to migrate MySQL into Microsoft SQL Server 2005. The technique is very easy, but useful if you plan to move your data from MySQL and upgrade it finally to a Microsoft SQL Server environment.

  • COUNT of DISTINCT Rows in SQL Server

    View: 1241    Download: 0   Comment: 0   Author: none  

    COUNT of DISTINCT Rows in SQL Server

    Category: SQL Server
    Fields: Other

    0/4 review
    SQL Server does not support COUNT(DISTINCT *). For example, the below query fails.

  • Finding SQL Servers on the Network

    View: 569    Download: 0   Comment: 0   Author: none  

    Finding SQL Servers on the Network

    Category: SQL Server
    Fields: Other

    0/2 review
    I am a TSQL fanatic. The programs I code are highly dependent upon MS SQL stored procedures. I pay for this love of TSQL when a major overhaul of the system is necessary. Sometimes my code needs to be updated heavily in two places; client and...

  • SQL Server and Database Enumerator

    View: 548    Download: 0   Comment: 0   Author: none  

    SQL Server and Database Enumerator

    Category: SQL Server
    Fields: Other

    0/1 review
    This sample helps you to enumerate the list of SQL Servers and the databases and languages that a particular SQL server has. The class CSQLInfoEnumerator encapsulates this functionality into it.

  • Dynamic Management Views [DMV] – A SQL Server 2005 Feature

    View: 567    Download: 0   Comment: 0   Author: none  

    Dynamic Management Views [DMV] – A SQL Server 2005 Feature

    Category: SQL Server
    Fields: Other

    0/2 review
    The DMVs; newly introduced in SQL Server 2005 gives the database administrator information about the current state of the SQL Server machine. These values will help the administrator to diagnose problems and tune the server for optimal performance....

  • Table Value Parameter in SQL Server 2008

    View: 474    Download: 0   Comment: 0   Author: none  

    Table Value Parameter in SQL Server 2008

    Category: SQL Server
    Fields: Computers - Technology

    0/1 review
    One of the fantastic new features of SQL Server 2008 is the Table value parameter. In previous versions of SQL Server, there wasn’t a native way to pass a table to a Stored Procedure or functions. The usual workaround was to pass a large varchar or...

  • SQL Server DO's and DONT's

    View: 468    Download: 0   Comment: 0   Author: none  

    SQL Server DO's and DONT's

    Category: SQL Server
    Fields: Computers - Technology

    0/0 review
    So, you are now the leader of a SQL Server based project and this is your first one, perhaps migrating from Access. Or maybe you have performance problems with your SQL Server and don't know what to do next. Or maybe you simply want to know of some...

 
Newsletter Email

File suggestion for you

File top downloads

logo codetitle
Codetitle.com - library source code to share, download the file to the community
Copyright © 2015. All rights reserved. codetitle.com Develope by Vinagon .Ltd