Skip navigation
McAfee Secure sites help keep you safe from identity theft, credit card fraud, spyware, spam, viruses and online scams
160 Views 1 Reply Latest reply: Sep 11, 2013 10:54 PM by petersimmons RSS
Don_Martin Apprentice 104 posts since
Nov 11, 2010
Currently Being Moderated

Sep 11, 2013 5:03 AM

Difference in using namend instance or standard instance?

Hi,

 

what kind of differences will come up with using a standard SQLInstallation (MSSQLserver instead of EPOSERVER). Are there any behvings with which the neccessarity of using a named instance on a one Server platform (ePO+SQL) is explainable? Which side effects come up with this or are there any problems in a nonclustered envirnoment known?

Simpel question: Why use a named instance?

  • petersimmons McAfee Employee 230 posts since
    Dec 22, 2009

    It is purely one of convenience of management. When using a dedicated SQL server there's no need to bother. When using a shared resource or a cluster it is highly advisable to seperate different sets of business functions into differing instances. This is largely an administrative concept but it does have some security involved since databases can theoretically access shared resources within the same instance.

More Like This

  • Retrieving data ...

Bookmarked By (0)

Legend

  • Correct Answers - 5 points
  • Helpful Answers - 3 points