I created a new SQL connection. the connection's status is valid. I tried querying with a query "SELECT * FROM [serverName].databaseName.dbo.tableName". This query works on other connected databases. However, I get this error when I query the new database:
When I try to run
EXEC sp_addlinkedserver @server='ALB-DB-13',
@srvproduct=N'SQL SERVER'
I get this error:
I have admin privileges, do I need to somehow log into SQL with an account with more permissions?
Is there something else I'm missing here?