Thursday, May 22, 2014

You don’t have an E-Mail address Issue while setting up Alerts



You don’t have an E-Mail address Issue while setting up Alerts

While I am working on alerts and setting up on my Documents I see an error “you don’t have an E-mail address specified”

After I digging into the issue finally I resolved this by doing some trouble shooting. In this article I am providing the steps to resolve the issue.

Solution: To make sure the below are set properly and configured to work alerts.
 
1.   Ensure that the Account setting up for  the alerts has assigned an E-mail address in AD.

2.   check the User Profile Account within SharePoint to see if the email address is being imported.

·        CA->Application management->manage service applications->User profiles

3.   Since, that the email address property is not being populated properly  manually setup the mapping .To do that

·        Manager user profiles-> Find the Contact Information”->Edit the Mail  

                                                        
                        http://sharepointobservations.files.wordpress.com/2013/07/ups-missing-email-08.png
                                        
Once done save and do the Incremental Import and check the alerts.

Please Comment if you need Any Help.Your Feed back is always Welcome.I Am Happy to Help !!!!!

Workflow service is not installed or workflow requires a compatible workflow service



Workflow service is not installed or workflow requires a compatible workflow service

When we creating the work flow, we encounter the issue of creating work flow in SharePoint. The error should be” SharePoint 2013 workflow requires a compatible workflow service configured with SharePoint such as workflow manager”


Initially, the Workflow Service in SharePoint 2013 is not connected. it requires a compatible workflow service such as Workflow Manager.
 


Solution:

1.   Ensure that the Service Application configured for the work flow manager

 CA -> Application Management -> Manage service applications ->      Workflow Service Application

Install and configure workflow for SharePoint Server 2013

Follow the below MS article to configure the Work flow in SharePoint 2013.
http://technet.microsoft.com/en-us/library/jj658588.aspx
 


Please Comment if you need Any Help.Your Feed back is always Welcome.I Am Happy to Help !!!!!

Wednesday, May 21, 2014

Cannot connect to the configuration database


Cannot connect to the configuration database

Issue:“Cannot connect to the configuration database or Unable to connect to database. Check data base connection information and make sure the database server is running.”



This is the error that every Administrator faced once in his seen on SharePoint Product Configuration Wizard.

Causes: This error could be of many reasons. I am giving some here as per my experience.

1.    SQL database and services are down.
2.    The SQL database may not be running correctly
3.    You applied a Hot fix or Service Pack and did not reboot.
4.    The Firewall is blocking the communication
5.    The SharePoint Installation Account does not have the required permissions to the SQL Server database.
6.    Network connectivity is not optimal between the SharePoint Server and SQL Server.
I am mentioning the steps here, where to look and how to trouble shoot the issue. 

Verify that the SQL database is running and services.

Ensure that the SQL services are up and running under System Services. 

Firewall
Firewall can block access and communication with your Microsoft SQL Server so you have 2 possibilities.
  1. Disable Firewall, easiest way on development machine but not secure and recommended for a Production environment.
  2. So you can create 2 rules on the Firewall:
1.    One inbound TCP rule with ports:1433,2383,2382
2.    One inbound UPD rule with port: 1434 


User Permissions
 
Ensure that the user running on SharePoint has the required permissions on SQL.
1.    Click Start, point to Programs, point to Microsoft SQL Server, and click Enterprise Manager
2.    In the left pane, double-click Microsoft SQL Servers, and then double-click your SQL server group.
3.    Double-click your server.
4.    Double-click Security.
5.    In the left pane, click Logins.
6.    In the right pane, double-click the user for your Farm Admin Global Administrator.
7.    In the SQL Server Login Properties dialog box, click Server Roles.
And select the following:  Security Administrators and the Database Creators check boxes and then click Database Access.

Connection between SharePoint and SQL server.
1.    Verify that SharePoint is using the correct IP address for the SQL server. To do this, run the ping command on the Windows SharePoint Services server.
2.    Verify that the SharePoint server is obtaining the correct IP address for the SQL server from DNS. To do this, run the nslookup command from the SharePoint Server.
3.    Make sure that there are no incorrect entries for the SQL server. To do this, examine the Hosts file on the SharePoint server. This file is in the following location:
%systemroot%\system32\drivers\etc\Hosts

4.    On the SharePoint server, look for SQL client aliases. To do this, follow these steps: Click
1.    Start, click Run, and then type cliconfg in the open box.
2.    Click the Alias tab. By default, there are no SQL client aliases. If you have any aliases for the SQL server, verify that they are correct, or remove them.
5.    Open the SQL Server Configuration Manager (Start SQL Server 2008  Configuration Tools  SQL Server Configuration Manager 

1.    Navigate to the SQL Server Network Configuration  Protocols for MSSQLSERVER node in the tree view
2.    Enable TCP/IP and Named Pipes (you’ll be warned that these changes will not apply until the service is shut down)

To assign a TCP/IP port number to the SQL Server Database Engine

·         In SQL Server Configuration Manager, in the console pane, expand SQL Server Network Configuration, expand Protocols for <instance name>, and then double-click TCP/IP.
·         If the TCP Dynamic Ports dialog box contains 0, indicating the Database Engine is listening on dynamic ports, delete the 0.
·         If the TCP Port box isn’t 1433, type the port number 1433 and then click OK.
·         In the console pane, click SQL Server Services.
·         In the details pane, right-click SQL Server (<instance name>) and then click Restart, to stop and restart SQL Server.

SharePoint administrative accounts: Local Administrator


Ensure The setup user administrator account requires the following permissions:

·         It must have domain user account permissions.
·         It must be a member of the local administrators group on each server in the SharePoint farm, excluding the server running SQL Server and the Simple Mail Transfer Protocol (SMTP) server.


Please Comment if you need Any Help.Your Feed back is always Welcome.I Am Happy to Help !!!!!

ShareThis

X