If the SQL Service account is not LOCALSYSTEM or a domain admin (or similar) then this error will happen and the SQL acount can't register an SPN.SPNs (Service Principal Names) aren't used by SQL unless you want to pass-through NT authentication to linked servers rather than explicit mappings to username/passwords.Our SQL Servers use a standard […]
2005-03-11
2005-02-24
2,222 reads
SQL Server has drivers to read almost any data source, but they are not always the easiest to work with. New author Kevin Terry spent quite some time learning how he could pull data from Outlook using DTS and scripting. Most information on the internet requires Exchange to be on the same server as SQL Server to get the data, but this solution works with any configuration, and can pull any information, email address, contact information, etc. from Outlook.
2005-02-01
18,371 reads
This article examines how to take advantage of VB Script and MS-DOS batch files to restore multiple DTS packages stored in the form of structured storage files from one folder to a SQL Server box.
2004-10-20
1,987 reads
SQL Server DTS may be one of the best tools ever included with a database server. It makes data movement, copying, any sort of ETL task a breeze. At least for the most part. Bruce Szabo found a place where the Copy Objects task sometimes doesn't work as expected. This article looks a problem he had as well as the solution that you can use to ensure that this task works reliably for you.
2004-10-13
8,903 reads
2004-10-08
1,700 reads
MAK examines how to save all of the DTS packages from SQL Server to a structured storage file automatically.
2004-10-07
2,334 reads
Have you ever wanted to run DTS on a workstation or server that doesn't have SQL installed? Here's the items you need to move to make it happen.
2004-09-15
1,549 reads
2004-08-17
2,526 reads
Automating SQL Server tasks is the sign of an experienced DBA. One who doesn't waste time on repetitive tasks that can be easily setup in a job, task, or some other scheduling process to run when they need to run. Haidong Ji has written a number of articles on how to perform automation and brings us yet another technique. This time he looks at managing your backup files, something that we all need to do, but all too often forget to do.
2004-08-02
17,360 reads
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers