CODEWITHSUNDEEP
sql-serverazureodbcazure-sql-databasessms
bneelon
bneelon

Reputation: 107

Server Objects not available in SQL Server Management Studio

I spun up an Azure SQL Database and connected to it using SSMS in hopes of following this tutorial. When I look in Object Explorer, the only two folders I see are "Databases" and "Security"; there is no "Server Objects", and for the life of me, I cannot figure out why not.

Available Folders

Is it an Azure SQL Database thing? Thank you in advance for any help you can provide!

Upvotes: 1

Views: 4574

Answers (1)

ColdSolstice
ColdSolstice

Reputation: 465

Azure SQL Database only allows database access. Server Objects is something you need access to the entire instance/server. If you want to use Azure, you'll need to spin up a VM and install SQL Server on there in order to follow this tutorial.

From the pictures in the tutorial it looks like they have SQL Server Express running on their local machine. If you can, try that route as it'll probably be cheaper and less hassle.

Upvotes: 6

Related Questions