Microsoft Certified Professional, Microsoft Business Solution Professional, Microsoft Licensing Specialist

posts - 68, comments - 179, trackbacks - 1

Friday, October 26, 2012

Create a custom form in Outlook 2010

Step 1: Create a custom form in Outlook 2010 =========== 1. Click the Developer tab, from the Custom Forms group, choose Design a Form. Note: If you are unable to see the Developer tab, please first show it by this method: Click the File tab. Under Help, click Options. Click Customize Ribbon. Under Customize the Ribbon, select the Developer check box. 2. Choose the Appointment form (Look in "Standard Forms Library") and click Open. 3. Select the All Fields tab, and then se

posted @ Friday, October 26, 2012 8:47 AM | Feedback (3) | Filed Under [ Ostatní ]

Friday, September 21, 2012

How to transfer logins and passwords between instances of SQL Server

Create a log in script in db MASTER USE master GO IF OBJECT_ID ('sp_hexadecimal') IS NOT NULL DROP PROCEDURE sp_hexadecimal GO CREATE PROCEDURE sp_hexadecimal @binvalue varbinary(256), @hexvalue varchar (514) OUTPUT AS DECLARE @charvalue varchar (514)

posted @ Friday, September 21, 2012 11:20 AM | Feedback (0) | Filed Under [ Microsoft SQLServer/Reporting Services ]

Thursday, June 14, 2012

Forefront TMG with EMS - unavailable malware and network inspection system

If you not see the current status in the Update Center Forefront Enterprise Management Server, it is very likely that you have set the same locale on the server with the EMS and Forefront TMG server 2010. Set the same locale and EMS console TMG server status will begin to show.

posted @ Thursday, June 14, 2012 12:22 PM | Feedback (0) | Filed Under [ ISA Server ]

Thursday, June 07, 2012

Přidání druhé a každé další organizace do MS CRM 2011 v případě využívání IFD

V Microsoft Dynamics CRM Deployment Manageru je potřeba přidat organizaci přes: dále dle průvodce. Přidání DNS záznamu do domény contoso.com, dle OrganizationName (např. Company ...) viz screen Poté by mělo fungovat přihlášení přes web https://ORGNAME.xxx.xx:444, ale nebude :-). Microsoft si vymyslel jeste jednu novou future, kterou je potřeba provést díky novému řešení IFD.

posted @ Thursday, June 07, 2012 1:12 PM | Feedback (0) | Filed Under [ Microsoft Dynamics CRM ]

Friday, May 18, 2012

Unable to validate SQL Server Reporting Services Report Server installation. Please check that it is correctly installed on the local machine.

Unable to validate SQL Server Reporting Services Report Server installation. Please check that it is correctly installed on the local machine. Modify the Install-config.xml file 1.Copy all the files in the SrsDataConnector folder on the installation CD to a folder on drive C. For example, copy the files to the following folder: C:\SrsDataConnector Note The SrsDataConnector folder is located in the following folder on the installation CD: drive:\Server\i386 The drive placeholder represent

posted @ Friday, May 18, 2012 10:10 PM | Feedback (0) | Filed Under [ Microsoft Dynamics CRM ]

Friday, January 06, 2012

How to find data types in Microsoft SQL Server

To find the data types in SQL Server can take advantage of the Transact-SQL script: SELECT DISTINCT QUOTENAME(OBJECT_SCHEMA_NAME([object_id])) + '.' + QUOTENAME(OBJECT_NAME([object_id])) FROM sys.columns WHERE [system_type_id] = 98; .............

posted @ Friday, January 06, 2012 8:42 AM | Feedback (1) | Filed Under [ Microsoft SQLServer/Reporting Services ]

Tuesday, November 15, 2011

USB support for ESX/ESXi 4.1

USB support for ESX/ESXi 4.1 ESX 4.1 supports USB device passthrough from an ESX or ESXi to a virtual machine. This article provides information about USB device passthrough requirements and limitations, as well as steps to add a USB controller and a USB device.

posted @ Tuesday, November 15, 2011 2:35 PM | Feedback (0) | Filed Under [ Ostatní VMWare ]

Thursday, August 25, 2011

Restart windows services without admin rights

Pro případ, že potřebujete aby měl uživatel právo restartovat windows services např. právě pro IIS (nebo i jiné) je potřeba provést následující kroky: 1. Stáhnout aplikaci SubInACL z webu MS - http://www.microsoft.com/downloads/details.aspx?familyid=E8BA3E56-D8FE-4A91-93CF-ED6985E3927B&displaylang=en 2. Nainstalovat aplikaci 3. Spustit příkaz subinacl /service serviceName /grant=domain1\user1 = TO

posted @ Thursday, August 25, 2011 10:17 AM | Feedback (0) | Filed Under [ Windows ]

IIS Management without admin rights

IIS Management Stačí v rámci role aplikačního serveru doinstalovat tento modul – Management Service A následně je potřeba nastavit potřebná oprávnění pro windows účet k tomu definovaný viz:

posted @ Thursday, August 25, 2011 10:07 AM | Feedback (0) | Filed Under [ IIS - Internet Information Services Windows ]

