0

I found this pretty weird thing when I first installed SQL Server 2008, for some reason there are two things that I want to get rid of and I can't:

  1. If my computer name is, say, ABC, then I always have to connect to ABC/MSSQLSERVER for the server name when I log in from the SQL Server client, instead of using just using ABC, may I know how I can do that?

  2. How can I default the DB so that if I have multiple DB on the server (System DB + my real DB), I can always default to use my real DB without saying "Use MyRealDB" every time?

Thanks a lot!

Regards, Anyi

Improve this question

2 Answers 2

Reset to default
6

1) When installing, you picked a named instance.

2) In user admin, you can specify the default database per user.

Improve this answer
Sign up to request clarification or add additional context in comments.

3 Comments

Thanks for your quick reply. So do I have to uninstall and reinstall for fix the first issue or I can simply convert the named instance to default instance somehow? And where I can choose to install named instance? I am using MS-SQL Server 2008 in Windows Server 2008 R2. Thanks!
I did a quick search to confirm what I thought, but the only way to change it is to reinstall.
Oh, well, I guess then I am out of luck then, OK, I'll try to reinstall tonight. Thanks!
2
  1. What's happened here is that your SQL Server is installed as a named instance. To remedy this, you'll have to remove and reinstall SQL Server.
Improve this answer

Comments

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.