Shulou(Shulou.com)05/31 Report--

How to use SQL Server Management to connect to SQL Azure, many novices are not very clear about this, in order to help you solve this problem, the following editor will explain for you in detail, people with this need can come to learn, I hope you can gain something.

We showed you how to create a SQL Azure Database earlier, and here we show how to use SQL Server Management Studio (SSMS) to connect to and manage SQL Azure Database. Please install SQL Server Manage Studio first to prepare this course content.

1. First of all, let's go to the Windows Azure user management interface.

two。 Select "--> Select the subscription, locate the newDB database you created earlier, then find the connection string in the Properties column on the right, and select the button to the right of View.

3. In the pop-up window, we can see the connection string connected to the SQL Azure database. We select the connection string and copy it to the clipboard.

5. Open the native SQL Server Management Studio (SSMS). Copy the clipboard SQL Azure connection string in Server Name and enter the administrator's username and password in: Login and Password.

6. In Object Explorer, we see that the SQL Azure database is no different from the local database. We can see the default master database for SQL Azure and the newDB database we created earlier.

7. You can see that I am currently connected to the master database. What if I want to switch to the newDB database? Experienced developers are sure to think of using the USE command. So I executed this command: USE newDB. But after the implementation, it was found that the implementation was not successful.

The red error message above tells us that USE statements are not supported in SQL Azure.

So what if we want to switch to the newDB database? We can only disconnect the current connection and then reconnect to the SQL Azure server.

8. We disconnect the current connection and re-enter it and select "Options" in the login window.

9. Select "Browse server" in the Connection to database of "Connection Properties"

10. After a moment, SSMS will read all the database information in SQL Azure, then we select newDB and click "OK"

11.newDB becomes the database we want to connect to. We choose "Connect" to log in to SQL Azure.

twelve。 Determine the selected database by executing select db_name ()

Is it helpful for you to read the above content? If you want to know more about the relevant knowledge or read more related articles, please follow the industry information channel, thank you for your support.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.