Where or How can I find the name of my MSSQL 2008 R2 Server?

Question

I installed MSSQL 2008 R2 on a windows 7. All I want to do is findout what the server name is. Where can I find it. How can I find it. Please help!!!!

Answer 1

Assuming you are working with SQL Express

By default SQL Express is installed as a named instance of  SQLExpress

you can connect to it using localhost\SQLExpress or <ComputerName>\SQLExpress
as server name in management studio express (computrename is hostname of your computer)

you can find your local instance (default or named) by opening SQL Server configuration manager (Start-->Run-->SQLServerManager10.msc) or from command prompt

running

SQLCMD -L

Answer 2

Are you able to log in? If yes, then in SSMS just do

SELECT @@SERVERNAME

---

For every expert, there is an equal and opposite expert. - Becker's Law


My blog

Answer 3

Thank you Chiraq!!! That did the trick..."and the minstrels all rejoiced"

---

Sean R McCormick Erin Go Bragh