UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Creating New Data Source To SQL Server - Azure, Any Versions    
 
   
tbs
post Oct 27 2017, 03:09 PM
Post#1



Posts: 257
Joined: 12-February 13



My head hurts....

I just went on an uncharted territory by signing up Azure account. I set up a sample (practice) SQL database.

I'm now trying to create a new Data Source to SQL Server. I'm following the instruction from this LINK.

I just want to make sure I'm doing it right because I'm getting an error (unable to connect). When I enter the Login ID as shown in this picture:

Attached File  Capture.JPG ( 34.09K )Number of downloads: 6


Is this LogIN/PW sign up account the same one you use to log in your Windows? Or is that the one that you use to log in your Azure account?

Thanks.
Go to the top of the page
 
GroverParkGeorge
post Oct 27 2017, 03:50 PM
Post#2


UA Admin
Posts: 31,191
Joined: 20-June 02
From: Newcastle, WA


It looks to me like you are trying to use the FMS login and password to connect to YOUR SQL Azure database.

You need to log in to your Azure account and locate the connection information for YOUR database there....

Attached File  AzureDB.png ( 31.76K )Number of downloads: 6


Attached File  ConnectionStringsAzure.png ( 30.93K )Number of downloads: 5

--------------------
Go to the top of the page
 
tbs
post Oct 30 2017, 08:55 AM
Post#3



Posts: 257
Joined: 12-February 13



Hmm...I wasn't using FMS account, but I will give it a shot later today and report back the result.

Thanks for the visuals. That is going to help.
Go to the top of the page
 
GroverParkGeorge
post Oct 30 2017, 09:09 AM
Post#4


UA Admin
Posts: 31,191
Joined: 20-June 02
From: Newcastle, WA


Okay, but the screen shot you posted showed the FMS credentials, so I have to ask. Making assumptions gets me into trouble too often. dontknow.gif

--------------------
Go to the top of the page
 


Custom Search
RSSSearch   Top   Lo-Fi    10th December 2017 - 11:12 PM