D
Diggers
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.
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.