Problem in IDENTITY COLUMNS

Hi folks! I've a merge replication setup b/w two servers.
Published tables have columns (INT IDENTITY SEED 1 INCREMENT[NOT FOR REPLICATION]).
Whenever i apply the SNAPSHOT, i have to run DBCC CHECKIDENT('table' RESEED) for each table at the subscriber twice, for the values in the columns are almost always greater than the ID-Seed value. For example the last Identity value in the column is 999 but whenever i insert a new row; i get error; couldn't insert duplicate value into the table. When i run the dbcc check i see the following message:
"Checking identity information: current identity value '1', current column value '999'."
How do i square this away?Originally posted by TALAT
Hi folks! I've a merge replication setup b/w two servers.
Published tables have columns (INT IDENTITY SEED 1 INCREMENT[NOT FOR REPLICATION]).
Whenever i apply the SNAPSHOT, i have to run DBCC CHECKIDENT('table' RESEED) for each table at the subscriber twice, for the values in the columns are almost always greater than the ID-Seed value. For example the last Identity value in the column is 999 but whenever i insert a new row; i get error; couldn't insert duplicate value into the table. When i run the dbcc check i see the following message:
"Checking identity information: current identity value '1', current column value '999'."
How do i square this away?

You will have to find the max value and do something like this.

DBCC CHECKIDENT('table',RESEED,@.max_value)|||Howdy!
Running: DBCC CHECKIDENT('table', RESEED). when i run it second time for the table; the identity value gets normal, i.e. it gets the same as the last value in the column. But it's rather painful to run it for each table. I never had this problem at the publisher it's only at the subscriber. Is there a permanent solution?

Thanx for the reply.

Problem creating SQL Server Mobile Subscription

Hi there

When I try and create a subscription in SQL Server Mobile to a published SQL Server 2005 database, I get the following problem error during the data synchronization process:

Failure to connect to SQL Server with provided connection information. SQL Server does not exist, access is denied because the IIS user is not a valid user on the SQL Server, or the password is incorrect.

HRESULT 0x80004005 (29061)

Any help would be gratefully appreciated.

Regards

JB

If you are using integrated authentication, make sure that the IIS user is able to connect to the publisher server.|||

Mahesh

Thanks for the reply. I have to confess I am not too clear on what you mean by this...still learning...

I used the computername/iuser_computername account to create the publisher. This user has access to the snapshot folder and the virtual directory for the web server. (by the way, all of this is running on the same machine - VS2005, SQL Server 2005, IIS 5.1, and SQL Server Mobile 2005)

As far as I can see, computername/iuser_computername has been used consistently during the creation of the publication (it appears on the Publication Access List for example). I use my own log in on the PC which has admin rights as the Snapshot Agent login for creation of the snapshots.

Where am I going wrong?

Thanks

|||Can you verify if the IUSR_xxx has access to the database by connecting to the server and using the database from an osql command?|||

I am getting the same error as this. When I go to the SQLCESA30.LOG file in the "C:\Program Files\Microsoft SQL Server 2005 Mobile Edition\Server\SqlMobileReplication" directory, the two entries that I get in the log are as follows:

2006/01/07 16:59:36 Hr=00000000 SQLCESA30.DLL loaded 0
2006/01/07 16:59:58 Hr=80004005 ERR:OpenDB failed getting pub version 28627

I'll start a new thread.

|||I've started a new thread at http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=193693&SiteID=1 for "Hr=80004005 ERR:OpenDB failed getting pub version 28627"|||

JB,

Chris, who started the other thread (with the note above) has had very similar issue. He troubleshooted the problem and has been kind enough to post the analysis and the resolution in his thread. Please go through that thread and see if it helps your problem. From what I see the error messages are very much related.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=194640&SiteID=1&mode=1

|||

Hi

I have been Getting the Same Error unable to connect to Sql server or IIS configured properly

Any one who any help me in this regard.

How we would make sure that --> If you are using integrated authentication, make sure that the IIS user is able to connect to the publisher server.

Rg Ad

