Querying New SQL Connection

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:
image
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?

The query you are running is hopping out of the SQL Server you are connected to, into some other server. Which hasn't been set up properly on the SQL Server. This is not an Ignition problem.