I'm sorry I meant SSMS. That's what we have.
I created a user and then checked the box that says user much change password at next login. Then I logged back into SSMS with the user and when I try to log in I received an error message that says: "A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.) (Microsoft SQL Server, Error: 233).
How can I have users change their password at the next login...if they can't log in.
Is there some way to do it through the application?