I am trying to login with an account (for example user name: SQL1) using SQL Authentication and having problems, it is not accepting the username/password. I know it is an active user because from a different domain I am able to login successfully using Windows Authentication. For testing logging from another domain I want to user SQL Authentication but I can't seem to get it working. When I login using the SA account, how can I change the password (SQL Authentication) for the user account: SQL1?
Thanks.