Please try to list out all the fields including the identity column explicitly

For example:

SET IDENTITY_INSERT table1 ON

insert table1 (field1,field2,field3...)

select * from table2

SET IDENTITY_INSERT table1 OFF