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 |
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
 Posted - 2008-12-16 : 00:19:37
|
| Dear All,in one of my servers, we got a problem that login failed. even from the SSMS, i've tried to connect, and it behave same login failed. after restarting the server, it became ready to accept the user. please let me know why this problem came for me?ArnavEven you learn 1%, Learn it with 100% confidence. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-12-16 : 00:53:48
|
| are you using windows authentication or sql authentication? |
 |
|
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
Posted - 2008-12-16 : 01:59:37
|
| Sql AuthenticationArnavEven you learn 1%, Learn it with 100% confidence. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-12-16 : 09:06:59
|
| Have you applied recent Service packs? |
|
|
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
Posted - 2008-12-17 : 00:16:13
|
| no till now it is working without any service packs....i'm planning to install SP2ArnavEven you learn 1%, Learn it with 100% confidence. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-12-17 : 09:31:01
|
| Did you check in Event log or SQL error log for reason behind it? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
sunsanvin
Master Smack Fu Yak Hacker
1274 Posts |
Posted - 2008-12-18 : 07:17:47
|
| Thankyou TaraArnavEven you learn 1%, Learn it with 100% confidence. |
|
|
|
|
|
|
login failed suddenly