I just installed SQL Server Developer Edition and SQL Server Management Studio, how can I configure the server? I want to configure it to have server name localhost-sql-server, with a login/password. I found the configuration manager but not sure where I can modify this.
Sql-server – Setting up SQL Server Developer Edition
configurationinstallationsql server
Related Question
- SQL Server 2008 Configuration Comparison – How to Compare Two Configurations
- Find SQL Server Version/Edition Without SSMS Installed
- Connect SQL Server 2008 R2 to SQL Server 2000
- SQL Server – How to Download SQL Server Developer Edition
- Sql-server – Connecting SQL Server Developer Edition to Visual Studio Windows Forms Application
- Sql-server – SQL Server Configuration Manager not showing services
- SQL Server – How to Deny Access to Certain Logins Over SSMS but Allow Over .Net SqlClient
Best Answer
For your first question:
This is normally done during installation. From the "Install SQL Server from the Installation Wizard (Setup)" article:
You would want a named instance. Instance names are limited to 16 characters and cannot contain hyphens (thanks to Dan Guzman for pointing that out), so you unfortunately can't name it "localhost-sql-server" per your original request.
I typically have multiple versions of SQL Server installed on my laptop, for different development projects, and name them "SQL2017" or "SQL2016" per the version installed. You may want to go with that route.
Once that's done, you can connect to it using the server name ".\SQL2017" (the computer name is part of the connection, which you can replace with ".\" for local connections).
I would recommend uninstalling SQL Server and setting it up this way from the start. I'm not aware of a simple way to change a default (standalone) instance to a named instance.
For your second question:
That's also normally done during installation, here's a relevant quote from the same docs page:
You would want mixed mode. Once the server is set up, you could connect with the "sa" account and create a login and user with the desired password:
Good luck!