Hello there,
I was able to migrate our application database to SQL AZURE.
Now I have a DSN connection with driver SQL Server Native Client 10.0 (version 2009.100.1617.00) to the database that I only changed the details to point to the SQL AZURE.
The connection test works fine and I am able to connect to the database from Management Studio.
But when I try to run my application it gives the follwing error in Event Viewer :
Action = SQLConnect
Return Code = -1 Date = 08/29/11 Time = 12:30:55
State = 37000
Error Msg = [Microsoft][SQL Server Native Client 10.0][SQL Server]Server name cannot be determined. It must appear as the first segment of the server's dns name (servername.database.windows.net). Some libraries do not send the server name, in which case the server name must be included as part of the user name (username@servername). In addition, if both formats are used, the server names must match.
I've double, triple,.... checked and all details are fine.
I tried also putting "tcp:" before the server and got same error.
Any Help?
- Moved by Wenchao Zeng Tuesday, August 30, 2011 3:13 AM sql azure connectivity issue (From:Windows Azure Platform Development)