Cannot login to SQLServer 2005

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.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

Cannot login to SQLServer 2005

Author

Topic

pssheba
Yak Posting Veteran

95 Posts

Posted - 2011-08-20 : 04:03:48

Hi everyone,
This is not the first time it happens to me.
I want to login to my SQLServer 2005 so i assign user name and password that has been working fine last 6 months (I get that trouble each 6 months approxtimately) and i get an error message that says that either user name or password is wrong.
I operate a "restore" to me Windows system. Only then i manage to login.
Isn't there a more simple way to recover the lost passwor/user ? Is there a text file that stores user names and their passwords so i can backup it rather then restore the whole system ?
Thanks !

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-08-20 : 04:10:14

have you set any expiration policy for the username?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

pssheba
Yak Posting Veteran

95 Posts

Posted - 2011-08-20 : 12:04:19

quote:
Originally posted by visakh16

have you set any expiration policy for the username?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

How do i check expiration date ?

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-08-20 : 12:25:13

In server-> security-> logins right click your login check properties and see if set password expiration property is set

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

pssheba
Yak Posting Veteran

95 Posts

Posted - 2011-08-20 : 14:53:11

quote:
Originally posted by visakh16

In server-> security-> logins right click your login check properties and see if set password expiration property is set

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Thanks,
In my login's properties "Enforce Password Policy" is signed.
"Enforce Password Expiration" is not signed".

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-08-21 : 00:30:52

then it shouldnt have expired. between whats your password policy?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

pssheba
Yak Posting Veteran

95 Posts

Posted - 2011-08-21 : 17:25:16

quote:
Originally posted by visakh16

then it shouldnt have expired. between whats your password policy?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Could you tell me do i check it?

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-08-22 : 01:34:19

it should be set in your windows domain

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

pssheba
Yak Posting Veteran

95 Posts

Posted - 2011-09-03 : 04:00:22

quote:
Originally posted by visakh16

it should be set in your windows domain

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Hi,
When I log out of Windows OS and reconnect, the problem is solved. When I use browser before I connect to the SQL server then, sometimes, I fail to do so.
The error message says:

[img]
E:\sql\dba\login_error.gif
[/img]

quote:

Cannot connect to SQLServerName
An error has occurred while establishing a connection to the server.
When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections to SQL Server. Error 40 , Error 2.

Thanks a lot

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2011-09-03 : 05:34:39

is sql server in same domain? also are you using a different credential while using browser

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources