Role Install - Fail to connect to SQL Server

Question

WSUS role - Server2012R2 STD (Hyper-V) Server name LongWSUS
SQL Server 2012 - Server2012R2 STD (Hyper-V) Server name LongSQL2012

Instance name - WSUS

I am re-installing WSUS role on LongWSUS and wish to use SQLServer as the repository. I setup a default instance on LongSQL2012 as WSUS and it completed successfully.

At Role Install - Database Instance Selection, it fails to connect

I also tried FQN and fails and last resort a "search:

I believe I have the credentials not setup correctly. Here is the WSUS instance default security

What do I have to do to make the connection?

Answer 1

Hi，

There are two points we should notice.

point 1 Instance name - WSUS
We have create the instance, so we should input 'LongSQL2012\WSUS' instead of LongSQL2012.

point 2 The user longsoho\adminwsus has no permission in Logins, so we should add the user in Logins.

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

I added longsoho\adminwsus to logins with server roles I thought appropriate:

However, still same connection failure:

I know getting connections is always problematic between hosts. But I noticed in the connection instance failure the destination server is longwsus not longsql2012. Is this the problem and if so, how do i correct it?

Answer 3

I did verify "allow remote connections to this server" on WSUS is checked

Answer 4

I did further research an found I had to open firewall on SQL Server for port 1434 & SQLBroeser.exe. It connected