Error during Synchronization

While synchronizing data between the PDA and MS SQL Server database, using Active Sync connection, the sync process fails at times and displays an empty error message box and occasionally it shows the following exception:

Error During Synchronization:

A native exception occurred.

ExceptionCode:0xc0000005

ExceptionAddress:0x01627b28

Reading: 0x1e000000

OK to terminate

CANCEL to debug

Moreover the .SDF file on the PDA gets corrupted. The ActiveSync connection drops as soon as the sync process fails. Later when the .SDF file is deleted and restored the synchronization is successful.

Note: The replication monitor in the SQL Server indicates that the synchronization was successful even when the above error occurs.

========================================================
** Sample code where the app crashes we encounter the issue:

Public Sub Synchronize (ByVal vShowMessage As Boolean)

Dim ce As SqlCeReplication = Nothing

Try

ce = New SqlCeReplication

'Set Internet properties.

ce.InternetUrl = vInternetURL ' "http://xx.xx.xx.xx/SQLCE/sscesa20.dll"

'Set Publisher properties.

ce.Publisher = vPublisher

ce.PublisherLogin = vPublisherLogin '"sa"

ce.PublisherPassword = vPublisherPassword '"xxxxxx"

ce.PublisherSecurityMode = SecurityType.DBAuthentication

ce.PublisherNetwork = NetworkType.DefaultNetwork

ce.PublisherDatabase = vPublisherDatabase

ce.Publication = vPub_Name

'Set Subscriber properties.

ce.Subscriber = vSub_Name

ce.SubscriberConnectionString = "Data Source=" & DB_PATH & vDatabase_Name

If File.Exists(DB_PATH & vDatabase_Name) = False Then

ce.AddSubscription(AddOption.CreateDatabase)

End If

ce.Synchronize()

Catch ex As SqlCeException

If vShowMessage = True Then

MsgBox(ex.Message)

End If

Throw ex

Catch ex1 As Exception

If vShowMessage = True Then

MsgBox(ex1.Message)

End If

Throw ex1

Finally

ce = Nothing

End Try

End Sub

This has been tracked and answered in "SQL Server Replication" forum under the following threads:

http://forums.microsoft.com/msdn/ShowPost.aspx?PostID=96703
http://forums.microsoft.com/msdn/ShowPost.aspx?PostID=96832

Thanks,
Laxmi NRO, MSFT, SQL Mobile

Error during Synchronization

While synchronizing data between the PDA and MS SQL Server database, using Active Sync connection, the sync process fails at times and displays an empty error message box and occasionally it shows the following exception:

Error During Synchronization:

A native exception occurred.

ExceptionCode:0xc0000005

ExceptionAddress:0x01627b28

Reading: 0x1e000000

OK to terminate

CANCEL to debug

Moreover the .SDF file on the PDA gets corrupted. The ActiveSync connection drops as soon as the sync process fails. Later when the .SDF file is deleted and restored the synchronization is successful.

Note: The replication monitor in the SQL Server indicates that the synchronization was successful even when the above error occurs.

========================================================
** Sample code where the app crashes we encounter the issue:

Public Sub Synchronize (ByVal vShowMessage As Boolean)

Dim ce As SqlCeReplication = Nothing

Try

ce = New SqlCeReplication

'Set Internet properties.

ce.InternetUrl = vInternetURL ' "http://xx.xx.xx.xx/SQLCE/sscesa20.dll"

'Set Publisher properties.

ce.Publisher = vPublisher

ce.PublisherLogin = vPublisherLogin '"sa"

ce.PublisherPassword = vPublisherPassword '"xxxxxx"

ce.PublisherSecurityMode = SecurityType.DBAuthentication

ce.PublisherNetwork = NetworkType.DefaultNetwork

ce.PublisherDatabase = vPublisherDatabase

ce.Publication = vPub_Name

'Set Subscriber properties.

ce.Subscriber = vSub_Name

ce.SubscriberConnectionString = "Data Source=" & DB_PATH & vDatabase_Name

If File.Exists(DB_PATH & vDatabase_Name) = False Then

ce.AddSubscription(AddOption.CreateDatabase)

End If

ce.Synchronize()

Catch ex As SqlCeException

If vShowMessage = True Then

