SqlDbx Forum

SqlDbx

You are not logged in.

#1 2010-12-01 00:00:02

Allen
Member

SQL Azure Connection

We just recently opened an account on Microsoft's Azure platform.

We were initially having trouble connecting to SQLServer Azure w/SQLDbx.  We found that the problem isn't SQLDbx at all.  You must pre-pend '@<servername>' in front of the user name like this:

User: 'MyLoginID@khcjfynfyi'

(Azure will assign you a cryptic server name like 'khcjfynfyi' above).

Rgds,
Allen

Offline

#2 2010-12-15 18:02:48

Allen
Member

Re: SQL Azure Connection

....just realized that rowcounts are not being displayed (Show Table Rowcount).  Must be due to a change in system tables.

Here is the new version info for SQLAzure: Microsoft SQL Azure (RTM) - 10.25.9501.0 Nov  3 2010 13:04:51 Copyright (c) Microsoft Corporation.

Let me know if you'd like to connect to mine to check out their changes to system tables, or shoot me the query you'd like me to run to check it for you.

Rgds,
Allen

Offline

Board footer

Powered by FluxBB