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 Monday, May 20, 2013 12:09 AM


SSC-Dedicated

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

Group: Administrators
Last Login: Yesterday @ 4:29 PM
Points: 32,819, Visits: 14,965
Comments posted to this topic are about the item Connecting to AdventureWorks on Azure






Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1454411
Posted Monday, May 20, 2013 8:17 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, December 06, 2013 8:52 AM
Points: 6, Visits: 19
Login is failing:
"Failed to connect to server mhknbn2kdz.database.windows.net (Microsoft.SqlServer.ConnectionInfo)
Additional Information:
Cannot open database "master" requested by login. The login failed.
Login failed for user 'sqlfamily'.
This session has been assigned a tracing ID of 'cfc865f3-2498-4240-b87b-a195f50fdfe6'. Provide
this tracing ID to customer support when you need assistance. (Microsoft SQL Server, Error: 4060)
Post #1454551
Posted Monday, May 20, 2013 9:38 AM


SSC-Dedicated

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

Group: Administrators
Last Login: Yesterday @ 4:29 PM
Points: 32,819, Visits: 14,965
You need to specify the database as "AdventureWorks2012".






Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1454596
Posted Monday, May 20, 2013 9:57 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, December 06, 2013 8:52 AM
Points: 6, Visits: 19
That worked. Thanks.
Post #1454606
Posted Monday, May 20, 2013 10:58 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, April 17, 2014 7:19 AM
Points: 22, Visits: 150
I can't connect

I cecked the server name, login, password and database and all is correctly filled, but I can't connect in any way. I'm using SSMS 2008 R2, but the azure site said it works (previous versions don't).

"Cannot connect to mhknbn2kdz.database.windows.net.
A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server) (Microsoft SQL Server, Error: 53)"

I believe I need help with firewall settings. What is the IP/port used by Azure? Is there anything we need to configure regarding network to access this database?

thanks in advance,
Post #1454638
Posted Monday, May 20, 2013 11:02 AM


SSC-Dedicated

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

Group: Administrators
Last Login: Yesterday @ 4:29 PM
Points: 32,819, Visits: 14,965
1433, the standard SQL port is used by Microsoft.

You can specify this as : mhknbn2kdz.database.windows.net, 1433







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1454642
Posted Monday, May 20, 2013 1:41 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, April 17, 2014 7:19 AM
Points: 22, Visits: 150
Thanks for the quick reply, Steve, but I still can't access it. Maybe there is some firewall interfering, because I'm on a corporate network right now. I'll try again from home and see if it can connect.

regards,
Post #1454713
Posted Monday, May 20, 2013 10:52 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, April 21, 2014 9:30 PM
Points: 16, Visits: 86
Does this only work with 2012 or should 2008R2 be able to connect?
Post #1454810
Posted Tuesday, May 21, 2013 5:53 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, April 17, 2014 7:19 AM
Points: 22, Visits: 150
MS says Management Studio 2008R2 is able to connect to Azure. 2008-non-R2 is NOT however.


(I forgot to try to access last night )
Post #1454947
Posted Tuesday, May 21, 2013 11:19 AM


SSC-Dedicated

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

Group: Administrators
Last Login: Yesterday @ 4:29 PM
Points: 32,819, Visits: 14,965
I don't have a 2008 SSMS handy to test, but it may not work. It should, but it may not. Are you connecting in a query window or object explorer? I'd expect the former to work.

You can download SSMS 2012 only: http://www.jasonstrate.com/2013/05/get-just-the-tools-ssms-download/







Follow me on Twitter: @way0utwest

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

Add to briefcase 12»»

Permissions Expand / Collapse