At our company we have several SQL Server Databases. one is at our data center one is local at our site and one is at Corporate HQ. The local SQL Server is where we run most of our reports from and we use that to link to the Data Center and Corporate HQ databases. The issue is that the Corporate uses Windows Authentication and the linked server requires SQL Server Authentication is there anyway around this limitation?
Also in asking this question there's a section below that says Tags. It's a required field but doesn't allow me to put the appropriate tag. There's a list but this issue isn't in the list and I don't have permission to create one. So I picked one at random so this question could be asked.
