September 25, 2003 at 1:13 pm
I have installed sql 2000 sp3 on a test server and have a question about cross-database ownership chaining. Currently I have an active/active sql server in production. The developers will be working in one db on one server and connect to another db on the second server. The production server is not yet on sp3. Am I using a form of cross database ownership chaining or is this new with sp3?
Thanks,
Tracy
September 25, 2003 at 1:17 pm
Cross-database ownership chaining only applies within the same instance. When you cross to a second instance, you're making a linked server (remote data) connection and you get a new security context based on how you defined access through the connection.
Cross-database ownership chaining has been on by default prior to SP3. With SP3 you now have an option to turn it off for databases other than master and msdb (which require them).
K. Brian Kelley
http://www.truthsolutions.com/
Author: Start to Finish Guide to SQL Server Performance Monitoring
K. Brian Kelley
@kbriankelley
September 25, 2003 at 1:20 pm
Great. THank you for the info.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply