No able to connect SQL

• 1 mai 2012 05:31

   

   
  

  0

  Hi All,

  First of all I would like to inform you that I am completely new on sharepoint.

  I have installed sharepoint server & in configuration wizard while I enter all the details related to SQL server it’s giving me error “Cannot connect to database master at SQL Server at <MYSERVERName>. The database might not exist, or the current user does not have permission to connect to it”

  Sharepoint is on separate server & SQL is in its own cluster.

  I checked below things

  1. Checked permission on SQL server. The account is having all the server role permission assigned to it.
  2. Tried entering Cluster name, exact active sql server hostname & also tried both names with their FQDN.
  3. Logged in with same user account (Which has all permission on SQL server) on sharepoint server & tried. Still same error.
  4. When I telnet to the cluster IP with port no.1433, the connection is getting failed.
  5. Windows firewall is turned off on all the servers.

  Note: - I have a Lync server which is using the same database & working fine. When I run telnet from the Lync server, it’s also getting failed, but still everything is working fine there…. :(

  Is there any way to identify if port no 1433 is opened or not, except telnet utility?

  Your help is extremely appreciated!

  ---

  Regards Rushikesh..

  • Mesaj
  • Citare