Below steps will guide you to create user in Microsoft SQL Management Studio and in Siebel. First create login, open MS SQL Management Studio and connect with database.Run below SQL statement. CREATE LOGIN <user-name> WITH PASSWORD = '<password>'; CREATE LOGIN EAIUSER WITH PASSWORD = 'EAIUSER'; Now create user in database. The SQL create user command takes the following syntax: create user <user-name> for login <login-name> create user EAIUSER for login EAIUSER Now you need to provide permissions to newly created user in database. There are tow ways based on user role in the organization select the appropriate method. One to provide the rights of specific database or assign the Membership role to newly created user. Expand the DB and go to Security/Users and find or add filter for new user as seen below. Right click and open properties. Now go Securables and click on Search button. A new window will popup as seen below. Check the Specific Objects...