none
SQL Server Enterprise Manager(2000)管理問題 RRS feed

  • 問題

  • Dear All:
    我新增了SQL Server群組
    由於客戶的資料庫是代管的
    所以可能SQL Server主機會重覆
    但登入帳號密碼是不一樣的
    請問在新增SQL註冊時
    如遇到一樣的主機IP
    一定只能建一個嗎
    因為現在我在登入SQL Server
    如遇到一樣的IP
    就要重新指向帳號密碼
    才可登入管理

    謝謝

    2006年7月18日 上午 01:47

解答

  • 您指的應該是multi instance吧??

    如果是的話,要用instance name的方式在EM上面註冊

    請參考

    There are two types of instances of SQL Server:

    Default Instances

    The default instance of the SQL Server 2000 database engine operates the same way as the database engines in earlier versions of SQL Server. The default instance is identified solely by the name of the computer on which the instance is running, it does not have a separate instance name. When applications specify only the computer name in their requests to connect to SQL Server, the SQL Server client components attempt to connect to the default instance of the database engine on that computer. This preserves compatibility with existing SQL Server applications.

    There can only be one default instance on any computer, the default instance can be any version of SQL Server.

    Named Instances

    All instances of the database engine other than the default instance are identified by an instance name specified during installation of the instance. Applications must provide both the computer name and the instance name of any named instance to which they are attempting to connect. The computer name and instance name are specified in the format computer_name\instance_name.

    There can be multiple named instances running on a computer, but only the SQL Server 2000 database engine can operate as a named instance. The database engines from earlier versions of SQL Server cannot operate as a named instance.

     

    2006年7月19日 上午 01:31