Re: Cannot connect to Query Analyzer

A few things to check on the issue with Query Analyzer:
First make sure you don't have tracing turned on. I don't
think this is your issue as you can open QA from the menu
but you would want to check to make sure. Open the Data
Sources (ODBC) tool from Administrative Tools. Go to the
tracing tab and make sure all tracing is turned off - the
buttons would display "Start <tool name> Tracing" if it's
turned off.
Try replacing the MMC app for SQL Server from the original
media. Find the file on your PC named SQL Server Enterprise
Manager.MSC. Rename it and replace it in the same location
with the original MSC file of the same name from the
original installation media.
In terms of the startup account, you wouldn't change the
password if it's running under a system account. Passwords
for those are managed by the operating system. It's
generally a better idea to run SQL Server under domain
accounts rather than system accounts. If your local SQL
Server doesn't need access to network resources in your
domain, you can create a local account on your PC and just
use that to run SQL Server. You want to change services
accounts from that security tab you saw in Enterprise
Manager. When you change the service accounts through
Enterprise Manager, the security and permissions necessary
on your PC for the service account would automatically be
handled, properly set when using Enterprise Manager.

-Sue

On Fri, 11 Aug 2006 14:03:02 -0700, Mike Collins
<MikeCollins@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

When I go to tools and select query analyzer, I get an hour glass cursor for
a second, or two, and then nothing.

I check the security tab and if you are talking about the startup service
account section, system account is currentlly selected, so I do not have the
option to type in an account and password. Should I be using a certain
account?

Thanks

"Sue Hoegemeier" wrote:

And what happens if while you are in Enterprise Manager, you
go to the menu to Tools and then select Query Analyzer? What
doesn't work? Does Query Analyzer not show up in the menu or
are you getting an error? If it's an error, what is the
exact error and error number?
To change the password for the service account from
Enterprise Manager, select the server, right click and
select Properties. Click on the Security tab. You can change
the password or account used for the service from this
screen.

-Sue

On Fri, 11 Aug 2006 05:32:02 -0700, Mike Collins
<MikeCollins@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

Just a few days ago, we changed the password on our server. After that, I
noticed that I could not open Query Analyzer from within Enterprise Manager.
I can open Query Analyzer from the start menu and login that way, but can
someone help in where to look to make it be able to open from with in
Enterprise Manager again. Also, I have a local SQL Server on my laptop and
when I tried to change the password to it, through the edit registration
section, I could not. Any thoughts on what where to look, or what I am
supposed to do, to be able to change the password on my local sql server?



.

Loading