Final answer:
To setup a server in SQL Server Management Studio, you should open SSMS, enter the server details, choose the authentication method, connect to the server, and then create databases and database objects as needed. Administrative rights are required for server setup.
Step-by-step explanation:
To setup a server in SQL Server Management Studio (SSMS), you must have administrative rights to the machine on which SQL Server is installed. Here's a step-by-step guide: Open SQL Server Management Studio. In the 'Connect to Server' window, enter the server name. This can be a local instance (e.g., localhost\SQLEXPRESS) or a network server instance. Specify the authentication method. You can use Windows Authentication (which uses your current user credentials) or SQL Server Authentication (which requires a username and password set up for the SQL Server).
Once you've entered your connection details, click 'Connect' to establish a connection with the server. If this is a new server and you need to create databases, right-click on the 'Databases' folder in the Object Explorer and select 'New Database'. Provide the necessary database information and click 'OK' to create the database. After setting up databases, you can begin creating tables, views, and other database objects as needed.