Hi,

I dont remember my code (ID and password) of authentication for SQL Management 2014 since I usually work with windows authentication. How am I able to retrieve it?

Thank you in advance

If you know the user id then we can reset the password otherwise create a new one.

Hi 

Using command prompt try this

--To create a new login and add that login to SYSADMIN server role:
0> SQLCMD -?   -- For help
1> CREATE LOGIN <Login_Name> with PASSWORD=<Password>

2> go

1> SP_ADDSRVROLEMEMBER '<Login_Name>','SYSADMIN'

2>go

Thanks

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

Please mark this reply as the answer or vote as helpful, as appropriate, to make it useful for other readers

• Edited by SequelMate 21 hours 24 minutes ago

Hi RSingh,

Thank for your quick replay. I have tried to create a new Login, but It has been impossible.
Could you tell me how I could do it?.

My steps were:

I started the program SQL Management, with the windows authentication and then I tried to create a new Login that it is inside in the SECURITY Folder, this folder is below Database folder. Is it correct?

Thank you in advance

Please ensure that you have the right permission to create a user.

Refer the below link to create a new user.

https://msdn.microsoft.com/en-us/library/ms173463.aspx

http://databases.about.com/od/sqlserver/ht/Creating-A-Sql-Server-2008-Database-Account.htm

Hi Frank,

The SECURITY folder location is correct, But your login should have a authentication or permissions to create a new login.

Only user having SysAdmin and Security Admin can add the logins.

Regards,

Satish.. :)