Re: Object browser or database dropdown in Query Analyzer freezes
- From: "William Vaughn \(MVP\)" <billva@xxxxxxxxxxxxxxx>
- Date: Sun, 30 Nov 2008 12:12:02 -0500
Yes, I expect it's a rights issue on the SQL Server itself. Each login is granted (or not granted) rights to the objects including the list of databases. Generally this prevents getting a connection so perhaps your login has rights to Views or SPs but not to the other objects. Frankly, this is exactly how it's supposed to work. Check with your DBA for details on how to expand those rights...
--
__________________________________________________________________________
William R. Vaughn
President and Founder Beta V Corporation
Author, Mentor, Dad, Grandpa
Microsoft MVP
(425) 556-9205 (Pacific time)
Hitchhiker’s Guide to Visual Studio and SQL Server (7th Edition)
http://betav.com/blog/billva
http://betav.com
____________________________________________________________________________________________
"techfam7" <techfam7@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:1D900930-0E4F-4C0C-BF18-21366E4F170D@xxxxxxxxxxxxxxxx
I can connect to SQLServer using Query Analyzer and execute queries just fine
but when I try to drop down the list of databases or open the Object Browser
window it freezes. I suspect it has something to do with authentication. It
is checking to see which databases I am allowed to see but never returns from
domain controller. Does anyone know which ports are being used for
authentication or verification? We don't see anything blocked. Firewall guys
say it is not theirs because nothing is blocked. Network guys say it is not
theirs because network is fine. All other applications appear to work fine,
it is only Query Analyzer and Enterprise Manager that lock up. Any ideas?
.
- References:
- Prev by Date: Re: could someone tell me how I would do this?
- Next by Date: Re: Link server to protected ACCESS file
- Previous by thread: Object browser or database dropdown in Query Analyzer freezes
- Next by thread: Trouble connecting to sql server 2005 express
- Index(es):
Relevant Pages
|
