Category Archives: Fix IT

How to fix stuff

SQL Services event ID 7000 and 7009

Problem: Reporting Services and Integration Services do not start any more . Error :A timeout was reached (30000 milliseconds) while waiting for the SQL Server Reporting Services (SQL1) service to connect. Error: The SQL Server Reporting Services (SQL1) service failed … Continue reading

Posted in Fix IT | Tagged , | Comments Off on SQL Services event ID 7000 and 7009

DNS Reverslookup Nameserver remove hangup

Problem While cleaning up nameserver entries in reverse lookup scopes dns GUI shows a popup asking ” Do you want to delete the glue record” and hangs. Solution

Posted in Fix IT, Information Technology | Tagged , , | Comments Off on DNS Reverslookup Nameserver remove hangup

File open – Security Warning

Problem Starting an application shows a popup with a question whether to start the file or not as the source oft the file is Internet. The file itself is located on a server defined as safe place within the organization. … Continue reading

Posted in Fix IT, Information Technology | Tagged , | Comments Off on File open – Security Warning

SCOM 2012 Gateway installation error

Problem: Running > MICROSOFT.ENTERPRISEMANAGEMENT.GATEWAYAPPROVALTOOL.EXE /ManagementServerName=msserver.domain /GatewayName=gwserver.domain /action=create < is ending in an error Unhandled Exception: System.IO.FileNotFoundException: Could not load file or assembly ‘Microsoft.EnterpriseManagement.DataAccessLayer, Version=7.0.5000.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35’ or one of its dependencies. The system cannot find the file specified.File name: ‘Microsoft.EnterpriseManagement.DataAccessLayer, … Continue reading

Posted in Fix IT | Tagged | Comments Off on SCOM 2012 Gateway installation error

SQL alias connection refused from remote system

Situation: There is an SQL 2012 server and a view remote Server requiting Connection to to this SQL  database Server. Problem / Error: No connection could be made because the target machine actively refused it. SQL Server with alias shows an … Continue reading

Posted in Fix IT | Tagged | Comments Off on SQL alias connection refused from remote system

Terminal Server HKCU Registry Keys contain old values

Problem: Some Registry keys in HKCU change back to an old value Reason: Long ago an installation was not correct terminated with “change user /execute”. So settings stayed in Registry as Master. (Shadow) Solution: Check HKEY_LOCAL_MACHINE\Software\Microsoft\Windows NT\CurrentVersion\Terminal Server\Install\Software or HKEY_LOCAL_MACHINE\Software\Wow6432Node\Microsoft\Windows … Continue reading

Posted in Fix IT, Information Technology | Tagged , , | Comments Off on Terminal Server HKCU Registry Keys contain old values

SQL Security : Restore User Mapping Database & SQL Management relation

To detect orphaned users, execute the following Transact-SQL statements per database: USE <database_name>;GO;sp_change_users_login @Action=’Report’;GO; Possible Response The output lists the users and corresponding security identifiers (SID) in the current database that are not linked to any SQL Server login. For … Continue reading

Posted in Fix IT, Information Technology | Tagged | Comments Off on SQL Security : Restore User Mapping Database & SQL Management relation