This is easily done, so let us explain how. OK, so begin by opening the SQL Server tool. From there, choose the database where you want to create a stored procedure.

To finish your new connection setting, click the small ellipsis button. You’ll need to do this to specify: server, login, database, and other connection properties.