There is no way to find the password. Your only option is to reset the password. But I believe it is not possible if we don’t know the password. IF its a sql login and you have access to the application servers, you could look for it in connection strings on those.

Username and Password are default set to AgroSoft and 12345 respectively. If you have chosen a different username and / or password, then they must be entered instead.

A login is a simple credential for accessing SQL Server. For example, you provide your username and password when logging on to Windows or even your e-mail account. This username and password builds up the credentials. Therefore, credentials are simply a username and a password.

Procedure

1. In the SQL Server Management Studio, open Object Explorer.
2. Click Server_instance_name > Security > Logins.
3. Right-click Logins and select New Login.
4. On the General page, in the Login name field, type the name for a new user.
5. Select SQL Server authentication.
6. In the Password field, type a password for the user.

As its name implies, a user without login cannot log into SQL Server. However, the “user” exists as a database object and may therefore be granted or denied permissions as may any other user. These permissions, of course, will be exactly those required by your stored procedure code. No more, no less.

Accessing the new SQL Server Instance

1. Open SQL Server Management Studio from the Windows Start menu. SQL Server login screen.
2. In the Connect to Server dialogue box: Option. Description. Server type.
3. Click Connect.
4. In the left pane confirm that you are connected to the new SQL server instance. Related Topics.

When you install Microsoft Data Engine (MSDE) version 1.0 or Microsoft SQL Server Desktop Engine (MSDE2000), the installation uses SQL Authentication by default. In addition, the default user name in these cases is sa, and the default password is blank.

Open SQL Server configuration manager and select the service of SQL Server instance. Right-click and click on the Properties option. After adding the startup parameter, click on the Apply button and then the OK button in the warning message window. Restart the SQL Server service to start SQL Server in single user mode.

A login is a security principal at the scope of the SQL Server instance, and a SQL Server instance can contain numerous databases. Simply stated, a login allows you to connect to a SQL Server instance. Once you are connected to SQL Server instance, you will typically need access to a particular database.

Step 3: Connect to your database using SSMS

1. Launch Microsoft SQL Server Management Studio.
2. The Server type should be Database Engine.
3. Enter the server name (see above)
4. Authentication is SQL Server Authentication.
5. Enter your database username (see above)
6. Enter your database password (see above)
7. Click Connect.

To create this user:

1. In SQL Server Management Studio, right-click Security > Logins; then select New Login.
2. Enter the username (for example, papercut).
3. Change the Server Authentication to SQL Server and Windows Authentication mode.
4. Enter the user’s password.
5. Disable password expiration.
6. Click OK.

IF its a sql login and you have access to the application servers, you could look for it in connection strings on those. There is no way to find the password. Your only option is to reset the password. But I believe it is not possible if we don’t know the password.

Passwords are case-sensitive. MUST_CHANGE Applies only to SQL Server logins. If this option is included, SQL Server will prompt for an updated password the first time the altered login is used. DEFAULT_DATABASE =database Specifies a default database to be assigned to the login.

PASSWORD =’password’ Applies only to SQL Server logins. Specifies the password for the login that is being changed. Passwords are case-sensitive. PASSWORD =hashed_password Applies to the HASHED keyword only. Specifies the hashed value of the password for the login that is being created.

Policy Enforcement. The enforcement of password policy can be configured separately for each SQL Server login. Use ALTER LOGIN (Transact-SQL) to configure the password policy options of a SQL Server login.