1

I need to install SQL Server Native Client 11 on my computer so I can access an Azure SQL Database (according to the instructions I am following) which is behind my Access Web App.

But Native Client 11 will not install - I am getting the message that it "is not compatible with this operating system". Google suggests I install version 10. Worth a go though I doubt it will work. It installs, but it is not establishing a connection. I get this error when creating a DSN after the login page:

Error 1

So I change the username to include the server name as instructed and I get this error:

enter image description here

It has been way more than 5 minutes. since I opened the Access Web App connection to From Any Location.

So do I actually have a connection issue or do I have a driver compatibility issue? How do I get Native Client 11 on Windows 10?

Edit: Made some things more clear above and here is some more data:

I realized that my office computer has SQL Express 2012 installed (I am at home right now) so it should have Native Client 11 on it. Sure enough. Do not know why I was able to install 2012 on Win10 there. Anyhoo, I tried to add the DSN on the office computer using native Client 11. I get past the login screen but when I try to select a default database from the drop down I get this error:

enter image description here

So I tried simply pasting the server name into the default database and it takes. But when I test the connection at the end of the wizard, I get the second error above about my IP address begin rejected.

To be clear about one thing, I cannot as far as I know, change the firewall rules on the SQL server as if I had a real Azure account. I have to tell Office 365 to do it via the settings in my Access Web App.

Oh, and I did open port 1433 in the firewall.

Brad Mathews
  • 1,567
  • 2
  • 23
  • 45
  • Which connection string do you use ? And if looks like the Installation was no problem, so please check your title. Please copy the error message AS text into your question so others can find it using the search – Marged Jan 26 '16 at 05:25
  • @Marged Version 11 did not install, version 10 did. I am too lazy to retype the entire message - I am waiting for Windows 23 when they finally allow cut/paste of MsgBoxes. – Brad Mathews Jan 26 '16 at 05:47
  • If you don't have the error message as text an answer will only help you because others will not be able to find it by searching for the error message. – Marged Jan 26 '16 at 05:48
  • 1
    @Brad Mathews: Btw, Copy & Paste from messages boxes works since win 98 or so. Just hit Ctrl+C while the message box has focus. – erg Jan 26 '16 at 08:17
  • Well, I solved part of my problem - I now have the SQL Azure connection working from my office computer. [See this post:](https://social.msdn.microsoft.com/Forums/office/en-US/a6f924e0-e64b-4cbe-85a6-04cecd3cf56c/cannot-access-back-end-database-for-access-web-app?forum=accessdev#a6f924e0-e64b-4cbe-85a6-04cecd3cf56c). I still want to get version 11 installed on my home computer if possible. – Brad Mathews Jan 26 '16 at 21:48
  • what did you do to solve the part of the problem? – Boboyum Jan 29 '16 at 17:43

1 Answers1

3

So I just solved the problem with my home computer by installing the SQL Server 2014 Management Studio. Native Client 11 is included and installs without complaint this way. My ODBC connection to SQL Azure is fully functional.

Brad Mathews
  • 1,567
  • 2
  • 23
  • 45