Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

Connecting to AdventureWorks on Azure Expand / Collapse
Author
Message
Posted Tuesday, May 21, 2013 12:02 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, November 26, 2014 10:23 AM
Points: 2,630, Visits: 4,041
I am able to connect with 2008R2. It's a fantastic idea to have this hosted by redgate.

Thanks.

Tom
Post #1455153
Posted Tuesday, May 21, 2013 10:32 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, November 21, 2014 6:54 AM
Points: 26, Visits: 175
just got SSMS installed at home. it works!!! too bad my corporate firewall blocks it...
Post #1455297
Posted Wednesday, May 22, 2013 2:23 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Wednesday, November 26, 2014 12:21 AM
Points: 6,743, Visits: 8,517
Tested it from home using SSMS2008R2 (sp2): Works like a charm

Now to get our company network admins to open the required port

ref:Guidelines for Connecting to Windows Azure SQL Database

The Windows Azure SQL Database service is only available with TCP port 1433. To access a SQL Database database from your computer, ensure that your firewall allows outgoing TCP communication on TCP port 1433.


Thanks again SSC for making life easy


Johan


Don't drive faster than your guardian angel can fly ...
but keeping both feet on the ground won't get you anywhere

- How to post Performance Problems
- How to post data/code to get the best help


- How to prevent a sore throat after hours of presenting ppt ?


"press F1 for solution", "press shift+F1 for urgent solution"


Need a bit of Powershell? How about this

Who am I ? Sometimes this is me but most of the time this is me
Post #1455361
Posted Friday, November 15, 2013 3:03 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Wednesday, November 26, 2014 12:21 AM
Points: 6,743, Visits: 8,517
Did you also publish a web service to consume e.g. the [northwind].[sales by year] stored procedure ?

trying to build my first Windows phone app and experienced the account doesn't have execute authority for this stored proc.




Johan


Don't drive faster than your guardian angel can fly ...
but keeping both feet on the ground won't get you anywhere

- How to post Performance Problems
- How to post data/code to get the best help


- How to prevent a sore throat after hours of presenting ppt ?


"press F1 for solution", "press shift+F1 for urgent solution"


Need a bit of Powershell? How about this

Who am I ? Sometimes this is me but most of the time this is me
Post #1514643
Posted Friday, November 15, 2013 9:17 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: 2 days ago @ 3:05 PM
Points: 31,284, Visits: 15,750
I haven't changed anything, but I'll look into this.






Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1514769
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse