Kalen Delaney Virtual Workshop: SQL Server 2008 Indexes – Internals and Best Practices – This Friday
Feb. 25, 2011 – Along with a good database design I would say that Indexes are a cornerstone to good database performance. There are a lot of other skills you can develop in relational databases; but without these two skills, you’re going to find yourself in a heap of trouble. The SSWUG.org’s virtual workshop, conducted by Microsoft SQL Server MVP Kalen Delaney, will give you the skills you need to understand indexes, evaluate their effectiveness and make the necessary adjustments for performance. Register today to save your spot.
$$SWYNK$$
Featured Article(s)
Troubleshooting SQL Server 2008 Merge Replication
In this article, Alexander Chigrik explains some problems that you can have when you work with SQL Server 2008 merge replication. He also tells how you can resolve these problems.
Featured White Paper(s)
VIDEO WHITEPAPER – How to Avoid Downtime – VIDEO WHITEPAPER
In this Experts & Insights video, we take a close-up look at the data protection challenges and solutions surrounding downtim… (read more)
Accessing Your SQL Server
Have you ever received the error message "NT AUTHORITYANONYMOUS LOGON login failed" when trying to connect to your database server? Sometimes I find this error when trying to copy data from one SQL Server instance to another…especially when using SQL Server Management Studio using local credentials instead of Active Directory. You may experience this issue even when using Active Directory credentials.
I was reading a cool blog by Brian Kelly titled "Understanding When Kerberos Delegation Is Needed for SQL Server" that covers the reason for this error message and provides some insight for resolving the problem through use of Active Directory. This blog is written from the perspective of a Web Server calling a Database using credentials from the user logged into a web site, connecting to SQL Server, and then having the first SQL Server connect to another SQL Server. While this isn’t the specific issue I’m talking about, the error message and cause is identical.
The Cause: By Default, Authentication is not allowed to be passed from one server to the next. In my scenario, connecting my SSMS to a database server will not allow me to run a query on a linked server. The credentials I am using to connect to the first server are not passed to a second server through a linked server connection. As a result, Anonymous credentials are passed for a remote query to a linked server, and if configured properly, will fail…I don’t want Anonymous users accessing my database.
The same problem occurs when trying to transfer data from one machine to another using SSMS remotely. One solution to this is to open SSMS in an RDP session on one or the other database servers, and then you can use the wizard to transfer data. When you are not allowed RDP access to your database servers, then you may try working with your network gurus to see if they will allow Active Directory to use Kerberos Delegation, resolving the problem.
Send your ideas, tips, and topics for future newsletters to btaylor@sswug.org.
Cheers,
Ben