Cannot connect to Query Analyzer

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?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@.discussions.microsoft.com> 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?|||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@.discussions.microsoft.com> wrote:
>
>|||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@.discussions.microsoft.com> wrote:
[vbcol=seagreen]
>When I go to tools and select query analyzer, I get an hour glass cursor fo
r
>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 th
e
>option to type in an account and password. Should I be using a certain
>account?
>Thanks
>"Sue Hoegemeier" wrote:
>|||Ok...I tried what you suggested with no luck. I'm thinking of maybe
reinstalling SQL Server.
For Query Analyzer, I tried replacing the file as you suggested but had the
same results (Enterprise Manager starts up fine, but still cannot start QA
from within Enterprise Manager).
Changing the password. I created an account on my laptop and changed SQL
Server from the system account to a local one and got the following message:
"Unable to detect the status of Full Text Search service or unable to start
the service. Continuing to change the account might affect Full Text Search
service later. Would you like to continue?". I wasn't sure what to do from
there, so I cancelled.
Any suggestions?
"Sue Hoegemeier" wrote:

> 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@.discussions.microsoft.com> wrote:
>
>|||On the Query Analyzer issue, try reinstalling the client
tools. If that still doesn't work, I have no idea how it
broke. Check that isqlw.exe has not been moved from the
default installation location, make sure the tools directory
is in your environment path, make sure you can access Query
Analyzer by typing isqlw from the run command, etc. But for
all of those issues, you should be getting a file not found
error. So I'd just try reinstalling the client and
reapplying the last service pack.
On the account, Try adding the local account you created to
the local administrators on your PC and make sure to add it
to the sysadmins server role on your PC. Then try changing
the service account in Enterprise Manager.
-Sue
On Tue, 15 Aug 2006 06:07:01 -0700, Mike Collins
<MikeCollins@.discussions.microsoft.com> wrote:
[vbcol=seagreen]
>Ok...I tried what you suggested with no luck. I'm thinking of maybe
>reinstalling SQL Server.
>For Query Analyzer, I tried replacing the file as you suggested but had the
>same results (Enterprise Manager starts up fine, but still cannot start QA
>from within Enterprise Manager).
>Changing the password. I created an account on my laptop and changed SQL
>Server from the system account to a local one and got the following message
:
>"Unable to detect the status of Full Text Search service or unable to start
>the service. Continuing to change the account might affect Full Text Search
>service later. Would you like to continue?". I wasn't sure what to do from
>there, so I cancelled.
>Any suggestions?
>"Sue Hoegemeier" wrote:
>|||Thanks. I got the login issue to work, and I will reinstall client tools whe
n
I get a chance. Thanks again for your help.
"Sue Hoegemeier" wrote:

> On the Query Analyzer issue, try reinstalling the client
> tools. If that still doesn't work, I have no idea how it
> broke. Check that isqlw.exe has not been moved from the
> default installation location, make sure the tools directory
> is in your environment path, make sure you can access Query
> Analyzer by typing isqlw from the run command, etc. But for
> all of those issues, you should be getting a file not found
> error. So I'd just try reinstalling the client and
> reapplying the last service pack.
> On the account, Try adding the local account you created to
> the local administrators on your PC and make sure to add it
> to the sysadmins server role on your PC. Then try changing
> the service account in Enterprise Manager.
> -Sue
> On Tue, 15 Aug 2006 06:07:01 -0700, Mike Collins
> <MikeCollins@.discussions.microsoft.com> wrote:
>
>