I just upgraded my desktop engine MSDE 1.0 to MSDE 2000 SP3a. Everything seemed to go well, MSSQLSERVER AND SQLSERVER Agent Services are running, problem is, I can no longer see the particular instance on the network from Enterprise Manager.
The installation instructions specified that if the Instance was to accept connections from applications on other computers not to specify the DISABLENETWORKPROTOCOLS parameter, so I didn't.
I'm a little green with this, can anyone suggest a place to start troubleshooting?Can you pull it up in Query Analyzer. Just type in (local) or whatever your instance name is for the connection server and see if it connects.
Showing posts with label mssqlserver. Show all posts
Showing posts with label mssqlserver. Show all posts
Wednesday, March 28, 2012
Wednesday, March 7, 2012
MSDE Installation
How do I set the SQLServerAgent service on automatically when I run the
installation? By default, the MSSQLServer service is set as automatic, but
the SQLServerAgent is Manual
hi Roy,
"Roy" <Roy@.discussions.microsoft.com> ha scritto nel messaggio
news:C42372B4-330B-4418-89E4-2F167D703AB8@.microsoft.com...
> How do I set the SQLServerAgent service on automatically when I run the
> installation? By default, the MSSQLServer service is set as automatic, but
> the SQLServerAgent is Manual
actually there's no way to set this at install time
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
installation? By default, the MSSQLServer service is set as automatic, but
the SQLServerAgent is Manual
hi Roy,
"Roy" <Roy@.discussions.microsoft.com> ha scritto nel messaggio
news:C42372B4-330B-4418-89E4-2F167D703AB8@.microsoft.com...
> How do I set the SQLServerAgent service on automatically when I run the
> installation? By default, the MSSQLServer service is set as automatic, but
> the SQLServerAgent is Manual
actually there's no way to set this at install time
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
MSDE install problems
hi ppl,
I get the following an error prompt/box pops up during
installation saying :
"Service 'MSSQLSERVER' (MSSQLSERVER) Could not be installed. Verify
that you have sufficient priviledge to install system services"
-cancel- -retry- -ignore- buttons, this has now happened 4 times
consistently.
Retry does not work, cancelling and ignore end the installation but theC:\Program Files\Microsoft SQL Server\... and subdir as well as
registry entries are created.
After this any re-install cancels (disappears) unless i manually
remove C:\Program Files\Microsoft SQL Server\ dirs and registry
entries. IF i do this then and try installing again then i get
"Service 'MSSQLSERVER' (MSSQLSERVER) Could not be installed. ..."
error again.
the parameters im using are:
BLANKSAPWD=1, REINSTALL=All , REINSTALLMODE=omus, disablerollback=1.
and switches:
/L*v MSDE_log.txt
i have attached log file.
Please help a stoopid newbie :(Please ignore this previous message, I seemed to have bypassed this old error, this old error only appeared when I don't specify an instance name.
When i do now specify one, then I get this error:
Starting custom action InstallPerfMon
Registering performance counters from sqlctr.ini
PerfmonLoad routine returned error code 267
Action ended 0:18:23: InstallFinalize. Return value 3.
I tried numerous things but the only stuff that works is when I make a C:\Program Files\Microsoft SQL Server\MSSQL\Binn directory and copy sqlctr.ini and sqlctr.h into it (which i poached from an install that didnt rollback).
But this results in the following error:
Starting custom action InstallSQLAgentSecurity
LoadLibrary failed for C:\Program Files\Microsoft SQL Server\Mssql\BinnMSSQL$DONALD007\Binn\SEMNT.DLL. GetLastError() returned: 126
Action ended 0:05:57: InstallFinalize. Return value 3.
Does anyone know how to solve this?
btw here are parameters
REINSTALL=All
REINSTALLMODE=omus
COLLATION=Latin1_General_CI_AS
TARGETDIR=C:\Program Files\Microsoft SQL Server\Mssql\Binn
DATADIR=C:\Program Files\Microsoft SQL Server\Mssql\Data
SAPWD=1111
INSTANCENAME=Donald007
This is a clean install of msde using sql service pack 3 on win xp pro.
I have attached a copy of my log file that is generated when this "LoadLibrary failed.." error occurs.
I also noticed that in the services i can still see a SQLSERVERAGENT even though this service is not started and the file it refers to has been deleted.
Originally posted by deekay2003
hi ppl,
I get the following an error prompt/box pops up during
installation saying :
"Service 'MSSQLSERVER' (MSSQLSERVER) Could not be installed. Verify
that you have sufficient priviledge to install system services"
-cancel- -retry- -ignore- buttons, this has now happened 4 times
consistently.
Retry does not work, cancelling and ignore end the installation but theC:\Program Files\Microsoft SQL Server\... and subdir as well as
registry entries are created.
After this any re-install cancels (disappears) unless i manually
remove C:\Program Files\Microsoft SQL Server\ dirs and registry
entries. IF i do this then and try installing again then i get
"Service 'MSSQLSERVER' (MSSQLSERVER) Could not be installed. ..."
error again.
the parameters im using are:
BLANKSAPWD=1, REINSTALL=All , REINSTALLMODE=omus, disablerollback=1.
and switches:
/L*v MSDE_log.txt
i have attached log file.
Please help a stoopid newbie :(
I get the following an error prompt/box pops up during
installation saying :
"Service 'MSSQLSERVER' (MSSQLSERVER) Could not be installed. Verify
that you have sufficient priviledge to install system services"
-cancel- -retry- -ignore- buttons, this has now happened 4 times
consistently.
Retry does not work, cancelling and ignore end the installation but theC:\Program Files\Microsoft SQL Server\... and subdir as well as
registry entries are created.
After this any re-install cancels (disappears) unless i manually
remove C:\Program Files\Microsoft SQL Server\ dirs and registry
entries. IF i do this then and try installing again then i get
"Service 'MSSQLSERVER' (MSSQLSERVER) Could not be installed. ..."
error again.
the parameters im using are:
BLANKSAPWD=1, REINSTALL=All , REINSTALLMODE=omus, disablerollback=1.
and switches:
/L*v MSDE_log.txt
i have attached log file.
Please help a stoopid newbie :(Please ignore this previous message, I seemed to have bypassed this old error, this old error only appeared when I don't specify an instance name.
When i do now specify one, then I get this error:
Starting custom action InstallPerfMon
Registering performance counters from sqlctr.ini
PerfmonLoad routine returned error code 267
Action ended 0:18:23: InstallFinalize. Return value 3.
I tried numerous things but the only stuff that works is when I make a C:\Program Files\Microsoft SQL Server\MSSQL\Binn directory and copy sqlctr.ini and sqlctr.h into it (which i poached from an install that didnt rollback).
But this results in the following error:
Starting custom action InstallSQLAgentSecurity
LoadLibrary failed for C:\Program Files\Microsoft SQL Server\Mssql\BinnMSSQL$DONALD007\Binn\SEMNT.DLL. GetLastError() returned: 126
Action ended 0:05:57: InstallFinalize. Return value 3.
Does anyone know how to solve this?
btw here are parameters
REINSTALL=All
REINSTALLMODE=omus
COLLATION=Latin1_General_CI_AS
TARGETDIR=C:\Program Files\Microsoft SQL Server\Mssql\Binn
DATADIR=C:\Program Files\Microsoft SQL Server\Mssql\Data
SAPWD=1111
INSTANCENAME=Donald007
This is a clean install of msde using sql service pack 3 on win xp pro.
I have attached a copy of my log file that is generated when this "LoadLibrary failed.." error occurs.
I also noticed that in the services i can still see a SQLSERVERAGENT even though this service is not started and the file it refers to has been deleted.
Originally posted by deekay2003
hi ppl,
I get the following an error prompt/box pops up during
installation saying :
"Service 'MSSQLSERVER' (MSSQLSERVER) Could not be installed. Verify
that you have sufficient priviledge to install system services"
-cancel- -retry- -ignore- buttons, this has now happened 4 times
consistently.
Retry does not work, cancelling and ignore end the installation but theC:\Program Files\Microsoft SQL Server\... and subdir as well as
registry entries are created.
After this any re-install cancels (disappears) unless i manually
remove C:\Program Files\Microsoft SQL Server\ dirs and registry
entries. IF i do this then and try installing again then i get
"Service 'MSSQLSERVER' (MSSQLSERVER) Could not be installed. ..."
error again.
the parameters im using are:
BLANKSAPWD=1, REINSTALL=All , REINSTALLMODE=omus, disablerollback=1.
and switches:
/L*v MSDE_log.txt
i have attached log file.
Please help a stoopid newbie :(
Monday, February 20, 2012
MSDE Error 70000
Hello, everyone
Can somebody clarify what type of ther error it is ?
Event Type: Information
Event Source: MSSQLSERVER
Event Category: (2)
Event ID: 17052
Date: 2/23/2006
Time: 3:01:03 PM
User: N/A
Computer: XXX
Description:
Error: 70000, Severity: 10, State: 1
Input buffer for processes 295: exec sp_XXX 1429, 0, 1475This is a multi-part message in MIME format.
--080606060502060508030601
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
System error numbers are up to 50000. So 70000 must be a user error
number assigned by the vendor/developer to some event. I don't think
there's anything anyone here can do to help you with that one, you need
to ask the vendor. Note, severity 10 is considered an informational
message only so perhaps it's nothing to be concerned about - once again,
ask the vendor (looks to me kind of like a debug statement - "this
(badly named) proc is being called with these parameters by this SPID").
--
*mike hodgson*
http://sqlnerd.blogspot.com
Djangar S. wrote:
>Hello, everyone
>Can somebody clarify what type of ther error it is ?
>Event Type: Information
>Event Source: MSSQLSERVER
>Event Category: (2)
>Event ID: 17052
>Date: 2/23/2006
>Time: 3:01:03 PM
>User: N/A
>Computer: XXX
>Description:
>Error: 70000, Severity: 10, State: 1
>Input buffer for processes 295: exec sp_XXX 1429, 0, 1475
>
>
--080606060502060508030601
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
<tt>System error numbers are up to 50000. So 70000 must be a user
error number assigned by the vendor/developer to some event. I don't
think there's anything anyone here can do to help you with that one,
you need to ask the vendor. Note, severity 10 is considered an
informational message only so perhaps it's nothing to be concerned
about - once again, ask the vendor (looks to me kind of like a debug
statement - "this (badly named) proc is being called with these
parameters by this SPID").</tt><br>
<div class="moz-signature">
<title></title>
<meta http-equiv="Content-Type" content="text/html; ">
<p><span lang="en-au"><font face="Tahoma" size="2">--<br>
</font></span> <b><span lang="en-au"><font face="Tahoma" size="2">mike
hodgson</font></span></b><span lang="en-au"><br>
<font face="Tahoma" size="2"><a href="http://links.10026.com/?link=http://sqlnerd.blogspot.com</a></font></span>">http://sqlnerd.blogspot.com">http://sqlnerd.blogspot.com</a></font></span>
</p>
</div>
<br>
<br>
Djangar S. wrote:
<blockquote cite="mid%23FuN0yMOGHA.2696@.TK2MSFTNGP14.phx.gbl"
type="cite">
<pre wrap="">Hello, everyone
Can somebody clarify what type of ther error it is ?
Event Type: Information
Event Source: MSSQLSERVER
Event Category: (2)
Event ID: 17052
Date: 2/23/2006
Time: 3:01:03 PM
User: N/A
Computer: XXX
Description:
Error: 70000, Severity: 10, State: 1
Input buffer for processes 295: exec sp_XXX 1429, 0, 1475
</pre>
</blockquote>
</body>
</html>
--080606060502060508030601--|||This is a multi-part message in MIME format.
--=_NextPart_000_0014_01C63933.5F319C80
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Thanks, Mike
"Mike Hodgson" <e1minst3r@.gmail.com> wrote in message =news:e%23a99$NOGHA.532@.TK2MSFTNGP15.phx.gbl...
System error numbers are up to 50000. So 70000 must be a user error =number assigned by the vendor/developer to some event. I don't think =there's anything anyone here can do to help you with that one, you need =to ask the vendor. Note, severity 10 is considered an informational =message only so perhaps it's nothing to be concerned about - once again, =ask the vendor (looks to me kind of like a debug statement - "this =(badly named) proc is being called with these parameters by this SPID").
--
mike hodgson
http://sqlnerd.blogspot.com=20
Djangar S. wrote: Hello, everyone
Can somebody clarify what type of ther error it is ?
Event Type: Information
Event Source: MSSQLSERVER
Event Category: (2)
Event ID: 17052
Date: 2/23/2006
Time: 3:01:03 PM
User: N/A
Computer: XXX
Description:
Error: 70000, Severity: 10, State: 1
Input buffer for processes 295: exec sp_XXX 1429, 0, 1475
--=_NextPart_000_0014_01C63933.5F319C80
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
Thanks, Mike
"Mike Hodgson" wrote =in message news:e%23a99$NOGHA.5=32@.TK2MSFTNGP15.phx.gbl...System error numbers are up to 50000. So 70000 must be a user error =number assigned by the vendor/developer to some event. I don't think =there's anything anyone here can do to help you with that one, you need to ask =the vendor. Note, severity 10 is considered an informational message =only so perhaps it's nothing to be concerned about - once again, ask the =vendor (looks to me kind of like a debug statement - "this (badly named) proc is =being called with these parameters by this SPID").
--mike =hodgsonhttp://sqlnerd.blogspot.com Djangar S. wrote: Hello, everyone
Can somebody clarify what type of ther error it is ?
Event Type: Information
Event Source: MSSQLSERVER
Event Category: (2)
Event ID: 17052
Date: 2/23/2006
Time: 3:01:03 PM
User: N/A
Computer: XXX
Description:
Error: 70000, Severity: 10, State: 1
Input buffer for processes 295: exec sp_XXX 1429, 0, 1475
--=_NextPart_000_0014_01C63933.5F319C80--
Can somebody clarify what type of ther error it is ?
Event Type: Information
Event Source: MSSQLSERVER
Event Category: (2)
Event ID: 17052
Date: 2/23/2006
Time: 3:01:03 PM
User: N/A
Computer: XXX
Description:
Error: 70000, Severity: 10, State: 1
Input buffer for processes 295: exec sp_XXX 1429, 0, 1475This is a multi-part message in MIME format.
--080606060502060508030601
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
System error numbers are up to 50000. So 70000 must be a user error
number assigned by the vendor/developer to some event. I don't think
there's anything anyone here can do to help you with that one, you need
to ask the vendor. Note, severity 10 is considered an informational
message only so perhaps it's nothing to be concerned about - once again,
ask the vendor (looks to me kind of like a debug statement - "this
(badly named) proc is being called with these parameters by this SPID").
--
*mike hodgson*
http://sqlnerd.blogspot.com
Djangar S. wrote:
>Hello, everyone
>Can somebody clarify what type of ther error it is ?
>Event Type: Information
>Event Source: MSSQLSERVER
>Event Category: (2)
>Event ID: 17052
>Date: 2/23/2006
>Time: 3:01:03 PM
>User: N/A
>Computer: XXX
>Description:
>Error: 70000, Severity: 10, State: 1
>Input buffer for processes 295: exec sp_XXX 1429, 0, 1475
>
>
--080606060502060508030601
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html;charset=ISO-8859-1" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
<tt>System error numbers are up to 50000. So 70000 must be a user
error number assigned by the vendor/developer to some event. I don't
think there's anything anyone here can do to help you with that one,
you need to ask the vendor. Note, severity 10 is considered an
informational message only so perhaps it's nothing to be concerned
about - once again, ask the vendor (looks to me kind of like a debug
statement - "this (badly named) proc is being called with these
parameters by this SPID").</tt><br>
<div class="moz-signature">
<title></title>
<meta http-equiv="Content-Type" content="text/html; ">
<p><span lang="en-au"><font face="Tahoma" size="2">--<br>
</font></span> <b><span lang="en-au"><font face="Tahoma" size="2">mike
hodgson</font></span></b><span lang="en-au"><br>
<font face="Tahoma" size="2"><a href="http://links.10026.com/?link=http://sqlnerd.blogspot.com</a></font></span>">http://sqlnerd.blogspot.com">http://sqlnerd.blogspot.com</a></font></span>
</p>
</div>
<br>
<br>
Djangar S. wrote:
<blockquote cite="mid%23FuN0yMOGHA.2696@.TK2MSFTNGP14.phx.gbl"
type="cite">
<pre wrap="">Hello, everyone
Can somebody clarify what type of ther error it is ?
Event Type: Information
Event Source: MSSQLSERVER
Event Category: (2)
Event ID: 17052
Date: 2/23/2006
Time: 3:01:03 PM
User: N/A
Computer: XXX
Description:
Error: 70000, Severity: 10, State: 1
Input buffer for processes 295: exec sp_XXX 1429, 0, 1475
</pre>
</blockquote>
</body>
</html>
--080606060502060508030601--|||This is a multi-part message in MIME format.
--=_NextPart_000_0014_01C63933.5F319C80
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Thanks, Mike
"Mike Hodgson" <e1minst3r@.gmail.com> wrote in message =news:e%23a99$NOGHA.532@.TK2MSFTNGP15.phx.gbl...
System error numbers are up to 50000. So 70000 must be a user error =number assigned by the vendor/developer to some event. I don't think =there's anything anyone here can do to help you with that one, you need =to ask the vendor. Note, severity 10 is considered an informational =message only so perhaps it's nothing to be concerned about - once again, =ask the vendor (looks to me kind of like a debug statement - "this =(badly named) proc is being called with these parameters by this SPID").
--
mike hodgson
http://sqlnerd.blogspot.com=20
Djangar S. wrote: Hello, everyone
Can somebody clarify what type of ther error it is ?
Event Type: Information
Event Source: MSSQLSERVER
Event Category: (2)
Event ID: 17052
Date: 2/23/2006
Time: 3:01:03 PM
User: N/A
Computer: XXX
Description:
Error: 70000, Severity: 10, State: 1
Input buffer for processes 295: exec sp_XXX 1429, 0, 1475
--=_NextPart_000_0014_01C63933.5F319C80
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&
Thanks, Mike
"Mike Hodgson"
--mike =hodgsonhttp://sqlnerd.blogspot.com Djangar S. wrote: Hello, everyone
Can somebody clarify what type of ther error it is ?
Event Type: Information
Event Source: MSSQLSERVER
Event Category: (2)
Event ID: 17052
Date: 2/23/2006
Time: 3:01:03 PM
User: N/A
Computer: XXX
Description:
Error: 70000, Severity: 10, State: 1
Input buffer for processes 295: exec sp_XXX 1429, 0, 1475
--=_NextPart_000_0014_01C63933.5F319C80--
Subscribe to:
Posts (Atom)