# Querying New SQL Connection

**URL:** <https://forum.inductiveautomation.com/t/querying-new-sql-connection/89070>\
**Category:** Ignition\
**Created:** [April 18, 2024, 5:48pm UTC](https://forum.inductiveautomation.com/t/querying-new-sql-connection/89070 "2024-04-18T17:48:33Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Pico\_Sankari](https://avatars.discourse-cdn.com/v4/letter/p/aeb1de/32.png) [@Pico\_Sankari](https://forum.inductiveautomation.com/u/Pico_Sankari)\
**Post date:** [April 18, 2024, 5:48pm UTC](https://forum.inductiveautomation.com/t/querying-new-sql-connection/89070/1 "2024-04-18T17:48:33Z")

</div>

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](https://us1.discourse-cdn.com/inductiveautomation/original/3X/4/f/4ff2fed87203d3a33405ccff13d3cd62ec5ef8bd.png)  
When I try to run

> EXEC sp\_addlinkedserver @server='ALB-DB-13',  
> @srvproduct=N'SQL SERVER'

I get this error:

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/b/b/bb489432c987912e191afa2c0561c1a7131452d2.png)  
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?

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [April 18, 2024, 6:05pm UTC](https://forum.inductiveautomation.com/t/querying-new-sql-connection/89070/2 "2024-04-18T18:05:25Z")

</div>

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.