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

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
AZhu
  • 1,312
  • 6
  • 22
  • 40

2 Answers2

6

1) When installing, you picked a named instance.

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

Community
  • 1
  • 1
NKCSS
  • 2,716
  • 1
  • 22
  • 38
  • 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! – AZhu Apr 08 '11 at 19:18
  • 2
    I did a quick search to confirm what I thought, but the only way to change it is to reinstall. – NKCSS Apr 08 '11 at 19:24
  • Oh, well, I guess then I am out of luck then, OK, I'll try to reinstall tonight. Thanks! – AZhu Apr 08 '11 at 20:13
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.
p.campbell
  • 98,673
  • 67
  • 256
  • 322