Tuesday 31 May 2016

The Secure Store Service application Secure Store Service Application is not accessible. The full exception text is:

Secure Store Service is not accessible

The Secure Store Service application Secure Store Service Application is not accessible. The full exception text is: The HTTP service located at https://........./SecureStoreService.svc/https is unavailable.  This could be because the service is too busy or because no endpoint was found listening at the specified address. Please ensure that the address is correct and try accessing the service again later.













Resolution:

1. Check AppPool Account which secure store service is running is not stopped.

Go to Inetmgr -> Find the application pool for Secure store Service  





If Stopped - start the AppPool



2.  Check if Secure store service is not started,  if not go and Start as below.

Central Admin - > Application Management -> Manage Services on the Server 

Secure Store Service -> Start


Hope this will fix the issue , 

A Network-related or instance-specific error occurred while establishing connection to SQL Server,

A Network-related or instance-specific error occurred while establishing connection to SQL Server, The Server was not found or was not accessible. verify that instance name is correct and that SQL Server is configured to allow remote connections.





Solution :




Monday 30 May 2016

Verification of prerequisites for Domain Controller promotion failed. The local Administrator account becomes the domain Administrator account when you create a new domain. The new domain cannot be created because the local Administrator account password does not meet requirements. Currently, a password is not required for the local Administrator account. We recommend that you use the net user command-line tool with the /passwordreq:yes option to require a password for this account before you create the new domain; otherwise, a password will not be required for the domain Administrator account.

Error While Setting Active Directory:


Verification of prerequisites for Domain Controller promotion failed. The local Administrator account becomes the domain Administrator account when you create a new domain. The new domain cannot be created because the local Administrator account password does not meet requirements. Currently, a password is not required for the local Administrator account. 

We recommend that you use the net user command-line tool with the /passwordreq:yes option to require a password for this account before you create the new domain; otherwise, a password will not be required for the domain Administrator account.


Resolution:








Change SQL Server Authentication Mode


  1. In SQL Server Management Studio Object Explorer, right-click the server, and then click Properties.
  2. On the Security page, under Server authentication, select the new server authentication mode, and then click OK.
  3. In the SQL Server Management Studio dialog box, click OK to acknowledge the requirement to restart SQL Server.
  4. In Object Explorer, right-click your server, and then click Restart. If SQL Server Agent is running, it must also be restarted.
 Change Security Authentication Mode



Enabling login for sa account

  1. In Object Explorer, expand Security, expand Logins, right-click sa, and then click Properties.
  2. On the General page, you might have to create and confirm a password for the login.

On the Status page, in the Login section, click Enabled, and then click OK.