One Way without Restart Service

I’ve come across a great way of resetting a SQL server “sa” password if you don’t have it, don’t have an account with sufficient privileges to reset it via SSMS, and most importantly, don’t have to stop the SQL services so processing can continue.fkgqx81huis863c-medium1

All you will need is psexec  (in the sysinternals  toolkit) available here à https://technet.microsoft.com/en-us/sysinternals/pxexec.aspx

Once the tools are extracted to a directory on the server:

Psexec.exe –s –i “{full path to the ssms.exe”}

This will start the SQL Management Studio as the NTSERVICE\SYSTEM account … enter the name of the SQL Server (or localhost) and then you’re in … reset the sa password in there

 

Another way

 

  1. Stop SQL Server Service
  2. Start is with 
    net start MSSQLSERVER /m"SQLCMD"
  3. sqlcmd -SServerName\InstanceName
  4. CREATE LOGIN RecoveryAcct WITH PASSWORD=’TempPass1’
    GO
  5. SP_ADDSRVROLEMEMBER RecoveryAcct,SYSADMIN
    GO
    This was on Microsoft SQL Server 2008 (SP2) – 10.0.4067.0 (X64).
     
VN:F [1.9.22_1171]
Rating: 0.0/10 (0 votes cast)
VN:F [1.9.22_1171]
Rating: 0 (from 0 votes)

MSInotclick2runWhen opening Outlook , the client would sync for about 4 seconds then crash with a “not responding error”

Faulting application name: OUTLOOK.EXE, version: 15.0.4420.1017, time stamp: 0x506734e2

Faulting module name: pstprx32.dll, version: 15.0.4420.1017, time stamp: 0x506732a1

Basics things I tried 

  1. Outlook Safe Mode
  2. Repairs OST’s

Online forums recommended I used these steps:

Steps to Revert for C2R:

Disable Updates:

1. Start Word.

2. Click File, and then click Account.

3. In the Product Information column, click Update Options, and then click Disable Updates.

Right click on the Start button and click Run and type CMD and click OK.

For an Office installation in a 32-bit version of Windows:

cd %programfiles%\Microsoft Office 15\ClientX86

For an Office installation in a 64-bit version of Windows:

cd %programfiles%\Microsoft Office 15\ClientX64

Run the following command to revert to May PU:

officec2rclient.exe /update user updatetoversion=15.0.4615.1002

However the version of office was MSI not Click2Run which meant no officec2rclient.exe!

Lots of people here said this was due to a Corrupt Calendar Entry : http://answers.microsoft.com/en-us/office/forum/office_2013_release-outlook/outlook-2013-constant-crashing/1171be81-86cd-4a9e-a17b-e6f6e151b817 , and again this user did not use the Outlook Calendar

In the end deleting the account and rebuilding OST from scratch fixed this!

VN:F [1.9.22_1171]
Rating: 0.0/10 (0 votes cast)
VN:F [1.9.22_1171]
Rating: 0 (from 0 votes)

SEPM[1]If you have seen the recent news of a Google Engineer reverse engineering Symantec’s Antivirus Kernel Decompresser 

http://www.itnews.com.au/news/symantec-scrambles-to-patch-severe-holes-in-26-products-429907

You will need to update all your Machines Symantec Endpoints to 12.1.7004.6500 ( Update to SEP 12.1 RU6 MP5 ) per Symantec recommendation here

https://www.symantec.com/security_response/securityupdates/detail.jsp?fid=security_advisory&pvid=security_advisory&year=&suid=20160628_00

More details of the patch

https://support.symantec.com/en_US/article.INFO3801.html

To do this on SEPM

*** Important Check for curent Autorestart settings***

  • Login to SEPM
  • Go to the Clients page
  • Select the group your server is in
  • Select the Policies tab at the top
  • Under Settings select General Settings
  • On the Restart Settings tab

First go here : https://symantec.flexnetoperations.com/control/symc/registeranonymouslicensetoken

And enter the license key for your Symantec Endpoint Product ( will start with M! ) can be be found by logging into your Symantec Account

After Download Symantec_Endpoint_Protection_12.1.6_MP5_SEPM_EN.exe

Run the installer on SEPM server ( may need a reboot before and backup of DB ) 

After installing you will have new packages available 

Run through this : http://www.symantec.com/connect/articles/upgrade-clients-sep-121-auto-upgrade-feature

VN:F [1.9.22_1171]
Rating: 0.0/10 (0 votes cast)
VN:F [1.9.22_1171]
Rating: 0 (from 0 votes)

iLO-3-Image[1]On trying to get to it in Firefox I was presented with 

SSL_ERROR_BAD_MAC_ALERT 

