Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Can't connect to MS SQL 2012 server for SCVMM install

Posted on 2014-04-21
2
3,624 Views
Last Modified: 2014-04-21
I cannot get my lab environment to install Microsoft System Center Virtual Machine Manager.  At the Database Configuration part it says "Setup cannot connect to the specified SQL Server instance."  

I have turned off both firewalls, verified that TCPIP is enabled on the SQL server, everywhere there is a port it is set to 1433 (default settings), started the SQL browser service, can UNC to SQL server and ping it and it APPEARS that the Instance Name is autopopulated when I try to fill out the form in the SCVMM install.  

Server Name: SCVMM
OS: Win Srv 2012

Server Name: MSSQL
OS: Win Srv 2012
SQL: MS SQL 2012

SCVMM Install Error
0
Comment
Question by:Tim Phillips
  • 2
2 Comments
 
LVL 6

Author Comment

by:Tim Phillips
ID: 40013609
Also, did a netstat for the PID of the SQL Server and I can see that it is listening:
Netstat
0
 
LVL 6

Accepted Solution

by:
Tim Phillips earned 0 total points
ID: 40013659
Added a new login in SQL for a domain user with rights to everything and it worked.  Go figure that the domain admin account didn't work out of the box.
0

Featured Post

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
SQL Server Configuration Manager WMI Error 11 18
sql server query 18 37
DNS zone 3 27
Windows Updates 14 30
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
Via a live example, show how to shrink a transaction log file down to a reasonable size.
This tutorial will walk an individual through the process of configuring their Windows Server 2012 domain controller to synchronize its time with a trusted, external resource. Use Google, Bing, or other preferred search engine to locate trusted NTP …

856 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question