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!