SQL 2K SSL Connection Problem
- From: Jim Raykowski <JimRaykowski@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Mon, 28 Jan 2008 14:49:00 -0800
Windows 2003 x64 edition with service packs. SQL 2000 with SP4 installed
supporting Microsoft Groove Server. After OS and SQL, created a special
account for use groove and gave the acct server and security admin and create
DB perms, installed fully patched both and then installed MS Groove Manager.
Initially had a few network issues but resolved all and eventually was able
to create all groove all grove domain intengrate with AD and sync. Added
relay server and then started adding users to test. Added two users in the
late afternoon got their clients connected and then went home for the
evening. I was able to access the groove manager web site and make all
configuration change no issues.
When I cam in the next morning I was unable to access the groove manager
web site or connect to the database using EM. In the app event log there is
an ASP.NET 2.X error. It is below
Event code: 3005
Event message: An unhandled exception has occurred.
Event time: 1/24/2008 9:43:14 AM
Event time (UTC): 1/24/2008 5:43:14 PM
Event ID: 4b1f69a8eb8444a597530de82542821b
Event sequence: 5563
Event occurrence: 5562
Event detail code: 0
Application information:
Application domain: /LM/W3SVC/1/Root/GMS-1-128456698832752092
Trust level: Full
Application Virtual Path: /GMS
Application Path: C:\Inetpub\wwwroot\GMS\
Machine name: GBGRV1
Process information:
Process ID: 2092
Process name: w3wp.exe
Account name: NT AUTHORITY\NETWORK SERVICE
Exception information:
Exception type: GMSException
Exception message: Database error
Request information:
Request URL: http://gbgrv1/gms/ManagementServer.aspx
Request path: /gms/ManagementServer.aspx
User host address: 192.168.2.60
User:
Is authenticated: False
Authentication Type:
Thread account name: NT AUTHORITY\NETWORK SERVICE
Thread information:
Thread ID: 1
Thread account name: NT AUTHORITY\NETWORK SERVICE
Is impersonating: False
Stack trace: at Groove.Management.Server.GMSDBProc..ctor(String
connectionString, String procName)
at Groove.Management.Server.GMSObject.FetchParameters(String ipprocName)
at Groove.Management.Server.GMSObject.PrepareCommand(String ipprocName)
at Groove.Management.Server.GMSObject.Execute(String ipprocName)
at Groove.Management.Server.GMSServer..ctor()
at Groove.Management.Server.GMSServer.get_Instance()
at
Microsoft.GrooveManagementServer.UI.Controls.GMSUIResourceUtility.GetFirstValidUserCulture()
at
Microsoft.GrooveManagementServer.UI.Controls.GMSUIResourceUtility..ctor(String[] ipUserLanguages, Hashtable& ipRMHashtable, ArrayList& ipSupportedCultures)
at
Microsoft.GrooveManagementServer.UI.Global.Application_BeginRequest(Object
sender, EventArgs e)
at
System.Web.HttpApplication.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean&
completedSynchronously)
The EM error is as follows:
A connection could not be established to (local).
Reason: SSL Security error
ConnectionOpen (SECDoClientHandshake()).
Please verify SQL Server is running and check you SQL Server Registration
properties (by right-clicking on the (local) node) and try again.
When I checked to see if the SQLServerAgent was running it was not so I
tried to start it and received the below error:
SQLServerAgent could not be started (reason: Unable to connect to server
‘(local)’;SQLServerAgent cannot start).
It appears that the groove manager server is running but I am unable to do
anything to the domain. Any ideas with these errors? As an FYI you have to
use a cert with Groove and I decided to use the built in capability of groove
to manage certs.
TIA,
--
Jim
"Nothing is fool proof to a talented fool"
.
- Follow-Ups:
- Re: SQL 2K SSL Connection Problem
- From: Ekrem Önsoy
- Re: SQL 2K SSL Connection Problem
- Prev by Date: Re: encrypted partition on the hard drive and must be encrypted wi
- Next by Date: Re: installation
- Previous by thread: Re: encrypted partition on the hard drive and must be encrypted wi
- Next by thread: Re: SQL 2K SSL Connection Problem
- Index(es):
Relevant Pages
|
