# SQL Server Data source for Custom Database Extension **URL:** \ **Category:** Extensions\ **Tags:** databases, extensions\ **Created:** [March 21, 2024, 3:41pm UTC](https://community.dynatrace.com/t/sql-server-data-source-for-custom-database-extension/44791 "2024-03-21T15:41:12Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![tvannamuthu](https://avatars.discourse-cdn.com/v4/letter/t/258eb7/32.png) [@tvannamuthu](https://community.dynatrace.com/u/tvannamuthu)\ **Post date:** [March 21, 2024, 3:41pm UTC](https://community.dynatrace.com/t/sql-server-data-source-for-custom-database-extension/44791/1 "2024-03-21T15:41:12Z")
Trying to migrate queries from Custom DB queries to Custom Database Extension. Created an extension for a query. During execution, the extension provides the following warning - Connection exists but no metrics have been produced for endpoints: But I know data is available at the endpoint as the same query when run separately provides the desired output. What might be causing this error? Appreciate any insights. ---
**Author:** ![Miguel\_RinconG](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/miguel_rincong/32/29455_2.png) [@Miguel\_RinconG](https://community.dynatrace.com/u/Miguel_RinconG)\ **Post date:** [March 22, 2024, 1:53pm UTC](https://community.dynatrace.com/t/sql-server-data-source-for-custom-database-extension/44791/2 "2024-03-22T13:53:47Z")
Hi [@tvannamuthu](https://community.dynatrace.com/user/17830) , Please shared your extension code. This is a query example: ```markup - group: User featureSet: User interval: minutes: 5 query: > SELECT count(CustomerID) as UserCount, Region FROM Customers where Region is not Null Group by Region dimensions: - key: custom.customquery.region value: col:Region metrics: - key: custom.customquery.sql.user value: col:UserCount ``` ---
**Author:** ![tvannamuthu](https://avatars.discourse-cdn.com/v4/letter/t/258eb7/32.png) [@tvannamuthu](https://community.dynatrace.com/u/tvannamuthu)\ **Post date:** [March 23, 2024, 11:35am UTC](https://community.dynatrace.com/t/sql-server-data-source-for-custom-database-extension/44791/3 "2024-03-23T11:35:49Z")
Hello Miguel\_RinconG, I was able to fix the issue by adding the database name in the monitoring configuration. It was mentioned as optional so did not add that initially but after adding the Database name extension started to fetch metrics. Thanks for your reply. ---
**Author:** ![ashafingilutfi](https://avatars.discourse-cdn.com/v4/letter/a/ed655f/32.png) [@ashafingilutfi](https://community.dynatrace.com/u/ashafingilutfi)\ **Post date:** [August 20, 2024, 12:24pm UTC](https://community.dynatrace.com/t/sql-server-data-source-for-custom-database-extension/44791/4 "2024-08-20T12:24:21Z")
Hi [@tvannamuthu](https://community.dynatrace.com/user/17830), How you add database name ? it is using  **connection string**  ? because the prompt is showing only service name/SID ---
**Author:** ![tvannamuthu](https://avatars.discourse-cdn.com/v4/letter/t/258eb7/32.png) [@tvannamuthu](https://community.dynatrace.com/u/tvannamuthu)\ **Post date:** [August 20, 2024, 12:55pm UTC](https://community.dynatrace.com/t/sql-server-data-source-for-custom-database-extension/44791/5 "2024-08-20T12:55:55Z")
Hi [@ashafingilutfi](https://community.dynatrace.com/user/79610) , Please see the screen shot below. Here is where database name was added. When you try to add monitoring configuration from an SQL Server extension you get this view. Hope this helps. ![tvannamuthu_0-1724158448080.png](https://global.discourse-cdn.com/dynatrace/original/3X/e/6/e6d406ab478d39bb6c6a41132fc0d7d9273ac262.png) ---
**Author:** ![chaitanya](https://avatars.discourse-cdn.com/v4/letter/c/848f3c/32.png) [@chaitanya](https://community.dynatrace.com/u/chaitanya)\ **Post date:** [August 30, 2024, 4:32pm UTC](https://community.dynatrace.com/t/sql-server-data-source-for-custom-database-extension/44791/6 "2024-08-30T16:32:27Z")
Hi there, I have added DB name correctly and syntax also correct but sometime queries throw same error as above. do we have any other solutions? thanks ---
**Author:** ![moin\_DT1](https://avatars.discourse-cdn.com/v4/letter/m/c67d28/32.png) [@moin\_DT1](https://community.dynatrace.com/u/moin_DT1)\ **Post date:** [September 25, 2024, 1:21pm UTC](https://community.dynatrace.com/t/sql-server-data-source-for-custom-database-extension/44791/7 "2024-09-25T13:21:12Z")
Hi All, We are having the same error, even though we have added Database name and other fields correctly. Does anyone have update? [@tvannamuthu](https://community.dynatrace.com/user/17830) [@chaitanya](https://community.dynatrace.com/user/64258) [@ashafingilutfi](https://community.dynatrace.com/user/79610) [@Miguel\_RinconG](https://community.dynatrace.com/user/46739) Thanks in advance, Moin ---
**Author:** ![PDivya](https://avatars.discourse-cdn.com/v4/letter/p/d07c76/32.png) [@PDivya](https://community.dynatrace.com/u/PDivya)\ **Post date:** [October 17, 2024, 2:56pm UTC](https://community.dynatrace.com/t/sql-server-data-source-for-custom-database-extension/44791/8 "2024-10-17T14:56:08Z")
Hi All, We are also having same error, provided DB name and all details, as with the same details it is working extension 1.0. Does anyone have update? Thanks Divya ---
**Author:** ![Mike\_Kristofic](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/mike_kristofic/32/8129_2.png) [@Mike\_Kristofic](https://community.dynatrace.com/u/Mike_Kristofic)\ **Post date:** [February 4, 2025, 2:56pm UTC](https://community.dynatrace.com/t/sql-server-data-source-for-custom-database-extension/44791/9 "2025-02-04T14:56:25Z")
Hi, my custom database extension suddenly stopped retrieving metrics with this very same message. Can’t find any details in remote plugin module. Is there any way to troubleshoot? Like increase extension logging level? Database name is provided already. Thanks Mike ---
**Author:** ![moin\_DT1](https://avatars.discourse-cdn.com/v4/letter/m/c67d28/32.png) [@moin\_DT1](https://community.dynatrace.com/u/moin_DT1)\ **Post date:** [May 16, 2025, 5:04pm UTC](https://community.dynatrace.com/t/sql-server-data-source-for-custom-database-extension/44791/10 "2025-05-16T17:04:02Z")
Hi [@Mike\_Kristofic](https://community.dynatrace.com/user/48221) , Yes first you can enable the Debug toggle in the configuration. And also you can download the zip file of diagnostic logs of an ActiveGate.