Tuesday, November 25, 2014

Event ID: 3041 BACKUP failed to complete the command BACKUP LOG <database name>

Issue:
Error in Application log:
Event ID: 3041 BACKUP failed to complete the command BACKUP LOG <databasename>. Check the backup application log for detailed messages.
Source: MSSQL$SQLEXPRESS

Cause:
This issue happens when the db-backupoperator does not have backup permission on the problematic database. Follow the below procedure the solve the issue.

Solution:
  1. Login to the server were the above mentioned problematic database is installed.
  2. Open SQL Server management studio (SSMS) and login as domain Admin.
  3. Then expand the Security folder > Expand Logins then select and right click NT AUTHORITY/SYSTEM account > click properties.
  4. On the properties tab select User Mapping > click problematic database and put a check mark > then select 'db-backupoperator' and put a tick mark, click Ok. See the example screenshot below.
  5. Close the SSMS  console.
image

Monday, November 24, 2014

Remove Rogue DHCP Authorized server from DHCP authorized list.

Some time we can see multiple DHCP server in the Manage Authorized Servers list of DHCP console, which is already removed from the domain. Before removing this make sure the IP address or server name is not present in AD or DNS. To remove this rogue DHCP server please follow the below steps.
  1. Run the command to display the authorized server >netsh dhcp show server, then note the full FQDN server name and ip address and perform the following steps.
  2. Type Net stop dhcpserver .
  3. Netsh DHCP delete server Full server name IP address. Eg: C:\> netsh dhcp delete server Server-001.test.internal 192.168.0.10
  4. Type Net start dhcpserver
  5. Reboot the server and and check if it is displaying in the authorized list.
But if the old server still in the list then need to perform the below mentioned steps in Adsiedit:
  1. Start Adsiedit.msc.
  2. Right click ADSI Edit > click connect to > then select Configuration from select a well known naming context drop down list.
  3. Expand the Configuration [Server Name] Container > then expand Services.
  4. Select Net Services.
  5. On the right hand side select record named CN=DHCPRoot.
  6. Right Click the CN=DhcpRoot entry and then click Properties.
  7. Highlight DhcpServers Attribute then click Edit button.
  8. Highlight the entry with the rogue Domain name in the value box and click Remove. Click OK to close DHCPServers editors screen.
  9. Once deleted the DHCPServers value will be displayed as not set.
  10. Save the change by clicking OK and close Adsiedit.
  11. Restart the DHCP server service.
  12. Once you have restarted the DHCP Server service, run the following command: Netsh DHCP show server to confirm the old value is no longer displaying.

Wednesday, November 12, 2014

Adding sites to Internet Explorer 11 compatibility list via GPO

As per Microsoft Internet Explorer 11 no longer supports these Group Policy settings:
http://technet.microsoft.com/en-us/library/dn321453.aspx
  • Turn on Internet Explorer 7 Standards Mode
  • Turn off Compatibility View button
  • Turn off Quick Tabs functionality
  • Turn off the quick pick menu
  • Use large icons for command buttons

Adding web site to Compatibility View List via GPO for IE 11.

1. In Windows 2008/2012 DC, open IE and add the web site to the Compatibility View Settings list.

2. Verify the setting in the registry key path HKEY_CURRENT_USER\Software\Microsoft\Internet Explorer\BrowserEmulation\ClearableListData\UserFilter

3. Open Group Policy Management Console by going to Administrative tools -> Group Policy management and select the User policy to edit.

4. Choose either Computer configuration or User Configuration.

5. Computer or User Configuration->Preference->Windows Setting->Registry.

6. Right click Registry and select New-> select Registry Wizard.

7. Select Local Machine and then check HKEY_CURRENT_USER\Software\Microsoft\Internet Explorer\BrowserEmulation\ClearableListData\UserFilter as below.
clip_image002

8. Click Finish.

9. Run gpupdate /force in DC.

10. Run gpupdate /force in a client machine or re-login.

11. You can check the registry key value in client machine and check in IE.










Thursday, November 6, 2014

Extending Cluster Shared Volumes (CSV) VHD in iSCSI Target Server 2012.

1. Extend LUN using OEM-specific tools in case of SAN.
2.  In case of iSCSI Virtual Disk first you need to extend the partition were iSCSI VHD files reside (in my case D: drive) on the iSCSI Target server.
3. Then go to Server manager -> select File and storage service -> iSCSI
4. Right click the .vhd which need to be extended then select Extend iSCSI Virtual Disk and provide new size.

                             image

5.  After extending LUN Find the CSV Owner which need to be extended by the following steps.
6.   Click Start, Administrative Tools, Failover Cluster Manager.
7.  Connect to the Cluster by clicking Manage Cluster from the MMC action pane
8.  Highlight the Cluster Shared Volumes node, and locate the server name under Current Owner.
9.  Then login to Cluster Owner server and go to Disk management.
10. From Disk management Action Menu -> Click ‘Rescan Disks’ and we can see the unallocated space there.
11. Right click the shared volume Disk and select Extend volume and provide the full unallocated space.
12. After that go to failover cluster and perform a refresh and now you can see the Cluster share volume is extended.

Wednesday, October 15, 2014

Publishing Blogger.com via Windows Live Writer

1. First thing Go to Blogger.com >> Settings >> Email & Mobile >> Posting using Email. By default, this feature is not enabled so first enable it by selecting any of the two options:
clip_image001Publish email immediately: It will publish all the articles which are sent through emails immediately onto your site. There is no second review involved in it. However, if somehow your secrete email address got leaked then, without any permission anyone can publish articles on your site.
clip_image001[1] Save emails as draft post: This function will not publish your articles immediately. In fact, all the post that your site will receive would be moved to the draft area. However, after reviewing you can  publish them as per the need.
                   clip_image002
