This step-by-step article describes how to troubleshoot the most typical sources of the “Cannot generate SSPI context” error message. You may receive this error message under the following conditions: –You are connecting to SQL Server. –You are using Integrated Security. –Kerberos is used t
Other News
What’s New in DTS?
(Kirk Haselden) In early 2000, the Microsoft Data Transformation Services (DTS) development team I work on started revising DTS with the goals of building on previous success and of improving the product to support user requests and to provide a richer extraction, transformation, and loading (ETL) p
Databases make XML connections
(Ian Yates) Getting people of different backgrounds to communicate effectively can be a difficult task, but translate that chore to data in disparate computer systems and, writes Ian Yates, you get help from XML. When it comes to human languages, there never was an obvious logical reason for the
Why Use .NET?
(Philip Miseldine) .NET hasn’t traditionally been the SitePoint community’s framework of choice for Web development. A simple comparison of the activity within the PHP and the .NET forums highlights this fact. But with the release of SitePoint’s first ASP.NET book, I thought it was about time us .NE
Build a Better Charting Engine Using Flash and XML
(Pallav Nadhani) When you think of the phrase “charting on the Web”, you probably think of COM components, .NET assemblies, or extensions (like Office Web Extensions). While these are great ways to chart your data, they do put a strain on the system when you need to chart data for thousands of concu
DB2 UDB for z/OS Version 8: Everything You Ever Wanted to Know , … and More
(Bart Steegmans) IBM DATABASE 2 Universal Database Server for z/OS Version 8 is the twelfth and largest release of DB2 for MVS. It brings new synergy with the zSeries hardware and is the first major subsystem to exploit the z/OS 64-bit virtual addressing capabilities. DB2 V8 offers data support,
Step by step migration of Content Manager version 8.2 on Windows platform
(Allan Tham) This guide is intended for a fast/easy migration of Content Manager version 8.2 from one Windows machine to the other. Screenshots for both step by step installation and migration are provided to ease the entire process.
Are Your Backups Useless?
(Brian Moran) SQL Server backups are useless if you can’t recover them. Backups are simply big disk files unless you have a recovery mechanism that puts those bits back into SQL Server when you need them. So when was the last time you tested your restore strategy? I’m not asking whether you’ve p
Optimizing Microsoft SQL Server Analysis Services: MDX Optimization Techniques: Introduction and the Role of Processing
(William E. Pearson, III) In this article, we will introduce an area of considerable interest among MSAS developers and practitioners, and an area where optimization skills are vital to the efficient operation of both client and server. In a subset of upcoming articles that I will publish on a recur
User Defined Functions in Microsoft SQL Server 2000
(Don Schlichting) User Defined Functions are compact pieces of Transact SQL code, which can accept parameters, and return either a value, or a table. They are saved as individual work units, and are created using standard SQL commands. Data transformation and reference value retrieval are common