newpersn Posted December 16, 2013 Posted December 16, 2013 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.DBConnection.DrainObsoleteConnections(SqlException e) at Microsoft.UpdateServices.DatabaseAccess.DBConnection.ExecuteCommandNoResult() at Microsoft.UpdateServices.Administration.ConfigureDB.ConnectToDB() at Microsoft.UpdateServices.Administration.ConfigureDB.Configure() at Microsoft.UpdateServices.Administration.PostInstall.Run() at Microsoft.UpdateServices.Administration.PostInstall.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?
CHR1S Posted December 16, 2013 Posted December 16, 2013 WebHostRepo Blog - How to remove SQL Server database from single-user mode
newpersn Posted December 16, 2013 Author Posted December 16, 2013 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.
newpersn Posted December 17, 2013 Author Posted December 17, 2013 It now telling me its in single user mode. But wont let me touch it :\
newpersn Posted December 17, 2013 Author Posted December 17, 2013 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.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction) at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(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.AttemptOneLogin(ServerInfo serverInfo, String newPassword, SecureString newSecurePassword, Boolean ignoreSniOpenTimeout, TimeoutTimer timeout, Boolean withFailover) at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(ServerInfo serverInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString connectionOptions, SqlCredential credential, TimeoutTimer timeout) at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(TimeoutTimer timeout, SqlConnectionString connectionOptions, SqlCredential credential, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance) at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, SqlCredential credential, Object providerInfo, String newPassword, SecureString newSecurePassword, Boolean redirectedUserInstance, SqlConnectionString userConnectionOptions, SessionData reconnectSessionData) at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection, DbConnectionOptions userOptions) at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnectionPool pool, DbConnection owningObject, DbConnectionOptions options, DbConnectionPoolKey poolKey, DbConnectionOptions userOptions) at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection) at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject, DbConnectionOptions userOptions, DbConnectionInternal oldConnection) at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, UInt32 waitForMultipleObjectsTimeout, Boolean allowCreate, Boolean onlyOneCheckConnection, DbConnectionOptions userOptions, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionPool.TryGetConnection(DbConnection owningObject, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions) at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource`1 retry) at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource`1 retry) at System.Data.SqlClient.SqlConnection.Open() at Microsoft.UpdateServices.DatabaseAccess.DBConnection.Connect(String connectionString) at Microsoft.UpdateServices.DatabaseAccess.DBConnection.Connect() at Microsoft.UpdateServices.Administration.ConfigureDB.CreateDBConnection() at Microsoft.UpdateServices.Administration.ConfigureDB.ConnectToDB() at Microsoft.UpdateServices.Administration.ConfigureDB.Configure() at Microsoft.UpdateServices.Administration.PostInstall.Run() at Microsoft.UpdateServices.Administration.PostInstall.Execute(String[] arguments) ClientConnectionId:00000000-0000-0000-0000-000000000000
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now