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
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
http://www.top-password.com/knowledge/unlock-sql-server-sa-account.html http://www.mssqltips.com/sqlservertip/2758/how-to-unlock-a-sql-login-without-resetting-the-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
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