• Are you able to login with the credentials using Manamgement Studio?

    Yes I'm able to login to Manamgement Studio using windows authentication as an admin

    But I'm not able to login as sa

    when i execute the following statement,

    CREATE LOGIN schemaUser WITH PASSWORD='Pass#123',DEFAULT_DATABASE=permissionsDB

    Is it creating a sql server account or windows account?

    error is as follow:

    TITLE: Connect to Server

    ------------------------------

    Cannot connect to USER-PC\SQLEXPRESS.

    ------------------------------

    ADDITIONAL INFORMATION:

    Login failed for user 'schemaUser'. (Microsoft SQL Server, Error: 18456)

    For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&EvtSrc=MSSQLServer&EvtID=18456&LinkId=20476

    ------------------------------

    BUTTONS:

    OK

    ------------------------------

    Thanks a lot!