After installing SQL Server 2008 R2, it wants a server name.
SQLCMD -L on cmd, but it shows the error below:
Data source name not found and no default driver specified
What am I doing wrong?
Any kind of help will be appreciated.
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.Sign up to join this community
You can go with two methods as given in answers to the Stack Overflow question How to find server name of SQL Server Management Studio.
Open up SQL Server Configuration Manager (search for it in the Start menu). Click on SQL Server Services. The instance name of SQL Server is in parenthesis inline with SQL Server service. If it says MSSQLSERVER, then it's the default instance. To connect to it in Management Studio, just type . (dot) OR (local) and click Connect. If the instance name is different, then use .[instance name] to connect to it (for example if the instance name is SQL2008, connect to .\SQL2008).
Also make sure SQL Server and SQL Server Browser services are running, otherwise you won't be able to connect.
Run this Query to get the name
On the server, go to SQL Server Configuration Manager.
Under SQL Server Services in the left pane, you will click and see Name, State, Start Mode, and Log On As for columns.
You should see SQL Server(NAME). Hopefully it is running, right click and go to properties. Click on the Service tab, you will see the Host Name, Name, Process ID, and other information here.
Please note, it's possible to install SQL Server Management Studios without installing and creating a SQL Server Database Engine. You may have to re-enter the installation to create and configure a Database Engine to connect to.