Can't connect to Alert Repository?

salhzmzm · May 7, 2010 8:38AM

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 D · May 10, 2010 11:42AM

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/C ... 000378.htm

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

http://www.red-gate.com/supportcenter/C ... c55308.htm

and

http://www.red-gate.com/supportcenter/C ... 000307.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/C ... _files.htm

salhzmzm · May 10, 2010 5:27PM

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 D · May 13, 2010 4:36AM

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?

salhzmzm · May 13, 2010 5:07AM

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 · May 17, 2010 7:02AM

What is the proplem?

Anu D · May 17, 2010 7:15AM

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?

salhzmzm · May 17, 2010 12:49PM

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?

This is the first time I use Red Gate products

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

I am using MS SQL Server 2008 and SQL Response Alert Repository Service on the same 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?

When I installed SQL Response Alert Repository I choosed the default port 7398

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?

There is no firewall

I think there is one thing you should know, I have created seperate account with a password for SQL Server and when I try to start SQL Response Alert Repository Service using SQL Server account, I got this error

Thanks in Advance

Anu D · May 19, 2010 2:53AM

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.

salhzmzm · May 20, 2010 11:58AM

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 · May 20, 2010 12:04PM

I am getting this error also:

all this errors and I don't know why :?:

salhzmzm · June 2, 2010 2:32AM

Any one can help me :!:

Anu D · June 3, 2010 9:51AM

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?

salhzmzm · June 8, 2010 4:50PM

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

I am using win 7

Anu D · June 9, 2010 4:38AM

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.

salhzmzm · June 9, 2010 3:57PM

I edited the adapters order and I seted the local area connection to be the first.

and I am getting this error :

Note : I checked that SQL response servive is running.

priyasinha · June 10, 2010 6:40AM

Hi,

Apologies for the issue you are facing. I have just sent you an email regarding this.

Thanks,
Priya

xexex · June 24, 2010 12:52AM

I've also got the same problem in Windows 7, is there any solution?

Can't connect to Alert Repository?

Comments

Product Learning

Community Forums

Events & Friends

Simple Talk