hi guys,
i was wondering if there is a bug in sql server 2000 that upon changing settings in the sqlserver agent or sqlserver services that it will actually change your nt user password.
a strange occurence happened to me i switched the sqlmail to a different outlook profile that is MAPI compliant i had to stop and start the sql server agent upon restart it said it could not log me in b/c my nt logon failed (i guess you can figure out by now that i have authentication as NT in my set up of sql server agent). well me knowing microsoft products i was like ah i will just reboot the machine) well upon reboot my administrator password which is empty "null value"no longer is valid.
now noone in the company said that they changed the administrator password and it is not logged into a domain so the machine is not on our companys network. we log in local to the machine as the administrator. the last things that i played around in with sql server was replication setting it up as a publisher and deleteing it and changing a mapi profile. is there anywhere in sql 2000 that messing with any setting that it will actually affect your windows nt user login?? i know i cant be loosing my mind here and i hope someone at my company wouldnt sabotage my machine. right now i have two options i can reinstall win 2000 and choose repair hoping that i will not lose my sql 2000 info or i can try a password cracker. any suggestions that might of cause this to happen?
regards,
Robertof course Microsoft is always providing use with new features, but I doubt this unlikely. What you described sounds exactly as if the user password had been changed at the OS level. The password could have been changed by mistake.
Showing posts with label agent. Show all posts
Showing posts with label agent. Show all posts
Tuesday, February 14, 2012
Sunday, February 12, 2012
can not start sql agent
SQL Book Online lists command sqlagent.exe can start SQL
agent.
I tried to start sql agent by using sqlagent.exe from
command prompt. But get error:
"You must start SQLServerAgent as a service (using the SQL
Server Service Manager)"
Does Book Online give wrong option?
Thanks for suggestions.
-TomHi,
You can use either Control panel -- Administrative tools -- Services --
there you can select and start "SQL Agent" service.
Otherwise from command prompt you can issue below command to start the sql
agent service.
net start sqlagent
Note:
The above service name will be SQLagent$instance_name if your sql server is
a named instance.
Thanks
Hari
MCDBA
"Tom Torain" <TST_MC@.hotmail.com> wrote in message
news:936801c3eac9$9df5e5d0$a301280a@.phx.gbl...
> SQL Book Online lists command sqlagent.exe can start SQL
> agent.
> I tried to start sql agent by using sqlagent.exe from
> command prompt. But get error:
> "You must start SQLServerAgent as a service (using the SQL
> Server Service Manager)"
> Does Book Online give wrong option?
> Thanks for suggestions.
> -Tom
>|||Hari,
Thanks so much. It works!
-Tom
>--Original Message--
>Hi,
>You can use either Control panel -- Administrative
tools -- Services --
>there you can select and start "SQL Agent" service.
>Otherwise from command prompt you can issue below command
to start the sql
>agent service.
>net start sqlagent
>Note:
>The above service name will be SQLagent$instance_name if
your sql server is
>a named instance.
>Thanks
>Hari
>MCDBA
>
>"Tom Torain" <TST_MC@.hotmail.com> wrote in message
>news:936801c3eac9$9df5e5d0$a301280a@.phx.gbl...
>> SQL Book Online lists command sqlagent.exe can start SQL
>> agent.
>> I tried to start sql agent by using sqlagent.exe from
>> command prompt. But get error:
>> "You must start SQLServerAgent as a service (using the
SQL
>> Server Service Manager)"
>> Does Book Online give wrong option?
>> Thanks for suggestions.
>> -Tom
>
>.
>
agent.
I tried to start sql agent by using sqlagent.exe from
command prompt. But get error:
"You must start SQLServerAgent as a service (using the SQL
Server Service Manager)"
Does Book Online give wrong option?
Thanks for suggestions.
-TomHi,
You can use either Control panel -- Administrative tools -- Services --
there you can select and start "SQL Agent" service.
Otherwise from command prompt you can issue below command to start the sql
agent service.
net start sqlagent
Note:
The above service name will be SQLagent$instance_name if your sql server is
a named instance.
Thanks
Hari
MCDBA
"Tom Torain" <TST_MC@.hotmail.com> wrote in message
news:936801c3eac9$9df5e5d0$a301280a@.phx.gbl...
> SQL Book Online lists command sqlagent.exe can start SQL
> agent.
> I tried to start sql agent by using sqlagent.exe from
> command prompt. But get error:
> "You must start SQLServerAgent as a service (using the SQL
> Server Service Manager)"
> Does Book Online give wrong option?
> Thanks for suggestions.
> -Tom
>|||Hari,
Thanks so much. It works!
-Tom
>--Original Message--
>Hi,
>You can use either Control panel -- Administrative
tools -- Services --
>there you can select and start "SQL Agent" service.
>Otherwise from command prompt you can issue below command
to start the sql
>agent service.
>net start sqlagent
>Note:
>The above service name will be SQLagent$instance_name if
your sql server is
>a named instance.
>Thanks
>Hari
>MCDBA
>
>"Tom Torain" <TST_MC@.hotmail.com> wrote in message
>news:936801c3eac9$9df5e5d0$a301280a@.phx.gbl...
>> SQL Book Online lists command sqlagent.exe can start SQL
>> agent.
>> I tried to start sql agent by using sqlagent.exe from
>> command prompt. But get error:
>> "You must start SQLServerAgent as a service (using the
SQL
>> Server Service Manager)"
>> Does Book Online give wrong option?
>> Thanks for suggestions.
>> -Tom
>
>.
>
Can not start SQL Agent
When I try to start SQL AGent I get the Following:
"An error 1722 (The RPC server is unavailable)"
Windows 2000, SQL 2000 sp3a.
The sql agent service is running.
Thanks
Dave.Make sure RPC services is running on the server but it may
be more likely that you have a problem with the permissions
set for the service account for SQL Agent. You can find the
required permissions in the following:
HOW TO: Change the SQL Server or SQL Server Agent Service
Account Without Using SQL Enterprise Manager in SQL Server
2000
http://support.microsoft.com/?id=283811
You can also find information on the permissions and service
accounts in books online under services accounts.
-Sue
On Fri, 24 Oct 2003 05:57:38 -0700, "David"
<anonymous@.discussions.microsoft.com> wrote:
>When I try to start SQL AGent I get the Following:
>"An error 1722 (The RPC server is unavailable)"
>Windows 2000, SQL 2000 sp3a.
>The sql agent service is running.
>Thanks
>Dave.
"An error 1722 (The RPC server is unavailable)"
Windows 2000, SQL 2000 sp3a.
The sql agent service is running.
Thanks
Dave.Make sure RPC services is running on the server but it may
be more likely that you have a problem with the permissions
set for the service account for SQL Agent. You can find the
required permissions in the following:
HOW TO: Change the SQL Server or SQL Server Agent Service
Account Without Using SQL Enterprise Manager in SQL Server
2000
http://support.microsoft.com/?id=283811
You can also find information on the permissions and service
accounts in books online under services accounts.
-Sue
On Fri, 24 Oct 2003 05:57:38 -0700, "David"
<anonymous@.discussions.microsoft.com> wrote:
>When I try to start SQL AGent I get the Following:
>"An error 1722 (The RPC server is unavailable)"
>Windows 2000, SQL 2000 sp3a.
>The sql agent service is running.
>Thanks
>Dave.
can not start sql agent
SQL Book Online lists command sqlagent.exe can start SQL
agent.
I tried to start sql agent by using sqlagent.exe from
command prompt. But get error:
"You must start SQLServerAgent as a service (using the SQL
Server Service Manager)"
Does Book Online give wrong option?
Thanks for suggestions.
-TomHi,
You can use either Control panel -- Administrative tools -- Services --
there you can select and start "SQL Agent" service.
Otherwise from command prompt you can issue below command to start the sql
agent service.
net start sqlagent
Note:
The above service name will be SQLagent$instance_name if your sql server is
a named instance.
Thanks
Hari
MCDBA
"Tom Torain" <TST_MC@.hotmail.com> wrote in message
news:936801c3eac9$9df5e5d0$a301280a@.phx.gbl...
Thanks so much. It works!
-Tom
tools -- Services --
to start the sql
your sql server is
agent.
I tried to start sql agent by using sqlagent.exe from
command prompt. But get error:
"You must start SQLServerAgent as a service (using the SQL
Server Service Manager)"
Does Book Online give wrong option?
Thanks for suggestions.
-TomHi,
You can use either Control panel -- Administrative tools -- Services --
there you can select and start "SQL Agent" service.
Otherwise from command prompt you can issue below command to start the sql
agent service.
net start sqlagent
Note:
The above service name will be SQLagent$instance_name if your sql server is
a named instance.
Thanks
Hari
MCDBA
"Tom Torain" <TST_MC@.hotmail.com> wrote in message
news:936801c3eac9$9df5e5d0$a301280a@.phx.gbl...
quote:|||Hari,
> SQL Book Online lists command sqlagent.exe can start SQL
> agent.
> I tried to start sql agent by using sqlagent.exe from
> command prompt. But get error:
> "You must start SQLServerAgent as a service (using the SQL
> Server Service Manager)"
> Does Book Online give wrong option?
> Thanks for suggestions.
> -Tom
>
Thanks so much. It works!
-Tom
quote:
>--Original Message--
>Hi,
>You can use either Control panel -- Administrative
tools -- Services --
quote:
>there you can select and start "SQL Agent" service.
>Otherwise from command prompt you can issue below command
to start the sql
quote:
>agent service.
>net start sqlagent
>Note:
>The above service name will be SQLagent$instance_name if
your sql server is
quote:
>a named instance.
>Thanks
>Hari
>MCDBA
>
>"Tom Torain" <TST_MC@.hotmail.com> wrote in message
>news:936801c3eac9$9df5e5d0$a301280a@.phx.gbl...
SQL[QUOTE]
>
>.
>
Can not see Filegroups in Backup Exec
Hi, I have MSDE2000 running on SBS2003 Standard with Backup Exec 9.1. As MSDE
is a new addition I have installed the SQL Agent for BEW however I can not
see the SQL Databases or filegroups under Selections in Backup Exec. I have
searched the Veritas KB plus the forums and have not found the answer... I
have set the checkbox in BEW /options/SQL to display the filegroups to no
avail. Is this a setting in SQL that I have missed?
Any thoughts would be great...
hi Johan,
Johan Strange wrote:
> Hi, I have MSDE2000 running on SBS2003 Standard with Backup Exec 9.1.
> As MSDE is a new addition I have installed the SQL Agent for BEW
> however I can not see the SQL Databases or filegroups under
> Selections in Backup Exec. I have searched the Veritas KB plus the
> forums and have not found the answer... I have set the checkbox in
> BEW /options/SQL to display the filegroups to no avail. Is this a
> setting in SQL that I have missed?
> Any thoughts would be great...
this is something you have to work with Veritas tech support or help file..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Hi , I have gone through the modrated forum and am at the stage where I am
going to pay for a support case ($85)... I will have to swallow this so I
want to post this to an MSDE forum incase anyone here has seen it before and
can suggest something that Veritas can not.
What you say is right, it is a Backup Exec issue that much is obvious.
Thanks
Johan
"Andrea Montanari" wrote:
> hi Johan,
> Johan Strange wrote:
> this is something you have to work with Veritas tech support or help file..
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
>
|||hi Johan,
Johan Strange wrote:
> Hi , I have gone through the modrated forum and am at the stage
> where I am going to pay for a support case ($85)... I will have to
> swallow this so I want to post this to an MSDE forum incase anyone
> here has seen it before and can suggest something that Veritas can
> not.
thank you...
in recent time it seems to happen very often...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
is a new addition I have installed the SQL Agent for BEW however I can not
see the SQL Databases or filegroups under Selections in Backup Exec. I have
searched the Veritas KB plus the forums and have not found the answer... I
have set the checkbox in BEW /options/SQL to display the filegroups to no
avail. Is this a setting in SQL that I have missed?
Any thoughts would be great...
hi Johan,
Johan Strange wrote:
> Hi, I have MSDE2000 running on SBS2003 Standard with Backup Exec 9.1.
> As MSDE is a new addition I have installed the SQL Agent for BEW
> however I can not see the SQL Databases or filegroups under
> Selections in Backup Exec. I have searched the Veritas KB plus the
> forums and have not found the answer... I have set the checkbox in
> BEW /options/SQL to display the filegroups to no avail. Is this a
> setting in SQL that I have missed?
> Any thoughts would be great...
this is something you have to work with Veritas tech support or help file..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Hi , I have gone through the modrated forum and am at the stage where I am
going to pay for a support case ($85)... I will have to swallow this so I
want to post this to an MSDE forum incase anyone here has seen it before and
can suggest something that Veritas can not.
What you say is right, it is a Backup Exec issue that much is obvious.
Thanks
Johan
"Andrea Montanari" wrote:
> hi Johan,
> Johan Strange wrote:
> this is something you have to work with Veritas tech support or help file..
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>
>
|||hi Johan,
Johan Strange wrote:
> Hi , I have gone through the modrated forum and am at the stage
> where I am going to pay for a support case ($85)... I will have to
> swallow this so I want to post this to an MSDE forum incase anyone
> here has seen it before and can suggest something that Veritas can
> not.
thank you...
in recent time it seems to happen very often...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.15.0 - DbaMgr ver 0.60.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
Subscribe to:
Posts (Atom)