Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2002
    Location
    chennai
    Posts
    30

    Unanswered: Named and default instance in SQL Server 2k

    Hi,

    I am trying to create a DB in a instance of sql server 2k. But the problem is, i have two instances, one default and the other named instance. So when i create a db in default instance, the same is getting
    created automatically in named instance. Same happens when i try to do this in named instance. I mean both are acting like mirror instances. Can anyone try to sort this out.

    thanks in advance,
    bobby

  2. #2
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    What are the names of both instances?
    Check SQL Error log for any information. Have you installed named instance seperately or tried a mirrored copy.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •