Edited by Rama Udaya Saturday, July 14, 2012 8:03 AM Marked as answer by amber zhangModerator Tuesday, July 24, 2012 1:25 AM Saturday, July 14, 2012 7:44 AM Reply | Quote Click "Yes." Now move on to the next post. 0 Back to top of the page up there ^ MultiQuote Reply #5 laserspeeddemon Member Group: Regular Members Posts: 6 Joined: Change directories by typing "cd C:\Program Files\Update Services\Tools\osql" and hit enter. Thanks for the info! http://devstude.net/connect-to/wsus-sql-error.php
Reason: Failed to open the explicitly specified database 'SUSDB'. [CLIENT: ] 2016-04-20 10:48:01.90 Logon Error: 18456, Severity: 14, State: 38. 2016-04-20 10:48:01.90 Logon Login failed for user 'NT AUTHORITY\NETWORK SERVICE'. Thanks. 0 LVL 3 Overall: Level 3 Message Expert Comment by:ajkreddy2011-01-27 if you dont mind please reboot your server 0 Message Author Comment by:jyarbrough_rc2011-01-27 I saw this earlier today Subscribe to our monthly newsletter for tech news and trends Membership How it Works Gigs Live Careers Plans and Pricing For Business Become an Expert Resource Center About Us Who We This is used to figure out the account that has access123SELECT session_id from sys.dm_Exec_requests where status <> 'sleeping' and session_id <> @@spidSELECT @@spid --This gets the allowed user SPIDsp_who 53 --The
If you wish to use the BUILTIN\Administrator permissions on SQL Server. I just cant seem to get Wsus to connect to it, Any help would be appreciated. These steps are only what fixed the problem through my own expirence and are offered only as an suggestion. Friday, May 20, 2016 3:39 PM Reply | Quote 18 Sign in to vote If you have KB3148812 - remove it.If you have KB3159706 - remove it.
Basically the steps boil down to: Open an elevated Command Prompt and run "C:\Program Files\Update Services\Tools\wsusutil.exe" postinstall /servicingEnableHTTP Activationunder.NET Framework 4.5 Featuresin the Server Manager Add Roles and Features WizardRestart the If the WID - leave that blank - it auto-detects the named pipes connection string. 0 Anaheim OP Alizain Patel May 25, 2016 at 2:13 UTC it throws no need to uninstall anything. Wsus Cannot Connect To Sql Server However, now I can't start the WSUS management console due to a connection error.
Friday, July 01, 2016 10:22 AM Reply | Quote 0 Sign in to vote Confirming this worked as well! :) I also had neither of the updates installed! There have been no changes to the system to cause this issue. Reason: Failed to open the explicitly specified database 'SUSDB'. [CLIENT: ] 2016-04-20 10:47:51.89 Logon Error: 18456, Severity: 14, State: 38. 2016-04-20 10:47:51.89 Logon Login failed for user 'NT AUTHORITY\NETWORK SERVICE'. Without KB3159706, you cannot deploy Windows 10.
Now run this command with path of the backup in place of my path (the bolded text): osql.exe -S %computername%\WSUS -E -Q "USE master ALTER DATABASE SUSDB SET SINGLE_USER WITH ROLLBACK Susdb Recovery Pending Wsus This is an informational message only. database shrinks (in the event that you drop a large category, like say you no longer support or patch Office 2003) database repairs (say the WSUS database is just plain broken Friday, August 26, 2016 1:28 AM Reply | Quote 0 Sign in to vote If you have KB3159706 - remove it. >>>This was the cause of my connection problem.
The database was installed with WSUS 3, which as I understand is a stripped down version of SQL 2005 known as Windows Internal Database so I guess embedded? A Security Warning will pop-up. Connect To Wsus Database With Management Studio WITHOUT checking any boxes click next. Wsus Login Failed For User 'nt Authority Network Service' Click on the above link.
I have been breaking my head since yesterday trying to get it up. When the installation is complete. Thank you! Not a good idea. \\.\pipe\microsoft##wid\tsql\query Login Failed
The timeout period elapsed prior to completion of the operation or the server is not responding. If you want to use a dedicated administrator connection, restart SQL Server using the trace flag 7806. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL You are correct that there is a update to the version of SQL and Windows Internal Database as 9.00.4035 is SP3. 0 LVL 47 Overall: Level 47 Windows Server
I will give instructions for both. Connect To Wsus 2012 Database With Management Studio The steps above worked as a charm! The server/instance name to connect to is: \\.\pipe\MSSQL$MICROSOFT##SSEE\sql\query You must also use "Windows Authentication" as the authentication method to connect to this database.
I have done this before on a different SBS 2008 server and didn't have this issue. Quote2007-06-29 04:03:24 Success MWUSSetup WSUS Server Setup Started. 2007-06-29 04:03:24 Success MWUSSetup Parsing command line arguments 2007-06-29 04:03:24 Success MWUSSetup WSUS Setup: Performing maintainance 2007-06-29 04:03:40 Success MWUSSetup Determing the installation To Save it (recommended). Wsus Database Error Reset Server Node Send to Email Address Your Name Your Email Address Cancel Post was not sent - check your email addresses!
Second Data Center CoLo and Multitenant setup Windows 8.1 deployment Deploying win 8.1 TECHNOLOGY IN THIS DISCUSSION Join the Community! Remove all Drivers from the WSUS Database.4. Adam is a Microsoft Windows PowerShell MVP, 2015 powershell.org PowerShell hero and has numerous Microsoft IT pro certifications. I again select "E:\WSUS\" to store the data.
Click on "Add/Remove Windows Components" Select "Application Server" and click details. Saturday, August 13, 2016 7:45 PM Reply | Quote 0 Sign in to vote See - http://blogs.technet.com/b/wsus/archive/2016/04/20/known-issues-with-kb3148812.aspx Uninstall KB3148812 https://blogs.technet.microsoft.com/wsus/2016/05/05/the-long-term-fix-for-kb3148812-issues/Don [doesn't work for MSFT, and they're probably glad about that ;] Edited by ObfuscatedClarity Thursday, September 15, 2016 3:25 PM Thursday, September 15, 2016 3:24 PM Reply | Quote 0 Sign in to vote Same here.