Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

How do I determine the server name for ms sql server. How do I make one, if there is no default server name. I need this so that I could use it as a database

Update: I tried using the computer name + / + SQLEXPRESS but no luck..I get this: alt text

share|improve this question
    
How about Fred –  Default Aug 27 '10 at 7:47

1 Answer 1

up vote 4 down vote accepted

Name of your server is name of computer itself + backslash + name of instance.

If computer is called XXX then server name would be just "XXX" for default instance. If you install SQL server express, name would be "XXX\SQLEXPRESS" since SQLEXPRESS is it's instance name.

If you want to access server on your local computer, simple dot will be enough (".") as server name.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.