MSDE SQL Agent Wont Start

Hi,
I have installed the MSDE and use mixed mode authenticaton.
The SQL Server Agent will not start due to login failures.
Normally, I would use the Enterprise Manager Managment wizard to
correct the System Account and Connection Credentials.

Can anyone tell me how to achieve this using OSQL?

Thanksthat'll be a long and very painful road...are you sure you want to go there?|||The other way to fix the SQLAgent account is through Windows Control Panel. You need "Services", one way to get to it is: Control Panel -> Administrative Tools -> Computer Management ... Services and Applications .. Services. There you can change the Properties of MSSQLAgent .|||Originally posted by ms_sql_dba
that'll be a long and very painful road...are you sure you want to go there?

We essentially have 2 systems in place. One system is a full blown installation of SQL Server 2000 (standard edition) on a server pc running windows 2000 server. This implementation includes the enterprise manager and query analyzer etc.

The second system (due to cost concern) uses MSDE with the same database and files. We do this so we can run our control system on a windows 2000 professional OS and hence keep the costs down.

I have no problem getting the SQLAgent running on a full system because I have the enterprise manager and its wizards to configure security and credentials for it. On the MSDE win2000 pro setup I do not have the tools and hence am forced to manipulate the configuration via OSQL - I will try using the control panel and services to configure it, but I am looking for a way to send the configuration via an OSQL (T-SQL script) that sets the services security to system account (Administrator) and the database login security to the SA account.

Thanks again|||Originally posted by ClayG
The other way to fix the SQLAgent account is through Windows Control Panel. You need "Services", one way to get to it is: Control Panel -> Administrative Tools -> Computer Management ... Services and Applications .. Services. There you can change the Properties of MSSQLAgent .

If I go to Administrative tools and services under SQLSERVERAGENT and properties, I can configure the security under the LOG ON tab to Local System Account. I have done this to no avail. I believe the problem exists with the fact that I use mixed mode authentication for SQL Server 2000. Using the Management Wizard under the Connection Tab, I need to specify the log in to the SQL database instance under the SA account with its respective password.
The service properties do not provide a means of specifying the credentials for the SQL Server Instance and database connection.

Regards and Thanks|||Enterprise manager should be able to talk to an MSDE instance. Is the MSDE instance not available to you, so you need to write a script?|||Originally posted by MCrowley
Enterprise manager should be able to talk to an MSDE instance. Is the MSDE instance not available to you, so you need to write a script?

Enterprise Manager is not installed- Since we are using Windows 2000 professional for this machine - which is stand alone and a completely different project. We chose to install MSDE with our standard database loaded in. I have no tools on the machine like enterprise manager to fix the issues. I need a means of deploying the security when no tools exist.

I did a search and found the following on a google group search - to which my response was as follows:

Good Afternoon,

I found your email through google_groups where you indicated the following to a user:
SQLServerAgent needs to be able to connect to SQL Server upon starting. See any errors in the sqlagent.out file. When you look in the Logins folder in Enterprise Manager, the BUILTIN\Administrators group must be granted access to the server. If the group has been removed or denied access, SQLServerAgent won't start
Sade Fashokun
SQL Server Support

My question if you don't mind answering it is as follows:

I am using MSDE on a windows 2000 professional OS installation with a default instance. SQL Server Agent will not start with the following error in the log:
Login Failed for User 'SCADA\Administrator' --

I am using mixed mode authentication and normally I would use the management wizard in Enterprise Manager under the Connection Tab to specify the SQL Agent Login
as the SA account and respective password. I do not want the Agent to Attempt a login through the windows Adminstrator account but instead through the SA or
other Database Security account.

Can you tell me how to change the Agent using OSQL etc. as I do not have the enterprise manager with MSDE -- to force it to use the SA account for the Sql Server Instance instead of the Window System Account the same as I would using the Management Wizard.|||You stated you have a full-blown installation of SQL Server (including tools). Just register your MSDE instance in the Enterprise Manager on that system. All you need is a network connection between the two boxes.|||Originally posted by MCrowley
You stated you have a full-blown installation of SQL Server (including tools). Just register your MSDE instance in the Enterprise Manager on that system. All you need is a network connection between the two boxes.

Okay, I understand that, I will try it out.
However, assume that I do not have such a system.
Is there a way to accomplish it without making such a connection
altering the login information for the agent via osql.

