Message=Could not find server 'AAASQL' in sys.servers. Verify that the correct server name was specified. If necessary, execute the stored procedure sp_addlinkedserver to add the server to sys.servers.

Question

I am in Power Query and I am given a custom function: to query from TWO different SQL servers - before they are different SQL servers but both on premise and right now I need change one server to Cloud version. 

 

After change, I was thrown this error message:  DataSource.Error: Microsoft SQL: Could not find server 'AAASQL' in sys.servers. Verify that the correct server name was specified. If necessary, execute the stored procedure sp_addlinkedserver to add the server to sys.servers.
Details:
DataSourceKind=SQL
DataSourcePath=BBBSQL;CSA
Message=Could not find server 'AAASQL' in sys.servers. Verify that the correct server name was specified. If necessary, execute the stored procedure sp_addlinkedserver to add the server to sys.servers.
ErrorCode=-2146232060
Number=7202
Class=11

Answer 1

Hi Juliana Zhou,

Please refer to this article: https://www.c-sharpcorner.com/blogs/could-not-find-server-server-name-in-sysservers-in-sql-server

And this similar thread: https://learn.microsoft.com/en-us/answers/questions/817819/could-not-find-server-servernamehere-in-sys-server

Best regards,

Seeya

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Answer 2

Apparently, you are submitting a query like:

SELECT ... FROM AAASQL.db.dbo.tbl

But on the SQL Server instance, there is no linked server AAASQL defined.

You need to talk with the DBA for the server you connect to, and ask that person to set up the linked server for you.