Thursday, February 10, 2011 8:54 PM
I am doing my first ever install of VMMSSP 2.0 after SCVMM 2008 R2 but I am unable to get past the "Configure the VMMSSP server and website components to the VMMSSP database screen"
I have a default instance of SQL server MSSQLSERVER on the local machine that SCVMM and VMMSSP is (trying to be) installed on. I am using a domain accouny which is included in local admin group of the box.
I just get the "SQL Server 2008 instance was not found on the specified computer message" regardless of whether I put in the name of the SQL server in lower or upper case. if I put a \ after the servername I get
"Either the specified server name is not valid, or the server is not reachable"
I have opened up all the normal ports in the firewall and SQL protocols are all on apart from VIA. Also browser service is running.
The installer just will not see my local installation of SQL 2008 R2. I have done the WMI thing as per this link and no joy.
myetails are as follows
2008 R2 Ent
SCVMM 2008 R2
sql 2008 R2
I am at a loss so any help would be massivly appreciated
Sunday, February 13, 2011 3:49 PM
I managed to resolve this by RTFM!!!
SQL 2008 R2 is not supoprted yet on SCVMM 2008 R2. I installed 2008 Enterprise and shabam all sorted.
I feel like such an ass sorry
I hang my head in shame :(
- Marked As Answer by AndyW77 Sunday, February 13, 2011 3:50 PM
Wednesday, March 23, 2011 5:08 PM
I had this same issue when I was trying to connect to the SQL database but it was not a SQL 2008 R2, it was SQL 2008, found out that the problem was that the user connecting to the SQL Server was not a local administrator of the SQL Server Machine. Once I added him to the administrators group, the installation went ok!
In case someone else has this issue... don't know why it has to be this way, but it is...
- Proposed As Answer by Ziv.Shih Monday, January 02, 2012 9:20 AM
Monday, January 02, 2012 9:23 AM
I got the same issue when using sql 2008 r2 for ssp 2.0, after add to sql server's local admin group. SSP 2.0 can get sql instances and continue installing.
Best Regards, Ziv.Shih
Tuesday, February 28, 2012 12:01 PMAccording to the deployment guide, SQL 2008 R2 is supported now, but I'm having this same issue. Are there any other steps I can try?