Wish you all very happy new year 2014!!
This year we are planning to focus more on recording video blogs and in this series I decided to write my first video blog on Extended Events.
Below are the highlights of this video blog.
Introduction to Extended Events
Why Extended Events?
When to use Extended Events?
How it works?
Highlights of Demo
New Extended Events related DMV’s
Configure an Extended Event session using GUI
How to read the XEL files.
Some special troubleshooting tips!
Note: Please watch this video in HD for better quality. If you wish to download, please click on the drop menu on the top left corner of this video. Read the rest of this entry »
When you see error “Cannot generate SSPI context” what is the first thing comes to your mind, SPN problem isn’t it?
There are many such errors which lead us to assume that we have problems with SPN. Although, it could be a correct approach, do we really try to understand how does this authentication work? Why it fails and how can we resolve such errors?
Well, I have also come across these errors numerous times and hence researched a bit deeper to find out some internals, how it works behind the scenes etc. And that calls for this two-series of blog post which will give us an insight of windows authentication process between an application and SQL Server, the related errors and their troubleshooting approach.
As stated above, this is a two-series blog which will cover the following:
Part -1: We will discuss about how windows authentication process works in SQL Server using SSPI
Part-2: I will try to explain why this authentication fails and how to troubleshoot these issues. Read the rest of this entry »
Have you ever faced situations like below?
1- You are logged in to one server with your domain credentials and some other user wants to connect to sql server using his domain credentials but he does not have logon rights to that server
2- You have SQL Server instance running in different domain and you have sysadmin rights to that instances however you do not have logon rights to any of the server in that domain in that case how to launch management studio or sqlcmd?
3- You are managing hundreds of SQL Server instances in different domains you are sysadmin to all the sql servers but no logon access to the servers and you want to run a query to all the instance from single central server.
Roadblock isn’t it? Read the rest of this entry »
Before I dive into the subject of this blog, a few words on Service SID. As you might know, SQL Server uses a service SID to provide service isolation. This feature was introduced in SQL 2008 and higher versions, however, whether you can install a SQL failover clustered instance (FCI) using Service SIDs or not, depends on the version of windows you are using. For SQL Server 2008 FCI, ideally you should be able to use the Service SID option if installing it over Windows 2008 or higher.
Read the rest of this entry »
Hope you are enjoying our blog posts. I am back with one more interesting issue.
I was at home enjoying weekend suddenly I see few sms and calls on my mobile. Everyone started complaining we are not able to connect to SQL Server. Ok, what’s a big deal I will fix the issue for you…
I started looking into the issue and got confused with the behavior. I see all the resources are up and running fine on cluster, everything looks to be clean No ERRORS in SQL Server error log and Event logs as well, then why no one is a able to connect to SQL Server. I also tried to connect to SQL Server and I was also not able to connect, got time out expire error message from Management Studio. It was failing with command prompt as well!!
Read the rest of this entry »