MSDE Sp3 client connection

Which mode are you authenticating with NT or SQL Server ?
The defaut MSDE mode is NT Authentication, which may cuase
connectivity issues.
MarkI am using mix mode. The problem has been solvoed now...
It is because of firewall... problem of our ISP.
Met vriendelijke groet,
Guoqi Zheng
Tel: +31 (0) 23 5343545
http://www.meetholland.com
"Mark Story" <anonymous@.discussions.microsoft.com> д?
:04c001c3d07e$09fda3a0$a601280a@.phx.gbl...

quote:

---

> Which mode are you authenticating with NT or SQL Server ?
> The defaut MSDE mode is NT Authentication, which may cuase
> connectivity issues.
> Mark

---

msde security - windows mode?

Hi,
I want to be able to use SQL authentication on my local MSDE 2000 , I've
added a user using sp_addlogin, and try to connect using it, however it
always gives me 'not associated with a trusted SQL server connection'. Is
there any way I can force it to go to SQL mode without reinstalling it?
Thanks> I want to be able to use SQL authentication on my local MSDE 2000 , I've
> added a user using sp_addlogin, and try to connect using it, however it
> always gives me 'not associated with a trusted SQL server connection'. Is
> there any way I can force it to go to SQL mode without reinstalling it?
Yes - check the article at http://support.microsoft.com/kb/285097/EN-US/.
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com|||> I want to be able to use SQL authentication on my local MSDE 2000 , I've
> added a user using sp_addlogin, and try to connect using it, however it
> always gives me 'not associated with a trusted SQL server connection'. Is
> there any way I can force it to go to SQL mode without reinstalling it?
Look at my answer in .security group.
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com

MSDE Running on Two Computers in Workgroup Mode

I have two PC running Windows XP Pro in Workgroup Mode. They both in mixed
authentication mode with blank sa password.
The usernames on each machine are the same and they have no password.
The problem I have is with merge replication. The replication fails with the
message "Login failed for user 'sa'. Reason: Not associated with a trusted
SQL Server connection."
Both computers use the local system account to start the SQL server agent.
If we connect manually to the database via ADO using the sa with blank
password we have no difficulties.
Can someone please advise where I am going wrong.
Thank you in advance.
Colin
Hi ,
There are a number of reasons why this error may occur:
Try using these steps:
1) Most probably you may not be able to logon on to the sql server using
windows authentication.
2) Try using windows authentication over named pipes instead fo tcp/ip to
connect to the sql server.
Make sure that you make use of an alias to do the task
This should fix the problem.
Girish Sundaram
This posting is provided "AS IS" with no warranties, and confers no rights.

MSDE login problem

After installing MSDE 2000 in mixed mode local access worked fine.
Accessing through network with enterprice manager at first didn't work.
Fixed by activating network protocols "TCP/IP" and "Named pipes" in database properties.
But only the first time. After that login by SQL user and password is denied after restart local MSDE machine.

Anyone know why?

thanks in advanceAfter that login by SQL user and password is denied after restart local MSDE machine

With this I mean access from other machines on the network. Local login is working ok.|||Solution found!

Install MSDE again with DISABLENETWORKPROTOCOLS=0.
Changing it afterwards with SQL Server enterprice manager doesn't work.

just for those who are having the same problem

MSDE installation without reboot

Hi all, I'm trying to install MSDE in silent mode and without using a .ini file (on a machine with windows 2000 server and SQL 2000 already insatalled).
At the end of the installation, the machine reboot automatically, but I need to stop this reboot to register some information and then reboot the machine.
Someone can help me?
Thanks all
Its something like 'REBOOT=REALLY_SUPPRESS'. Not sure about the spelling.
Its not documented in the SQL install but may be on MS site somewhere.
"A@.Rome" wrote:

