Manually install the prerequisite updates for Internet Explorer 10

The installation of Internet Explorer 10 requires an Internet connection download a set of prerequisite updates. You may download the prerequisite updates for offline installation of Internet Explorer 10.

The following are the list of prerequisite updates may require a system restart after installation. However, you can safely ignore individual restart requests and just restart the system after all the updates are installed.

1. 2729094 – An update for the Segoe UI symbol font in Windows 7 and in Windows Server 2008 R2 is available

32-bit package: http://go.microsoft.com/fwlink/p/?LinkId=258384
64-bit package: http://go.microsoft.com/fwlink/p/?LinkId=258385

2. 2731771 – An update that provides new APIs for conversion between local time and UTC in Windows 7 or in Windows Server 2008 R2 is available

32-bit package: http://go.microsoft.com/fwlink/p/?LinkId=272350
64-bit package: http://go.microsoft.com/fwlink/p/?LinkId=272351

3. 2533623 – Microsoft Security Advisory: Insecure library loading could allow remote code execution

32-bit package: http://go.microsoft.com/fwlink/p/?LinkId=254721
64-bit package: http://go.microsoft.com/fwlink/p/?LinkId=254722

4. 2670838 -A platform update is available for Windows 7 SP1 and Windows Server 2008 R2 SP1

32-bit package: http://go.microsoft.com/fwlink/p/?LinkId=272353
64-bit package: http://go.microsoft.com/fwlink/p/?LinkId=272354

5. 2786081 – Internet Explorer 10 does not save credentials for a website after you log off from or restart a computer that is running Windows 7 SP1 or Windows Server 2008 R2 SP1

32-bit package: http://go.microsoft.com/fwlink/p/?LinkId=285867
64-bit package: http://go.microsoft.com/fwlink/p/?LinkId=285866

Understanding SPMinuteSchedule.BeginSecond property and SPMinuteSchedule.EndSecond property

The SPMinuteSchedule.BeginSecond property and the SPMinuteSchedule.EndSecond property specify a start window of execution. The SharePoint Timer service starts the timer job at a random time between the BeginSecond property and the EndSecond property. This aspect of the timer service is designed for expensive jobs that execute on all servers in the farm. If all the jobs started at the same time, it could place an unwanted heavy load on the farm. The randomization helps spread the load out across the farm.

ComCamp2014 – What’s new in Visual Studio 2013

A fellow friend of mine, Ming Man will be presenting “What’s New in Visual Studio 2013″ in ComCamp2014. He will be covering a selected subset of the new features in Visual Studio 2013 such as:

. Peek Definition (Alt + F12)
. Enhanced Scrollbar
. Navigate To (Ctrl+,)
. Auto Brace Complete
. Move Line Up/ Down (Alt Arrow-Up/ Arrow-Down)
. New IDE Features for JavaScript
. and many more…

Ming Man is Microsoft MVP specializing in Visual C# since year 2006. He has more than 20 years of experience in software development. He has developed numerous software applications in COBOL, Java, classic Visual Basic, Visual Basic.NET, and Visual C#.

You may register for his session at this link:

https://msevents.microsoft.com/CUI/EventDetail.aspx?EventID=1032577242&Culture=en-MY

Where to download the full offline installer for Skype for Windows desktop

Recently, a few of friends asked me whether there are any possibilities to get hold of the full offline installer for Skype for Windows desktop. If you want to download the current full offline installer for Skype for Windows desktop, this is the link:

http://www.skype.com/go/getskype-full

How to configure SQL Server Express to allow remote TCP/IP connections on port 1433?

You can perform the following steps if you need to configure SQL Server Express to allow remote TCP/IP connections on port 1433:

1. Launch SQL Server Configuration Manager.
2. Go to SQL Server Network Configuration > Protocols for SQLEXPRESS.
3. Make sure TCP/IP is enabled.
4. Right-click on TCP/IP and select Properties.
5. Verify that, under IP2, the IP Address is set to the your computer’s IP address on the local subnet.
6. Scroll down to IPAll.
7. Make sure that TCP Dynamic Ports is set to blank.
8. Make sure that TCP Port is set to 1433.

ASP.NET Website Administration Tool: Unable to connect to SQL Server database

ASP.NET Website Administration Tool: Unable to connect to SQL Server database

If you have problems connecting to SQL Server database through the ASP.NET Website Administrator Tool, you may try to perform one of the following steps:

Step 1:
In some cases, you need to change the connection string:

<connectionStrings>
<add name=”ApplicationServices”
connectionString=”data source=##SERVERNAME##;Integrated Security=True;Initial Catalog=aspnetdb”
providerName=”System.Data.SqlClient” />
</connectionStrings>

Step 2:
In some cases, the ASP.NET service account (Machine_X\ASPNET or Network Service) requries access granting to the source database:

– Grant ASPNET access to the database
USE [##DBNAME##]
GO

– Grant login to Network service for ASPNET membership
EXEC sp_grantlogin N’##SERVICEACCOUNT##’
go

– Grant minimum permissions
USE [##DBNAME##]
GO
sp_addrolemember ‘aspnet_Membership_FullAccess’, N’##SERVICEACCOUNT##’
GO

IMPORTANT NOTE:
From the information that I have gathered throughout the Internet, I believed you cannot use the AttachDbFilename with a full blown SQL Server. Either add “\SQLEXPRESS” (instance name) to your server name or get rid of the AttachDbFileName and use Database=”##DATABASENAME##”.

Grant NT AUTHORITY\NETWORK SERVICE login and database access to a SQL Server database

To grant NT AUTHORITY\NETWORK SERVICE login and database access to a SQL Server database, you can execute the following Transact-SQL code:

EXEC sp_grantlogin N’NT AUTHORITY\NETWORK SERVICE’

EXEC sp_grantdbaccess N’NT AUTHORITY\NETWORK SERVICE’

IMPORTANT NOTE:

  • sp_grantlogin creates a SQL Server login. This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature. Use CREATE LOGIN instead.
  • sp_grantdbaccess adds a database user to the current database. This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature. Use CREATE USER instead.

 

Follow

Get every new post delivered to your Inbox.