Download SQL Server Express

It’s Just easier this way… http://www.hanselman.com/blog/DownloadSQLServerExpress.aspx DOWNLOAD SQL SERVER 2014 EXPRESS You likely just want SQL Server 2014 Express with Tools. This download includes SQL Management Studio. SQL Server 2014 Express x64 SQL Server 2014 Express x86 Here’s just SQL Server 2014 Management Studio SQL Management Studio x64 SQL Management Studio x86 SQL Server 2014 Read more about Download SQL Server Express[…]

A network-related or instance-specific error occurred while establishing a connection to SQL Server.

Windows 2008 R2 1) SQL Server should be up and running. All Programs >> Microsoft SQL Server 2008 >> Configuration Tools >> SQL Server Configuration Manager >> SQL Server Services, and check if SQL Server service status is “Running”. Run “sqlcmd -L” in your command prompt to ascertain if your server is included in your Read more about A network-related or instance-specific error occurred while establishing a connection to SQL Server.[…]

Change SQL Server (MSSQL) Password

If you’ve forgotten the sa password for your SQL server, you are probably in a panic. Fear not, for you can change the password and once again have access to the powers of the SA account using Windows Authentication mode. Login into SQL Server using Windows Authentication. In Object Explorer, open Security folder, open Logins Read more about Change SQL Server (MSSQL) Password[…]

SQL Server Firewall Rule in Plesk on Windows server

Enable the firewall within Plesk then add the needed rules to Windows Firewall (set the IP’s can connect on tcp/1433). Plesk does not have the ability to set the IP’s or IP range. Resources http://www.rackspace.com/knowledge_center/article/configuring-ms-sql-server-for-remote-access http://www.rackspace.com/knowledge_center/article/creating-an-inbound-custom-allow-rule-for-windows-firewall-windows-2008