Solved

WSUS and SQL on Server 2012 R2 and with SQL 2012

Posted on 2014-12-29
12
1,271 Views
Last Modified: 2016-02-20
This is a brand new VM.  I installed Server 2012 R2 and patched it up.

I joined it to the domain.

I installed SQL 2012 default install with Windows authentication.

I added the WSUS role, unchecked WID and checked Database.

Now I am at the config screen.  

It reads Complete WSUS Installation.  For DB instance, I have wsus\updates.  Store locally is checked, and my path to content directory is e:\wsusupdates.

When I click run, I get: Fatal Error: a network related or instance specific error occurred while establishing a connection to SQL server.  The server was not found or not accessible.  Verify that the instance name is correct and that the SQL server is configured to allow remote connections. (provider SQL network interfaces, error 26 - error locating server/instance specified.

HELP!  :)

Thanks

Cliff
0
Comment
Question by:crp0499
  • 6
  • 3
  • 2
  • +1
12 Comments
 
LVL 76

Accepted Solution

by:
arnold earned 250 total points
ID: 40522861
Are you connecting locally or trying to remotely?
You likely got notice in the sql install that deals with configuring the type of access need pipes, shared memory and tcp/ip as well as then making the appropriate adjustments to the advanced firewall rules to allo port 1433 through.
These changes require the restart of the services.

What instance did you install sql as ? Because it seems that you have an instance, I gather you have two sql instances one with default and one as /updates. Within the sql configuration interface, you have to configure each accordingly if tcp/ip is needed.  Note you can only have on bind to an Ip and a specific port.
0
 

Author Comment

by:crp0499
ID: 40522877
Locally.  WSUS and SQL on the same server.  I don't think the second instance has been created yet.  I just have the normal master DBs and the other three default.

My install was default.  I even selected all options with default settings and Windows authentication.

My firewall is off.
0
 
LVL 56

Assisted Solution

by:Cliff Galiher
Cliff Galiher earned 167 total points
ID: 40522893
Per your initial question "For DB instance, I have wsus\updates.". If you installed SQL with all defaults as your follow-up suggests then no such instance "wsus\updates" exists. That will definitely be an issue. You need to make sure the DB instance name you enter and the instance name of the SQL install actually match.
0
 

Author Comment

by:crp0499
ID: 40522898
my default instance was WSUS\MSSQLSERVER
0
 

Author Comment

by:crp0499
ID: 40522899
and, in services, I do have the MSSQLSERVER listed as a running service.  Now I'm getting error 25, connection string not valid.
0
 
LVL 78

Assisted Solution

by:David Johnson, CD, MVP
David Johnson, CD, MVP earned 83 total points
ID: 40522952
is the server computer name wsus?  That is what you've configured it for. and the database will be susdb.mdf
0
Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

 
LVL 56

Assisted Solution

by:Cliff Galiher
Cliff Galiher earned 167 total points
ID: 40522962
Now that we are getting into things, perhaps I'll ask....why not just use the internal database?   It'll solve your immediate issue and is far easier to support.

There is usually only one reason to use (and burn a license) of a full-blown SQL server...and that is in very large environments where you don't want to run the SQL instance on the same machine as the IIS and update engine.  For performance, or high availability, etc, then there are benefits to separating the two. But since you are already just installing SQL on your WSUS server, it seems like you are not getting any of the benefit and are creating a bit of a hassle. Probably unnecessarily.

-Cliff
0
 

Author Comment

by:crp0499
ID: 40522963
the server name is WSUS and my default instance is MSSQLSERVER.  So, when asked for the host to connect to, I specify wsus\mssqlserver
0
 

Author Comment

by:crp0499
ID: 40522969
Hi Cliff, this is Cliff.  That's what I'm trying now.  I'm backing everything out and getting back down to the OS and starting over.

I'll be done in a few ... and will report back.
0
 
LVL 76

Assisted Solution

by:arnold
arnold earned 250 total points
ID: 40522993
Mssqlserver means default instance meaning no instance name to i.e sql connect to wsus and that is it. If you are local on the system localhost will work as well.
Make sure you have configured the server to listen on tcp/ip using the sql server configuration tool.
When using sql server management as long as you run the browser service, you can let it search for available sql instances which should show wsus.
0
 

Author Comment

by:crp0499
ID: 40523053
I backed all the way out, stripped it down to the OS and went back with WID.  Now I the winwriter won't start, cannot find file specified.  

MSSQL$MICROSOFT##WID won't start because widwriter won't start.
0
 
LVL 76

Assisted Solution

by:arnold
arnold earned 250 total points
ID: 40523070
How did you backout through snapshots?
I would suggest the first habit to drop when encountering a difficult situation is starting to uninstall things. At times the uninstall attemp is unclean making the remaining system less stable/manageable than it was.

Just start from scratch on a new VM. Install OS. Install sql server. Configure sql server to listen on TCP/ip and use mixed role and set the SA password. Add administrator to be admin of sql server(required since windows 2008). Restart sql service.
Make sure to install sql server management suite (express)
Make sure you can connect using ssms/e into the server.
 Add the wsus role, point the database to the sql server instance.


See if that works out better for you
0

Featured Post

What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

OfficeMate Freezes on login or does not load after login credentials are input.
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
This tutorial will walk an individual through the steps necessary to join and promote the first Windows Server 2012 domain controller into an Active Directory environment running on Windows Server 2008. Determine the location of the FSMO roles by lo…

706 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

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now