How To Enable Remote Connections In SQL Server 2012

By default, remote connections should be enabled in SQL Server 2012, but if you are having trouble connecting to SQL you may need to enable this setting. To enable remote connections in SQL Server 2012, do the following: On the SQL Server, open Microsoft SQL Management Studio 2012 Connect to the SQL Server instance Right […]
Continue reading…

 

Invalid Prefix Or Suffix Characters. (MS Visual Database Tools) – SQL Server Management Studio

When trying to edit the top 200 rows of a database through the GUI (Right clicking on a database in SQL Server Management Studio and clicking Edit Top 200 Rows), you can get the following error message: Microsoft SQL Server Management Studio Invalid prefix or suffix characters. (MS Visual Database Tools) This occurs when you […]
Continue reading…

 

How To Upgrade SQL Server 2008 R2 Or Previous To 2012

There are two upgrade paths for upgrading Microsoft SQL Server 2008 (R2) to SQL 2012, broadly speaking they are an inline upgrade or a migration. My preferred method for upgrading to SQL Server 2012 is with a migration because it’s smoother to plan and execute. It does however, require more effort redirecting applications to new […]
Continue reading…

 

Microsoft SQL Server 2012 Installation Hangs

When installing MS SQL 2012, the installation can hang on the product key page. To get out of this, right click the Task Bar icon for the SQL Server 2012 installation and click Managed SQL Server Installer. This will then prompt you to continue, click Yes and this will stop the installation from hanging. Unfortunately, […]
Continue reading…

 

Error While Enabling Windows Feature NetFx3 – SQL 2012

When installing Microsoft SQL Server 2012, you may get this error: Microsoft SQL Server 2012 Setup The following error has occurred: Error while enabling Windows feature: NetFx3, Error Code: -2146498298 , Please try enabling Windows feature : NetFx3 from Windows management tools and then run setup again. For more information on how to enable Windows […]
Continue reading…

 

Unable To Open .BAK Files For SQL Restore – SQL Server 2012

If you are trying to restore a SQL database in Microsoft SQL Server 2012, but are unable to open or even view¬†the .BAK files, it may be because they are on a network share. Microsoft SQL Server 2012 will only allow restores from .BAK files located on a drive local to the server The fix […]
Continue reading…

 

SQL Server 2008 R2 Service Pack 1 Or Later Is Required For Upgrade

When upgrading Microsoft SQL 2008 R2 to MSSQL 2012, you may get the following error message: Rule Check Result Rule “SQL Server 2008 R2 Service Pack 1 or later is required for upgrade.” failed. The SQL Server 2008 R2 Features that have been selected to be upgraded to SQL Server 2012 are not at the […]
Continue reading…

 

Microsoft SQL Server 2012 Transact-SQL ScriptDom

When installing Microsoft SQL Server 2012 Upgrade Advisor, you get the following message and the installation stops: Setup is missing prerequisits: Microsoft SQL Server 2012 Transact-SQL ScriptDom, which is not installed by Upgrade Advisor Setup. To Continue, install SQL Server 2012 Transact-SQL ScriptDom from below hyperlink and then run the Upgrade Advisor Setup operation again […]
Continue reading…

 

How To Restore A Database In SQL Server 2012

Restoring a database in Microsoft SQL 2012 is very simple. To restore a SQL database you need the .bak file and sometimes the .trn file (depending on the type of backup that was taken). Open Microsoft SQL Management Studio (It doesn’t have to be 2012. Athough this guide is aimed at SQL 2012, there should […]
Continue reading…