MsgBox(ex.Message)

End If

Throw ex

Catch ex1 As Exception

If vShowMessage = True Then

MsgBox(ex1.Message)

End If

Throw ex1

Finally

ce = Nothing

End Try

End Sub

This has been tracked and answered in "SQL Server Replication" forum under the following threads:

http://forums.microsoft.com/msdn/ShowPost.aspx?PostID=96703
http://forums.microsoft.com/msdn/ShowPost.aspx?PostID=96832

Thanks,
Laxmi NRO, MSFT, SQL Mobilesql

Error Copying from 2000 to 2005

Hello. I'm getting a frustrating error trying to copy a database from SQL
2000 to SQL 2005 using the copy wizard. The attempt fails with two errors in
the event log on the SQL 2005 server. I am running SQL 2005 64-bit Edition o
n
Windows Server 2003 64 on a Intel Xeon EMT. I continue to receive the error
even after an upgrade to SP1:
Faulting application dtexec.exe, version 2005.90.1399.0, stamp 43500d1a,
faulting module kernel32.dll, version 5.2.3790.1830, stamp 42438b79, debug?
0, fault address 0x0000000000027d0d.
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
&&
Faulting application dtexec.exe, version 2005.90.1399.0, stamp 43500d1a,
faulting module kernel32.dll, version 5.2.3790.1830, stamp 42438b79, debug?
0, fault address 0x0000000000027d0d.
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
From this link:
http://www.dbtalk.net/microsoft-pub...
-a-165165.html
It would seem that others are also having this issue - but nothing from
Microsoft on it. I'm not sure how to move forward. And yes, I do realize tha
t
Its probably simplier to offline the database and copy the files, but that i
s
not what I want to do. I want to use a feature of the product we purchased.
Has anyone run into and FIXED this issue before.
Thanks!
Errol NealHi
Try RESTORE command
"Errol Neal" <ErrolNeal@.discussions.microsoft.com> wrote in message
news:5F4BA321-C5BB-4427-A6C8-014E1F22995D@.microsoft.com...
> Hello. I'm getting a frustrating error trying to copy a database from SQL
> 2000 to SQL 2005 using the copy wizard. The attempt fails with two errors
> in
> the event log on the SQL 2005 server. I am running SQL 2005 64-bit Edition
> on
> Windows Server 2003 64 on a Intel Xeon EMT. I continue to receive the
> error
> even after an upgrade to SP1:
> Faulting application dtexec.exe, version 2005.90.1399.0, stamp 43500d1a,
> faulting module kernel32.dll, version 5.2.3790.1830, stamp 42438b79,
> debug?
> 0, fault address 0x0000000000027d0d.
> For more information, see Help and Support Center at
> http://go.microsoft.com/fwlink/events.asp.
> &&
> Faulting application dtexec.exe, version 2005.90.1399.0, stamp 43500d1a,
> faulting module kernel32.dll, version 5.2.3790.1830, stamp 42438b79,
> debug?
> 0, fault address 0x0000000000027d0d.
> For more information, see Help and Support Center at
> http://go.microsoft.com/fwlink/events.asp.
> From this link:
> http://www.dbtalk.net/microsoft-pub...0-a-165165.html
> It would seem that others are also having this issue - but nothing from
> Microsoft on it. I'm not sure how to move forward. And yes, I do realize
> that
> Its probably simplier to offline the database and copy the files, but that
> is
> not what I want to do. I want to use a feature of the product we
> purchased.
> Has anyone run into and FIXED this issue before.
> Thanks!
> Errol Neal|||Just an update, if someone is looking for solution:
Make sure SQLServer domain user you are running SQL SERVER on new
server has access to old SQL server. Usually you need to add SQL User
domain account to Local Administrator group on the old server.

Error Copying from 2000 to 2005