Friday, August 19, 2011

Microsoft Message Queue - Permission denied

V případě, že se nejste schopen dostat a změnit nastavení Microsoft Message Queue na Security tabu, je potřeba provést následující kroky: 1. Vytvořit si novou, nebo použít jinou plně funkční queue, kde jste schopni editovat Security tab 2. Stop MSMQ Service 3. Otevřete folder C:\WINDOWS\system32\msmq\storage\lqs 4. Otevřete soubory pomocí notepadu a najděte nefunkční queue s Security tabem

posted @ Friday, August 19, 2011 10:57 AM | Feedback (0) | Filed Under [ Windows ]

Saturday, June 11, 2011

How to backup Sharepoint in Data Protection Manager 2010

Pro potřeby zálohování a Item-Level recovery Sharepoint v DPM 2010 je potřeba provést následující kroky: Instalace DPM agenta na srv s Sharepointem Na klientovi Sharepoint s DPM agentem spusťte příkaz %programfiles%\Microsoft Data Protection Manager\DPM\bin\ConfigureSharepoint.exe –enableSharepointProtection Při spuštění budete požádání o zadání přihašovacích údajů na Sharepoint pod účtem s právy Farm Admina Sharepointu (není potřeba aby se jednalo o lokálního administrátora

posted @ Saturday, June 11, 2011 12:50 AM | Feedback (1) | Filed Under [ Ostatní ]

Thursday, June 02, 2011

How to retrieve a result set of all tables in the DB with their disk space usage

with this transact sql script:

create table #Temp (
    name nvarchar(128),
    [rows] char(11),
    reserved varchar(18),
    data varchar(18),
    index_size varchar(18),
    unused varchar(18)
)

insert into #Temp
    exec sp_msforeachtable 'sp_spaceused ''?'''

select * from #Temp order by cast(replace(reserved,' kb','') as int) desc

posted @ Thursday, June 02, 2011 12:30 PM | Feedback (4) | Filed Under [ Microsoft SQLServer/Reporting Services ]

Tuesday, May 31, 2011

VPN connection fails on Windows Vista client

VPN connection fails on Windows Vista client: "Error 609: A device type was specfied that does not exit" On a Windows Vista computer, you are unable to establish a connection to the VPN server. The following symptoms occur: 1. After you enter the username and password for the VPN connection, it tries to connect for a while then the error message occurs: Failed to connect to 2. If you create a new VPN connection, it shows as a Dial-up connection. 3. This event is log

posted @ Tuesday, May 31, 2011 1:32 PM | Feedback (2) | Filed Under [ Windows ]

Thursday, May 26, 2011

The base class includes the field 'reportViewer', but its type (Microsoft.Reporting.WebForms.ReportViewer) is not compatible with the type of control (Microsoft.Reporting.WebForms.ReportViewer)

This error is generated after update related in some way with reports of Microsoft SQL Server Reporting Services, or their parts.

To remedy sufficient to modify the existing applications web.config. This is a key value or a reference to the library - Microsoft.ReportViewer.WebForms, which may be in some versions such as version = 9.0.0.0, 8.0.0.0, and so on.

To re-operation reports is a need to return to the previous value. For example, from version 9.0.0.0 to version 8.0.0.0 etc.

posted @ Thursday, May 26, 2011 3:24 PM | Feedback (1) | Filed Under [ Microsoft SQLServer/Reporting Services Microsoft Dynamics CRM ]

Wednesday, May 25, 2011

A macro that is contained in an encrypted Office Open XML file does not run in 2007 Office programs

In one of the 2007 Microsoft Office programs that are listed in the "Applies to" section, when you try to run a macro that is contained in an encrypted Office Open XML file, such as an .xlsm file, a .docm file, or a .pptxm file, the macro does not run as expected. An encrypted file is a file that you protect by using any of the following methods: Password protection Information Rights Management (IRM) Workbook protection in Microsoft Office Excel 2007 To resolve this

posted @ Wednesday, May 25, 2011 2:31 PM | Feedback (1) | Filed Under [ Ostatní Windows ]

Wednesday, May 18, 2011

How to change the Visual Studio Build Service Account

After you have changed the account you are using for the Visual Studio Team Foundation Build service, you must configure a new build service account. Stop Visual Studio Team Foundation Build Service Start - Administrative Tools - Services Find service "Visual Studio Team Foundation Build Service" Right-click to Stop service Right-click to Properties

posted @ Wednesday, May 18, 2011 8:45 AM | Feedback (2) | Filed Under [ Ostatní ]

Wednesday, December 08, 2010

Enable xp_cmd_shell on SQL server 2008 or 2008R2

If you need to enable xp_cmd_shell for someone who is not the sysadmin on your SQL Server following is required: 1. run this transact sql commands: EXEC sp_configure 'show advanced options', 1 GO RECONFIGURE GO EXEC sp_configure 'xp_cmdshell', 1 GO RECONFIGURE

posted @ Wednesday, December 08, 2010 9:47 AM | Feedback (3) | Filed Under [ Microsoft SQLServer/Reporting Services ]

