> Make sure the Network Service account has Read/Write permissions to your BCM folder which is located at the path below when running
> under Windows XP:
> C:\Documents and Settings\<USER>\Local Settings\Application Data\Microsoft\Business Contact Manager
>
> Also, check to see that the "SQL Server (MSSMLBIZ)" service is running by right-clicking on "My Computer" and selecting "Manage".
> Then expand "Services and Applications" and click "Services"
>
> --
> Visit team blog at
http://blogs.msdn.com/bcm> This posting is provided "AS IS" with no warranties, and confers no rights
> "Diggers" <Diggers[ at ]discussions.microsoft.com> wrote in message news:6A873A31-6730-4D37-B14B-6B540CA38B9C[ at ]microsoft.com...
> hello,
>
> I have shared my database and am able to connect to it from a remote
> machine. However when I try to create an offline Db on teh remote machine I
> get the error database creation unsuccessful. Any ideas.
>
> I am attaching my sql error log.
>
> 2007-02-20 19:00:11.70 Server Microsoft SQL Server 2005 - 9.00.1399.06
> (Intel X86)
> Oct 14 2005 00:33:37
> Copyright (c) 1988-2005 Microsoft Corporation
> Enterprise Evaluation Edition on Windows NT 5.1 (Build 2600: Service Pack 2)
>
> 2007-02-20 19:00:11.70 Server (c) 2005 Microsoft Corporation.
> 2007-02-20 19:00:11.70 Server All rights reserved.
> 2007-02-20 19:00:11.70 Server Server process ID is 3792.
> 2007-02-20 19:00:11.70 Server Logging SQL Server messages in file
> 'D:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG'.
> 2007-02-20 19:00:11.70 Server This instance of SQL Server last reported
> using a process ID of 3600 at 2/20/2007 6:59:45 PM (local) 2/20/2007 5:59:45
> PM (UTC). This is an informational message only; no user action is required.
> 2007-02-20 19:00:11.70 Server Registry startup parameters:
> 2007-02-20 19:00:11.70 Server -d D:\Program Files\Microsoft SQL
> Server\MSSQL.1\MSSQL\DATA\master.mdf
> 2007-02-20 19:00:11.70 Server -e D:\Program Files\Microsoft SQL
> Server\MSSQL.1\MSSQL\LOG\ERRORLOG
> 2007-02-20 19:00:11.70 Server -l D:\Program Files\Microsoft SQL
> Server\MSSQL.1\MSSQL\DATA\mastlog.ldf
> 2007-02-20 19:00:11.71 Server SQL Server is starting at normal priority
> base (=7). This is an informational message only. No user action is required.
> 2007-02-20 19:00:11.71 Server Detected 1 CPUs. This is an informational
> message; no user action is required.
> 2007-02-20 19:00:11.79 Server Using dynamic lock allocation. Initial
> allocation of 2500 Lock blocks and 5000 Lock Owner blocks per node. This is
> an informational message only. No user action is required.
> 2007-02-20 19:00:11.82 Server Attempting to initialize Microsoft
> Distributed Transaction Coordinator (MS DTC). This is an informational
> message only. No user action is required.
> 2007-02-20 19:00:11.84 Server The Microsoft Distributed Transaction
> Coordinator (MS DTC) service could not be contacted. If you would like
> distributed transaction functionality, please start this service.
> 2007-02-20 19:00:11.84 Server Database Mirroring Transport is disabled
> in the endpoint configuration.
> 2007-02-20 19:00:11.84 spid5s Starting up database 'master'.
> 2007-02-20 19:00:11.98 spid5s Recovery is writing a checkpoint in
> database 'master' (1). This is an informational message only. No user action
> is required.
> 2007-02-20 19:00:12.14 spid5s SQL Trace ID 1 was started by login "sa".
> 2007-02-20 19:00:12.18 spid5s Starting up database 'mssqlsystemresource'.
> 2007-02-20 19:00:12.57 spid5s Server name is 'LAPTOP-ONE\MSSMLBIZ'.
> This is an informational message only. No user action is required.
> 2007-02-20 19:00:12.57 spid9s Starting up database 'model'.
> 2007-02-20 19:00:12.82 Server A self-generated certificate was
> successfully loaded for encryption.
> 2007-02-20 19:00:12.82 Server Server is listening on [ 'any' <ipv4>
> 1050].
> 2007-02-20 19:00:12.84 Server Server is listening on [ 'any' <ipv4>
> 5356].
> 2007-02-20 19:00:12.84 Server Server local connection provider is ready
> to accept connection on [ \\.\pipe\SQLLocal\MSSMLBIZ ].
> 2007-02-20 19:00:12.84 Server Server named pipe provider is ready to
> accept connection on [ \\.\pipe\MSSQL$MSSMLBIZ\sql\query ].
> 2007-02-20 19:00:12.84 Server Server is listening on [ 127.0.0.1 <ipv4>
> 1133].
> 2007-02-20 19:00:12.84 Server Dedicated admin connection support was
> established for listening locally on port 1133.
> 2007-02-20 19:00:13.06 spid9s Clearing tempdb database.
> 2007-02-20 19:00:13.70 spid9s Starting up database 'tempdb'.
> 2007-02-20 19:00:13.89 spid12s The Service Broker protocol transport is
> disabled or not configured.
> 2007-02-20 19:00:13.89 spid12s The Database Mirroring protocol transport
> is disabled or not configured.
> 2007-02-20 19:00:13.93 spid12s Service Broker manager has started.
> 2007-02-20 19:00:27.85 Server The SQL Network Interface library could
> not register the Service Principal Name (SPN) for the SQL Server service.
> Error: 0x54b. Failure to register an SPN may cause integrated authentication
> to fall back to NTLM instead of Kerberos. This is an informational message.
> Further action is only required if Kerberos authentication is required by
> authentication policies.
> 2007-02-20 19:00:27.85 Server SQL Server is now ready for client
> connections. This is an informational message; no user action is required.
> 2007-02-20 19:00:27.87 spid5s Starting up database 'msdb'.
> 2007-02-20 19:00:28.37 spid5s Recovery is complete. This is an
> informational message only. No user action is required.
> 2007-02-20 19:00:45.46 spid51 Starting up database
> 'MSSmallBusinessOutlook_offline'.
> 2007-02-20 19:00:45.71 spid51 index restored for
> MSSmallBusinessOutlook_offline.sysowners.
> 2007-02-20 19:00:45.73 spid51 index restored for
> MSSmallBusinessOutlook_offline.sysschobjs.
> 2007-02-20 19:00:45.74 spid51 index restored for
> MSSmallBusinessOutlook_offline.syscolpars.
> 2007-02-20 19:00:45.74 spid51 index restored for
> MSSmallBusinessOutlook_offline.sysnsobjs.
> 2007-02-20 19:00:45.74 spid51 index restored for
> MSSmallBusinessOutlook_offline.syscerts.
> 2007-02-20 19:00:45.76 spid51 index restored for
> MSSmallBusinessOutlook_offline.sysxprops.
> 2007-02-20 19:00:45.76 spid51 index restored for
> MSSmallBusinessOutlook_offline.sysscalartypes.
> 2007-02-20 19:00:45.76 spid51 index restored for
> MSSmallBusinessOutlook_offline.sysidxstats.
> 2007-02-20 19:00:45.78 spid51 index restored for
> MSSmallBusinessOutlook_offline.sysclsobjs.
> 2007-02-20 19:00:45.78 spid51 index restored for
> MSSmallBusinessOutlook_offline.sysremsvcbinds.
> 2007-02-20 19:00:45.78 spid51 index restored for
> MSSmallBusinessOutlook_offline.sysrts.
> 2007-02-20 19:00:45.79 spid51 index restored for
> MSSmallBusinessOutlook_offline.sysasymkeys.
> 2007-02-20 19:00:45.79 spid51 index restored for
> MSSmallBusinessOutlook_offline.syssqlguides.
> 2007-02-20 19:00:46.06 spid51 Setting database option AUTO_CLOSE to OFF
> for database MSSmallBusinessOutlook_offline.
> 2007-02-20 19:00:46.07 spid51 Setting database option RECOVERY to
> BULK_LOGGED for database MSSmallBusinessOutlook_offline.
> 2007-02-20 19:00:46.09 spid51 Setting database option RECOVERY to
> RECMODEL_70BACKCOMP for database MSSmallBusinessOutlook_offline.
> 2007-02-20 19:00:46.45 spid51 Setting database option
> TORN_PAGE_DETECTION to ON for database MSSmallBusinessOutlook_offline.
> 2007-02-20 19:00:46.51 spid51 Setting database option READ_WRITE to ON
> for database MSSmallBusinessOutlook_offline.
> 2007-02-20 19:00:46.63 spid51 Setting database option AUTO_SHRINK to
> OFF for database MSSmallBusinessOutlook_offline.
> 2007-02-20 19:00:46.65 spid51 Setting database option ANSI_NULL_DEFAULT
> to OFF for database MSSmallBusinessOutlook_offline.
> 2007-02-20 19:00:46.68 spid51 Setting database option
> RECURSIVE_TRIGGERS to OFF for database MSSmallBusinessOutlook_offline.
> 2007-02-20 19:00:46.70 spid51 Setting database option ANSI_NULLS to OFF
> for database MSSmallBusinessOutlook_offline.
> 2007-02-20 19:00:46.73 spid51 Setting database option
> CONCAT_NULL_YIELDS_NULL to OFF for database MSSmallBusinessOutlook_offline.
> 2007-02-20 19:00:46.74 spid51 Setting database option
> CURSOR_CLOSE_ON_COMMIT to OFF for database MSSmallBusinessOutlook_offline.
> 2007-02-20 19:00:46.79 spid51 Setting database option CURSOR_DEFAULT to
> GLOBAL for database MSSmallBusinessOutlook_offline.
> 2007-02-20 19:00:46.81 spid51 Setting database option QUOTED_IDENTIFIER
> to OFF for database MSSmallBusinessOutlook_offline.
> 2007-02-20 19:00:46.92 spid51 Setting database option ANSI_WARNINGS to
> OFF for database MSSmallBusinessOutlook_offline.
> 2007-02-20 19:00:46.95 spid51 Setting database option
> AUTO_CREATE_STATISTICS to ON for database MSSmallBusinessOutlook_offline.
> 2007-02-20 19:00:46.98 spid51 Setting database option
> AUTO_UPDATE_STATISTICS to ON for database MSSmallBusinessOutlook_offline.
> 2007-02-20 19:00:49.65 spid52 Setting database option SINGLE_USER to ON
> for database MSSmallBusinessOutlook_offline.
>
>
>
>
>