i am trying to migrate database from sql server 2008 sp1 and 2012, in management studio, i am trying to connect to sql azure db, for this, Connect to database engine, enter my server name, login and pwd, sql server authentication used.
details: ***.database.windows.net, sql server authentication, loginid@
i got the error.
TITLE: Connect to Server
Cannot connect to **********.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)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&EvtSrc=MSSQLServer&EvtID=53&LinkId=20476
The network path was not found
this is one problem, but if i do not attach sql azure db in my local management studio , i directly started process from tool, in end step , after created script , finl step also getting like similar error,
please help me in this. tried with 2008 and 2012 also in win 2008 r2 server. firewall stopped also. added 1433 outbound port also.