|||I try use IIS 7, but its difficult than I though. When create publication under IIS 6 I just only add IUSR into login, then create publication and put IUSR into PAL, then subscription just work fine. But when use IIS 7 I follow the steps for IIS 6 then when try synchronize data it said that the IUSR is not valid SQL Server user, is the IIS 7 have another guest account so I can put it into login?

Thanks,

Problem creating SQL Server Mobile Subscription

Hi there

When I try and create a subscription in SQL Server Mobile to a published SQL Server 2005 database, I get the following problem error during the data synchronization process:

Failure to connect to SQL Server with provided connection information. SQL Server does not exist, access is denied because the IIS user is not a valid user on the SQL Server, or the password is incorrect.

HRESULT 0x80004005 (29061)

Any help would be gratefully appreciated.

Regards

JB

If you are using integrated authentication, make sure that the IIS user is able to connect to the publisher server.|||

Mahesh

Thanks for the reply. I have to confess I am not too clear on what you mean by this...still learning...

I used the computername/iuser_computername account to create the publisher. This user has access to the snapshot folder and the virtual directory for the web server. (by the way, all of this is running on the same machine - VS2005, SQL Server 2005, IIS 5.1, and SQL Server Mobile 2005)

As far as I can see, computername/iuser_computername has been used consistently during the creation of the publication (it appears on the Publication Access List for example). I use my own log in on the PC which has admin rights as the Snapshot Agent login for creation of the snapshots.

Where am I going wrong?

Thanks

|||Can you verify if the IUSR_xxx has access to the database by connecting to the server and using the database from an osql command?|||

I am getting the same error as this. When I go to the SQLCESA30.LOG file in the "C:\Program Files\Microsoft SQL Server 2005 Mobile Edition\Server\SqlMobileReplication" directory, the two entries that I get in the log are as follows:

2006/01/07 16:59:36 Hr=00000000 SQLCESA30.DLL loaded 0
2006/01/07 16:59:58 Hr=80004005 ERR:OpenDB failed getting pub version 28627

I'll start a new thread.

|||I've started a new thread at http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=193693&SiteID=1 for "Hr=80004005 ERR:OpenDB failed getting pub version 28627"|||

JB,

Chris, who started the other thread (with the note above) has had very similar issue. He troubleshooted the problem and has been kind enough to post the analysis and the resolution in his thread. Please go through that thread and see if it helps your problem. From what I see the error messages are very much related.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=194640&SiteID=1&mode=1

|||

Hi

I have been Getting the Same Error unable to connect to Sql server or IIS configured properly

Any one who any help me in this regard.

How we would make sure that --> If you are using integrated authentication, make sure that the IIS user is able to connect to the publisher server.

Rg Ad

|||I try use IIS 7, but its difficult than I though. When create publication under IIS 6 I just only add IUSR into login, then create publication and put IUSR into PAL, then subscription just work fine. But when use IIS 7 I follow the steps for IIS 6 then when try synchronize data it said that the IUSR is not valid SQL Server user, is the IIS 7 have another guest account so I can put it into login?

Thanks,

Problem creating SQL Server Mobile Subscription

Hi there

When I try and create a subscription in SQL Server Mobile to a published SQL Server 2005 database, I get the following problem error during the data synchronization process:

Failure to connect to SQL Server with provided connection information. SQL Server does not exist, access is denied because the IIS user is not a valid user on the SQL Server, or the password is incorrect.

HRESULT 0x80004005 (29061)

Any help would be gratefully appreciated.

Regards

JB

If you are using integrated authentication, make sure that the IIS user is able to connect to the publisher server.|||

Mahesh

Thanks for the reply. I have to confess I am not too clear on what you mean by this...still learning...

I used the computername/iuser_computername account to create the publisher. This user has access to the snapshot folder and the virtual directory for the web server. (by the way, all of this is running on the same machine - VS2005, SQL Server 2005, IIS 5.1, and SQL Server Mobile 2005)

As far as I can see, computername/iuser_computername has been used consistently during the creation of the publication (it appears on the Publication Access List for example). I use my own log in on the PC which has admin rights as the Snapshot Agent login for creation of the snapshots.

Where am I going wrong?

Thanks

|||Can you verify if the IUSR_xxx has access to the database by connecting to the server and using the database from an osql command?|||

