<div>
please provide any specific &nbsp;errors and try to create ODBC DSN with this user (check TCP and Port if) also try to grant DBO role permissions (just for test)
</div>


please provide any specific  errors and try to create ODBC DSN with this user (check TCP and Port if) also try to grant DBO role permissions (just for test)

<div>
<div class="content wysiwyg-content">
I can't get an ODBC connection to work for a non-dbo user when trying to establish a connection to an Azure SQL DB. &nbsp;It works fine for a dbo user. &nbsp;It appears to have something to do with the default DB but the ODBC generator in windows 7 wont allow me to change the default db. &nbsp;I know the non-dbo user has valid SQL credentials because I can connect to the remote Azure server/DB through Navicat as that user. &nbsp;Any suggestions are welcome.
</div>
</div>


I can't get an ODBC connection to work for a non-dbo user when trying to establish a connection to an Azure SQL DB.  It works fine for a dbo user.  It appears to have something to do with the default DB but the ODBC generator in windows 7 wont allow me to change the default db.  I know the non-dbo user has valid SQL credentials because I can connect to the remote Azure server/DB through Navicat as that user.  Any suggestions are welcome.

Azure SQL connection through Excel 2010 using ODBC

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Microsoft Azure is a cloud computing platform and infrastructure for building, deploying and managing applications and services through datacenters. It provides both platform-as-a-service (PaaS) and infrastructure-as-a-service (IaaS) services and supports many different programming languages, tools and frameworks, including both Microsoft-specific and third-party software and systems. Cloud Services is a PaaS environment and can be used to create scalable applications and services; there are specific software development kits (SDKs) provided by Microsoft for Python, Java, Node.js and .NET. Azure also has file and storage services, data management, analytics and DNS services.