Saturday, February 25, 2012

Can someone tell me what this means in SQL 7.0?

This is what I see in SQL Manager.
Thanks.
--
George Hester
_________________________________the database server is running and you are connected to it|||Well then what does it mean when the little red squiggly line is NOT =
there? Same thing? hmm...
--=20
George Hester
__________________________________
"Scott Morris" <bogus@.bogus.com> wrote in message =
news:uZukznd2DHA.1760@.TK2MSFTNGP10.phx.gbl...
quote:

> the database server is running and you are connected to it
>=20
>
|||The squiggly line means you are connected. Its absence means you are not
connected. It may appear there is no difference if security is set up (and
the server is registered) such that you don't need to enter a password to
connect. However, there is a definite difference.
"George Hester" <hesterloli@.hotmail.com> wrote in message
news:%23z%231WAe2DHA.2528@.TK2MSFTNGP10.phx.gbl...
Well then what does it mean when the little red squiggly line is NOT there?
Same thing? hmm...
George Hester
__________________________________
"Scott Morris" <bogus@.bogus.com> wrote in message
news:uZukznd2DHA.1760@.TK2MSFTNGP10.phx.gbl...
quote:

> the database server is running and you are connected to it
>
|||It should mean that SQL Server is running but you are not connected.
Rand
This posting is provided "as is" with no warranties and confers no rights.|||OK so the red squigly line means the MSSQL Service is starting without a =
user account and its concommitant password? That makes sense because =
the service is starting with the LocalSystem account. For some reason I =
am unable to change the account used to start the service. When I try =
to set the service to use My Administrator account in the Enterprise =
Manager I get a "A required priviledge is not held by the client." I =
suppose I could set the MSSQL Service to start using the Administrator =
account in the Services applet of Windows 2000. I haven't tried that =
because I felt if I couldn't do it in the Enterprise Manager then trying =
it there would fail just as well. But I'll give that a shot.
--=20
George Hester
__________________________________
"Scott Morris" <bogus@.bogus.com> wrote in message =
news:OdTNsIe2DHA.2184@.TK2MSFTNGP12.phx.gbl...
quote:

> The squiggly line means you are connected. Its absence means you are =

not
quote:

> connected. It may appear there is no difference if security is set up =

(and
quote:

> the server is registered) such that you don't need to enter a password =

to
quote:

> connect. However, there is a definite difference.
>=20
> "George Hester" <hesterloli@.hotmail.com> wrote in message
> news:%23z%231WAe2DHA.2528@.TK2MSFTNGP10.phx.gbl...
> Well then what does it mean when the little red squiggly line is NOT =

there?
quote:

> Same thing? hmm...
>=20
> --=20
> George Hester
> __________________________________
> "Scott Morris" <bogus@.bogus.com> wrote in message
> news:uZukznd2DHA.1760@.TK2MSFTNGP10.phx.gbl...
>=20
>
|||No. The red squigly line has NOTHING to do with the account that the
service is using. It indicates that EM has established a connection to the
server (using whatever account / security is specified in the registration).
EM is only an application that can be used to manage database servers. It
is only an application - it is NOT the database server program / service.
If you are having problems changing the account under which the DBMS runs,
then I suggest that you start a new thread with the appropriate subject and
details. In addition, you should search the newsgroups - as most issues
have been addressed (and are often FAQs).
"George Hester" <hesterloli@.hotmail.com> wrote in message
news:%23qpbbmi2DHA.2156@.TK2MSFTNGP12.phx.gbl...
OK so the red squigly line means the MSSQL Service is starting without a
user account and its concommitant password? That makes sense because the
service is starting with the LocalSystem account. For some reason I am
unable to change the account used to start the service. When I try to set
the service to use My Administrator account in the Enterprise Manager I get
a "A required priviledge is not held by the client." I suppose I could set
the MSSQL Service to start using the Administrator account in the Services
applet of Windows 2000. I haven't tried that because I felt if I couldn't
do it in the Enterprise Manager then trying it there would fail just as
well. But I'll give that a shot.
George Hester
__________________________________
"Scott Morris" <bogus@.bogus.com> wrote in message
news:OdTNsIe2DHA.2184@.TK2MSFTNGP12.phx.gbl...
quote:

> The squiggly line means you are connected. Its absence means you are not
> connected. It may appear there is no difference if security is set up

(and
quote:

> the server is registered) such that you don't need to enter a password to
> connect. However, there is a definite difference.
> "George Hester" <hesterloli@.hotmail.com> wrote in message
> news:%23z%231WAe2DHA.2528@.TK2MSFTNGP10.phx.gbl...
> Well then what does it mean when the little red squiggly line is NOT

there?
quote:

> Same thing? hmm...
> --
> George Hester
> __________________________________
> "Scott Morris" <bogus@.bogus.com> wrote in message
> news:uZukznd2DHA.1760@.TK2MSFTNGP10.phx.gbl...
>
|||I have. The red sqiggly line is not right.
--=20
George Hester
__________________________________
"Scott Morris" <bogus@.bogus.com> wrote in message =
news:u7Lb9Mq2DHA.1924@.TK2MSFTNGP10.phx.gbl...
quote:

> No. The red squigly line has NOTHING to do with the account that the
> service is using. It indicates that EM has established a connection =

to the
quote:

> server (using whatever account / security is specified in the =

registration).
quote:

> EM is only an application that can be used to manage database servers. =

It
quote:

> is only an application - it is NOT the database server program / =

service.
quote:

> If you are having problems changing the account under which the DBMS =

runs,
quote:

> then I suggest that you start a new thread with the appropriate =

subject and
quote:

> details. In addition, you should search the newsgroups - as most =

issues
quote:

> have been addressed (and are often FAQs).
>=20
> "George Hester" <hesterloli@.hotmail.com> wrote in message
> news:%23qpbbmi2DHA.2156@.TK2MSFTNGP12.phx.gbl...
> OK so the red squigly line means the MSSQL Service is starting without =

a
quote:

> user account and its concommitant password? That makes sense because =

the
quote:

> service is starting with the LocalSystem account. For some reason I =

am
quote:

> unable to change the account used to start the service. When I try to =

set
quote:

> the service to use My Administrator account in the Enterprise Manager =

I get
quote:

> a "A required priviledge is not held by the client." I suppose I =

could set
quote:

> the MSSQL Service to start using the Administrator account in the =

Services
quote:

> applet of Windows 2000. I haven't tried that because I felt if I =

couldn't
quote:

> do it in the Enterprise Manager then trying it there would fail just =

as
quote:

> well. But I'll give that a shot.
>=20
> --=20
> George Hester
> __________________________________
> "Scott Morris" <bogus@.bogus.com> wrote in message
> news:OdTNsIe2DHA.2184@.TK2MSFTNGP12.phx.gbl...
are not[QUOTE]
up[QUOTE]
> (and
password to[QUOTE]
> there?
>=20
>

No comments:

Post a Comment