Database version:Windows Azure
ADS version : ads-windows-x64-14.0-rc-44
Windows:8-64 bit
Connect to Azure Database->Go to master Database->Right Clcik->FluidShell->A new window will be opened, now you will observer that at the top of the Window after master database we have login name (master/sqladmin1 in mycase)
Now Connect to Sql Server 2005-> Go to master Database->Right Clcik->FluidShell->A new window will be opened, now you will observer that at the top of the Window after master database we have "schema name".
Now again go to Azure -> Go to any other database other then "master" Database->Right Clcik->FluidShell->A new window will be opened, now you will observer that at the top of the Window after database name we have "schema name".
Now run Following commands in FluidShell
change schema
list schemas
You will see that the output given by the first command will not be part of output of second command. See attached screen shots for refrence.
In Azure for master database as well we should have "Schema name" instead of Login name.
|
46 KB
|
20 KB
Nhi, can you look into it when you have time? Is there anything special about the azure master database in that it differs from SQL Server ?
It is working as expected. The string to the right of the database name is the database user, not schema, associated with the login.
Please verify in the master DB in both Azure and SqlServer to see what user is associated with the login. For example, look at the users inside the Users folder in the master DB. One of those user will have a login name in square brackets which is the login used for this connection. This is the user that will be displayed in the Fluidshell session.
It is working as expected. The string to the right of the database name is the database user, not schema, associated with the login.
Please verify in the master DB in both Azure and SqlServer to see what user is associated with the login. For example, look at the users inside the Users folder in the master DB. One of those user will have a login name in square brackets which is the login used for this connection. This is the user that will be displayed in the Fluidshell session.
Issue #10480 |
Closed |
Invalid |
Resolved |
Completion |
No due date |
No fixed build |
No time estimate |
Nhi, can you look into it when you have time? Is there anything special about the azure master database in that it differs from SQL Server ?