# Azure SQl setup in dbt project

**URL:** <https://discourse.getdbt.com/t/azure-sql-setup-in-dbt-project/5333>\
**Category:** Help\
**Tags:** testing\
**Created:** [November 11, 2022, 12:32pm UTC](https://discourse.getdbt.com/t/azure-sql-setup-in-dbt-project/5333 "2022-11-11T12:32:18Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![Arjha121](https://avatars.discourse-cdn.com/v4/letter/a/a4c791/32.png) [@Arjha121](https://discourse.getdbt.com/u/Arjha121)\
**Post date:** [November 11, 2022, 12:32pm UTC](https://discourse.getdbt.com/t/azure-sql-setup-in-dbt-project/5333/1 "2022-11-11T12:32:18Z")

</div>

Hi all,

I am setting up Azure sql project in dbt Core, but I keep on getting the below issue–

> Database Error  
> (‘01S00’, ‘[01S00] [Microsoft][ODBC Driver Manager] Invalid connection string attribute (0) (SQLDriverConnect)’)

I have installed dbt-sqlserver adapter but when I try to initiate this project it says ‘no sample profile found’ so I create the profiles.yml file manually with below details.  
testdemo:  
target: dev  
outputs:  
dev:  
type: sqlserver  
driver: SQL Server  
server: .windows.net  
port: 1433  
database: RnD  
schema:  
user:  
password:  
target: dev

In driver value…I have tried like --‘ODBC Driver 17 for SQL Server’ and ‘ODBC Driver 18 for SQL Server’, all are installed in my window VM.  
any help would really be appreciated.