Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Georgevv
Starting Member
3 Posts |
 Posted - 2013-06-11 : 02:02:57
|
| Good day I am creating a new user lets say User1 in SQL Server authentication when I add the new password lets say the password I put in is Password2 Then after I have save and close when I try to log in with this user it say the password is wrong. So I go back and I see the password is change now there is alot more dots and I dont know the password. It dont matter how much I try to change the password it always go back to some other kind of password and that is with a new user I have create in SQL manager studio 2008. Please help. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-06-11 : 02:13:02
|
| nope...you will still be able to login with password you typed. It just encrypts value internally thats why you see a longer value of dots there.It may be that you didnt type set password correctly.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
 |
|
|
Georgevv
Starting Member
3 Posts |
Posted - 2013-06-11 : 02:34:59
|
| Thanks I will check again but I have even make the password sort to make sure that I dont do a type error but still it says wrong password. I will take later a screen shot and past it as well. I have make the password like 4 characters and one number and still it dont work and when I go back in there is about 10 or more dots. I know this is strange. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-06-11 : 02:39:12
|
| hmmm..not something i've seen before. Is there some policy set in database by the admin?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
Georgevv
Starting Member
3 Posts |
Posted - 2013-06-11 : 02:46:27
|
| No There is no policy set by admin. I am practicing at my home computer I only installed a default instance of SQL 2008 and created a very small database now I want to practice adding users and give each just rights I have done exactly as on the Nuggets training video so I know the steps but the guy on the video can log in but with me it says the user password is wrong But thanks for your help I will play around with it. :-) |
|
|
|
|
|
|
create user login password dont want to change