To create the local database, set the Database Name and select the authentication type to “ Windows Authentication”.
Read: The Database as Part of the System Architecture If you have the permissions then you can connect to it by giving server address and the authentication details. Once you will open the Management Studio Software, it will ask you to connect.
Here are two quick methods that explain how to open SQL Server Management Studio Software on your computer. It allows you to connect to a remote instance of an SQL Server and it is generally used by the administrator, testers, and the Developers. The objective of this software is to make database handling easier with Graphical User-Interface instead of Command-Line prompt.
This Software is available for free from Microsoft to create and manage the SQL databases. How to install, run and open the SQL Server Management Studio Software
Keep default option File for Backup Media Type unchanged. Select backup devices dialog screen will be displayed. When Restore Database wizard is displayed, in General tab switch to Device on Source section to point to database backup file of AdventureWorks sample database. I want to create a new database on my SQL Server instance using this backup file of the AdventureWords database.įirst, launch SQL Server Management Studio (SSMS)Ĭonnect to SQL Server instance which you want to create AdventureWorks database I have also downloaded AdventureWorks sample database backup file. I have a SQL Server 2014 instance running on my development computer.