Post reply

Named Instance SQL2008R2

  • June 28, 2013 at 2:37 pm

    #279634

    I am trying to install SQL2008R2 enterprize version on server 2. Can I use the existing Instance name ( suppose INST01 is already exist in Server1) Because when I am trying to use the same instance during installation I am getting this error 'access denied' when the user has the local admin access.

  • June 28, 2013 at 2:50 pm

    #1628426

    Are you trying to upgrade the existing instance or create a new instance?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • June 28, 2013 at 2:56 pm

    #1628429

    Creating new instance on new server.

  • June 28, 2013 at 3:13 pm

    #1628430

    Then you need to use an instance name that does not exist on that server.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • June 28, 2013 at 3:18 pm

    #1628431

    Shouldn't it be ok if the instances are on different servers?

    I'm sure it's a different problem (I might be wrong:-P).

    Luis C.
    General Disclaimer:
    Are you seriously taking the advice and code from someone from the internet without testing it? Do you at least understand it? Or can it easily kill your server?

    How to post data/code on a forum to get the best help: Option 1 / Option 2

  • June 28, 2013 at 3:30 pm

    #1628434

    That's what I thought. Thanks

  • June 28, 2013 at 3:46 pm

    #1628437

    Be sure to run the setup program as an admin, got burned on that before.. My user has admin but it seemed to have problems so when I ran the setup as an admin I didn't have the same problems..

    YMMV

    CEWII

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply