Hi All,

 

Question:  I obtained my .pfx cert from my MS folks last week   It was simply called   cert.pfx

 

My Asset synch point is setup to reference that file.

 

Unfortunately when I look in the AIUpdateSvc.log file I see MANY errors like this:

"Exception attempting sync - An error has occurred while establishing a connection to the server.  When connecting to SQL Server 2005,"

 

Note that I HAVE verified the database name is correct in the registry and DID already make sure the SPN was registered

 

The only other weird variable is that this is on Server 2003 x64

 

I HAVE seen others complaining of similar (i.e. x64 and sync errors) in this post:  http://forums.microsoft.com/technet/showpost.aspx?pageindex=1&siteid=17&postid=3775872&sb=0&d=1&at=7&ft=11&tf=0&pageid=0

 

Jon

Asset Intelligence Catalog Sync Service Information: 0 : Wed, 19 Nov 2008 13:11:36 GMT:=====================Data/Status copied to outbox=====================
Asset Intelligence Catalog Sync Service Information: 0 : Wed, 19 Nov 2008 13:11:36 GMT:Within poll interval, skip settings refresh
Asset Intelligence Catalog Sync Service Information: 0 : Wed, 19 Nov 2008 13:11:36 GMTync schedule did not return a next sync time
Asset Intelligence Catalog Sync Service Information: 0 : Wed, 19 Nov 2008 13:20:23 GMTervice Starting
Asset Intelligence Catalog Sync Service Information: 0 : Wed, 19 Nov 2008 13:20:24 GMTervice Started
Asset Intelligence Catalog Sync Service Information: 0 : Wed, 19 Nov 2008 13:20:24 GMT:Co-located on site server UT40SGM
Asset Intelligence Catalog Sync Service Information: 0 : Wed, 19 Nov 2008 13:20:24 GMTutput directory is i:\Microsoft Configuration Manager\inboxes\AIKbMgr.box
Asset Intelligence Catalog Sync Service Information: 0 : Wed, 19 Nov 2008 13:20:25 GMT:=====================Data/Status copied to outbox=====================
Asset Intelligence Catalog Sync Service Information: 0 : Wed, 19 Nov 2008 13:20:25 GMT:Within poll interval, skip settings refresh
Asset Intelligence Catalog Sync Service Information: 0 : Wed, 19 Nov 2008 13:20:25 GMTync schedule did not return a next sync time
Asset Intelligence Catalog Sync Service Error: 0 : Wed, 19 Nov 2008 13:35:41 GMT:Exception attempting sync - An error has occurred while establishing a connection to the server.  When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
Asset Intelligence Catalog Sync Service Information: 0 : Wed, 19 Nov 2008 13:35:41 GMT:=====================Data/Status copied to outbox=====================
Asset Intelligence Catalog Sync Service Information: 0 : Wed, 19 Nov 2008 13:49:13 GMT:Within poll interval, skip settings refresh
Asset Intelligence Catalog Sync Service Information: 0 : Wed, 19 Nov 2008 13:49:13 GMTync schedule did not return a next sync time
Asset Intelligence Catalog Sync Service Error: 0 : Wed, 19 Nov 2008 14:04:20 GMT:Exception attempting sync - An error has occurred while establishing a connection to the server.  When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
Asset Intelligence Catalog Sync Service Information: 0 : Wed, 19 Nov 2008 14:04:20 GMT:=====================Data/Status copied to outbox=====================
Asset Intelligence Catalog Sync Service Error: 0 : Wed, 19 Nov 2008 14:19:34 GMT:Exception attempting sync - An error has occurred while establishing a connection to the server.  When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

(in reply to jkaiser)

(in reply to bmason505)

(in reply to SMSExpert)