I set up a linked server from server A to server B using the password "cookie".. Bob in the reporting department wants to use the linked server to create a query for use in a SSRS report. What permissions does BOB need to have to server B and or what special permissions does BOB need to use linked server?
Microsoft SQL Server 2008Microsoft SQL Server 2005