Friday, March 9, 2012
error 1053 when I try to start SQLagent
on "system Log" The interface is unknown.
Hi,
I feel that Service startup account for SQL Agent do not have previlages in
registry. Can you add that user in Administarter group and try starting
the SQL agent service.
Verify, what is there in SQLAGENT.OUT file ?
Thanks
Hari
MCDBA
"Tom" <anonymous@.discussions.microsoft.com> wrote in message
news:19cb101c41cc2$1bc4ec20$a101280a@.phx.gbl...
> I also get and error of unable to complete the operation
> on "system Log" The interface is unknown.
error 1053 when I try to start SQLagent
not been started.
>--Original Message--
>I also get and error of unable to complete the operation
>on "system Log" The interface is unknown.
>.
>
Here is how I got around the problem, trying to put a program to run as a Service
in Windows:
How to setup the Morning Negotiation Tool(MNTOOL), so it will
Run as a Service in Windows 2003 Server.
1.) You must have the following programs, which you can find
in the Microsoft NT/2000 resource kit:
a.) srvany.exe.
b.) instsrv.exe.
2. Put the MNTOOL execution file in the directory D:\smt_tool as pass.exe.
3. Copy INSTSRV.EXE and SRVANY.EXE, on Windows 2003 Server, under
the directory C:\windows\.
4. Run "C:\Windows\INSTSRV MNTOOL C:\Windows\srvany.exe"
5. Using REGEDT32 find the following key:-
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Servic es\MNTOOL
6. Create a new key called "Parameters" , under MNTOOL.
7. Create a new REG_SZ value, under Parameters, called "Application" and give it
the value d:\smt_tool\pass.exe.
8. Run Control Panel, Services, find the MNTOOL service and change the Startup
settings for this service to log on account smt, which should have Administrator
permissions.
9. Start the MNTOOL service, from the Service menu, and it should remain
running. Do a Cntrl/Alt/Delete to get the TASK Manager ICON and make
sure it says that PASS.exe is running.
Note:
To delete the MNTOOL, from running as a service, you can use the following
DOS command, which is only available in Windows XP PRO and Windows
2003 Service software: “sc delete MNTOOL”
? NJC 4/08/2004
error 1053 when I try to start SQLagent
on "system Log" The interface is unknown.Hi,
I feel that Service startup account for SQL Agent do not have previlages in
registry. Can you add that user in Administarter group and try starting
the SQL agent service.
Verify, what is there in SQLAGENT.OUT file ?
Thanks
Hari
MCDBA
"Tom" <anonymous@.discussions.microsoft.com> wrote in message
news:19cb101c41cc2$1bc4ec20$a101280a@.phx.gbl...
> I also get and error of unable to complete the operation
> on "system Log" The interface is unknown.|||sqlagent.out => startup erroe: The event log service has
not been started.
>--Original Message--
>I also get and error of unable to complete the operation
>on "system Log" The interface is unknown.
>.
>|||Here is how I got around the problem, trying to put a program to run as a Servic
in Windows
How to setup the Morning Negotiation Tool(MNTOOL), so it wil
Run as a Service in Windows 2003 Server.
1.) You must have the following programs, which you can fin
in the Microsoft NT/2000 resource kit
a.) srvany.exe
b.) instsrv.exe
2. Put the MNTOOL execution file in the directory D:\smt_tool as pass.exe
3. Copy INSTSRV.EXE and SRVANY.EXE, on Windows 2003 Server, unde
the directory C:\windows\.
4. Run "C:\Windows\INSTSRV MNTOOL C:\Windows\srvany.exe"
5. Using REGEDT32 find the following key:-
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MNTOOL
6. Create a new key called "Parameters" , under MNTOOL
7. Create a new REG_SZ value, under Parameters, called "Application" and give i
the value d:\smt_tool\pass.exe.
8. Run Control Panel, Services, find the MNTOOL service and change the Startu
settings for this service to log on account smt, which should have Administrato
permissions
9. Start the MNTOOL service, from the Service menu, and it should remai
running. Do a Cntrl/Alt/Delete to get the TASK Manager ICON and mak
sure it says that PASS.exe is running
Note
To delete the MNTOOL, from running as a service, you can use the followin
DOS command, which is only available in Windows XP PRO and Window
2003 Service software: â'sc delete MNTOOLâ?
© NJC 4/08/200
error 1053 when I try to start SQLagent
not been started.
>--Original Message--
>I also get and error of unable to complete the operation
>on "system Log" The interface is unknown.
>.
>Here is how I got around the problem, trying to put a program to run as a Se
rvice
in Windows:
How to setup the Morning Negotiation Tool(MNTOOL), so it will
Run as a Service in Windows 2003 Server.
1.) You must have the following programs, which you can find
in the Microsoft NT/2000 resource kit:
a.) srvany.exe.
b.) instsrv.exe.
2. Put the MNTOOL execution file in the directory D:\smt_tool as pass.exe.
3. Copy INSTSRV.EXE and SRVANY.EXE, on Windows 2003 Server, under
the directory C:\windows\.
4. Run "C:\Windows\INSTSRV MNTOOL C:\Windows\srvany.exe"
5. Using REGEDT32 find the following key:-
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControl
Set\Services\MNTOOL
6. Create a new key called "Parameters" , under MNTOOL.
7. Create a new REG_SZ value, under Parameters, called "Application" and giv
e it
the value d:\smt_tool\pass.exe.
8. Run Control Panel, Services, find the MNTOOL service and change the Start
up
settings for this service to log on account smt, which should have Administr
ator
permissions.
9. Start the MNTOOL service, from the Service menu, and it should remain
running. Do a Cntrl/Alt/Delete to get the TASK Manager ICON and make
sure it says that PASS.exe is running.
Note:
To delete the MNTOOL, from running as a service, you can use the following
DOS command, which is only available in Windows XP PRO and Windows
2003 Service software: “sc delete MNTOOL”
? NJC 4/08/2004
error 1053 when I try to start SQLagent
on "system Log" The interface is unknown.Hi,
I feel that Service startup account for SQL Agent do not have previlages in
registry. Can you add that user in Administarter group and try starting
the SQL agent service.
Verify, what is there in SQLAGENT.OUT file ?
Thanks
Hari
MCDBA
"Tom" <anonymous@.discussions.microsoft.com> wrote in message
news:19cb101c41cc2$1bc4ec20$a101280a@.phx
.gbl...
> I also get and error of unable to complete the operation
> on "system Log" The interface is unknown.
Wednesday, March 7, 2012
Error [1,133,:] What does this mean
Hello,
on a WinCE5.0 device I run the following commands - (not complete):
DataSet oDS;
DataTable oDT=null;
// fill oDS from Web-Service ...
localhost.ODPService _wsTemp = _MAPD.GetWebService();
oDS = _wsTemp.GetAllZaehler();
string sConn = null;
//SqlCeEngine engine = null;
System.Data.SqlServerCe.SqlCeConnection oConn=null;
if (File.Exists(_MAPD.ExePfad + "MACOS_mo_db.sdf"))
{
sConn = "data source ='" + @._MAPD.ExePfad + "MACOS_mo_db.sdf'; mode=Exclusive; Password='xxxx'";
oConn = newSqlCeConnection(sConn);
if (oConn == null)
thrownewException("SQL-Connection zu " + @._MAPD.ExePfad + "MACOS_mo_db.sdf? konnte nicht erstellt werden!");
...
oConn.Open();
SqlCeCommand oCmd = newSqlCeCommand();
oCmd.Connection = oConn;
oCmd.CommandText = "DELETE from mo_OB_ZAEHLER";
oCmd.ExecuteNonQuery(); // This works !!
oCmd.Dispose();
oCmd = newSqlCeCommand();
oCmd.Connection = oConn;
string sStmt = "INSERT into mo_OB_ZAEHLER( OBJEKT_GUID, IDENT_NR, KURZ_TIT, OB_BEZ, EINHEIT, DATUM_ALT, STAND_ALT, ABGEHOLT, GESCHRIEBEN ) values ( :1, :2, :3, :4, :5, :6, :7, :8, :9 )";
oCmd.CommandText = sStmt;
oDT = oDS.Tables[0];
SqlCeParameter oP1 = newSqlCeParameter();
SqlCeParameter oP2 = newSqlCeParameter();
SqlCeParameter oP3 = newSqlCeParameter();
SqlCeParameter oP4 = newSqlCeParameter();
SqlCeParameter oP5 = newSqlCeParameter();
SqlCeParameter oP6 = newSqlCeParameter();
SqlCeParameter oP7 = newSqlCeParameter();
SqlCeParameter oP8 = newSqlCeParameter();
SqlCeParameter oP9 = newSqlCeParameter();
oP1.ParameterName = ":1";
oP2.ParameterName = ":2";
oP3.ParameterName = ":3";
oP4.ParameterName = ":4";
oP5.ParameterName = ":5";
oP6.ParameterName = ":6";
oP7.ParameterName = ":7";
oP8.ParameterName = ":8";
oP9.ParameterName = ":9";
oCmd.Parameters.Add(oP1);
oCmd.Parameters.Add(oP2);
oCmd.Parameters.Add(oP3);
oCmd.Parameters.Add(oP4);
oCmd.Parameters.Add(oP5);
oCmd.Parameters.Add(oP6);
oCmd.Parameters.Add(oP7);
oCmd.Parameters.Add(oP8);
oCmd.Parameters.Add(oP9);
DateTime oNow = newDateTime();
oNow = DateTime.Now;
for (int iRow = 0; iRow < oDT.Rows.Count; iRow++)
{
oCmd.Parameters[0].Value = oDT.Rows[iRow]["OBJEKT_GUID"];
oCmd.Parameters[1].Value = oDT.Rows[iRow]["IDENT_NR"];
oCmd.Parameters[2].Value = oDT.Rows[iRow]["KURZ_TIT"];
oCmd.Parameters[3].Value = oDT.Rows[iRow]["OB_BEZ"];
oCmd.Parameters[4].Value = oDT.Rows[iRow]["EINHEIT"];
oCmd.Parameters[5].Value = oDT.Rows[iRow]["DATUM_ALT"];
oCmd.Parameters.Value = oDT.Rows[iRow]["STAND_ALT"];
oCmd.Parameters[7].Value = oNow;
oCmd.Parameters.Value = (int)0;
oCmd.ExecuteNonQuery();
}
....
at oCmd.ExecuteNonQuery() - line after oCmd.Parameters.Value =... - an error with Message " [ 1,133,: ]" is thrown.
What does this mean?
Where can I find discription of error codes? Why is there no further text in the Exception object?
I checked the parameters set in oCmd and they seem to be correct.
Please help.
J?rg
The error indicates a SQL parsing error at character 133. Change your parameter names from :1 to @.1 (and so on).
For information on how to get detailed SQL CE error information, see: http://msdn2.microsoft.com/en-us/library/ms174079(SQL.90).aspx
Sunday, February 26, 2012
Error (re)installing Sql Server 2000
while reinstalling Sql server 2000 (after complete uninstall process),
system says:
"previous installation leaves suspended operations on files into computer.
It needs to be restarted before executing installation program."
Problem still remains , also after resterting pc many times, so i can't
reinstall Sql server 2000 cause there are no skip possibilities to this
dialog box.
I try to restore Ms Server 2003 Enterprise: the problem still remain...
Nicola BazziHi Nicola
Check out manually removing SQL Server at
http://support.microsoft.com/kb/290991 in particular the reference to your
error message.
John
"Nicola" wrote:
> Hi,
> while reinstalling Sql server 2000 (after complete uninstall process),
> system says:
> "previous installation leaves suspended operations on files into computer.
> It needs to be restarted before executing installation program."
> Problem still remains , also after resterting pc many times, so i can't
> reinstall Sql server 2000 cause there are no skip possibilities to this
> dialog box.
> I try to restore Ms Server 2003 Enterprise: the problem still remain...
> --
> Nicola Bazzi
Error (re)installing Sql Server 2000
while reinstalling Sql server 2000 (after complete uninstall process),
system says:
"previous installation leaves suspended operations on files into computer.
It needs to be restarted before executing installation program."
Problem still remains , also after resterting pc many times, so i can't
reinstall Sql server 2000 cause there are no skip possibilities to this
dialog box.
I try to restore Ms Server 2003 Enterprise: the problem still remain...
--
Nicola BazziHi Nicola
Check out manually removing SQL Server at
http://support.microsoft.com/kb/290991 in particular the reference to your
error message.
John
"Nicola" wrote:
> Hi,
> while reinstalling Sql server 2000 (after complete uninstall process),
> system says:
> "previous installation leaves suspended operations on files into computer.
> It needs to be restarted before executing installation program."
> Problem still remains , also after resterting pc many times, so i can't
> reinstall Sql server 2000 cause there are no skip possibilities to this
> dialog box.
> I try to restore Ms Server 2003 Enterprise: the problem still remain...
> --
> Nicola Bazzi