I am getting the same error as this. When I go to the SQLCESA30.LOG file in the "C:\Program Files\Microsoft SQL Server 2005 Mobile Edition\Server\SqlMobileReplication" directory, the two entries that I get in the log are as follows:

2006/01/07 16:59:36 Hr=00000000 SQLCESA30.DLL loaded 0
2006/01/07 16:59:58 Hr=80004005 ERR:OpenDB failed getting pub version 28627

I'll start a new thread.

|||I've started a new thread at http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=193693&SiteID=1 for "Hr=80004005 ERR:OpenDB failed getting pub version 28627"|||

JB,

Chris, who started the other thread (with the note above) has had very similar issue. He troubleshooted the problem and has been kind enough to post the analysis and the resolution in his thread. Please go through that thread and see if it helps your problem. From what I see the error messages are very much related.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=194640&SiteID=1&mode=1

|||

Hi

I have been Getting the Same Error unable to connect to Sql server or IIS configured properly

Any one who any help me in this regard.

How we would make sure that --> If you are using integrated authentication, make sure that the IIS user is able to connect to the publisher server.

Rg Ad

|||I try use IIS 7, but its difficult than I though. When create publication under IIS 6 I just only add IUSR into login, then create publication and put IUSR into PAL, then subscription just work fine. But when use IIS 7 I follow the steps for IIS 6 then when try synchronize data it said that the IUSR is not valid SQL Server user, is the IIS 7 have another guest account so I can put it into login?

Thanks,

Problem creating SQL Server Mobile Subscription

Hi there

When I try and create a subscription in SQL Server Mobile to a published SQL Server 2005 database, I get the following problem error during the data synchronization process:

Failure to connect to SQL Server with provided connection information. SQL Server does not exist, access is denied because the IIS user is not a valid user on the SQL Server, or the password is incorrect.

HRESULT 0x80004005 (29061)

Any help would be gratefully appreciated.

Regards

JB

If you are using integrated authentication, make sure that the IIS user is able to connect to the publisher server.|||

Mahesh

Thanks for the reply. I have to confess I am not too clear on what you mean by this...still learning...

I used the computername/iuser_computername account to create the publisher. This user has access to the snapshot folder and the virtual directory for the web server. (by the way, all of this is running on the same machine - VS2005, SQL Server 2005, IIS 5.1, and SQL Server Mobile 2005)

As far as I can see, computername/iuser_computername has been used consistently during the creation of the publication (it appears on the Publication Access List for example). I use my own log in on the PC which has admin rights as the Snapshot Agent login for creation of the snapshots.

Where am I going wrong?

Thanks

|||Can you verify if the IUSR_xxx has access to the database by connecting to the server and using the database from an osql command?|||

I am getting the same error as this. When I go to the SQLCESA30.LOG file in the "C:\Program Files\Microsoft SQL Server 2005 Mobile Edition\Server\SqlMobileReplication" directory, the two entries that I get in the log are as follows:

2006/01/07 16:59:36 Hr=00000000 SQLCESA30.DLL loaded 0
2006/01/07 16:59:58 Hr=80004005 ERR:OpenDB failed getting pub version 28627

I'll start a new thread.

|||I've started a new thread at http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=193693&SiteID=1 for "Hr=80004005 ERR:OpenDB failed getting pub version 28627"|||

JB,

Chris, who started the other thread (with the note above) has had very similar issue. He troubleshooted the problem and has been kind enough to post the analysis and the resolution in his thread. Please go through that thread and see if it helps your problem. From what I see the error messages are very much related.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=194640&SiteID=1&mode=1

|||

Hi

I have been Getting the Same Error unable to connect to Sql server or IIS configured properly

Any one who any help me in this regard.

How we would make sure that --> If you are using integrated authentication, make sure that the IIS user is able to connect to the publisher server.

Rg Ad

|||I try use IIS 7, but its difficult than I though. When create publication under IIS 6 I just only add IUSR into login, then create publication and put IUSR into PAL, then subscription just work fine. But when use IIS 7 I follow the steps for IIS 6 then when try synchronize data it said that the IUSR is not valid SQL Server user, is the IIS 7 have another guest account so I can put it into login?

Thanks,