DSN Error connecting to database

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)
August 29th, 2011 2:36pm

I've done that from the start and I still get the same error.
August 30th, 2011 11:37am

Hi Nelson,

Please make sure to install the SQL Server Native Client provider from SQL Server 2008 R2 SP1, since the new SQL Azure Service Release from July 2011 requires this.

Free Windows Admin Tool Kit Click here and download it now
August 30th, 2011 6:31pm

Hello,

I've installed Service Pack 1 for SQL Server 2008 R2 (KB2528583), version 10.51.2500.0, rebooted and still get the same problem.

 

August 31st, 2011 1:07pm

If your SQL Azure Server is e.g.: ABCD.database.windows.net

Your login ID for the DSN should be: username@ABCD

Have you tried that? 

Free Windows Admin Tool Kit Click here and download it now
September 8th, 2011 11:17am

I think the problem here is that your username has @
April 30th, 2014 6:57pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics