Welcome to Sign in | Help
in Search

SQL Notification Server - SQL Server Named Instance in ICF

Last post 05-15-2009, 8:04 PM by ggciubuc. 1 replies.
Sort Posts: Previous Next
  •  04-13-2009, 8:16 PM 7056

    SQL Notification Server - SQL Server Named Instance in ICF

    Salut,

    Am incercat sa creez o instanta pt. Notification Server din SQL Management Studio. Pt. asta i-am dat Instance Configuration File.

    Iata o bucata de ICF:

    <?xml version="1.0" encoding="utf-8"?>
    <NotificationServicesInstance xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns="http://www.microsoft.com/MicrosoftNotificationServices/ConfigurationFileSchema">
     <InstanceName>FlightInstance</InstanceName>
     <SqlServerSystem>%SqlServer%</SqlServerSystem>
     <Applications>
      <Application>


    Cum pasez numele instantei de SQL Server la %SqlServer% in SSMS? Problema este ca numele instantei mele de SQL Server contine backslash. Cand introduc MYSERVER\INST pentru %SqlServer%  imi da urmatoarea eroare:

     

    TITLE: Microsoft.SqlServer.NotificationServices
    ------------------------------

    The specified system name is not valid. The following are not allowed: "localhost", ".", an IP address, or any string containing a backslash character.
    Element Name: Providers/HostedProvider/SystemName
    System Name:
    MYSERVER\INST
    Line Number: 187
    Line Position: 4
    File Name: C:\Program Files\Microsoft SQL Server\90\Samples\Notification Services\Flight\AppDefinition\appADF.xml


    Cum as putea sa-i dau numele instantei de sql server?

    Multumesc

  •  05-15-2009, 8:04 PM 7197 in reply to 7056

    Re: SQL Notification Server - SQL Server Named Instance in ICF

    ioan ivanov:


     <SqlServerSystem>%SqlServer%</SqlServerSystem>
     


    In loc de %SqlServer%  puneti numele masinii gazda de exemplu "localhost "  (fara ghilimele)

    Iata un articol interesant pe care-l stiu de cand m-am jucat si eu cu Notification Services :http://www.devx.com/dbzone/Article/28522  ; din ce stiu NS-ul v fi scapat din brate de Microsoft in favoarea Reporting Services

    Gheorghe Ciubuc,SQL Server Influencer, MCP(SQL 2000), MCTS (SQL Server 2005) , OCA(Oracle 9i), Sybase(Brainbench)
View as RSS news feed in XML
Powered by Community Server (Commercial Edition), by Telligent Systems