Hello. I'm getting a frustrating error trying to copy a database from SQL
2000 to SQL 2005 using the copy wizard. The attempt fails with two errors in
the event log on the SQL 2005 server. I am running SQL 2005 64-bit Edition on
Windows Server 2003 64 on a Intel Xeon EMT. I continue to receive the error
even after an upgrade to SP1:
Faulting application dtexec.exe, version 2005.90.1399.0, stamp 43500d1a,
faulting module kernel32.dll, version 5.2.3790.1830, stamp 42438b79, debug?
0, fault address 0x0000000000027d0d.
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
&&
Faulting application dtexec.exe, version 2005.90.1399.0, stamp 43500d1a,
faulting module kernel32.dll, version 5.2.3790.1830, stamp 42438b79, debug?
0, fault address 0x0000000000027d0d.
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
From this link:
http://www.dbtalk.net/microsoft-public-sqlserver-dts/error-copying-sql-server-2000-a-165165.html
It would seem that others are also having this issue - but nothing from
Microsoft on it. I'm not sure how to move forward. And yes, I do realize that
Its probably simplier to offline the database and copy the files, but that is
not what I want to do. I want to use a feature of the product we purchased.
Has anyone run into and FIXED this issue before.
Thanks!
Errol NealHi
Try RESTORE command
"Errol Neal" <ErrolNeal@.discussions.microsoft.com> wrote in message
news:5F4BA321-C5BB-4427-A6C8-014E1F22995D@.microsoft.com...
> Hello. I'm getting a frustrating error trying to copy a database from SQL
> 2000 to SQL 2005 using the copy wizard. The attempt fails with two errors
> in
> the event log on the SQL 2005 server. I am running SQL 2005 64-bit Edition
> on
> Windows Server 2003 64 on a Intel Xeon EMT. I continue to receive the
> error
> even after an upgrade to SP1:
> Faulting application dtexec.exe, version 2005.90.1399.0, stamp 43500d1a,
> faulting module kernel32.dll, version 5.2.3790.1830, stamp 42438b79,
> debug?
> 0, fault address 0x0000000000027d0d.
> For more information, see Help and Support Center at
> http://go.microsoft.com/fwlink/events.asp.
> &&
> Faulting application dtexec.exe, version 2005.90.1399.0, stamp 43500d1a,
> faulting module kernel32.dll, version 5.2.3790.1830, stamp 42438b79,
> debug?
> 0, fault address 0x0000000000027d0d.
> For more information, see Help and Support Center at
> http://go.microsoft.com/fwlink/events.asp.
> From this link:
> http://www.dbtalk.net/microsoft-public-sqlserver-dts/error-copying-sql-server-2000-a-165165.html
> It would seem that others are also having this issue - but nothing from
> Microsoft on it. I'm not sure how to move forward. And yes, I do realize
> that
> Its probably simplier to offline the database and copy the files, but that
> is
> not what I want to do. I want to use a feature of the product we
> purchased.
> Has anyone run into and FIXED this issue before.
> Thanks!
> Errol Neal|||Just an update, if someone is looking for solution:
Make sure SQLServer domain user you are running SQL SERVER on new
server has access to old SQL server. Usually you need to add SQL User
domain account to Local Administrator group on the old server.

Error connecting

Cannot open database requested in login <DatabaseName>. Login fails.
Login failed for user <DOMAINNAME\User>.
Please help."Viktor Zadro" <viktor.zadro@.tel.net.ba> wrote in message
news:ukzXI7IcEHA.3016@.tk2msftngp13.phx.gbl...
> Cannot open database requested in login <DatabaseName>. Login fails.
> Login failed for user <DOMAINNAME\User>.
>
How are you attempting to connect? Can you reproduce this using Query
Analyzer? What login and database permissions have you defined for this
user?
Steve|||Hello, Steve,
How can I manage SQL Server's users, for example, how to change the 'sa' pas
sword?
Is it can only be done by using 'Enterprise Manager'?
LLF
--
There's an unfinished grid inside my head...
"Steve Thompson" wrote:

> "Viktor Zadro" <viktor.zadro@.tel.net.ba> wrote in message
> news:ukzXI7IcEHA.3016@.tk2msftngp13.phx.gbl...
> How are you attempting to connect? Can you reproduce this using Query
> Analyzer? What login and database permissions have you defined for this
> user?
> Steve
>
>|||LLF,
You can use Enterprise Manager if you wish. Enterprise
Manager is really just executing T-SQL commands for you so
you can manage these through Query Analyzer or any other
tool that can connect to and execute queries on SQL Server.
Passwords are changed using sp_password.
You can add logins using sp_grantlogin for Windows logins or
sp_addlogin for SQL logins.
You can add users to a database using sp_grantdbaccess.
You can find all of these system stored procedures
documented in SQL Server Books Online.
-Sue
On Tue, 27 Jul 2004 10:01:37 -0700, LLF
<LLF@.discussions.microsoft.com> wrote:

