none
Unknown SQL Exception -1 occurred

    Question

  • Hi ,

    I am facing below error in qlik view server , kindly help me to resolve the same.

    Unknown SQL Exception -1 occurred. Additional error information from SQL Server is included below.

    A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)

    Thanks,

    Srinivasan.B


    Srinivasan.B

    Friday, May 11, 2012 1:16 PM

Answers

  • Could you please check to see if the ports TCP/1433 and UDP/1434 are open in the firewall. Sharepoint uses these ports to connect to SQL. 

    Try pinging the SQL server from sharepoint (ping "IPaddress") and vice versa. 

    Secondly you can try specifying the connection this way:

    ServerFQDN\Instance name or

    ServerIPAddress\Instance name

    Please check if you are using an account that has the right permissions to the database instance as well:

    http://technet.microsoft.com/en-us/library/ee513066.aspx



    Friday, May 11, 2012 3:28 PM

All replies

  • Could you please check to see if the ports TCP/1433 and UDP/1434 are open in the firewall. Sharepoint uses these ports to connect to SQL. 

    Try pinging the SQL server from sharepoint (ping "IPaddress") and vice versa. 

    Secondly you can try specifying the connection this way:

    ServerFQDN\Instance name or

    ServerIPAddress\Instance name

    Please check if you are using an account that has the right permissions to the database instance as well:

    http://technet.microsoft.com/en-us/library/ee513066.aspx



    Friday, May 11, 2012 3:28 PM
  • First check to see if you have the correct spelling for the sql server or sql server instance.   Is instance on the root (as in just the server name)?   Try running the SQL server browser.   Also were you able to connect to this before or is this the first time you are trying to connect to this sql server?

    HTH


    de Nada

    Friday, May 11, 2012 7:22 PM