WSUS and SQL on Server 2012 R2 and with SQL 2012
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
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
Last Comment
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
my default instance was WSUS\MSSQLSERVER
ASKER
and, in services, I do have the MSSQLSERVER listed as a running service. Now I'm getting error 25, connection string not valid.
SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
the server name is WSUS and my default instance is MSSQLSERVER. So, when asked for the host to connect to, I specify wsus\mssqlserver
ASKER
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.
I'll be done in a few ... and will report back.
SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
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.
MSSQL$MICROSOFT##WID won't start because widwriter won't start.
SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Microsoft SQL Server
Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.
171K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
ASKER
My install was default. I even selected all options with default settings and Windows authentication.
My firewall is off.