Why does SQL Server 2008 Express Management Studio change the password of a new login automatically? -


I created a new login using Express Management Studio and SQL Server authentication. When creating, the password changes automatically in some long form and I am not able to set the password using the newly created user.

What do I have to do to use the same password which I set up and it does not tamper with?

I think there is space on Frosso's comment. The SQL Server is not changing the password you entered, but SQL Server Management Studio (SSMS) is visually modifying the password and to confirm the password entry box to reveal it longer than what the password is is.

Have you tried to create a new SQL account, have been trying to reconnect with the SQL server through SSMS and through SSMS. password? If this works, you know that you have created the account properly and that the password is actually correct.

As Frosso also said, if you are unable to connect to the SQL Server database remotely, then it is most likely the fact that SQL Server Express Box Has not been configured from.

This KB article describes the steps you take to enable remote connections. It is written on SQL Server 2005, but I believe that the same basic steps apply to SQL Server 2008.


Comments

Popular posts from this blog

Eclipse CDT variable colors in editor -

AJAX doesn't send POST query -

wpf - Custom Message Box Advice -