why you need a auto Generated id?. I think you work done sql Automatically,
CREATE TABLE [dbo].[Table_Name](
[id] [int] NOT NULL, ///this id will automatically increment.
[role] [varchar](20) NULL,
[password] [varchar](20) NULL,
CONSTRAINT [PK_jogi2] PRIMARY KEY CLUSTERED
(
For any query hit reply option.