| Author |
Topic |
|
ttakundwa
Starting Member
5 Posts |
 Posted - 2007-09-06 : 13:20:14
|
| We have SQL Standard installed on a Windows XP. I start up SQL Server Management Studio and am presented with the authentication dialog. I select Windows Authentication and click Connect and it hangs. If I select SQL Server authentication and choose a known correct login, I get the same result (hangs). If I Cancel, all buttons are disabled, but the dialog remains. I cannot even shut it down with the upper right corner "x". The only way I've found to end it is via Task Manager.Also, if I just cancel out of the authentication dialog box without attempting to connect, I'm able to do admin things like attach/detach databases, view tables via the object browser, etc.. I cannot execute queries. Help guys, iam stuck.Thanks a lot... |
|
|
Zoroaster
Aged Yak Warrior
702 Posts |
Posted - 2007-09-06 : 13:40:25
|
If you can access the database admin stuff in the Object Explorer have you tried clicking "New Query" to see if it opens the query window?
Future guru in the making. |
 |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2007-09-06 : 15:52:50
|
| have you applied the patches yet? 3054 should be your latest version if you downloaded sp2 in april and applied gdr2--------------------keeping it simple... |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-09-06 : 15:56:26
|
| There's actually an even later patch already out. It's put the version at 3186.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
ttakundwa
Starting Member
5 Posts |
Posted - 2007-09-07 : 04:30:04
|
quote:
Originally posted by Zoroaster
If you can access the database admin stuff in the Object Explorer have you tried clicking "New Query" to see if it opens the query window?
Future guru in the making.
cannot connect to using the new query thing, it just does the same thing (hangs) |
|
|
|
ttakundwa
Starting Member
5 Posts |
Posted - 2007-09-07 : 04:39:04
|
quote:
Originally posted by jen
have you applied the patches yet? 3054 should be your latest version if you downloaded sp2 in april and applied gdr2--------------------keeping it simple...
hie, thanks, the server was still running without any SP, i will install it and apply the patches. But does it have to be this way??? this minute you login the next you just can't, mainly due to a patch??? eishh, MS.... |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-09-07 : 13:30:45
|
| You should also install the SP and patches to your client. They aren't only for the database engine on the server. They also contain bug fixes for the client tools. Always get patched to the latest version when you encounter issues that way we can rule it out.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2007-09-07 : 13:52:49
|
Already? MS is making them like some factory candiesAfter checking the fixes, I think I'll wait for SP3. We can only afford 2 major downtimes and 1 I've already used, the other one I reserve for SP3  , otherwise this fix at the end of this yearThanks Taraquote:
Originally posted by tkizer
There's actually an even later patch already out. It's put the version at 3186.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/
--------------------keeping it simple... |
|
|
|
ttakundwa
Starting Member
5 Posts |
Posted - 2007-09-10 : 08:40:21
|
hie Tara,It seems it had nothing to do with the patches, the problem was a registered server which had its name changed on the network, so for all that time it hanged it was trying to access that server, what i had to do was to delete the registered server, and it connected fine.i did apply the patches after that tho.thanks guys,quote:
Originally posted by tkizer
You should also install the SP and patches to your client. They aren't only for the database engine on the server. They also contain bug fixes for the client tools. Always get patched to the latest version when you encounter issues that way we can rule it out.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/
|
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-09-10 : 11:31:58
|
| I wasn't saying that the service packs or patches would fix the issue, but you should always get these installed when an issue arises to eliminate that as the resolution. This is just standard troubleshooting procedures.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-09-10 : 22:18:39
|
| And that's the first thing Microsoft support will let you do. |
|
|
|
|
SQL Server Management Studio login issues