How to connect to SDS?

Question

Hi,
I registered for SQL Services at http://portal.ex.azure.microsoft.com/ and I created a new solution. My question is, how do I connect?
I find a code example at http://blogs.msdn.com/jcurrier/archive/2009/03/29/sds-coding-examples-part-1-c-ado-net.aspx
and it got code like these:

            connStringBuilder.DataSource = "myserver.data.dev.mscds.com
"; // Specify the DNS name of my SDS server (which holds my master db).


            connStringBuilder.InitialCatalog = "mydatabase
";              // Specify your user database to connect to.


...


            connStringBuilder.UserID = "jeff@myserver
";                   // Specify my user id (and the server name which holds my master db)


            connStringBuilder.Password = "****
";                          // Finally, specify my password.

Where do I find out the data source, initial catalog, etc?

Thanks,
dk

Answer 1

Hi dk,

you need give solution name as username and for password,  solution password.

Regards
Kapil

Answer 2

https://accesscontrol.ex.azure.microsoft.com/ManageAccount.aspx is where you manage your solution credentials.

---

Aaron Stanley King - Microsoft Consultant - Perpetual Technologies, Inc. - http://www.perptech.com

Answer 3

Hello,
Thank you for your kind replies.
I have more questions: what do I put for data source and initial catalog? I tried to put "myserver.data.dev.mscds.com" and "https://data.database.windows.net/v1/" as the data source but neither worked. For initial catalog I tried to leave it blank.
Thanks,
dk

Answer 4

As far as I know the SQL logins haven't been turned on.  You still have to use the REST connection and query it like you would Astoria via the web service.  That is probably the issue.  SDS is still in V1.  V2 is due out any time now.

---

Aaron Stanley King - Microsoft Consultant - Perpetual Technologies, Inc. - http://www.perptech.com