Email Alert Links

• 
  Hi Bern,
  
  Running the SQL Response Client app should set up the relevant settings on that machine to handle sqlresponse:// urls.
  
  --
  Daniel

  dlkj September 25, 2008 05:13

  - 0 +
• 
  Daniel,
  
  The client is running on the repository server. I'm assuming that I don't have to install the client on every monitored server. It seems logical that the URL should point to a file on the host server with details about the server being reported on.
  
  Thanks,
  - Bern

  Bern Anderson September 25, 2008 10:09

  - 0 +
• 
  Hi Bern,
  
  The client does not need to be installed on the Alert Repository machine or the monitored SQL Servers.
  
  Clicking on a sqlresponse:// URL will cause the Client to launch, and then connect to the specified repository.
  --
  Daniel

  dlkj September 25, 2008 10:16

  - 0 +
• 
  I just get a local link browser that opens to 'my documents'.

  Bern Anderson September 25, 2008 14:13

  - 0 +
• 
  Hi Bern,
  The way it should work is that when you first run the client it registers the sqlresponse:// URL type. So when you get an email and click on the link it should fire up the client, connect to the alert repository then download and display the alert in question.
  
  So when you click on the link it just opens "My Documents" yes? Presumably this is on a machine where you have run the client at least once? What OS are you running (Vista, XP, Win2k etc).

  Nigel Morse September 26, 2008 05:08

  - 0 +
• 
  I am on Windows XP SP2
  I have the client installed on my laptop
  Repository is on the remote SQL Server
  
  
  when I click on a link in email alert, it opens up my SQL Response client, and go to that alert directly

  jerryhung September 26, 2008 10:06

  - 0 +
• 
  Nigel,
  
  Both the respository and the client are installed on my test server which is running Win Server 2003 Standard edition, SP2. The emails go to Outlook on my workstation which is running Win XP Professional, SP2.
  
  When I click the URL, it opens to "My Documents" on my workstation. Where can I edit the "sqlresponse://" URL so it connects to the appropriate location?
  
  Thanks,
  - Bern

  Bern Anderson September 26, 2008 12:28

  - 0 +
• 
  Hi Bern,
  You need to install the client on your own machine for the URL to work - you should be able to connect the client to the repository on the test server then. The links can only bring up the client on the same machine.

  Nigel Morse September 29, 2008 06:09

  - 0 +
• 
  Thanks Nigel; it makes sense now. Any chance that it the future, the email could be modified to create a web link to the error details? The goal is that an on-call person could open the emailed link in a blackberry and identify the issue in question.
  
  Thanks,
  
  - Bern

  Bern Anderson September 29, 2008 12:00

  - 0 +

Add comment

Please sign in to leave a comment.