My technical group and I have been unable to connect our ASP application to our Azure database. We have tried all the following
a) Ensuring our database is operable by connecting to it with SQL Server Management Studio
b) Opening the correct ports by using Windows Firewall after RDP into the VM
c) Used Azure to mark database endpoints for the VM
d) We also created another login on our master database and used those to create a user on the database we wanted to connect to
e) We also tried a DSN
None of these approaches worked.
Using the DSN, we received the error:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC SQL Server Driver][SQL Server]'' is an invalid name because it contains a NULL character or an invalid unicode character.
Using SQL Native Client, we received the error:
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
Any help or thoughts would be much appreciated.
- Moved by Prasant ChhetriMicrosoft contingent staff, Moderator Monday, May 25, 2015 10:53 AM Moving this to appropriate forum