SQL error log file location

1. Click Start -> Programs -> Microsoft SQL Server 2008/2012 -> Configuration Tools -> SQL Server Configuration Manager

2. In SQL Server Configuration Manager, click SQL Server Services on the left side and then right click on SQL Server (MSSQLSEVER) and select Properties from the drop down as shown below. For a named instance, right click on the appropriate SQL Server (INSTANCENAME) service.

3. In SQL Server (MSSQLSERVER) Properties window click on the Advanced tab and then expand the drop down next to Startup Parameters. The location of SQL Server Error Log file is mentioned next to the "-e" startup parameter

Navigate to the physical file location and open it or u can also use SQL query to get log details

EXEC sp_readerrorlog

Reference : 

http://www.mssqltips.com/sqlservertip/2506/identify-location-of-the-sql-server-error-log-file/

SQL Query to get SQL Error Logs

Go to SQL -> New Query and paste the following query it should return you the latest Error log

EXEC sp_readerrorlog

For more details and reference : 

http://www.lucasnotes.com/2012/10/querying-sql-server-error-log.html

 

http://sqlserverzest.com/2013/03/25/easy-way-to-search-the-sql-server-error-log/

 

http://sqlandme.com/2012/01/25/sql-server-reading-errorlog-with-xp_readerrorlog/

Cannot open database "SharePoint_Config" requested by the login. the login failed error

error - Cannot open database "SharePoint_Config" requested by the login. the login failed

After re-installing MSQL 2012,I tried to connect the Central Admin which gave the following error :

So I ran… SharePoint 2010 Products Configuration Wizard  

I got this error while I was trying to run SharePoint 2010 Products Configuration Wizard.

Resolution :

1)      Run this command : PSConfig -cmd configdb –disconnect

2)      Make sure the account that you are using has following roles assigned in SQL  

Dbcreator , public and securityadmin roles

Go to SQL -> Security -> Logins -> UserAccount -> Right Click -> Properties -> Server Roles -> Check -> Assign the Dbcreator , public and securityadmin roles - OK

3)      open regedit (from run command) ,Navigate to HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Shared Tools\Web Server Extensions\14.0\Secure

4)      Run SharePoint 2010 Products Configuration Wizard and Re-create new farm

Creating new farm will take sometime,so have some patience ;)

Well I am not sure if Step 1 & 2 are required but I am just letting you know the drill that I followed

Additionally Tips :

·         Make sure all the SQL services are running with the account that you are using to install Sharepoint.

·         Also make sure the Sharepoint timer services are running.

·         Checking the error in Event viewer can also help, you can then google the error.

References :

http://answers.flyppdevportal.com/categories/sharepoint2010/sharepoint2010setup.aspx?ID=b7ba6c51-3248-4dc2-a476-49cdd4267210

http://technet.microsoft.com/en-us/library/ee662513(office.14).aspx

Hope this helps !

Error - Cannot connect to configuration database

Cannot connect to configuration database - Error

After re-installing MSQL 2012,I tried to connect the Central Admin which gave the following error :

So I ran… SharePoint 2010 Products Configuration Wizard  

I got this error while I was trying to run SharePoint 2010 Products Configuration Wizard.

Resolution :

1)      Run this command : PSConfig -cmd configdb –disconnect

2)      Make sure the account that you are using has following roles assigned in SQL  

Dbcreator , public and securityadmin roles

Go to SQL -> Security -> Logins -> UserAccount -> Right Click -> Properties -> Server Roles -> Check -> Assign the Dbcreator , public and securityadmin roles - OK

3)      open regedit (from run command) ,Navigate to HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Shared Tools\Web Server Extensions\14.0\Secure

4)      Run SharePoint 2010 Products Configuration Wizard and Re-create new farm

Creating new farm will take sometime,so have some patience ;)

Well I am not sure if Step 1 & 2 are required but I am just letting you know the drill that I followed

Additionally Tips :

·         Make sure all the SQL services are running with the account that you are using to install Sharepoint.

·         Also make sure the Sharepoint timer services are running.

·         Checking the error in Event viewer can also help, you can then google the error.

References :

http://answers.flyppdevportal.com/categories/sharepoint2010/sharepoint2010setup.aspx?ID=b7ba6c51-3248-4dc2-a476-49cdd4267210

http://technet.microsoft.com/en-us/library/ee662513(office.14).aspx

or simple process would be

Please follow a general practise when your SharePoint Central Admin does not work make sure

1)    Go to run->Services.msc à SharePoint timer services are running()

2)    Go to run->Services.msc à SQL(SharePoint)  service is running

3)    Go to IIS àIn application pool – make sure Central Admin  v4 application is started

In my case the application pool wasn’t working, so I started the Central Admin v4 application pool

And TaDa ! My central admin starts working J

Hope this helps !