Red Gate forums :: View topic - The server has rejected the credentials
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Response 1
SQL Response 1 forum

The server has rejected the credentials

Search in SQL Response 1 forum
Post new topic   Reply to topic
Jump to:  
Author Message
skallebank



Joined: 29 Dec 2005
Posts: 5

PostPosted: Thu Jun 24, 2010 11:34 am    Post subject: The server has rejected the credentials Reply with quote

Hi,
Any suggestions to what im doing wrong?

I have db server located at our dmz. I have installed SQL Response Alert Repository using my login at dmz.

When i try to connect to the repository, i get the "The server has rejected the credentials" error:

what am i doing wrong?
Back to top
View user's profile Send private message Send e-mail
peter.peart
Site Admin


Joined: 02 Sep 2008
Posts: 362
Location: Top floor, RG towers with the cool kids

PostPosted: Fri Jun 25, 2010 12:41 pm    Post subject: Reply with quote

Hi there,

It sounds to me as if you are running into the secure remoting issue when connecting the SQL Response client to an alert repository that is in a different domain.

The below knowledgebase article should explain how to get around this, however if I am misunderstanding please do let me know:

http://redg.at/bsOD8D

HTH!

Pete
_________________
Peter Peart
Red Gate Software Ltd
+44 (0)870 160 0037 ext. 8569
1 866 RED GATE ext. 8569
Back to top
View user's profile Send private message Send e-mail
skallebank



Joined: 29 Dec 2005
Posts: 5

PostPosted: Fri Jun 25, 2010 12:54 pm    Post subject: Reply with quote

Hi,

I did as you told, and now im getting another error:
"No connection could be made because the target machine actively refused it"

Code:
<?xml version="1.0" encoding="utf-8"?>
<SqlResponseConfig>
   <TcpPort>7398</TcpPort>
   <DataDirectory>C:\Documents and Settings\All Users\Application Data\Red Gate\SQL Response 1\Alert Repository\</DataDirectory>
   <ServiceType>user</ServiceType>
   <ServiceStart>1</ServiceStart>
   <!-- This will affect the polling frequency for these recommendations; No backup exists for database, Full backup overdue, Log backup overdue,   Integrity check overdue and Page Verification is off- setting to 5 hourly  -->
   <DatabaseRecommendationCheckTime>18000</DatabaseRecommendationCheckTime>
   <!-- This will affect the polling frequency for these recommendations; Transaction Log has excessive free space and Data file has excessive free   space- setting to 5 hourly -->
   <DBFileTime>18000</DBFileTime>
   <!-- This will affect the polling frequency for these alerts; Computer unreachable, Computer Login Failure, SQL Server Lgon failure and SQL Server      unreachable - setting to every 5 minutes -->
   <WmiPingTime>300</WmiPingTime>
   <!-- This will affect the polling frequency for these alerts; Job Failure, Job did not start, Job duration unusual and SQL Server agent not running -  setting to every minute -->
   <JobInfoTime>60</JobInfoTime>
   <!-- This will affect the polling frequency for these alerts; Low physical memory and CPU utilization unusual and also affect the wmi get machine      statistics and sql get machine statics calls- setting to every 30 seconds -->
   <PerfMonTime>30</PerfMonTime>
   <!-- This will affect the polling frequency for this alert; Low disk space - setting to every 2 minutes -->
   <DiskInfoTime>120</DiskInfoTime>
   <!-- This will affect the polling frequency for these alerts; Long running query and Blocked SQL Process - setting to every 45 seconds-->
   <SysProcessesTime>45</SysProcessesTime>
   <!-- This will affect the polling frequency for these alerts; SQL Deadlock and SQL Server error log entry - setting to every minute  -->
   <SqlErrorLogTime>60</SqlErrorLogTime>
   <!-- This will affect the polling frequency for checking the clock time skew of the machine - setting to every 2 minutes -->
   <ClockSkewTime>120</ClockSkewTime>
   <!-- This will affect the polling frequency for checking for cluster fail over - setting to every minute -->
   <ClusterActiveNodeTime>60</ClusterActiveNodeTime>
   <!-- This will affect the polling frequency for checking for databases changing state - setting to every 2 minutes -->
   <DatabaseStateTime>120</DatabaseStateTime>
   <!-- This will affect the polling frequency for checking for Index Fragmentation - setting to every 5 Hours, however the IndexSchedule tag will override this-->
   <DatabaseIndexTime>18000</DatabaseIndexTime>
   <!-- This will affect the Scheduling for Index fragmentation checking - setting to occur at 04:00 am on Sunday (UTC) -->
   <!-- Monday=1, Tuesday=2,Wednesday=3,Thursday=4,Friday=5,Saturday=6,Sunday=7 -->
   <!-- Currently there are only schedules of type Weekly supported. -->
   <!--<IndexSchedule type="Weekly" day="7" time="04:00"/>-->
   <SecureRemoting>False</SecureRemoting>

</SqlResponseConfig>


Code:

<?xml version="1.0"?>
<root>
  <persistRoot version="1" isObject="true">
    <Type>Settings</Type>
    <MainFormX>0</MainFormX>
    <MainFormY>0</MainFormY>
    <MainFormWidth>0</MainFormWidth>
    <MainFormHeight>0</MainFormHeight>
    <MainFormWindowState>2</MainFormWindowState>
    <MRUServers>
    </MRUServers>
    <PerformanceGraphColors>
    </PerformanceGraphColors>
    <IncidentCachePath>
    </IncidentCachePath>
    <MaxIncidentCacheBytes>104857600</MaxIncidentCacheBytes>
    <TimeFrameIndex>0</TimeFrameIndex>
    <UseIncidentSummaryDiskCache>False</UseIncidentSummaryDiskCache>
    <CommentUsername>
    </CommentUsername>
    <AlertView>
    </AlertView>
    <RecommendationView>
    </RecommendationView>
    <GroupByServer>False</GroupByServer>
    <ShowAlerts>True</ShowAlerts>
    <CacheTimestampMargin>1000</CacheTimestampMargin>
    <SecureRemoting>False</SecureRemoting>
    <AlertRepositoryVersion>0.0.0.0</AlertRepositoryVersion>
    <AskToUpgradeAlertRepository>True</AskToUpgradeAlertRepository>
  </persistRoot>
</root>
Back to top
View user's profile Send private message Send e-mail
peter.peart
Site Admin


Joined: 02 Sep 2008
Posts: 362
Location: Top floor, RG towers with the cool kids

PostPosted: Fri Jun 25, 2010 1:07 pm    Post subject: Reply with quote

Hi there,

Is there a firewall between these domains? Since SQL Response uses WMI connections this can be tricky to configure through firewalls. You may want to have a look at the below articles which should help with this error message:

http://redg.at/aI4WIQ

http://redg.at/aGwME2

There is also an issue where if you have more than 2 NIC's on the AR machine and the one that you are connecting to is not the top binding NIC, SQL Response will have issues with connections. You may also want to stop the AR service and try pinging the IP address of the machine hosting the AR machine to make sure that you can get a connection, and then restart the AR service.

HTH!

Pete
_________________
Peter Peart
Red Gate Software Ltd
+44 (0)870 160 0037 ext. 8569
1 866 RED GATE ext. 8569
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group