>Hello, Steve,
>How can I manage SQL Server's users, for example, how to change the 'sa' pa
ssword?
>Is it can only be done by using 'Enterprise Manager'?
>LLF|||Thanks a lot !
LLF
There's an unfinished grid inside my head...
"Sue Hoegemeier" wrote:

> LLF,
> You can use Enterprise Manager if you wish. Enterprise
> Manager is really just executing T-SQL commands for you so
> you can manage these through Query Analyzer or any other
> tool that can connect to and execute queries on SQL Server.
> Passwords are changed using sp_password.
> You can add logins using sp_grantlogin for Windows logins or
> sp_addlogin for SQL logins.
> You can add users to a database using sp_grantdbaccess.
> You can find all of these system stored procedures
> documented in SQL Server Books Online.
> -Sue
> On Tue, 27 Jul 2004 10:01:37 -0700, LLF
> <LLF@.discussions.microsoft.com> wrote:
>
>

Error connecting

Cannot open database requested in login <DatabaseName>. Login fails.
Login failed for user <DOMAINNAME\User>.
Please help.
"Viktor Zadro" <viktor.zadro@.tel.net.ba> wrote in message
news:ukzXI7IcEHA.3016@.tk2msftngp13.phx.gbl...
> Cannot open database requested in login <DatabaseName>. Login fails.
> Login failed for user <DOMAINNAME\User>.
>
How are you attempting to connect? Can you reproduce this using Query
Analyzer? What login and database permissions have you defined for this
user?
Steve
|||Hello, Steve,
How can I manage SQL Server's users, for example, how to change the 'sa' password?
Is it can only be done by using 'Enterprise Manager'?
LLF
There's an unfinished grid inside my head...
"Steve Thompson" wrote:

> "Viktor Zadro" <viktor.zadro@.tel.net.ba> wrote in message
> news:ukzXI7IcEHA.3016@.tk2msftngp13.phx.gbl...
> How are you attempting to connect? Can you reproduce this using Query
> Analyzer? What login and database permissions have you defined for this
> user?
> Steve
>
>
|||LLF,
You can use Enterprise Manager if you wish. Enterprise
Manager is really just executing T-SQL commands for you so
you can manage these through Query Analyzer or any other
tool that can connect to and execute queries on SQL Server.
Passwords are changed using sp_password.
You can add logins using sp_grantlogin for Windows logins or
sp_addlogin for SQL logins.
You can add users to a database using sp_grantdbaccess.
You can find all of these system stored procedures
documented in SQL Server Books Online.
-Sue
On Tue, 27 Jul 2004 10:01:37 -0700, LLF
<LLF@.discussions.microsoft.com> wrote:

>Hello, Steve,
>How can I manage SQL Server's users, for example, how to change the 'sa' password?
>Is it can only be done by using 'Enterprise Manager'?
>LLF
|||Thanks a lot !
LLF
There's an unfinished grid inside my head...
"Sue Hoegemeier" wrote:

> LLF,
> You can use Enterprise Manager if you wish. Enterprise
> Manager is really just executing T-SQL commands for you so
> you can manage these through Query Analyzer or any other
> tool that can connect to and execute queries on SQL Server.
> Passwords are changed using sp_password.
> You can add logins using sp_grantlogin for Windows logins or
> sp_addlogin for SQL logins.
> You can add users to a database using sp_grantdbaccess.
> You can find all of these system stored procedures
> documented in SQL Server Books Online.
> -Sue
> On Tue, 27 Jul 2004 10:01:37 -0700, LLF
> <LLF@.discussions.microsoft.com> wrote:
>
>

error code 17058

Hi everyone. I installed SP1 and it required a reboot. When I attempted to
start the
service from the Management Studio it fails and indicates an instance
failure (system.data). When I attempt to start from the administrative
services control
it fails and indicates a 17058 error, but the search results indicate this
is associated
with sql2000. The directory indicates the system files are there. I have
current
backups of system and data files. Anything I can do short of a complete
reload?
Thanks to everyone for being there to help.
SQL2005 and almost SP1
EdHi!

