microsoft sql studio management windows 10

#Microsoft sql studio management windows 10 how to#
#Microsoft sql studio management windows 10 install#
#Microsoft sql studio management windows 10 update#
#Microsoft sql studio management windows 10 password#

sp_Blitz – totally free health check script that warns you about dangerous things in your SQL Server that may present problems later.

How I Configure SQL Server Management Studio – my setup tips.

#Microsoft sql studio management windows 10 how to#

Now that you have an account that’s safe to use for learning, here are a few next steps of tools to explore on how to get to know your SQL Server better. Then, as soon as you’re done doing high-permissions stuff, close that window, and you’re back to your regular low-permission stuff. Note that the login change only affects the currently open query window: that’s the safest way to minimize the damage. That’ll give you the connect-to-server dialog box. To change accounts for the current query window, click the change-connection button at the top right. If you do need to switch over to your regular high-permission account, you could close SSMS entirely and reopen it, but there’s an easier way. Click Connect, and you’re now working a little more safely, without the superpowers of your regular domain login. This time, at the connection dialog:Ĭhoose SQL Server authentication because we created a new SQL login, and then type in your low-privileged username and password. This helps prevent you accidentally causing a resume-generating event.Ĭlose SSMS, and reopen it again. Now that you have a low-privileged account, you’re going to want to use this by default when you connect into SQL Servers with Management Studio.

Learn to switch back & forth between accounts. If you’ve got some time and you’re willing to roll up your sleeves a little, here’s how to deny writes in all new databases long term. If someone restores a database into this environment, you’ll be able to write to it. That only affects the databases you have in place today. Copy/paste the below into your new query window so we can find out if you have Windows-only authentication turned on:ĪLTER ROLE ADD MEMBER '

Start a new query by clicking File, New, Database Engine Query, or right-click on the SQL Server name and click New Query: We need to fix that so you don’t do something stupid. In the next step, we’ll set you up a low-privilege account.Ĭlick Connect, and you’ll be handsomely rewarded with a window that looks like this:Īt this point, you’re able to do … all kinds of dangerous things, actually. In that case, go ahead and use that for now.

#Microsoft sql studio management windows 10 password#

You might have a username & password on a post-it note somewhere, like from the person who installed it, and it might have a username of “sa”. If that fails, you either don’t have access to the server, or it’s configured with SQL authentication. This is usually the same as the server name itself, but if you have fancier setups like named instances or non-default port numbers, you’ll need to specify those here.Īuthentication – probably Windows, try that first. Server name – the DNS name or IP address where your SQL Server answers connection requests. Connect to your SQL ServerĪfter launching SSMS, you get a connection dialog:

You’re the kind of person who reads this blog, after all, and I … let’s just stop there. You wouldn’t remote desktop into the SQL Server and start playing Fortnite, now, would you? Don’t answer that. Over time, you’ll learn that running SSMS (as with any other app) on the SQL Server itself will slow it down.

It doesn’t matter what version of SQL Server you’re running in production: as long as you’re running a currently supported version of SQL Server (2012 & newer as of this writing), you always wanna run the latest version of SSMS, which will include a ton of bug fixes.ĭo this installation on your desktop or laptop, not on the SQL Server itself.

#Microsoft sql studio management windows 10 update#

If you already have a version of SSMS, the installer will automatically update it to the latest version.

#Microsoft sql studio management windows 10 install#

The first step is really easy: go here to get the latest version of SSMS and install it. Download and install SSMS (but not on the server itself)

Learn to switch back & forth between the low-privileged account and your regular one.

Create a low-privileged login so that you don’t accidentally drop objects.

Download the free Microsoft SQL Server Management Studio and install it, accepting the defaults.