InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSun, 19 May 2013 12:10:48 GMT20http://www.sqlservercentral.com/Forums/Topic1384484-1526-1.aspxnew users are at least a three step process:create the user in Active directory (you said that was done)create a login for the user in SQL Server(you said that was done)Create a user in the database to match the login(missing?)Assign the appropriate permissions/role so the user can access data(missing)[code]--creat the login for the Active Directory UserCREATE LOGIN [mydomain\NewUse] FROM WINDOWS;--switch to the right database: if more than one database, repeat for each oneUSE SandBox;GO--Create the user to match the loginCREATE USER [mydomain\NewUser] FROM LOGIN [mydomain\NewUser]--assign permissions--put the user in the correct permissions roleexec sp_addrolemember 'RoleAlreadyCreated', 'mydomain\NewUser'--an example in case you don't have the role with the right permissions yet:CREATE ROLE [AlmostOwners] EXEC sp_addrolemember N'db_ddladmin', N'AlmostOwners'EXEC sp_addrolemember N'db_datareader', N'AlmostOwners'EXEC sp_addrolemember N'db_datawriter', N'AlmostOwners'--can the users EXECUTE procedures? comment out if falseGRANT EXECUTE TO [AlmostOwners]exec sp_addrolemember 'AlmostOwners', ' mydomain\NewUser'[/code]Wed, 14 Nov 2012 06:16:56 GMTLowellhttp://www.sqlservercentral.com/Forums/Topic1384484-1526-1.aspx--deleted duplicate post.Wed, 14 Nov 2012 06:08:38 GMTLowellhttp://www.sqlservercentral.com/Forums/Topic1384484-1526-1.aspxWhat kind of SQL login did you create?Windows Authentication? SQL Server Authentication?Did you enable it?Wed, 14 Nov 2012 05:38:27 GMTKoen Verbeeckhttp://www.sqlservercentral.com/Forums/Topic1384484-1526-1.aspxwindows id is created by windows team and by using sql administrator login i created sql login but some times it says unable to connect in this case what should i doWed, 14 Nov 2012 05:27:09 GMTnaga.rohitkumarhttp://www.sqlservercentral.com/Forums/Topic1384484-1526-1.aspxYou say the windows user is created but have you created a SQL Server login as well?Wed, 14 Nov 2012 03:59:47 GMTAbu Dinahttp://www.sqlservercentral.com/Forums/Topic1384484-1526-1.aspxHow did you create the user?Wed, 14 Nov 2012 03:53:10 GMTKoen Verbeeckhttp://www.sqlservercentral.com/Forums/Topic1384484-1526-1.aspxHI to all ,windows user is created and unable to connect to sqlserver management studio Wed, 14 Nov 2012 02:28:48 GMTnaga.rohitkumar