On trying to get to it through Chrome I was presented with

This site can’t provide a secure connection

10.0.0.2 uses an unsupported protocol.
ERR_SSL_VERSION_OR_CIPHER_MISMATCH

The client and server don't support a common SSL protocol version or cipher suite. This is likely to be caused when the server needs RC4, which is no longer considered secure.

We tried through CLI : 

load -source http://webserverip/iso/ilo2_229.bin /map1/firmware1

However this was giving us errors for some reason

We found a workaround in Internet Explorer is to disable TLS 1.2 (Tools >
Options > Advanced > UNTICK Use TLS1.2). 

After Restarting IE , it logged us into the ilo , however this was not the stop of the problems , upgrading to the latest firmware 1.57 gave us errors

We had to update to 1.28 first , then we could upgrade to the latest , below is a link to someone has all the links to the correct BIN files

HP ProLiant ILO firmware

VN:F [1.9.22_1171]
Rating: 10.0/10 (1 vote cast)
VN:F [1.9.22_1171]
Rating: 0 (from 0 votes)

 

Default password for console is admin

After setting the IP , you need to reset the management card

Once reset , the http webserver listens , then when you browse to it is displays:

Unable to display webpage after clicking

The card is configured in SSL mode.
Click here to go in HTTPS.

however https:// does not load.

This is due to the low certificate this device uses for https communication ( 512 ) and RSA keys under 1024 bits have been blocked

You can re-enable this on your local PC via the command : 

certutil -setreg chain\minRSAPubKeyBitLength 512

VN:F [1.9.22_1171]
Rating: 3.0/10 (1 vote cast)
VN:F [1.9.22_1171]
Rating: +1 (from 1 vote)

blue-wallpaper_windows_10_hd_2880x1800[1]Had a user that could not open .jpg’s , and when she did it would crash explorer.exe. Trying to change the default programs did not work , and the open with right click in explorer would not display.

Checking Event viewer I had the below

svchost (2148) TILEREPOSITORYS-1-5-21-2633014675-3390063305-1885502253-1001: An attempt to move the file “C:\Users\%username%\AppData\Local\TileDataLayer\Database\EDB.log” to “C:\Users\%username%\AppData\Local\TileDataLayer\Database\EDB0000A.log” failed with system error 183 (0x000000b7): “Cannot create a file when that file already exists. “. The move file operation will fail with error -1022 (0xfffffc02).

I just renamed \AppData\Local\TileDataLayer\Database Folder to \AppData\Local\TileDataLayer\Database.old in Windows and restarted explorer.exe which created a new one straight away , and fixed the issue

VN:F [1.9.22_1171]
Rating: 0.0/10 (0 votes cast)
VN:F [1.9.22_1171]
Rating: 0 (from 0 votes)

WordIf you experience Word freezing when changing fonts this is caused by Office update released on 9th Feb: https://support.microsoft.com/en-us/kb/3114717

Uninstalling it fixes the issue.

You can use Office CAT Tool: https://www.microsoft.com/en-au/download/details.aspx?id=36852 , to find local problems with your Word or Outlook setup

VN:F [1.9.22_1171]
Rating: 0.0/10 (0 votes cast)
VN:F [1.9.22_1171]
Rating: 0 (from 0 votes)

vmware_view_pilot-5132020[1]Recently spun up a new Windows 7 virtual machine on an ESX cluster. After installing VMware Tools and rebooting the machine , the NIC card would stay unconnected. You would tick the connected box , restart the machine and the Tick would untick.

The default port limit on a vSwitch if you don’t use VLAN’s to segment traffic is 120. So when you hit this limit the above happens. I increased the port limit on each host to double. The VSphere client says you need to reboot the host to apply this , but I just vMotioned the machines from one to another which seemed to fix the problem.

VN:F [1.9.22_1171]
Rating: 0.0/10 (0 votes cast)
VN:F [1.9.22_1171]
Rating: 0 (from 0 votes)

Opening OWA produced the following error : A mailbox couldn’t be found for Domain\User. If the problem continues, contact your helpdesk.

Opening Outlook produced  Outlook cannot open the file because it is not associated with the default

Even though the user was in the GAL , Sending a user an email produced the following bounce back:

#554-5.2.1 mailbox disabled 554 5.2.1 STOREDRV.Deliver.Exception:AccountDisabledException.MapiExceptionMailboxDisabled;

Run this after Disabling a Mailbox ( it’s a nightly job otherwise ) 


Get-MailboxDatabase | Clean-MailboxDatabase

 

VN:F [1.9.22_1171]
Rating: 0.0/10 (0 votes cast)
VN:F [1.9.22_1171]
Rating: 0 (from 0 votes)