Your SQL Server user ID must have sufficient authority to reset an identity seed. If you are the table's owner, this grants the authority, as does a sysadmin or db_ddladmin user type.