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.