Category Archives: Fix IT

How to fix stuff

DNS Reverslookup Nameserver remove hangup

Posted on 2013/11/21 by maoeh

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

Posted on 2013/10/30 by maoeh

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

Posted on 2013/10/21 by maoeh

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

Posted on 2013/10/08 by maoeh

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

Posted on 2013/10/02 by maoeh

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

Posted on 2013/09/30 by maoeh

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

TempDB SQL 2012 splitting

Posted on 2013/09/30 by maoeh

Open SQL Management Studio.Disconnect all server connections.Leave GUI open as we need the Query Analizer stop all SQL services open services by running service.msc open properties of the sql instance and copy the sql executing pathC:\Program Files\Microsoft SQL Server\MSSQL11.SQL1\MSSQL\Binn\sqlservr.exe -c … Continue reading →

Posted in Fix IT, Information Technology | Tagged | Comments Off on TempDB SQL 2012 splitting