Monday, July 29, 2013
The purpose of this post is to provide instructions for installing .NET framework (NetFx3) on Windows Server 2012 using PowerShell.
.NET Framework is a requirement for SQL Server 2012. If this has not been installed prior to a SQL Server 2012 installation, then an error message will surface during the installation process. It is recommended to run the PowerShell command for installing Netfx3 prior to beginning the SQL Server installation.
1. Make the Windows Server 2012 media (DVD) available. For this example, I mounted a DVD drive on drive letter Z.
2. Open Windows PowerShell as an Administrator.
3. Run the following PowerShell command, replacing the source details with those specific to your environment.
PS C:\Windows\system32> dism /online /enable-feature /all /featurename:NetFx3 /source:z:\sources\sxs
Microsoft TechNet (February, 2012). DISM - Deployment Image Servicing and Management Technical Reference. Retrieved July 29, 2013 from http://technet.microsoft.com/en-us/library/hh824821.aspx
Microsoft TechNet (February, 2012). Use DISM in Windows PowerShell. Retrieved July 29, 2013 from http://technet.microsoft.com/en-us/library/hh825010.aspx
Verbeeck, K. (April, 2013). Error while enabling Windows Feature: Netfx3. Retrieved July 29, 2013 from http://www.sqlservercentral.com/blogs/koen-verbeeck/2013/04/29/error-while-enabling-windows-feature-netfx3
Thursday, July 18, 2013
How to retrieve collation information for SQL Server 2012.
During the set up of SQL Server 2012, the default collations are as follows (as shown below):
Database Engine: SQL_Latin1_General_CP1_CI_AS
Analysis Services: Latin1_General_CI_AS
To retrieve the collation of the Database Engine for an existing SQL Server instance:
SELECT CONVERT (varchar, SERVERPROPERTY('collation'));
To retrieve the collation of databases attached to the SQL Server instance:
SELECT name, collation_name FROM sys.databases;
MSDN (2012). View Collation Information. Retrieved July 18, 2013 from http://msdn.microsoft.com/en-us/library/hh230914.aspx
Wednesday, July 03, 2013
1. Open Server Manager.
2. Click "Local Server"
3. In the Properties section, locate "IE Enhanced Security Configuration." It is currently set to "On." Click "On" to open a dialog window.
4. Change the "Internet Explorer Enhanced Security Configuration" settings to Off as needed. Click OK and close Server Manager.
- ▼ July (3)
- ► 2012 (13)
- ► 2011 (27)
- ► 2010 (60)
- ► 2009 (40)
- ► 2008 (45)
- ► 2007 (80)
Events / Conferences / User Groups
- AIIM Conference
- Boston Area SharePoint User Group
- Boston Azure User Group
- Enterprise Search Summit
- Microsoft Build
- Microsoft SharePoint Conference
- Microsoft TechEd
- New England ASP.NET Professionals User Group
- New England Oracle Applications User Group
- Oracle Applications User Group (OAUG)
- Oracle OpenWorld
- PeopleSoft Government Contractor Special Interest Group
- PeopleSoft Southern New England Users Group
- Quest International Users Group
- SharePoint Saturday
- SQL PASS
- SQL Saturday
- Startup Weekend