> Hi all, I'm trying to install MSDE in silent mode and without using a .ini file (on a machine with windows 2000 server and SQL 2000 already insatalled).
> At the end of the installation, the machine reboot automatically, but I need to stop this reboot to register some information and then reboot the machine.
> Someone can help me?
> Thanks all
|||Thank you very much Jon, I'll try to look for that
"Jon Bishop" wrote:
[vbcol=seagreen]
> Its something like 'REBOOT=REALLY_SUPPRESS'. Not sure about the spelling.
> Its not documented in the SQL install but may be on MS site somewhere.
> "A@.Rome" wrote:
|||Jon, you're right. The exact spelling is 'reboot=reallysuppress' and it's the
option that REALLY suppress the reboot
Here it is the link to the research I've done restricted to the microsoft
support site:
http://www.google.com/search?hl=en&l...ally suppress
thank you so much, Andrew @. Rome
"Jon Bishop" wrote:
[vbcol=seagreen]
> Its something like 'REBOOT=REALLY_SUPPRESS'. Not sure about the spelling.
> Its not documented in the SQL install but may be on MS site somewhere.
> "A@.Rome" wrote:

MSDE HELP

Hi,
I have 2 PCs that aren't in any domain.
One of PCs, have installed on MSDE. I change the authentication
mode from windows to mixed mode.
Created users inside MSDE.
In the PC with MSDE I can enter with all users, but in the other PC I could
not connect to the server.
I tried to register in Enterprise Manager that MSDE instalation and I get
the following error
SQL Server Enterprise Manager
SQL Server registration failed because of the connection failure displayed
below. Do you wish to Register anyway?
SQL Server does not exist or access denied.
ConnectionOpen (Connect())
Yes No
I already add the TCP 1433 and UDP 1434 ports to windows firewal, I tried to
with the firewall disconected and i get always the same error.
So I think the problem could be in permissions, but how can I set permisons
in one computer to a user from another computer. Don't forget that the pcs
aren't in any domain.
Or how can I put on PC connecting to the MSDE in the other PC?
thanks
Mestre
hi Mestre,
Mestre wrote:
> Hi,
> I have 2 PCs that aren't in any domain.
> One of PCs, have installed on MSDE. I change the authentication
> mode from windows to mixed mode.
> Created users inside MSDE.
> In the PC with MSDE I can enter with all users, but in the other PC I
> could not connect to the server.
> I tried to register in Enterprise Manager that MSDE instalation and I
> get the following error
> --
> SQL Server Enterprise Manager
> --
> SQL Server registration failed because of the connection failure
> displayed below. Do you wish to Register anyway?
> SQL Server does not exist or access denied.
> ConnectionOpen (Connect())
> --
> Yes No
> --
>
> I already add the TCP 1433 and UDP 1434 ports to windows firewal, I
> tried to with the firewall disconected and i get always the same
> error.
> So I think the problem could be in permissions, but how can I set
> permisons in one computer to a user from another computer. Don't
> forget that the pcs aren't in any domain.
> Or how can I put on PC connecting to the MSDE in the other PC?
please have a look at
http://support.microsoft.com/default...06&Product=sql
for the most common causes of this exception.. and of course please verify
that remote access to the instance is enabled with the Server Network
Utility (svrnetcn.exe) as MSDE installs by default disabling all network
protocols...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.16.0 - DbaMgr ver 0.61.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Andrea,
you're right. I discover that, but I ony have time to update the posts
today.
Thanks,
Mestre
"Andrea Montanari" <andrea.sqlDMO@.virgilio.it> wrote in message
news:4271egF1hrbv5U1@.individual.net...
> hi Mestre,
> Mestre wrote:
> please have a look at
> http://support.microsoft.com/default...06&Product=sql
> for the most common causes of this exception.. and of course please verify
> that remote access to the instance is enabled with the Server Network
> Utility (svrnetcn.exe) as MSDE installs by default disabling all network
> protocols...
> --
> Andrea Montanari (Microsoft MVP - SQL Server)
> http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
> DbaMgr2k ver 0.16.0 - DbaMgr ver 0.61.0
> (my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
> interface)
> -- remove DMO to reply
>

MSDE Fails to install on Win2k Server (Application Server Mode)

Am trying to install the latest version of MSDE on a Windows 2000 (SP3) server running in Application Server Mode. Installation almost completes then stops and rolls back without warning or error message. Can't find a reason for this and previously posted solutions (e.g. install latest MDAC) don't seem to work. So off to the forums for help....what am I missing? The verbose log is attached (as it is too long).Did you modify the log at all ?|||Originally posted by rnealejr
Did you modify the log at all ?

What you see is what I got....however last night while doing some work from home I discovered the answer I was looking for in MS KB317268 - in a nutshell you have to install it from the console and can't install it as admin from a terminal session...don't know why - but it sure is a royal pain....