> Hi everyone. I installed SP1 and it required a reboot. When I attempted to
> start the
> service from the Management Studio it fails and indicates an instance
> failure (system.data). When I attempt to start from the administrative
> services control
> it fails and indicates a 17058 error, but the search results indicate this
> is associated
> with sql2000. The directory indicates the system files are there. I have
> current
> backups of system and data files. Anything I can do short of a complete
> reload?
> Thanks to everyone for being there to help.
> SQL2005 and almost SP1
This can be SQL 2005 error as well - check, for example
c33f0483c5587bdf." target="_blank">http://groups.google.si/group/micro...3f0483c5587bdf.
If this is what you get, you should not use Network Service account for the
SQL Server service.
Dejan Sarka, SQL Server MVP
Mentor, www.SolidQualityLearning.com
Anything written in this message represents solely the point of view of the
sender.
This message does not imply endorsement from Solid Quality Learning, and it
does not represent the point of view of Solid Quality Learning or any other
person, company or institution mentioned in this message

error code 17058

Hi everyone. I installed SP1 and it required a reboot. When I attempted to
start the
service from the Management Studio it fails and indicates an instance
failure (system.data). When I attempt to start from the administrative
services control
it fails and indicates a 17058 error, but the search results indicate this
is associated
with sql2000. The directory indicates the system files are there. I have
current
backups of system and data files. Anything I can do short of a complete
reload?
Thanks to everyone for being there to help.
SQL2005 and almost SP1
EdHi!
> Hi everyone. I installed SP1 and it required a reboot. When I attempted to
> start the
> service from the Management Studio it fails and indicates an instance
> failure (system.data). When I attempt to start from the administrative
> services control
> it fails and indicates a 17058 error, but the search results indicate this
> is associated
> with sql2000. The directory indicates the system files are there. I have
> current
> backups of system and data files. Anything I can do short of a complete
> reload?
> Thanks to everyone for being there to help.
> SQL2005 and almost SP1
This can be SQL 2005 error as well - check, for example
http://groups.google.si/group/microsoft.public.sqlserver.server/browse_thread/thread/fd5cb2a8c242612a/c33f0483c5587bdf?lnk=st&q=17058+sql+server+error&rnum=1&hl=sl#c33f0483c5587bdf.
If this is what you get, you should not use Network Service account for the
SQL Server service.
--
Dejan Sarka, SQL Server MVP
Mentor, www.SolidQualityLearning.com
Anything written in this message represents solely the point of view of the
sender.
This message does not imply endorsement from Solid Quality Learning, and it
does not represent the point of view of Solid Quality Learning or any other
person, company or institution mentioned in this message

error code 17058

Hi everyone. I installed SP1 and it required a reboot. When I attempted to
start the
service from the Management Studio it fails and indicates an instance
failure (system.data). When I attempt to start from the administrative
services control
it fails and indicates a 17058 error, but the search results indicate this
is associated
with sql2000. The directory indicates the system files are there. I have
current
backups of system and data files. Anything I can do short of a complete
reload?
Thanks to everyone for being there to help.
SQL2005 and almost SP1
Ed
Hi!

> Hi everyone. I installed SP1 and it required a reboot. When I attempted to
> start the
> service from the Management Studio it fails and indicates an instance
> failure (system.data). When I attempt to start from the administrative
> services control
> it fails and indicates a 17058 error, but the search results indicate this
> is associated
> with sql2000. The directory indicates the system files are there. I have
> current
> backups of system and data files. Anything I can do short of a complete
> reload?
> Thanks to everyone for being there to help.
> SQL2005 and almost SP1
This can be SQL 2005 error as well - check, for example
http://groups.google.si/group/micros...f0483c5587bdf.
If this is what you get, you should not use Network Service account for the
SQL Server service.
Dejan Sarka, SQL Server MVP
Mentor, www.SolidQualityLearning.com
Anything written in this message represents solely the point of view of the
sender.
This message does not imply endorsement from Solid Quality Learning, and it
does not represent the point of view of Solid Quality Learning or any other
person, company or institution mentioned in this message