Thursday, 4 September 2014

Произошла исключительная ситуация (Microsoft Office Excel) Метод SaveAs из Класса Workbook завершен неверно


Ошибка:
"Произошла исключительная ситуация (Microsoft Office Excel): Метод SaveAs из Класса Workbook завершен неверно."

Решение:
У меня на Windows Server 2008 R2 помогло создание двух папок:
C:\Windows\SysWOW64\config\systemprofile\Desktop
C:\Windows\System32\config\systemprofile\Desktop

t-sql скрипт сжатия журнала транзакций


Иногда не получается сжать журнал транзакций через SSMS, в такие моменты очень выручит данный скрипт. Его можно использовать как при запросе в консоле, так и в планировщике SSMS

USE rstv_trade;
GO
ALTER DATABASE rstv_trade
SET RECOVERY SIMPLE;
GO
DBCC SHRINKFILE (rnd_trade_log, 30000);
GO
ALTER DATABASE rstv_trade
SET RECOVERY FULL;
GO

где:
-rstv_trade -логическое имя базы.
-30000 размер журнала в МБ.

Wednesday, 3 September 2014

Задача сообщила об ошибке (0x8004010F) Сбой операции Невозможно найти объект

Ошибка:Задача сообщила об ошибке (0x8004010F) : 'Сбой операции. Невозможно найти объект.'

Возможное решение:
В моем случае помогло отсоединение адресных книг и/или отсоединения pst файлов с данными. Так же можно перенести данные из старого в новый pst файл.

Friday, 6 June 2014

зависла служба

Проблема: Зависла служба
 
Решение:
sc queryex spooler
Теперь когда мы узнали PID можем убить нужный процесс
taskkill /f /pid [PID]

Tuesday, 14 January 2014

Reset password cisco asa 5505

In this article, I'll explain how to perform a password "reset" on your Cisco ASA security appliance. The more commonly used term for this procedure is "password recovery" which is left over from the days when you could actually view passwords in configuration files in plain text. Today, such passwords are encrypted and not actually recoverable. Instead, you will gain access to the appliance via the console port and reset the password(s) to known values.
This procedure requires physical access to the device. You will power-cycle your appliance by unplugging it at the power strip and plugging it back in. You will then interrupt the boot process and change the configuration register value to prevent the appliance from reading its stored configuration at boot. Since the device ignores its saved configuration on boot, you are able to access its configuration modes without passwords. Once you're in configuration mode, you will load the saved configuration from flash memory, change the passwords to a known value, change the configuration register value to tell the device to load its saved configuration on boot, and reload the device.
Caution: As with all configuration procedures, these procedures should be tested in a laboratory environment prior to usage in a production environment to ensure suitability for your situation.
The following steps were designed using a Cisco ASA 5505 Security Appliance. They are not appropriate for a Cisco PIX Firewall appliance.
1. Power-cycle your security appliance by removing and re-inserting the power plug at the power strip.
2. When prompted, press Esc to interrupt the boot process and enter ROM Monitor mode. You should immediately see a rommon prompt (rommon #0>).
3. At the rommon prompt, enter the confreg command to view the current configuration register setting: rommon #0>confreg
4. The current configuration register should be the default of 0x01 (it will actually display as 0x00000001). The security appliance will ask if you want to make changes to the configuration register. Answer no when prompted.
5. You must change the configuration register to 0x41, which tells the appliance to ignore its saved (startup) configuration upon boot: rommon #1>confreg 0x41
6. Reset the appliance with the boot command: rommon #2>boot
7. Notice that the security appliance ignores its startup configuration during the boot process. When it finishes booting, you should see a generic User Mode prompt: ciscoasa>
8. Enter the enable command to enter Privileged Mode. When the appliance prompts you for a password, simply press (at this point, the password is blank): ciscoasa>enable Password: ciscoasa#
9. Copy the startup configuration file into the running configuration with the following command: ciscoasa#copy startup-config running-config Destination filename [running-config]?
10. The previously saved configuration is now the active configuration, but since the security appliance is already in Privileged Mode, privileged access is not disabled. Next, in configuration mode, enter the following command to change the Privileged Mode password to a known value (in this case, we'll use the password system): asa#conf t asa(config)#enable password system
11. While still in Configuration Mode, reset the configuration register to the default of 0x01 to force the security appliance to read its startup configuration on boot: asa(config)#config-register 0x01
12. Use the following commands to view the configuration register setting: asa(config)#exit asa#show version
13. At bottom of the output of the show version command, you should see the following statement: Configuration register is 0x41 (will be 0x1 at next reload)
14. Save the current configuration with the copy run start command to make the above changes persistent: asa#copy run start Source filename [running-config]
15. Reload the security appliance: asa# reload System config has been modified. Save? [Y]es/[N]o:yes
Cryptochecksum: e87f1433 54896e6b 4e21d072 d71a9cbf
2149 bytes copied in 1.480 secs (2149 bytes/sec) Proceed with reload? [confirm]
When your security appliance reloads, you should be able to use your newly reset password to enter privileged mode.
Copyright (c) 2007 Don R. Crawley

Wednesday, 25 December 2013

полезности

проверка совместимости железа с гипервизором
http://www.vmware.com/resources/compatibility/search.php

Thursday, 28 November 2013

Проброс SSL 443 на нестандартный порт в TMG 2010

Когда нужно прокинуть не стандартный порт можно использовать утилиту.
ISAtpre или js скрипт. гугл легко находит оба.
http://www.isaserver.org/articles-tutorials/articles/2004tunnelportrange.html