Thursday, November 25, 2010

VJSLib.dll - 64bit edition version

Ke stažení zde - http://www.martinfiala.net/download/vjslib_core_nativ_dlls.zip

posted @ Thursday, November 25, 2010 12:57 PM | Feedback (7) | Filed Under [ Ostatní Windows ]

Tuesday, July 20, 2010

Microsoft SQL Server - Forgot the SA Password

Dobrý den, v případě, že jste zapomněli, ztratili nebo nemáte k dispozici heslo pro SA účet na SQL Server a jiný účet s právy System Administrator v SQL Serveru není k dispozici - je zde jedna možnost jak zajistit opět přístup do SQL Serveru pod účtem/právy SA v SQL Serveru a to tato:

posted @ Tuesday, July 20, 2010 9:31 AM | Feedback (4) | Filed Under [ Microsoft SQLServer/Reporting Services ]

Monday, March 08, 2010

The following system error occurred: Logon failure: unknown user name or bad password

Na Microsoft SQL Serveru 2008 a pravděpodobně i verzi 2005 se Vám může zobrazovat hlášení při pokusu o přepočet olap kostky v Analysis Services tato informace: The following system error occurred: "Logon failure: unknown user name or bad password"...........

posted @ Monday, March 08, 2010 2:03 PM | Feedback (3) | Filed Under [ Microsoft SQLServer/Reporting Services ]

Thursday, January 21, 2010

Microsoft CRM and Microsoft SQL Connection Timeout

Tento timeout se může v rámci Microsoft CRm objevovat. Důvodem může být příliš velké množství záznamů v MS CRM, které není schopen server do výchozího časového timeoutu OLEDB pro SQL zobrazit. Tento typ timeoutu má jako svůj průvodní jev výpis chybové hlášky cca po 30 sekundách, což je výchozí timeout OLEDB. Samozřejmě se počítá s tím, že SQL Server je funkční a spuštěn :-).

posted @ Thursday, January 21, 2010 9:24 AM | Feedback (3) | Filed Under [ Microsoft SQLServer/Reporting Services Microsoft Dynamics CRM ]

Thursday, December 17, 2009

At least the setup user needs to be mapped before this organization can be imported

If you have this problem if you upgrade Microsoft Microsoft Dynamics CRM 3.0 to Microsoft Microsoft Dynamics CRM 4.0 and need to do one of the following steps: 1st run the database script - update systemuser set IsDisabled = 0 where DomainName = 'DOMAIN \ user' or 2nd set the user mapping user rights SystemAdministrator the Microsoft Dynamics CRM user with administrator rights on the installed server

posted @ Thursday, December 17, 2009 1:03 PM | Feedback (6) | Filed Under [ Microsoft Dynamics CRM ]

Thursday, October 08, 2009

A dynamic link library (DLL) initialization routine failed.

Tento problém se vyskytuje např. v případě používání cdosys.dll a cdonts.dll. Jedná se o problém ne SQL Serveru ve, kterém se toto objevuje, ale je to problém Windows Serveru 2000/2003. Detailní popis a řešení problému je přesně specifikováno zde - http://support.microsoft.com/kb/941105

posted @ Thursday, October 08, 2009 12:18 PM | Feedback (1) | Filed Under [ Microsoft SQLServer/Reporting Services Windows ]

Monday, August 10, 2009

ID 207 Details: No such interface supported (0x80004002)

Chyba způsobená po instalaci SP1 na Data Protection Manager 2007.

Chyba je následující:
An Unexpected error occurred during a VSS operation. 
ID 207 Details: No such interface supported (0x80004002) 
Recommended action: Retry the operation

Chyba v MSDPMCurr.errlog:
GetDifferentialSoftwareSnapshotMgmt3Interface () failed: (0x80004002)

Přeregistrujte vss_ps.dll na DPM server:
1. Z příkazového řádku spusťte "regsvr32 %windir%\System32\vss_ps.dll"
2. Poté restartujte službu “Volume Shadow Copy” a opakujte krok, který Vám způsobil chybu v DPM
Pokud Vám toto nepomůže, tak vyzkoušejte tento krok KB940032

posted @ Monday, August 10, 2009 9:37 AM | Feedback (4) | Filed Under [ Ostatní Windows ]

Saturday, June 13, 2009

Oracle data connection in Microsoft Visual Studio .NET, Configure Oracle SQL Developer

Instalace konektivity do Visual Studia V průběhu instalace Oracle Dev Tools budete vyzváni na výběr Visual Studia pro které má být instalováno, vyberte všechny verze. Po instalaci Oracle Developer tools pro Visual Studio z adresy http://www.oracle.com/technology/tech/dotnet/tools/index.html se zobrazí tato informace: Run Oracle Providers for ASP. NET SQL scripts located in C:\app\”user”\product\11.1.0\client_1\ASP.NET\SQL directory. Před konfiguraci Visual Studia je potřeba nahrát do

posted @ Saturday, June 13, 2009 12:29 AM | Feedback (24) | Filed Under [ Ostatní ]