locked
At least one SQL server instance errored out during opening a connection. Such instances (if any) have been removed. RRS feed

  • Question

  • Hi,

    Im trying to install the SSP 2.0 SP1. I have three seperated servers on the same domain.

    Im installing the Server component and when im trying to the connect the VMMSSP server component to the VMMSSP database i recieve the following error.

     

    "At least one SQL server instance errored out during opening a connection. Such instances (if any) have been removed."

     

    Any suggestions?

     

    Tuesday, September 13, 2011 9:37 AM

Answers

  • As it seems that the Database login with the user that setup the database was not allowed.

    Adding the user to the login database solved the problem

    • Marked as answer by Santosh Karale Tuesday, September 13, 2011 7:19 PM
    Tuesday, September 13, 2011 11:39 AM

All replies

  • As it seems that the Database login with the user that setup the database was not allowed.

    Adding the user to the login database solved the problem

    • Marked as answer by Santosh Karale Tuesday, September 13, 2011 7:19 PM
    Tuesday, September 13, 2011 11:39 AM
  • Hi 

    Please i am having same issue

    How will i add the user to the login database

    My server name is MYCLOUD but user is administrator

    kindly assist because i have been going on on this for alomst 2 nights  now

    Azeez

    Friday, November 11, 2011 9:54 PM
  • Did you ever get this answered, I am struggling with the same problem
    Sunday, November 20, 2011 10:24 PM
  • Hi

    VMMSSP 2.0 SP1 supports SQL Server 2008 and above. Can you please specify which version of SQL Server you are using.  VMMSSP 2.0 SP1 will filter out the unsupported instances or instances where current user is not having the permissions.

    Thanks,

    Santosh..

    Thursday, December 15, 2011 6:17 AM