Connecting to AdventureWorks on Azure

Question

Connecting to AdventureWorks on Azure

Viewing 15 posts - 16 through 30 (of 34 total)

You must be logged in to reply to this topic. Login to reply

snr 33755 Grasshopper Points: 18 More actions · Answer 1

Fantastic! Thank you for continuing to support this! I followed the instructions, and manually typed in the default database (see above posts), and it connected fine.:-)

This will be very helpful. I had been using the free month of Azure from Microsoft, but ran out of time.

Thanks again!

g.britton SSChampion Points: 13863 More actions · Answer 2

Hey Steve, I just noticed that, after connecting to this database, the account doesn't have EXECUTE permission on at least one PROC:

uspGetWhereUsedProductID

Gerald Britton, Pluralsight courses

Steve Jones - SSC Editor SSC Guru Points: 736172 More actions · Answer 3

g.britton (7/20/2016)
Hey Steve, I just noticed that, after connecting to this database, the account doesn't have EXECUTE permission on at least one PROC:
uspGetWhereUsedProductID

Better? Granted exec to the role for procs.

g.britton SSChampion Points: 13863 More actions · Answer 4

Steve Jones - SSC Editor (7/20/2016)
g.britton (7/20/2016)
Hey Steve, I just noticed that, after connecting to this database, the account doesn't have EXECUTE permission on at least one PROC:
uspGetWhereUsedProductID
Better? Granted exec to the role for procs.

Thanks, I'll give it a shot!

Gerald Britton, Pluralsight courses

a.abalos.castillo Mr or Mrs. 500 Points: 559 More actions · Answer 5

As of November 8th 2016, the database seems not available. Error message "The user was not authorized".

Steve Jones - SSC Editor SSC Guru Points: 736172 More actions · Answer 6

I tried this morning and it seemed to work for me. Did you specify AdventureWorks2012 as the datbase? Don't leave it as default.

mamo4444 Newbie Points: 1 More actions · Answer 7

It seems that the Azure SQL DB is still up and running but when connecting via SSMS the following message is received:

Login failed for user 'sqlfamily'

There is a similar response when trying to connect with Power BI:

We couldn't authenticate with the credentials provided.

Has there been an update to the username/password?

-Manuel

Steve Jones - SSC Editor SSC Guru Points: 736172 More actions · Answer 8

A subscription problem occurred. I have a ticket open to try and resolve this.

Osvaldo Newbie Points: 1 More actions · Answer 9

Hello Steve,

I am having the same issue. seems that user is not valid, could you please help me to connect the database?

Regards.

Steve Jones - SSC Editor SSC Guru Points: 736172 More actions · Answer 10

OK, I was unable to get the original database back as the subscription expired.

I have created a new one and updated the credentials in the article.

brentwc Newbie Points: 5 More actions · Answer 11

Is anyone else seeing firewall issues on the server side?

Steve - can you widen the IPs allowed to read the database.

https://github.com/microsoft/azuredatastudio/issues/13839

Steve Jones - SSC Editor SSC Guru Points: 736172 More actions · Answer 12

The IPs are not restricted. What issue are you getting? I just had someone connect from SQLCMd and I've been able to connect from SSMS and ADS. Are you using the updated credentials (Nov 2020) and specifying the database name?

brentwc Newbie Points: 5 More actions · Answer 13

Hi Steve,

Yes, I think I am using the appropriate credentials - unless the article updated per your November comment appeared somewhere other than here: https://www.sqlservercentral.com/articles/connecting-to-adventureworks-on-azure

When I use the connection properties to specify the database, I am not permitted to see the server with ADS giving notice that my IP is not granted access through the server firewall.

You probably don't see this issue if you are running logged into your azure account which created the database.

However, ADS provides an option to update the server firewall rules by saving my IP range. (and also provides this link https://docs.microsoft.com/en-us/azure/azure-sql/database/firewall-configure to instruct further how to update the server settings)

fwissue

I've seen similar firewall issues persist in my corporate environment for Azure Synapse SQL pools (formerly azure sql datawarehouse) recently when new security requirements started to narrow the whitelist.

My friend, whom I'm introducing to ADS has a personal azure cloud account and has the same permitting issue to use the demo database. (So I don't think that my logging into my azure account should matter in the prompt from ADS above, but only would allow me to update the IP list as proposed if my account were granted such permissions on your server.)

Summer 2020, I was able to login using ADS just fine without any issue and find this to be a great resource in getting T-SQL to new users quickly.

Hopefully we can get this up and running for similar intros - it is a great resource.

Thanks

-Brent

Steve Jones - SSC Editor SSC Guru Points: 736172 More actions · Answer 14

That's strange, but I think this is your firewall, not mine. I've had a few friends test this, and the IP range is open to 0.0.0.0, so all IPs.

brentwc Newbie Points: 5 More actions · Answer 15

Thanks Steve,

From what I see on my side, there isn't anything on my firewall that would not permit me to access your server.

Why would ADS provide the message "your client IP does not have access to the server" if the issue is my firewall?

Might you make the range explicit 0.0.0.0 to 255.255.255.255 and allow me to re-try?

Best,

Brent