sql server - Cannot connect to instance with new user -


i tried creating user login below script, similar steps indicated here:

create login radu_test password = 'abcd1234!!!!';  create user radu_test login radu_test;  grant select on dbo.accountinformation radu_test; 

and tried connect user in ssms, i'm getting below error , i'm kind of stumped next. i'm pretty sure basic thing, can't understand i'm doing wrong.

any appreciated!

enter image description here

in sql server (instance) properties check mixed authentication mode. must enable in order connect sql server login.


Comments

Popular posts from this blog

AbotX : How do you create a parallel crawler that stays on and can be added to at run time from new requests -

android - Create single AAR file from multiple modules using Gradle -

Android: SharingActionView on swipe from bottom -