This forum has migrated to Microsoft Q&A. Visit Microsoft Q&A to post new questions.

Remove From My Forums

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

Question
0

Sign in to vote

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

0

Sign in to vote
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

0

Sign in to vote
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
0

Sign in to vote

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
0

Sign in to vote

Did you ever get this answered, I am struggling with the same problem

Sunday, November 20, 2011 10:24 PM
0

Sign in to vote

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