How to connect to SDS?Hi,<br/> 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? <br/> I find a code example at http://blogs.msdn.com/jcurrier/archive/2009/03/29/sds-coding-examples-part-1-c-ado-net.aspx<br/> and it got code like these:<br/> <pre><span><span style="font-size:x-small"> connStringBuilder.DataSource = &quot;<span style="color:#8b0000">myserver.data.dev.mscds.com</span> &quot;; <span style="color:#008000">// Specify the DNS name of my SDS server (which holds my master db).</span> <br/> connStringBuilder.InitialCatalog = &quot;<span style="color:#8b0000">mydatabase</span> &quot;; <span style="color:#008000">// Specify your user database to connect to.</span> <br/> ...<span style="color:#008000"></span> <br/> connStringBuilder.UserID = &quot;<span style="color:#8b0000">jeff@myserver</span> &quot;; <span style="color:#008000">// Specify my user id (and the server name which holds my master db)</span> <br/> connStringBuilder.Password = &quot;<span style="color:#8b0000">****</span> &quot;; <span style="color:#008000">// Finally, specify my password.</span> </span> </span> </pre> Where do I find out the data source, initial catalog, etc?<br/> <br/> Thanks,<br/> dk<br/>© 2009 Microsoft Corporation. All rights reserved.Tue, 16 Jun 2009 18:47:25 Z9140b5c3-cc71-4cb3-b9a7-0d40e8d586ddhttp://social.msdn.microsoft.com/Forums/en-US/ssdsgetstarted/thread/9140b5c3-cc71-4cb3-b9a7-0d40e8d586dd#9140b5c3-cc71-4cb3-b9a7-0d40e8d586ddhttp://social.msdn.microsoft.com/Forums/en-US/ssdsgetstarted/thread/9140b5c3-cc71-4cb3-b9a7-0d40e8d586dd#9140b5c3-cc71-4cb3-b9a7-0d40e8d586dddk1027http://social.msdn.microsoft.com/Profile/en-US/?user=dk1027How to connect to SDS?Hi,<br/> 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? <br/> I find a code example at http://blogs.msdn.com/jcurrier/archive/2009/03/29/sds-coding-examples-part-1-c-ado-net.aspx<br/> and it got code like these:<br/> <pre><span><span style="font-size:x-small"> connStringBuilder.DataSource = &quot;<span style="color:#8b0000">myserver.data.dev.mscds.com</span> &quot;; <span style="color:#008000">// Specify the DNS name of my SDS server (which holds my master db).</span> <br/> connStringBuilder.InitialCatalog = &quot;<span style="color:#8b0000">mydatabase</span> &quot;; <span style="color:#008000">// Specify your user database to connect to.</span> <br/> ...<span style="color:#008000"></span> <br/> connStringBuilder.UserID = &quot;<span style="color:#8b0000">jeff@myserver</span> &quot;; <span style="color:#008000">// Specify my user id (and the server name which holds my master db)</span> <br/> connStringBuilder.Password = &quot;<span style="color:#8b0000">****</span> &quot;; <span style="color:#008000">// Finally, specify my password.</span> </span> </span> </pre> Where do I find out the data source, initial catalog, etc?<br/> <br/> Thanks,<br/> dk<br/>Tue, 16 Jun 2009 06:28:09 Z2009-06-16T06:28:09Zhttp://social.msdn.microsoft.com/Forums/en-US/ssdsgetstarted/thread/9140b5c3-cc71-4cb3-b9a7-0d40e8d586dd#be548043-ef75-4a77-a078-1d22e055e2a9http://social.msdn.microsoft.com/Forums/en-US/ssdsgetstarted/thread/9140b5c3-cc71-4cb3-b9a7-0d40e8d586dd#be548043-ef75-4a77-a078-1d22e055e2a9Kapil Muni Guptahttp://social.msdn.microsoft.com/Profile/en-US/?user=Kapil%20Muni%20GuptaHow to connect to SDS?Hi dk,<br/><br/>you need give solution name as username and for password,  solution password.<br/><br/>Regards<br/>KapilTue, 16 Jun 2009 07:36:39 Z2009-06-16T07:37:28Zhttp://social.msdn.microsoft.com/Forums/en-US/ssdsgetstarted/thread/9140b5c3-cc71-4cb3-b9a7-0d40e8d586dd#a10db2c5-a697-4772-84a9-4684cec71940http://social.msdn.microsoft.com/Forums/en-US/ssdsgetstarted/thread/9140b5c3-cc71-4cb3-b9a7-0d40e8d586dd#a10db2c5-a697-4772-84a9-4684cec71940Aaron Stanley Kinghttp://social.msdn.microsoft.com/Profile/en-US/?user=Aaron%20Stanley%20KingHow to connect to SDS?<a href="https://accesscontrol.ex.azure.microsoft.com/ManageAccount.aspx">https://accesscontrol.ex.azure.microsoft.com/ManageAccount.aspx</a> is where you manage your solution credentials.<hr class="sig">Aaron Stanley King - Microsoft Consultant - Perpetual Technologies, Inc. - http://www.perptech.com Tue, 16 Jun 2009 15:14:31 Z2009-06-16T15:14:31Zhttp://social.msdn.microsoft.com/Forums/en-US/ssdsgetstarted/thread/9140b5c3-cc71-4cb3-b9a7-0d40e8d586dd#3c847b49-1481-48e3-848c-0a4ad8450313http://social.msdn.microsoft.com/Forums/en-US/ssdsgetstarted/thread/9140b5c3-cc71-4cb3-b9a7-0d40e8d586dd#3c847b49-1481-48e3-848c-0a4ad8450313dk1027http://social.msdn.microsoft.com/Profile/en-US/?user=dk1027How to connect to SDS?Hello,<br/> Thank you for your kind replies.<br/> I have more questions: what do I put for data source and initial catalog? I tried to put &quot;myserver.data.dev.mscds.com&quot; and &quot;https://data.database.windows.net/v1/&quot; as the data source but neither worked. For initial catalog I tried to leave it blank.<br/> Thanks,<br/> dk<br/>Tue, 16 Jun 2009 18:39:14 Z2009-06-16T18:39:14Zhttp://social.msdn.microsoft.com/Forums/en-US/ssdsgetstarted/thread/9140b5c3-cc71-4cb3-b9a7-0d40e8d586dd#cffb3328-3126-437d-a60a-7e82f21094fdhttp://social.msdn.microsoft.com/Forums/en-US/ssdsgetstarted/thread/9140b5c3-cc71-4cb3-b9a7-0d40e8d586dd#cffb3328-3126-437d-a60a-7e82f21094fdAaron Stanley Kinghttp://social.msdn.microsoft.com/Profile/en-US/?user=Aaron%20Stanley%20KingHow to connect to SDS?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.<hr class="sig">Aaron Stanley King - Microsoft Consultant - Perpetual Technologies, Inc. - http://www.perptech.com Tue, 16 Jun 2009 18:45:08 Z2009-06-16T18:45:08Z