Now to post to your blogger site through emails you have to generate a secrete email address for your site. I will prefer you to enter some illogical terms i.e. A54SXvg@example.com, zZnF4B@example.com, etc so nobody can guess them. After inserting your secrete word, hit the Save Button to conclude.
2. Go to your Gmail account, then take the Account details from the top right corner > then on the Security page Enable “Access for less secure apps”.
3. After that disable 2 step verification from the Security page. Logoff and login again to confirm.
4. Now try to login in Windows Live Writer and it will connect successfully.
 
 
 
Note: Courtesy for first step http://www.mybloggerlab.com/2013/02/how-to-publish-posts-to-blogger-remotely-through-emails.html




Friday, October 3, 2014

Event ID: 1310 Source: ASP.NET 2.0.50727.0

Issue: WSUS and other MMC console will fail to list the content's. The root cause of this issue is an ASP.Net error with Event ID: 1310. Detailed Event ID is here.


Event ID: 1310
Event message: A compilation error has occurred.
Source: ASP.NET 2.0.50727.0
error CS0016: Could not write to output file 'c:\Windows\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files\simpleauthwebservice\b1f83e7a\9a274e9f\App_global.asax.ar_utinm.dll' -- 'The file exists. '


Solution:

1. If there is more than 65535 files in your temp folder, the method GetTempFileName will throw this error.
2. Clear all the temp files in C:\Windows\temp folder which will now allow the Asp.net temp file to write in the temp folder.





Thursday, October 2, 2014

Configuring Remote connection to SQL Server

Normally it is recommended to have the SQL server installed on the Local machine were you have to use it, but there are cases were you should install it on another machine and install application which is using SQL on another machine, like using VAMT tools. We can follow the below procedure to configure it.
  1. Log on to the server were your current SQL instance in configured. 
  2. From the Start menu choose All Programs -> Microsoft SQL Server 2008 R2 -> Configuration Tools. 
  3. In the left-hand pane of the SQL Server Configuration Manager -> expand the SQL Server Network Configuration node. 
  4. Select the Protocols for [INSTANCE NAME] node (depends on the name of your SQL instance). 
  5. In the right-hand pane, right-click TCP/IP and choose Enable. 
  6. Then restart the SQL Server service as below. 
  7. In the left-hand pane of the SQL Server Configuration Manager, select SQL Server Services. 
  8. In the right-hand pane, right-click the SQL Server service representing your SQL Instance and choose Restart. 
  9. Close the SQL Server Configuration Manager.
  10. Now from the Windows Start Menu choose All Programs -> Microsoft SQL Server 2008 R2 -> SQL Server Management Studio. 
  11. In the left-hand pane of the SQL Server Management Studio, right-click on the SQL instance [SERVERNAME]\[INSTANCENAME]and choose Properties. 
  12. In the left-hand pane of the Server Properties window, select Connections. 
  13. Enable the 'Allow remote connections to this computer' tick box and click OK. 
  14. Close the SQL Server Management Studio. 
  15. Restart the SQL Server service as mentioned above step 6 to 9.

Wednesday, October 1, 2014

Installing and Configuring VAMT 3.0


VAMT is designed to manage volume activation for: Windows Vista, Windows 7, Windows 8, Windows 8.1, Windows Server 2008, Windows Server 2008 R2, Windows Server 2012, Windows Server 2012 R2, Microsoft Office 2010, and Microsoft Office 2013. Computers installed with volume editions of Windows XP or Windows Server 2003 cannot be managed using VAMT. However, Office 2010 and Office 2013 products installed on these two operating systems can still be managed. 

For further information please follow Microsoft technet article. 


Download VAMT 3: https://www.microsoft.com/en-us/download/details.aspx?id=39982


  1. Remove previously installed VAMT 2.0 from your server (if installed).
  2. Download the tool from the above Microsoft Downloads link and install this on to one of your domain controllers/or a workstation (the tool needs to gather information from the Active Directory). 
  3. It will download adksetup.exe then double click it.
  4. In Specify location window chose the first option to download and install the Assessment and Deployment Kit in this computer.
  5. Select No on next screen -> next -> click Accept and on the 'Select the feature window' Deselect all the other and select only Volume Activation management Tool (VAMT) and Microsoft SQl server 2012 express.
  6. If you have any previous SQL express version or need to access the remote SQL then leave the sql 2012 express, if not select SQL express 2012 also.
  7. Then click install.
  8. After the installation is finished and you open the VAMT tool for the first time you need to specify a database, select the Server, then select   and just type the name of the new database. Type VAMT as database name. To configure remote SQL server follow steps mentioned in "For Remote SQLExpress access".
  9. The default database name will be ADK by default, VAMT is configured to use an SQL database that is installed on the local machine during ADK setup and displays the server name as .\ADK.
  10. On the right pane window right click the Products and select discover products.
  11. In Discover product window select "Search for computers in active directory" and provide the daomin name in Domain filter criteria.
  12. Select the required products and on the right side window select the computers to activate.
  13. Then right click the computer name (you can select multiple computers also) then select ->update license status -> select current credential.
  14. Now it will update the product information and the computers will be available in its corresponding product list (eg: for office it will be listed in Office products and windows 7 in Windows list).
  15. If you are using the connection without any proxy server you can select Online activate -> current credential. If using proxy follow below step.
  16. Then right click the computer in the products and then select Activate -> Proxy activate -> Choose the option "Acquire confirmation ID, apply to selected machines(s) and activate". (Do not enable the tick mark below.)
  17. Click Ok, It will activate the product.