May 20, 2013 at 12:09 am
Comments posted to this topic are about the item Connecting to AdventureWorks on Azure
May 20, 2013 at 8:17 am
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)
May 20, 2013 at 9:38 am
You need to specify the database as "AdventureWorks2012".
May 20, 2013 at 9:57 am
That worked. Thanks.
May 20, 2013 at 10:58 am
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,
May 20, 2013 at 11:02 am
1433, the standard SQL port is used by Microsoft.
You can specify this as : mhknbn2kdz.database.windows.net, 1433
May 20, 2013 at 1:41 pm
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,
May 20, 2013 at 10:52 pm
Does this only work with 2012 or should 2008R2 be able to connect?
May 21, 2013 at 5:53 am
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 🙁 )
May 21, 2013 at 11:19 am
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/
May 21, 2013 at 12:02 pm
I am able to connect with 2008R2. It's a fantastic idea to have this hosted by redgate.
Thanks.
Tom
May 21, 2013 at 10:32 pm
just got SSMS installed at home. it works!!! too bad my corporate firewall blocks it... 🙁
May 22, 2013 at 2:23 am
Tested it from home using SSMS2008R2 (sp2): Works like a charm 🙂
Now to get our company network admins to open the required port :crazy:
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
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- 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
November 15, 2013 at 3:03 am
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
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- 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
November 15, 2013 at 9:17 am
I haven't changed anything, but I'll look into this.
Viewing 15 posts - 1 through 15 (of 34 total)
You must be logged in to reply to this topic. Login to reply