+ Post New Thread
Results 1 to 6 of 6
Windows Server 2012 Thread, Problems with WSUS within 2012 R2 with SQL 2012 in Technical; Im having some problems trying to get this going. SQL 2012 with SCCM 2012. SCCM 2012 install fine, Started going ...
  1. #1
    newpersn's Avatar
    Join Date
    Nov 2010
    Location
    Gloucestershire
    Posts
    1,220
    Thank Post
    281
    Thanked 110 Times in 83 Posts
    Rep Power
    76

    Problems with WSUS within 2012 R2 with SQL 2012

    Im having some problems trying to get this going. SQL 2012 with SCCM 2012.

    SCCM 2012 install fine, Started going to get roles to it. And i cant seem to get it passed WSUS or software point.

    Log is here...

    2013-12-16 14:24:41 Postinstall started
    2013-12-16 14:24:41 Detected role services: Api, UI, WidDatabase, Services
    2013-12-16 14:24:41 Start: LoadSettingsFromParameters
    2013-12-16 14:24:41 Content local is: True
    2013-12-16 14:24:41 Content directory is: C:\Sources
    2013-12-16 14:24:41 SQL instname is:
    2013-12-16 14:24:41 End: LoadSettingsFromParameters
    2013-12-16 14:24:41 Start: Run
    2013-12-16 14:24:41 Fetching WsusAdministratorsSid from registry store
    2013-12-16 14:24:41 Value is S-1-5-21-2589001167-4160105790-1896818315-1010
    2013-12-16 14:24:41 Fetching WsusReportersSid from registry store
    2013-12-16 14:24:41 Value is S-1-5-21-2589001167-4160105790-1896818315-1011
    2013-12-16 14:24:44 Configuring content directory...
    2013-12-16 14:24:44 Configuring groups...
    2013-12-16 14:24:44 Starting group configuration for WSUS Administrators...
    2013-12-16 14:24:44 Found group in regsitry, attempting to use it...
    2013-12-16 14:24:48 Writing group to registry...
    2013-12-16 14:24:48 Finished group creation
    2013-12-16 14:24:48 Starting group configuration for WSUS Reporters...
    2013-12-16 14:24:48 Found group in regsitry, attempting to use it...
    2013-12-16 14:24:48 Writing group to registry...
    2013-12-16 14:24:48 Finished group creation
    2013-12-16 14:24:48 Configuring permissions...
    2013-12-16 14:24:48 Fetching content directory...
    2013-12-16 14:24:48 Fetching ContentDir from registry store
    2013-12-16 14:24:48 Value is C:\Sources
    2013-12-16 14:24:48 Fetching group SIDs...
    2013-12-16 14:24:48 Fetching WsusAdministratorsSid from registry store
    2013-12-16 14:24:48 Value is S-1-5-21-2589001167-4160105790-1896818315-1010
    2013-12-16 14:24:48 Fetching WsusReportersSid from registry store
    2013-12-16 14:24:48 Value is S-1-5-21-2589001167-4160105790-1896818315-1011
    2013-12-16 14:24:48 Creating group principals...
    2013-12-16 14:24:48 Granting directory permissions...
    2013-12-16 14:24:48 Granting permissions on content directory...
    2013-12-16 14:24:48 Granting registry permissions...
    2013-12-16 14:24:48 Granting registry permissions...
    2013-12-16 14:24:48 Granting registry permissions...
    2013-12-16 14:24:48 Configuring shares...
    2013-12-16 14:24:48 Configuring network shares...
    2013-12-16 14:24:48 Fetching content directory...
    2013-12-16 14:24:48 Fetching ContentDir from registry store
    2013-12-16 14:24:48 Value is C:\Sources
    2013-12-16 14:24:48 Fetching WSUS admin SID...
    2013-12-16 14:24:48 Fetching WsusAdministratorsSid from registry store
    2013-12-16 14:24:48 Value is S-1-5-21-2589001167-4160105790-1896818315-1010
    2013-12-16 14:24:48 Content directory is local, creating content shares...
    2013-12-16 14:24:48 Creating share "UpdateServicesPackages" with path "C:\Sources\UpdateServicesPackages" and description "A network share to be used by client systems for collecting all software packages (usually applications) published on this WSUS system."
    2013-12-16 14:24:48 Deleting existing share...
    2013-12-16 14:24:49 Creating share...
    2013-12-16 14:24:49 Share successfully created
    2013-12-16 14:24:49 Creating share "WsusContent" with path "C:\Sources\WsusContent" and description "A network share to be used by Local Publishing to place published content on this WSUS system."
    2013-12-16 14:24:49 Deleting existing share...
    2013-12-16 14:24:49 Creating share...
    2013-12-16 14:24:49 Share successfully created
    2013-12-16 14:24:49 Creating share "WSUSTemp" with path "C:\Program Files\Update Services\LogFiles\WSUSTemp" and description "A network share used by Local Publishing from a Remote WSUS Console Instance."
    2013-12-16 14:24:49 Deleting existing share...
    2013-12-16 14:24:49 Creating share...
    2013-12-16 14:24:49 Share successfully created
    2013-12-16 14:24:49 Finished creating content shares
    2013-12-16 14:24:49 Stopping service WSUSService
    2013-12-16 14:24:49 Stopping service W3SVC
    2013-12-16 14:24:49 Configuring WID database...
    2013-12-16 14:24:49 Configuring the database...
    2013-12-16 14:24:49 Establishing DB connection...
    2013-12-16 14:24:49 Checking to see if database exists...
    2013-12-16 14:24:49 Database exists
    2013-12-16 14:24:49 Switching database to single user mode...
    2013-12-16 14:24:57 System.Data.SqlClient.SqlException (0x80131904): Changes to the state or options of database 'SUSDB' cannot be made at this time. The database is in single-user mode, and a user is currently connected to it.
    ALTER DATABASE statement failed.
    at Microsoft.UpdateServices.DatabaseAccess.DBConnecti on.DrainObsoleteConnections(SqlException e)
    at Microsoft.UpdateServices.DatabaseAccess.DBConnecti on.ExecuteCommandNoResult()
    at Microsoft.UpdateServices.Administration.ConfigureD B.ConnectToDB()
    at Microsoft.UpdateServices.Administration.ConfigureD B.Configure()
    at Microsoft.UpdateServices.Administration.PostInstal l.Run()
    at Microsoft.UpdateServices.Administration.PostInstal l.Execute(String[] arguments)
    ClientConnectionId:94422464-5ee9-4592-852e-32d6f1e1961e
    Same error in both powershell and using the wizzard..

    To me it seems like it wont install or config the WSUS to use SQL but i cant find the database to fix or sort this problem out.

    Any help?

  2. #2

    CHR1S's Avatar
    Join Date
    Feb 2006
    Location
    Birmingham
    Posts
    4,503
    Thank Post
    1,581
    Thanked 485 Times in 303 Posts
    Rep Power
    217

  3. #3
    newpersn's Avatar
    Join Date
    Nov 2010
    Location
    Gloucestershire
    Posts
    1,220
    Thank Post
    281
    Thanked 110 Times in 83 Posts
    Rep Power
    76
    Msg 1205, Level 13, State 68, Line 1
    Transaction (Process ID 58) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
    Msg 5069, Level 16, State 1, Line 1
    ALTER DATABASE statement failed.
    I got 4 process which i cant end.
    Msg 6107, Level 14, State 1, Line 1
    Only user processes can be killed.

  4. #4
    newpersn's Avatar
    Join Date
    Nov 2010
    Location
    Gloucestershire
    Posts
    1,220
    Thank Post
    281
    Thanked 110 Times in 83 Posts
    Rep Power
    76
    SCCM2012 single user.png

    It now telling me its in single user mode. But wont let me touch it :\

  5. #5
    newpersn's Avatar
    Join Date
    Nov 2010
    Location
    Gloucestershire
    Posts
    1,220
    Thank Post
    281
    Thanked 110 Times in 83 Posts
    Rep Power
    76
    Now im getting these errors. :/

    SQL server is online. its called SCCM2012/CM_CKS


    2013-12-17 10:34:29 Postinstall started
    2013-12-17 10:34:29 Detected role services: Api, Database, UI, Services
    2013-12-17 10:34:29 Start: LoadSettingsFromParameters
    2013-12-17 10:34:29 Content local is: True
    2013-12-17 10:34:29 Content directory is: C:\SOURCES
    2013-12-17 10:34:29 SQL instname is: SCCM2012\CM_CKS
    2013-12-17 10:34:29 End: LoadSettingsFromParameters
    2013-12-17 10:34:29 Start: Run
    2013-12-17 10:34:29 Fetching WsusAdministratorsSid from registry store
    2013-12-17 10:34:29 Value is S-1-5-21-2589001167-4160105790-1896818315-1010
    2013-12-17 10:34:29 Fetching WsusReportersSid from registry store
    2013-12-17 10:34:29 Value is S-1-5-21-2589001167-4160105790-1896818315-1011
    2013-12-17 10:34:30 Configuring content directory...
    2013-12-17 10:34:30 Configuring groups...
    2013-12-17 10:34:30 Starting group configuration for WSUS Administrators...
    2013-12-17 10:34:30 Found group in regsitry, attempting to use it...
    2013-12-17 10:34:32 Writing group to registry...
    2013-12-17 10:34:32 Finished group creation
    2013-12-17 10:34:32 Starting group configuration for WSUS Reporters...
    2013-12-17 10:34:32 Found group in regsitry, attempting to use it...
    2013-12-17 10:34:32 Writing group to registry...
    2013-12-17 10:34:32 Finished group creation
    2013-12-17 10:34:32 Configuring permissions...
    2013-12-17 10:34:32 Fetching content directory...
    2013-12-17 10:34:32 Fetching ContentDir from registry store
    2013-12-17 10:34:32 Value is C:\SOURCES
    2013-12-17 10:34:32 Fetching group SIDs...
    2013-12-17 10:34:32 Fetching WsusAdministratorsSid from registry store
    2013-12-17 10:34:32 Value is S-1-5-21-2589001167-4160105790-1896818315-1010
    2013-12-17 10:34:32 Fetching WsusReportersSid from registry store
    2013-12-17 10:34:32 Value is S-1-5-21-2589001167-4160105790-1896818315-1011
    2013-12-17 10:34:32 Creating group principals...
    2013-12-17 10:34:32 Granting directory permissions...
    2013-12-17 10:34:32 Granting permissions on content directory...
    2013-12-17 10:34:32 Granting registry permissions...
    2013-12-17 10:34:32 Granting registry permissions...
    2013-12-17 10:34:32 Granting registry permissions...
    2013-12-17 10:34:32 Configuring shares...
    2013-12-17 10:34:32 Configuring network shares...
    2013-12-17 10:34:32 Fetching content directory...
    2013-12-17 10:34:32 Fetching ContentDir from registry store
    2013-12-17 10:34:32 Value is C:\SOURCES
    2013-12-17 10:34:32 Fetching WSUS admin SID...
    2013-12-17 10:34:32 Fetching WsusAdministratorsSid from registry store
    2013-12-17 10:34:32 Value is S-1-5-21-2589001167-4160105790-1896818315-1010
    2013-12-17 10:34:32 Content directory is local, creating content shares...
    2013-12-17 10:34:32 Creating share "UpdateServicesPackages" with path "C:\SOURCES\UpdateServicesPackages" and description "A network share to be used by client systems for collecting all software packages (usually applications) published on this WSUS system."
    2013-12-17 10:34:32 Deleting existing share...
    2013-12-17 10:34:32 Creating share...
    2013-12-17 10:34:32 Share successfully created
    2013-12-17 10:34:32 Creating share "WsusContent" with path "C:\SOURCES\WsusContent" and description "A network share to be used by Local Publishing to place published content on this WSUS system."
    2013-12-17 10:34:32 Deleting existing share...
    2013-12-17 10:34:33 Creating share...
    2013-12-17 10:34:33 Share successfully created
    2013-12-17 10:34:33 Creating share "WSUSTemp" with path "C:\Program Files\Update Services\LogFiles\WSUSTemp" and description "A network share used by Local Publishing from a Remote WSUS Console Instance."
    2013-12-17 10:34:33 Deleting existing share...
    2013-12-17 10:34:33 Creating share...
    2013-12-17 10:34:33 Share successfully created
    2013-12-17 10:34:33 Finished creating content shares
    2013-12-17 10:34:33 Stopping service WSUSService
    2013-12-17 10:34:33 Stopping service W3SVC
    2013-12-17 10:34:33 Configuring database...
    2013-12-17 10:34:33 Configuring the database...
    2013-12-17 10:34:33 Establishing DB connection...
    2013-12-17 10:35:32 System.Data.SqlClient.SqlException (0x80131904): A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)
    at System.Data.SqlClient.SqlInternalConnection.OnErro r(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
    at System.Data.SqlClient.TdsParser.ThrowExceptionAndW arning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
    at System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, Boolean withFailover)
    at System.Data.SqlClient.SqlInternalConnectionTds.Att emptOneLogin(ServerInfo serverInfo, String newPassword, SecureString newSecurePassword, Boolean ignoreSniOpenTimeout, TimeoutTimer timeout, Boolean withFailover)
    at System.Data.SqlClient.SqlInternalConnectionTds.Log inNoFailover(ServerInfo serverInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString connectionOptions, SqlCredential credential, TimeoutTimer timeout)
    at System.Data.SqlClient.SqlInternalConnectionTds.Ope nLoginEnlist(TimeoutTimer timeout, SqlConnectionString connectionOptions, SqlCredential credential, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance)
    at System.Data.SqlClient.SqlInternalConnectionTds..ct or(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, SqlCredential credential, Object providerInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString userConnectionOptions, SessionData reconnectSessionData)
    at System.Data.SqlClient.SqlConnectionFactory.CreateC onnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions)
    at System.Data.ProviderBase.DbConnectionFactory.Creat ePooledConnection(DbConnectionPool pool, DbConnection owningObject, DbConnectionOptions options, DbConnectionPoolKey poolKey, DbConnectionOptions userOptions)
    at System.Data.ProviderBase.DbConnectionPool.CreateOb ject(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection)
    at System.Data.ProviderBase.DbConnectionPool.UserCrea teRequest(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection)
    at System.Data.ProviderBase.DbConnectionPool.TryGetCo nnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection)
    at System.Data.ProviderBase.DbConnectionPool.TryGetCo nnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection)
    at System.Data.ProviderBase.DbConnectionFactory.TryGe tConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection)
    at System.Data.ProviderBase.DbConnectionInternal.TryO penConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions)
    at System.Data.SqlClient.SqlConnection.TryOpenInner(T askCompletionSource`1 retry)
    at System.Data.SqlClient.SqlConnection.TryOpen(TaskCo mpletionSource`1 retry)
    at System.Data.SqlClient.SqlConnection.Open()
    at Microsoft.UpdateServices.DatabaseAccess.DBConnecti on.Connect(String connectionString)
    at Microsoft.UpdateServices.DatabaseAccess.DBConnecti on.Connect()
    at Microsoft.UpdateServices.Administration.ConfigureD B.CreateDBConnection()
    at Microsoft.UpdateServices.Administration.ConfigureD B.ConnectToDB()
    at Microsoft.UpdateServices.Administration.ConfigureD B.Configure()
    at Microsoft.UpdateServices.Administration.PostInstal l.Run()
    at Microsoft.UpdateServices.Administration.PostInstal l.Execute(String[] arguments)
    ClientConnectionId:00000000-0000-0000-0000-000000000000

  6. #6
    newpersn's Avatar
    Join Date
    Nov 2010
    Location
    Gloucestershire
    Posts
    1,220
    Thank Post
    281
    Thanked 110 Times in 83 Posts
    Rep Power
    76
    Anyone??

SHARE:
+ Post New Thread

Similar Threads

  1. Problems with WSUS. Doesnt know whether its there or not!
    By superatticman in forum Windows Server 2000/2003
    Replies: 7
    Last Post: 30th May 2012, 05:35 PM
  2. Squid with on a Win2008 R2 server problems
    By FatBoy in forum Internet Related/Filtering/Firewall
    Replies: 6
    Last Post: 30th September 2010, 02:29 PM
  3. [SCCM 2007] SCCM 2007 R2 with SQL Tech
    By beardy in forum O/S Deployment
    Replies: 0
    Last Post: 27th April 2010, 04:52 PM
  4. Problems with WSUS failing to download updates
    By srochford in forum Windows
    Replies: 0
    Last Post: 2nd July 2008, 10:00 PM
  5. Multiple SQL Apps on same server with WSUS installed
    By ITWombat in forum Educational Software
    Replies: 3
    Last Post: 8th May 2006, 07:14 AM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •