Can't connect to Alert Repository?

salhzmzm · Joined: 07 May 2010 Posts: 10

Hi

first, I installed SQL toolbelt then I opened SQL Response 1,
I followed insrtuction to setup Alert Repository, every thing here is ok.

When I try to connect to Alert Repository I got this error :

I checked Alert Repository service and it's running with Administrator account.

What is the proplem?

Anu Deshpande · Joined: 20 Apr 2009 Posts: 595 Location: Cambridge

Many thanks for your post.

It sounds like you may be encountering a known issue when the server you are monitoring is on a different domain. Plese see the following knowledgebase article:

http://www.red-gate.com/supportcenter/Content.aspx?p=SQL%20Response&c=knowledgebase%5cSQL_Response%5cKB200904000378.htm

If this is not the case, please check your login credentials as per:

http://www.red-gate.com/supportcenter/Content.aspx?p=SQL%20Response&c=SQL_Response/help/1.1/SR_Installing_Alert_Repository.htm&toc=SQL_Response/help/1.1/toc55308.htm

and

http://www.red-gate.com/supportcenter/Content.aspx?p=SQL%20Response&c=knowledgebase/SQL_Response/KB200810000307.htm

If you still have problems, please send across the Alert Repository logs . You can get these as per:

http://www.red-gate.com/supportcenter/Content.aspx?p=SQL%20Response&c=SQL_Response%5cknowledgebase%5cSR_log_files.htm
_________________
Anuradha Deshpande
Product Support
Redgate Software Ltd.
E-mail: support@red-gate.com

salhzmzm · Joined: 07 May 2010 Posts: 10

thanks for helping me.

I folloed the instructions [How do I use the SQL Response client across domains?] in the first situation and now I am getting new error :

It seems that a connection has been made and then closed.

Anu Deshpande · Joined: 20 Apr 2009 Posts: 595 Location: Cambridge

Many thanks for your post.

Can you kindly confrim that you have changed the setting for Secure remoting to <SecureRemoting>False</SecureRemoting>? For both Client and server config file?

Are you running Alert Repository on Virtual machine?
_________________
Anuradha Deshpande
Product Support
Redgate Software Ltd.
E-mail: support@red-gate.com

salhzmzm · Joined: 07 May 2010 Posts: 10

I am running SQL SERVER 2008 on my PC and I am not using virtual machine.

I confrim that I have changed the setting for Secure remoting to <SecureRemoting>False</SecureRemoting>? For my PC

salhzmzm · Joined: 07 May 2010 Posts: 10

What is the proplem?

Anu Deshpande · Joined: 20 Apr 2009 Posts: 595 Location: Cambridge

Can we assumed correctly that SQL Response was working correctly prior to this error occurring? Or you have never been able ever to connect to the Alert Repository Machine?

Can you please ensure that the SQL Response Alert Repository Service is in a started condition on the Alert Repository machine?

From the screen shot, I see that you are attempting to connection on the default port 7398, is this the port configured when the Alert Repository was first created?

Are there any firewall type devices between the SQL Response Client and the Alert Repository machine? If the answer is yes, is the firewall configured to allow data through port 7398?

Can you telnet from the SQL Response Client Machine to the Alert Repository machine on port 7398 or the port number configured, if different from the default port number?
_________________
Anuradha Deshpande
Product Support
Redgate Software Ltd.
E-mail: support@red-gate.com

salhzmzm · Joined: 07 May 2010 Posts: 10

Anu Deshpande · Joined: 20 Apr 2009 Posts: 595 Location: Cambridge

Thanks for the update.

Your Alert Repository service is not running.

Can you kindly use a windows account and not a sql server account to run the service?

Kindly let me know how it goes.
_________________
Anuradha Deshpande
Product Support
Redgate Software Ltd.
E-mail: support@red-gate.com

salhzmzm · Joined: 07 May 2010 Posts: 10

Thanks for helping me.

First, I want to tell you that I am running SQL Server on this account "SQL2008SBSDE" (this is windows account)
and I setup the service to run on the same account "SQL2008SBSDE" and it's running successfully

and I am opening red-gate SQL Response 1 from othe account with admins privilliges

now I am getting this new error :

salhzmzm · Joined: 07 May 2010 Posts: 10

I am getting this error also:

all this errors and I don't know why Question

salhzmzm · Joined: 07 May 2010 Posts: 10

Any one can help me Exclamation

Anu Deshpande · Joined: 20 Apr 2009 Posts: 595 Location: Cambridge

Apologies for delay in replying you.

Can you take a look in the Advanced Network Settings, specifically the binding order? Can you make sure that the correct NIC is the first binding?
_________________
Anuradha Deshpande
Product Support
Redgate Software Ltd.
E-mail: support@red-gate.com

salhzmzm · Joined: 07 May 2010 Posts: 10

Can you tell me where I can find Advanced Network Settings.

I am using win 7

Anu Deshpande · Joined: 20 Apr 2009 Posts: 595 Location: Cambridge

Open up your "Network and Sharing Center."

Click "Change Adapter Settings" in right-hand pane.

This should bring you to Control Panel\Network and Internet\Network Connections. You can also get there by running "ncpa.cpl".

Hit "ALT" to make the menu bar visible, and pick "Advanced" (Alt-N will bring you directly to that menu), and pick "Advanced Settings".

That will open the Advance Settings window, and you can adjust your binding order there.
_________________
Anuradha Deshpande
Product Support
Redgate Software Ltd.
E-mail: support@red-gate.com

	All times are GMT + 1 Hour Go to page 1, 2 Next
Page 1 of 2