Download SQL Server 2016

Download SQL Server 2016 from this Microsoft’s website..https://www.microsoft.com/en-us/sql-server/sql-server-downloads. The good news is now Microsoft has started giving Developer Edition for free.. So get your copy and hope you will hone your SQL Server skills..

–Bru Medishetty

Do you like this site? Like our FB page @Facebook.com\LearnSQLWithBru so that, you know when there is a new blog post.

SQL Server 2014 released, get your evaluation copy

Starting today, April 1st (not a April fools joke), Microsoft has made available SQL Server 2014, the latest version of the database platform to the general public (aka RTM, Release to Market). You can go to this page — > Technet Evaluation Center to download your evaluation copy of SQL Server 2014. I am excited my self to see SQL Server 2014 in action personally. I finished downloading the eval copy and am looking forward to install it in a couple of days time. You can visit this page to get more information on SQL Server 2014..

Good luck !!!

— Bru Medishetty

Do you like this site? Like our FB page @ Facebook.com\LearnSQLWithBru so that, you know when there is a new blog post.

Cannot connect to a SQL Server 2008 named instance; How to resolve

Last month, I had this issue where a couple of applications had issues authenticating to a SQL Server 2008 R2 instance. So I started to troubleshoot this issue by duplicating from my workstation and finally arriving at a solution. This blog will explain what was caused this issue and the solution to that issue.

This SQL instance (that I had issues) is a 2008 R2 SQL Cluster and named instance, but it was configured to be accessible through the port 1433. So the SQL Instance was accessible both ways as (“clustername” and also as “clustername\instancename”). After a maintenance over a weekend (what is done on that cluster, what settings have been made and why is way out of topic in this blog), we started to have couple of applications not being able to authenticate to this SQL instance.  At first I could not think why this was happening, as I was able to see several users and applications connected to this instance and working fine (All SQL jobs running etc etc). I tried to login to that SQL instance (I commonly use just the clustername to connect) and was successful. Thought the individual accounts these applications are using to authenticate, have been disabled, but that was not the case, and lastly when I tried to login using the entire clustername\instancename then I found that I was having the same authentication failed error that those applications have been reporting. 

Solution

After looking at the state of SQL Services in SQL Server Configuration Manager, I found that the SQL Server Browser Service, though the Start Mode was set to Automatic, it did not start and was causing this issue. So I started the service and tried to login using the  clustername\instancename and it started to work…

SQL Server Browser

The above pic is how it looked on my server when I saw the services in configuration manager. (Note that this screen shot is from my lab not the actual server where this issue occurred).

Do you like this site? Like our FB page @ Facebook.com\LearnSQLWithBru so that, you know when there is a new blog post.

–Bru Medishetty

Product-Ads-75-Clicks_728x90._V174189179_