Author Archives: maoeh

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

Read and change Active Synch profile domain wide

Posted on 2013/10/01 by maoeh

To list or change Active Sync profiles from users in a forest use the following Powershell PS1 commands. Run these lines in a Exchange 2010 PS1 box # select the Forest as target set-adServerSettings -viewEntireForest $true # list user with … Continue reading →

Posted in Uncategorized | Tagged , | Comments Off on Read and change Active Synch profile domain wide

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

move user homes to an other drive using a link

Posted on 2012/08/28 by maoeh

If you don’t like to have your homes on C: . Boot your computer using your installation CD and change to a command line prompt. Check where your drives are now. For this example lets say boot disk C: is on … Continue reading →

Posted in Uncategorized | Tagged , | Comments Off on move user homes to an other drive using a link

Cleanup windows 7 disk

Posted on 2012/08/28 by maoeh

To cleanup a disk and remove unused programs start cleanmgr.exe. This small program scans your disk and gives you a choice of items to select from like temporary files, servicepack sources etc.

Posted in Uncategorized | Tagged , | Comments Off on Cleanup windows 7 disk