Tried to install security patch ms03-031 on sql2k sp3
server, but got message said that there is no valid
instance for the patch. Anyone else had this problem?I would first run Select @.@.version from Query Analyzer to verify that the
version is 2000.8.00.760 (SP3)
Rand
This posting is provided "as is" with no warranties and confers no rights.|||Thanks for the response, Rand.
Yes, I did that and even tried to reapply sp3 but still
can't install that patch with same message. Any other
reasons?
>--Original Message--
>I would first run Select @.@.version from Query Analyzer to
verify that the
>version is 2000.8.00.760 (SP3)
>Rand
>This posting is provided "as is" with no warranties and
confers no rights.
>.
>|||Check the registry for the version number.
HKLM\Software\Microsoft\MSSQLServer\MSSQLServer\CurrentVersion\CSDVersion.
Make sure it also say 8.00.760
Rand.
This posting is provided "as is" with no warranties and confers no rights.|||Thanks for the response, Rand. That was first thing I do
and it returned correct result. I even tried reapply sp3
but still got message said that can't find instance for
the patch. Any other reasons?
>--Original Message--
>I would first run Select @.@.version from Query Analyzer to
verify that the
>version is 2000.8.00.760 (SP3)
>Rand
>This posting is provided "as is" with no warranties and
confers no rights.
>.
>|||It says 8.00.534, I changed it to 8.00.760 but still
doesn't let me apply the patch.
>--Original Message--
>Check the registry for the version number.
>HKLM\Software\Microsoft\MSSQLServer\MSSQLServer\CurrentVer
sion\CSDVersion.
>Make sure it also say 8.00.760
>Rand.
>This posting is provided "as is" with no warranties and
confers no rights.
>.
>
Showing posts with label message. Show all posts
Showing posts with label message. Show all posts
Friday, March 30, 2012
Wednesday, March 28, 2012
Install problem
I'am trying to install MSDE Rel A but when installer starts to extract files
to installation folder i get error message saying i don't have enough space
on hard disk.
Disk is 40GB anf there's 28GB free space left...
-mikko
Try running CHKDSK on the drive you are having the problem with. Also, what
OS and file system are you running?
Jim
"Jeter" <ei@.oo.ei> wrote in message
news:ODdmFxcFFHA.1348@.TK2MSFTNGP14.phx.gbl...
> I'am trying to install MSDE Rel A but when installer starts to extract
> files
> to installation folder i get error message saying i don't have enough
> space
> on hard disk.
> Disk is 40GB anf there's 28GB free space left...
> -mikko
>
to installation folder i get error message saying i don't have enough space
on hard disk.
Disk is 40GB anf there's 28GB free space left...
-mikko
Try running CHKDSK on the drive you are having the problem with. Also, what
OS and file system are you running?
Jim
"Jeter" <ei@.oo.ei> wrote in message
news:ODdmFxcFFHA.1348@.TK2MSFTNGP14.phx.gbl...
> I'am trying to install MSDE Rel A but when installer starts to extract
> files
> to installation folder i get error message saying i don't have enough
> space
> on hard disk.
> Disk is 40GB anf there's 28GB free space left...
> -mikko
>
Friday, March 23, 2012
Install fails on SQL Express (part of setup for Accounting Express 2007)
Am running vista premium and am trying to complete the installation of Office 2007 Professional (disc 2) and keep getting an error message that SQL Service 2005 (Express) cannot install. Logfile below:
Microsoft SQL Server 2005 9.00.3042.00
==============================
OS Version : Home Edition (Build 6000)
Time : Sun Mar 04 15:25:13 2007
Machine : MICHAELTODD-PC
Product : Microsoft SQL Server Setup Support Files (English)
Product Version : 9.00.3042.00
Install : Successful
Log File : c:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0008_MICHAELTODD-PC_SQLSupport_1.log
--
Machine : MICHAELTODD-PC
Product : Microsoft SQL Server Native Client
Product Version : 9.00.3042.00
Install : Successful
Log File : c:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0008_MICHAELTODD-PC_SQLNCLI_1.log
--
Machine : MICHAELTODD-PC
Product : Microsoft SQL Server VSS Writer
Product Version : 9.00.3042.00
Install : Successful
Log File : c:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0008_MICHAELTODD-PC_SqlWriter_1.log
--
Machine : MICHAELTODD-PC
Product : SQL Server Database Services
Error : SQL Server Setup Failed to compile the Managed Object Format (MOF) file c:\Program Files\Microsoft SQL Server\90\Shared\sqlmgmproviderxpsp2up.mof. To proceed, see "Troubleshooting an Installation of SQL Server 2005" or "How to: View SQL Server 2005 Setup Log Files" in SQL Server 2005 Setup Help documentation.
--
Machine : MICHAELTODD-PC
Product : SQL Server Database Services
Error : SQL Server Setup Failed to compile the Managed Object Format (MOF) file c:\Program Files\Microsoft SQL Server\90\Shared\sqlmgmproviderxpsp2up.mof. To proceed, see "Troubleshooting an Installation of SQL Server 2005" or "How to: View SQL Server 2005 Setup Log Files" in SQL Server 2005 Setup Help documentation.
--
Machine : MICHAELTODD-PC
Product : Microsoft SQL Server 2005 Express Edition
Product Version : 9.1.2047.00
Install : Failed
Log File : c:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0008_MICHAELTODD-PC_SQL.log
Last Action : InstallFinalize
Error String : SQL Server Setup Failed to compile the Managed Object Format (MOF) file c:\Program Files\Microsoft SQL Server\90\Shared\sqlmgmproviderxpsp2up.mof. To proceed, see "Troubleshooting an Installation of SQL Server 2005" or "How to: View SQL Server 2005 Setup Log Files" in SQL Server 2005 Setup Help documentation.
Error Number : 29513
--
SQL Server Setup failed. For more information, review the Setup log file in %ProgramFiles%\Microsoft SQL Server\90\Setup Bootstrap\LOG\Summary.txt.
Time : Sun Mar 04 15:27:03 2007
List of log files:
c:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0008_MICHAELTODD-PC_Core(Patched).log
c:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0008_MICHAELTODD-PC_SQLSupport_1.log
c:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0008_MICHAELTODD-PC_SQLNCLI_1.log
c:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0008_MICHAELTODD-PC_SqlWriter_1.log
c:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0008_MICHAELTODD-PC_SQL.log
c:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0008_MICHAELTODD-PC_Datastore.xml
c:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0008_MICHAELTODD-PC_.NET Framework 2.0.log
c:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0008_MICHAELTODD-PC_Support.log
c:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0008_MICHAELTODD-PC_Core.log
c:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Summary.txt
c:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0008_MICHAELTODD-PC_SCC.log
This is probably caused by a corruption in WMI in your Windows Server. Try reinstalling WMI. There's information on how to do this at: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/wmisdk/wmi/reinstalling_wmi.asp
Michelle
|||That link doesn't go to a working page..?|||Well I can't seem to find the original article but here is a couple of things to try.
Can you run “winmgmt /verifyrepository”? If this returns “ WMI repository is inconsistent” then you will have to rebuild the repository. You can rebuild it using “winmgmt /salvagerepository”.
Michelle
|||Thank you, Michelle.
I am having the same problem trying to install Accounting Express 2007 on my new Vista Ultimate machine.
The machine already has SQL Express loaded. Management Server Express works.
"winmgmt /verifyrepository" runs and says repository is inconsistent...
"winmgmt /salvagerepository" runs and produces:
WMI repository salvage failed
Error code: 0x8007041B
Facility: Win32
Description: A stop control has been sent to a service that other running services are dependent on.
Check out the following post it has a solution.
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1094559&SiteID=1
Michelle
sqlInstall fails on SQL Express (part of setup for Accounting Express 2007)
Am running vista premium and am trying to complete the installation of Office 2007 Professional (disc 2) and keep getting an error message that SQL Service 2005 (Express) cannot install. Logfile below:
Microsoft SQL Server 2005 9.00.3042.00
==============================
OS Version : Home Edition (Build 6000)
Time : Sun Mar 04 15:25:13 2007
Machine : MICHAELTODD-PC
Product : Microsoft SQL Server Setup Support Files (English)
Product Version : 9.00.3042.00
Install : Successful
Log File : c:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0008_MICHAELTODD-PC_SQLSupport_1.log
--
Machine : MICHAELTODD-PC
Product : Microsoft SQL Server Native Client
Product Version : 9.00.3042.00
Install : Successful
Log File : c:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0008_MICHAELTODD-PC_SQLNCLI_1.log
--
Machine : MICHAELTODD-PC
Product : Microsoft SQL Server VSS Writer
Product Version : 9.00.3042.00
Install : Successful
Log File : c:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0008_MICHAELTODD-PC_SqlWriter_1.log
--
Machine : MICHAELTODD-PC
Product : SQL Server Database Services
Error : SQL Server Setup Failed to compile the Managed Object Format (MOF) file c:\Program Files\Microsoft SQL Server\90\Shared\sqlmgmproviderxpsp2up.mof. To proceed, see "Troubleshooting an Installation of SQL Server 2005" or "How to: View SQL Server 2005 Setup Log Files" in SQL Server 2005 Setup Help documentation.
--
Machine : MICHAELTODD-PC
Product : SQL Server Database Services
Error : SQL Server Setup Failed to compile the Managed Object Format (MOF) file c:\Program Files\Microsoft SQL Server\90\Shared\sqlmgmproviderxpsp2up.mof. To proceed, see "Troubleshooting an Installation of SQL Server 2005" or "How to: View SQL Server 2005 Setup Log Files" in SQL Server 2005 Setup Help documentation.
--
Machine : MICHAELTODD-PC
Product : Microsoft SQL Server 2005 Express Edition
Product Version : 9.1.2047.00
Install : Failed
Log File : c:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0008_MICHAELTODD-PC_SQL.log
Last Action : InstallFinalize
Error String : SQL Server Setup Failed to compile the Managed Object Format (MOF) file c:\Program Files\Microsoft SQL Server\90\Shared\sqlmgmproviderxpsp2up.mof. To proceed, see "Troubleshooting an Installation of SQL Server 2005" or "How to: View SQL Server 2005 Setup Log Files" in SQL Server 2005 Setup Help documentation.
Error Number : 29513
--
SQL Server Setup failed. For more information, review the Setup log file in %ProgramFiles%\Microsoft SQL Server\90\Setup Bootstrap\LOG\Summary.txt.
Time : Sun Mar 04 15:27:03 2007
List of log files:
c:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0008_MICHAELTODD-PC_Core(Patched).log
c:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0008_MICHAELTODD-PC_SQLSupport_1.log
c:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0008_MICHAELTODD-PC_SQLNCLI_1.log
c:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0008_MICHAELTODD-PC_SqlWriter_1.log
c:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0008_MICHAELTODD-PC_SQL.log
c:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0008_MICHAELTODD-PC_Datastore.xml
c:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0008_MICHAELTODD-PC_.NET Framework 2.0.log
c:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0008_MICHAELTODD-PC_Support.log
c:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0008_MICHAELTODD-PC_Core.log
c:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Summary.txt
c:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0008_MICHAELTODD-PC_SCC.log
This is probably caused by a corruption in WMI in your Windows Server. Try reinstalling WMI. There's information on how to do this at: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/wmisdk/wmi/reinstalling_wmi.asp
Michelle
|||That link doesn't go to a working page..?|||Well I can't seem to find the original article but here is a couple of things to try.
Can you run “winmgmt /verifyrepository”? If this returns “ WMI repository is inconsistent” then you will have to rebuild the repository. You can rebuild it using “winmgmt /salvagerepository”.
Michelle
|||Thank you, Michelle.
I am having the same problem trying to install Accounting Express 2007 on my new Vista Ultimate machine.
The machine already has SQL Express loaded. Management Server Express works.
"winmgmt /verifyrepository" runs and says repository is inconsistent...
"winmgmt /salvagerepository" runs and produces:
WMI repository salvage failed
Error code: 0x8007041B
Facility: Win32
Description: A stop control has been sent to a service that other running services are dependent on.
Check out the following post it has a solution.
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1094559&SiteID=1
Michelle
Wednesday, March 21, 2012
Install Error - Operating System Service Pack Level (SP1)
I am attempting to install SQL Server 2005 Developer Edition (from CD) on my IBM PC with XP Operating System. During set up, I get a error message (see below) telling me about a Service Pack requirement. When I click on the link provided in the error message, it does not lead to any service pack download.
I'm trying to read thru these forum posts, it seems that there is a service pack that I need to download after installing SQL Server 2005. But how can I install the pack after when I can't install SQL Server. Any help would be greatly appreciated. Below is more information about the version of windows my PC has.
My PC: Windows Version 5.1 (Build 2600.xpsp2.030422-1633:Service Pack 1)
Error message from install program:
Operating System Service Pack Level Requirement. (Error)
Messages
Operating System Service Pack Level Requirement.
"The current operating system does not meet Service Pack level requirements for this SQL Server release. Install the most recent Service Pack from the Microsoft download center at http://go.microsoft.com/fwlink/?LinkId=50380, and then run SQL Server Setup again."
SQL Server 2005 Developer Edition needs SP2 on operating sytesm Windows XP. Please update your operating sytem and then install SQL Server 2005 again. Please see the BOL (Books On Line) for detailed inforamtion.
Install Error
I am recieving an "Error!" message while installing just
the Microsoft SQL Server Reporting Services Setup Support
Files".
I have met all the pre-requirements and have this running
fine on a development server.
Server is Windows 2000 Server SP4, SQL 2000 SP3, Windows
Installer 2.0, and the .NET framework.
The install bombs almost immediately and no log files are
being created for me to troubleshoot.
Thanks.Hi Chris, I'm getting this same error. Have you found a solution? Thanks!
"Chris" wrote:
> I am recieving an "Error!" message while installing just
> the Microsoft SQL Server Reporting Services Setup Support
> Files".
> I have met all the pre-requirements and have this running
> fine on a development server.
> Server is Windows 2000 Server SP4, SQL 2000 SP3, Windows
> Installer 2.0, and the .NET framework.
> The install bombs almost immediately and no log files are
> being created for me to troubleshoot.
> Thanks.
>|||Same problem here as well. Any tips? /Chris2
"DRS" wrote:
> Hi Chris, I'm getting this same error. Have you found a solution? Thanks!
> "Chris" wrote:
> > I am recieving an "Error!" message while installing just
> > the Microsoft SQL Server Reporting Services Setup Support
> > Files".
> >
> > I have met all the pre-requirements and have this running
> > fine on a development server.
> >
> > Server is Windows 2000 Server SP4, SQL 2000 SP3, Windows
> > Installer 2.0, and the .NET framework.
> >
> > The install bombs almost immediately and no log files are
> > being created for me to troubleshoot.
> >
> > Thanks.
> >|||Here was the response from Chris, it worked for me, hope this helps you:
"Yes it was strange. I was able to resolve if I remember correctly by
installing from another location. This is what I did and it appeared to
have something to do with the CDROM drive. I donâ't know why. I was
installing to an older HP Netserver and a new Dell Poweredge.
1. I shared my cdrom drive.
2. From the box in question, log onto the share.. start/run
\\â'pcnameâ'\cdrom
3. I ran the setup like that and it worked fine. "
"Chris Leaf" wrote:
> Same problem here as well. Any tips? /Chris2
> "DRS" wrote:
> > Hi Chris, I'm getting this same error. Have you found a solution? Thanks!
> >
> > "Chris" wrote:
> >
> > > I am recieving an "Error!" message while installing just
> > > the Microsoft SQL Server Reporting Services Setup Support
> > > Files".
> > >
> > > I have met all the pre-requirements and have this running
> > > fine on a development server.
> > >
> > > Server is Windows 2000 Server SP4, SQL 2000 SP3, Windows
> > > Installer 2.0, and the .NET framework.
> > >
> > > The install bombs almost immediately and no log files are
> > > being created for me to troubleshoot.
> > >
> > > Thanks.
> > >
the Microsoft SQL Server Reporting Services Setup Support
Files".
I have met all the pre-requirements and have this running
fine on a development server.
Server is Windows 2000 Server SP4, SQL 2000 SP3, Windows
Installer 2.0, and the .NET framework.
The install bombs almost immediately and no log files are
being created for me to troubleshoot.
Thanks.Hi Chris, I'm getting this same error. Have you found a solution? Thanks!
"Chris" wrote:
> I am recieving an "Error!" message while installing just
> the Microsoft SQL Server Reporting Services Setup Support
> Files".
> I have met all the pre-requirements and have this running
> fine on a development server.
> Server is Windows 2000 Server SP4, SQL 2000 SP3, Windows
> Installer 2.0, and the .NET framework.
> The install bombs almost immediately and no log files are
> being created for me to troubleshoot.
> Thanks.
>|||Same problem here as well. Any tips? /Chris2
"DRS" wrote:
> Hi Chris, I'm getting this same error. Have you found a solution? Thanks!
> "Chris" wrote:
> > I am recieving an "Error!" message while installing just
> > the Microsoft SQL Server Reporting Services Setup Support
> > Files".
> >
> > I have met all the pre-requirements and have this running
> > fine on a development server.
> >
> > Server is Windows 2000 Server SP4, SQL 2000 SP3, Windows
> > Installer 2.0, and the .NET framework.
> >
> > The install bombs almost immediately and no log files are
> > being created for me to troubleshoot.
> >
> > Thanks.
> >|||Here was the response from Chris, it worked for me, hope this helps you:
"Yes it was strange. I was able to resolve if I remember correctly by
installing from another location. This is what I did and it appeared to
have something to do with the CDROM drive. I donâ't know why. I was
installing to an older HP Netserver and a new Dell Poweredge.
1. I shared my cdrom drive.
2. From the box in question, log onto the share.. start/run
\\â'pcnameâ'\cdrom
3. I ran the setup like that and it worked fine. "
"Chris Leaf" wrote:
> Same problem here as well. Any tips? /Chris2
> "DRS" wrote:
> > Hi Chris, I'm getting this same error. Have you found a solution? Thanks!
> >
> > "Chris" wrote:
> >
> > > I am recieving an "Error!" message while installing just
> > > the Microsoft SQL Server Reporting Services Setup Support
> > > Files".
> > >
> > > I have met all the pre-requirements and have this running
> > > fine on a development server.
> > >
> > > Server is Windows 2000 Server SP4, SQL 2000 SP3, Windows
> > > Installer 2.0, and the .NET framework.
> > >
> > > The install bombs almost immediately and no log files are
> > > being created for me to troubleshoot.
> > >
> > > Thanks.
> > >
Install Error
Hello, I'm trying to install report services on windows 2003 server. I'm
getting this error message
"System Check Results
IIS is wither not installed or not configured for a server componenet
installation."
I already registed using aspnet_regiis â'i this command and also given
read-write access. I have default website up and running and point to
C:\Inetpub\wwwroot.
Any idea?.Thanks for all your help on this.I am having the exact same issue. Did you resolve it? If so, how?
Thanks in advance.
Eric
"Pandi" wrote:
> Hello, I'm trying to install report services on windows 2003 server. I'm
> getting this error message
> "System Check Results
> IIS is wither not installed or not configured for a server componenet
> installation."
> I already registed using aspnet_regiis â'i this command and also given
> read-write access. I have default website up and running and point to
> C:\Inetpub\wwwroot.
> Any idea?.Thanks for all your help on this.|||Yes I resolve it by uninstalling IIS and reinstall IIS. Looks like
Installation does not work if you have any other web site running on the same
machine.
I had three website running on the same server, now i have only one report
server website running on that box. Looks like report services only run on
default website. I'm trying to move that virtual directory to different
website on the same box, but i could not get this to work. but i will try to
move this to different website eventually.
Thanks , Pandi
"Eric S." wrote:
> I am having the exact same issue. Did you resolve it? If so, how?
> Thanks in advance.
> Eric
> "Pandi" wrote:
> > Hello, I'm trying to install report services on windows 2003 server. I'm
> > getting this error message
> > "System Check Results
> > IIS is wither not installed or not configured for a server componenet
> > installation."
> > I already registed using aspnet_regiis â'i this command and also given
> > read-write access. I have default website up and running and point to
> > C:\Inetpub\wwwroot.
> >
> > Any idea?.Thanks for all your help on this.
getting this error message
"System Check Results
IIS is wither not installed or not configured for a server componenet
installation."
I already registed using aspnet_regiis â'i this command and also given
read-write access. I have default website up and running and point to
C:\Inetpub\wwwroot.
Any idea?.Thanks for all your help on this.I am having the exact same issue. Did you resolve it? If so, how?
Thanks in advance.
Eric
"Pandi" wrote:
> Hello, I'm trying to install report services on windows 2003 server. I'm
> getting this error message
> "System Check Results
> IIS is wither not installed or not configured for a server componenet
> installation."
> I already registed using aspnet_regiis â'i this command and also given
> read-write access. I have default website up and running and point to
> C:\Inetpub\wwwroot.
> Any idea?.Thanks for all your help on this.|||Yes I resolve it by uninstalling IIS and reinstall IIS. Looks like
Installation does not work if you have any other web site running on the same
machine.
I had three website running on the same server, now i have only one report
server website running on that box. Looks like report services only run on
default website. I'm trying to move that virtual directory to different
website on the same box, but i could not get this to work. but i will try to
move this to different website eventually.
Thanks , Pandi
"Eric S." wrote:
> I am having the exact same issue. Did you resolve it? If so, how?
> Thanks in advance.
> Eric
> "Pandi" wrote:
> > Hello, I'm trying to install report services on windows 2003 server. I'm
> > getting this error message
> > "System Check Results
> > IIS is wither not installed or not configured for a server componenet
> > installation."
> > I already registed using aspnet_regiis â'i this command and also given
> > read-write access. I have default website up and running and point to
> > C:\Inetpub\wwwroot.
> >
> > Any idea?.Thanks for all your help on this.
Monday, March 19, 2012
Installation
Hi,
We are attempting to install Reporting Services on a Win2K domain
controller. At the end of the installation, a message appears saying that
we need to activate the service manually. However, using the rsconfig
utility returns this message:
Failure starting the web service:
The Report Server Web service has not generated a public key. The service
may not have started successfully. Check the log files for more
information.
The logs don't appear to contain any clues. If I attempt to connect to
http://machine/Reports or http://machine/ReportServer then the following
message appears:
Cannot execute a program. The command being executed was
"c:\winnt\microsoft.net\framework\v1.1.4322\csc.exe" /noconfig
@."c:\winnt\microsoft.net\framework\v1.1.4322\Temporary ASP.NET
Files\reportserver\94eb9a55\49df36c9\jgljplnh.cmdline".
Does anyone have any suggestions?
Thanks in advance,
PeterDid you try rsactivate?
"Peter Kenyon" <p.kenyon.no.spam@.paradise.net.nz> wrote in message
news:%23xX2zKVbEHA.368@.TK2MSFTNGP10.phx.gbl...
> Hi,
> We are attempting to install Reporting Services on a Win2K domain
> controller. At the end of the installation, a message appears saying that
> we need to activate the service manually. However, using the rsconfig
> utility returns this message:
> Failure starting the web service:
> The Report Server Web service has not generated a public key. The service
> may not have started successfully. Check the log files for more
> information.
> The logs don't appear to contain any clues. If I attempt to connect to
> http://machine/Reports or http://machine/ReportServer then the following
> message appears:
> Cannot execute a program. The command being executed was
> "c:\winnt\microsoft.net\framework\v1.1.4322\csc.exe" /noconfig
> @."c:\winnt\microsoft.net\framework\v1.1.4322\Temporary ASP.NET
> Files\reportserver\94eb9a55\49df36c9\jgljplnh.cmdline".
> Does anyone have any suggestions?
> Thanks in advance,
> Peter
>|||"Stan" <nospam@.yahoo.com> wrote in message
news:uA%236RumbEHA.2660@.tk2msftngp13.phx.gbl...
> Did you try rsactivate?
>
Yes, many times :-(
The message I receive is always:
Failure starting the web service:
The Report Server Web service has not generated a public key. The service
may not have started successfully. Check the log files for more
information.
The log files directory is full of hundreds of files, new ones appear every
few minutes. Perhaps the service is continuously attempting to start up and
failing? The log files don't seem to indicate any error though. Here is a
typical example:
<Product>Microsoft SQL Server Reporting Services Version
8.00.743.00</Product>
<Locale>en-US</Locale>
<TimeZone>New Zealand Standard Time</TimeZone>
<Path>C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\LogFiles\ReportServerService__07_21_2004_11_35_59.log</Path>
<SystemName>HMSERVER</SystemName>
<OSName>Microsoft Windows NT 5.0.2195.0</OSName>
<OSVersion>5.0.2195.0</OSVersion>
</Header>
ReportingServicesService!library!f7c!7/21/2004-11:35:59:: i INFO:
Initializing ConnectionType to '0' as specified in Configuration file.
ReportingServicesService!library!f7c!7/21/2004-11:35:59:: i INFO:
Initializing IsSchedulingService to 'True' as specified in Configuration
file.
ReportingServicesService!library!f7c!7/21/2004-11:35:59:: i INFO:
Initializing IsNotificationService to 'True' as specified in Configuration
file.
ReportingServicesService!library!f7c!7/21/2004-11:35:59:: i INFO:
Initializing IsEventService to 'True' as specified in Configuration file.
ReportingServicesService!library!f7c!7/21/2004-11:35:59:: i INFO:
Initializing PollingInterval to '10' second(s) as specified in Configuration
file.
ReportingServicesService!library!f7c!7/21/2004-11:35:59:: i INFO:
Initializing MemoryLimit to '60' percent as specified in Configuration file.
ReportingServicesService!library!f7c!7/21/2004-11:35:59:: i INFO:
Initializing RecycleTime to '720' minute(s) as specified in Configuration
file.
ReportingServicesService!library!f7c!7/21/2004-11:35:59:: i INFO:
Initializing MaximumMemoryLimit to '80' percent as specified in
Configuration file.
ReportingServicesService!library!f7c!7/21/2004-11:35:59:: i INFO:
Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in
Configuration file.
ReportingServicesService!library!f7c!7/21/2004-11:35:59:: i INFO:
Initializing MaxQueueThreads to '0' thread(s) as specified in Configuration
file.
ReportingServicesService!library!f7c!7/21/2004-11:36:00:: i INFO:
Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in
Configuration file.
ReportingServicesService!library!f7c!7/21/2004-11:36:00:: i INFO:
Initializing MaxScheduleWait to '5' second(s) as specified in Configuration
file.
ReportingServicesService!library!f7c!7/21/2004-11:36:00:: i INFO:
Initializing DatabaseQueryTimeout to '120' second(s) as specified in
Configuration file.
ReportingServicesService!library!f7c!7/21/2004-11:36:00:: i INFO:
Initializing InstanceName to 'MSSQLSERVER' as specified in Configuration
file.
ReportingServicesService!library!f7c!7/21/2004-11:36:00:: i INFO:
Initializing ProcessRecycleOptions to '0' as specified in Configuration
file.
ReportingServicesService!library!f7c!7/21/2004-11:36:00:: i INFO:
Initializing RunningRequestsScavengerCycle to '60' second(s) as specified in
Configuration file.
ReportingServicesService!library!f7c!7/21/2004-11:36:00:: i INFO:
Initializing RunningRequestsDbCycle to '60' second(s) as specified in
Configuration file.
ReportingServicesService!library!f7c!7/21/2004-11:36:00:: i INFO:
Initializing RunningRequestsAge to '30' second(s) as specified in
Configuration file.
ReportingServicesService!library!f7c!7/21/2004-11:36:00:: i INFO:
Initializing CleanupCycleMinutes to '10' minute(s) as specified in
Configuration file.
ReportingServicesService!library!f7c!7/21/2004-11:36:00:: i INFO:
Initializing SecureConnectionLevel to '0' as specified in Configuration
file.
ReportingServicesService!library!f7c!7/21/2004-11:36:00:: i INFO:
Initializing DisplayErrorLink to 'True' as specified in Configuration file.
ReportingServicesService!resourceutilities!f7c!7/21/2004-11:36:00:: i INFO:
Running on 2 physical processors, 2 logical processors
ReportingServicesService!resourceutilities!f7c!7/21/2004-11:36:00:: i INFO:
Reporting Services starting SKU: Enterprise
ReportingServicesService!runningjobs!f7c!7/21/2004-11:36:00:: i INFO:
Database Cleanup (NT Service) timer enabled: Cycle: 600 seconds
ReportingServicesService!runningjobs!f7c!7/21/2004-11:36:00:: i INFO:
Running Requests Scavenger timer enabled: Cycle: 60 seconds
ReportingServicesService!runningjobs!f7c!7/21/2004-11:36:00:: i INFO:
Running Requests DB timer enabled: Cycle: 60 seconds
ReportingServicesService!runningjobs!f7c!7/21/2004-11:36:00:: i INFO:
Execution Log Entry Expiration timer enabled: Cycle: 51839 seconds
ReportingServicesService!runningjobs!f7c!7/21/2004-11:36:00:: i INFO: Memory
stats update timer enabled: Cycle: 60 seconds
ReportingServicesService!crypto!f38!7/21/2004-11:36:03:: i INFO:
Initializing crypto as user: NT AUTHORITY\SYSTEM
ReportingServicesService!crypto!f38!7/21/2004-11:36:03:: i INFO: Exporting
public key
ReportingServicesService!crypto!f38!7/21/2004-11:36:04:: i INFO: Performing
sku validation
ReportingServicesService!crypto!f38!7/21/2004-11:36:04:: i INFO: Importing
existing encryption key
ReportingServicesService!dbpolling!f38!07/21/2004-11:36:05:: EventPolling
polling service started
ReportingServicesService!dbpolling!f38!07/21/2004-11:36:05::
NotificationPolling polling service started
ReportingServicesService!dbpolling!f38!07/21/2004-11:36:05:: SchedulePolling
polling service started
ReportingServicesService!dbpolling!1154!7/21/2004-11:36:05:: EventPolling
heartbeat thread started.
ReportingServicesService!dbpolling!880!7/21/2004-11:36:05:: Polling started
ReportingServicesService!dbpolling!1848!7/21/2004-11:36:05::
NotificationPolling heartbeat thread started.
Peter|||Look in the reportserver_<date>.log files. They should provide some clue as
to why the activation is failing.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Peter Kenyon" <p.kenyon.no.spam@.paradise.net.nz> wrote in message
news:urOwhLrbEHA.808@.tk2msftngp13.phx.gbl...
> "Stan" <nospam@.yahoo.com> wrote in message
> news:uA%236RumbEHA.2660@.tk2msftngp13.phx.gbl...
> > Did you try rsactivate?
> >
> Yes, many times :-(
> The message I receive is always:
> Failure starting the web service:
> The Report Server Web service has not generated a public key. The service
> may not have started successfully. Check the log files for more
> information.
> The log files directory is full of hundreds of files, new ones appear
every
> few minutes. Perhaps the service is continuously attempting to start up
and
> failing? The log files don't seem to indicate any error though. Here is a
> typical example:
>
> <Product>Microsoft SQL Server Reporting Services Version
> 8.00.743.00</Product>
> <Locale>en-US</Locale>
> <TimeZone>New Zealand Standard Time</TimeZone>
> <Path>C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> Services\LogFiles\ReportServerService__07_21_2004_11_35_59.log</Path>
> <SystemName>HMSERVER</SystemName>
> <OSName>Microsoft Windows NT 5.0.2195.0</OSName>
> <OSVersion>5.0.2195.0</OSVersion>
> </Header>
> ReportingServicesService!library!f7c!7/21/2004-11:35:59:: i INFO:
> Initializing ConnectionType to '0' as specified in Configuration file.
> ReportingServicesService!library!f7c!7/21/2004-11:35:59:: i INFO:
> Initializing IsSchedulingService to 'True' as specified in Configuration
> file.
> ReportingServicesService!library!f7c!7/21/2004-11:35:59:: i INFO:
> Initializing IsNotificationService to 'True' as specified in
Configuration
> file.
> ReportingServicesService!library!f7c!7/21/2004-11:35:59:: i INFO:
> Initializing IsEventService to 'True' as specified in Configuration file.
> ReportingServicesService!library!f7c!7/21/2004-11:35:59:: i INFO:
> Initializing PollingInterval to '10' second(s) as specified in
Configuration
> file.
> ReportingServicesService!library!f7c!7/21/2004-11:35:59:: i INFO:
> Initializing MemoryLimit to '60' percent as specified in Configuration
file.
> ReportingServicesService!library!f7c!7/21/2004-11:35:59:: i INFO:
> Initializing RecycleTime to '720' minute(s) as specified in Configuration
> file.
> ReportingServicesService!library!f7c!7/21/2004-11:35:59:: i INFO:
> Initializing MaximumMemoryLimit to '80' percent as specified in
> Configuration file.
> ReportingServicesService!library!f7c!7/21/2004-11:35:59:: i INFO:
> Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in
> Configuration file.
> ReportingServicesService!library!f7c!7/21/2004-11:35:59:: i INFO:
> Initializing MaxQueueThreads to '0' thread(s) as specified in
Configuration
> file.
> ReportingServicesService!library!f7c!7/21/2004-11:36:00:: i INFO:
> Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in
> Configuration file.
> ReportingServicesService!library!f7c!7/21/2004-11:36:00:: i INFO:
> Initializing MaxScheduleWait to '5' second(s) as specified in
Configuration
> file.
> ReportingServicesService!library!f7c!7/21/2004-11:36:00:: i INFO:
> Initializing DatabaseQueryTimeout to '120' second(s) as specified in
> Configuration file.
> ReportingServicesService!library!f7c!7/21/2004-11:36:00:: i INFO:
> Initializing InstanceName to 'MSSQLSERVER' as specified in Configuration
> file.
> ReportingServicesService!library!f7c!7/21/2004-11:36:00:: i INFO:
> Initializing ProcessRecycleOptions to '0' as specified in Configuration
> file.
> ReportingServicesService!library!f7c!7/21/2004-11:36:00:: i INFO:
> Initializing RunningRequestsScavengerCycle to '60' second(s) as specified
in
> Configuration file.
> ReportingServicesService!library!f7c!7/21/2004-11:36:00:: i INFO:
> Initializing RunningRequestsDbCycle to '60' second(s) as specified in
> Configuration file.
> ReportingServicesService!library!f7c!7/21/2004-11:36:00:: i INFO:
> Initializing RunningRequestsAge to '30' second(s) as specified in
> Configuration file.
> ReportingServicesService!library!f7c!7/21/2004-11:36:00:: i INFO:
> Initializing CleanupCycleMinutes to '10' minute(s) as specified in
> Configuration file.
> ReportingServicesService!library!f7c!7/21/2004-11:36:00:: i INFO:
> Initializing SecureConnectionLevel to '0' as specified in Configuration
> file.
> ReportingServicesService!library!f7c!7/21/2004-11:36:00:: i INFO:
> Initializing DisplayErrorLink to 'True' as specified in Configuration
file.
> ReportingServicesService!resourceutilities!f7c!7/21/2004-11:36:00:: i
INFO:
> Running on 2 physical processors, 2 logical processors
> ReportingServicesService!resourceutilities!f7c!7/21/2004-11:36:00:: i
INFO:
> Reporting Services starting SKU: Enterprise
> ReportingServicesService!runningjobs!f7c!7/21/2004-11:36:00:: i INFO:
> Database Cleanup (NT Service) timer enabled: Cycle: 600 seconds
> ReportingServicesService!runningjobs!f7c!7/21/2004-11:36:00:: i INFO:
> Running Requests Scavenger timer enabled: Cycle: 60 seconds
> ReportingServicesService!runningjobs!f7c!7/21/2004-11:36:00:: i INFO:
> Running Requests DB timer enabled: Cycle: 60 seconds
> ReportingServicesService!runningjobs!f7c!7/21/2004-11:36:00:: i INFO:
> Execution Log Entry Expiration timer enabled: Cycle: 51839 seconds
> ReportingServicesService!runningjobs!f7c!7/21/2004-11:36:00:: i INFO:
Memory
> stats update timer enabled: Cycle: 60 seconds
> ReportingServicesService!crypto!f38!7/21/2004-11:36:03:: i INFO:
> Initializing crypto as user: NT AUTHORITY\SYSTEM
> ReportingServicesService!crypto!f38!7/21/2004-11:36:03:: i INFO: Exporting
> public key
> ReportingServicesService!crypto!f38!7/21/2004-11:36:04:: i INFO:
Performing
> sku validation
> ReportingServicesService!crypto!f38!7/21/2004-11:36:04:: i INFO: Importing
> existing encryption key
> ReportingServicesService!dbpolling!f38!07/21/2004-11:36:05:: EventPolling
> polling service started
> ReportingServicesService!dbpolling!f38!07/21/2004-11:36:05::
> NotificationPolling polling service started
> ReportingServicesService!dbpolling!f38!07/21/2004-11:36:05::
SchedulePolling
> polling service started
> ReportingServicesService!dbpolling!1154!7/21/2004-11:36:05:: EventPolling
> heartbeat thread started.
> ReportingServicesService!dbpolling!880!7/21/2004-11:36:05:: Polling
started
> ReportingServicesService!dbpolling!1848!7/21/2004-11:36:05::
> NotificationPolling heartbeat thread started.
> Peter
>
We are attempting to install Reporting Services on a Win2K domain
controller. At the end of the installation, a message appears saying that
we need to activate the service manually. However, using the rsconfig
utility returns this message:
Failure starting the web service:
The Report Server Web service has not generated a public key. The service
may not have started successfully. Check the log files for more
information.
The logs don't appear to contain any clues. If I attempt to connect to
http://machine/Reports or http://machine/ReportServer then the following
message appears:
Cannot execute a program. The command being executed was
"c:\winnt\microsoft.net\framework\v1.1.4322\csc.exe" /noconfig
@."c:\winnt\microsoft.net\framework\v1.1.4322\Temporary ASP.NET
Files\reportserver\94eb9a55\49df36c9\jgljplnh.cmdline".
Does anyone have any suggestions?
Thanks in advance,
PeterDid you try rsactivate?
"Peter Kenyon" <p.kenyon.no.spam@.paradise.net.nz> wrote in message
news:%23xX2zKVbEHA.368@.TK2MSFTNGP10.phx.gbl...
> Hi,
> We are attempting to install Reporting Services on a Win2K domain
> controller. At the end of the installation, a message appears saying that
> we need to activate the service manually. However, using the rsconfig
> utility returns this message:
> Failure starting the web service:
> The Report Server Web service has not generated a public key. The service
> may not have started successfully. Check the log files for more
> information.
> The logs don't appear to contain any clues. If I attempt to connect to
> http://machine/Reports or http://machine/ReportServer then the following
> message appears:
> Cannot execute a program. The command being executed was
> "c:\winnt\microsoft.net\framework\v1.1.4322\csc.exe" /noconfig
> @."c:\winnt\microsoft.net\framework\v1.1.4322\Temporary ASP.NET
> Files\reportserver\94eb9a55\49df36c9\jgljplnh.cmdline".
> Does anyone have any suggestions?
> Thanks in advance,
> Peter
>|||"Stan" <nospam@.yahoo.com> wrote in message
news:uA%236RumbEHA.2660@.tk2msftngp13.phx.gbl...
> Did you try rsactivate?
>
Yes, many times :-(
The message I receive is always:
Failure starting the web service:
The Report Server Web service has not generated a public key. The service
may not have started successfully. Check the log files for more
information.
The log files directory is full of hundreds of files, new ones appear every
few minutes. Perhaps the service is continuously attempting to start up and
failing? The log files don't seem to indicate any error though. Here is a
typical example:
<Product>Microsoft SQL Server Reporting Services Version
8.00.743.00</Product>
<Locale>en-US</Locale>
<TimeZone>New Zealand Standard Time</TimeZone>
<Path>C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
Services\LogFiles\ReportServerService__07_21_2004_11_35_59.log</Path>
<SystemName>HMSERVER</SystemName>
<OSName>Microsoft Windows NT 5.0.2195.0</OSName>
<OSVersion>5.0.2195.0</OSVersion>
</Header>
ReportingServicesService!library!f7c!7/21/2004-11:35:59:: i INFO:
Initializing ConnectionType to '0' as specified in Configuration file.
ReportingServicesService!library!f7c!7/21/2004-11:35:59:: i INFO:
Initializing IsSchedulingService to 'True' as specified in Configuration
file.
ReportingServicesService!library!f7c!7/21/2004-11:35:59:: i INFO:
Initializing IsNotificationService to 'True' as specified in Configuration
file.
ReportingServicesService!library!f7c!7/21/2004-11:35:59:: i INFO:
Initializing IsEventService to 'True' as specified in Configuration file.
ReportingServicesService!library!f7c!7/21/2004-11:35:59:: i INFO:
Initializing PollingInterval to '10' second(s) as specified in Configuration
file.
ReportingServicesService!library!f7c!7/21/2004-11:35:59:: i INFO:
Initializing MemoryLimit to '60' percent as specified in Configuration file.
ReportingServicesService!library!f7c!7/21/2004-11:35:59:: i INFO:
Initializing RecycleTime to '720' minute(s) as specified in Configuration
file.
ReportingServicesService!library!f7c!7/21/2004-11:35:59:: i INFO:
Initializing MaximumMemoryLimit to '80' percent as specified in
Configuration file.
ReportingServicesService!library!f7c!7/21/2004-11:35:59:: i INFO:
Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in
Configuration file.
ReportingServicesService!library!f7c!7/21/2004-11:35:59:: i INFO:
Initializing MaxQueueThreads to '0' thread(s) as specified in Configuration
file.
ReportingServicesService!library!f7c!7/21/2004-11:36:00:: i INFO:
Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in
Configuration file.
ReportingServicesService!library!f7c!7/21/2004-11:36:00:: i INFO:
Initializing MaxScheduleWait to '5' second(s) as specified in Configuration
file.
ReportingServicesService!library!f7c!7/21/2004-11:36:00:: i INFO:
Initializing DatabaseQueryTimeout to '120' second(s) as specified in
Configuration file.
ReportingServicesService!library!f7c!7/21/2004-11:36:00:: i INFO:
Initializing InstanceName to 'MSSQLSERVER' as specified in Configuration
file.
ReportingServicesService!library!f7c!7/21/2004-11:36:00:: i INFO:
Initializing ProcessRecycleOptions to '0' as specified in Configuration
file.
ReportingServicesService!library!f7c!7/21/2004-11:36:00:: i INFO:
Initializing RunningRequestsScavengerCycle to '60' second(s) as specified in
Configuration file.
ReportingServicesService!library!f7c!7/21/2004-11:36:00:: i INFO:
Initializing RunningRequestsDbCycle to '60' second(s) as specified in
Configuration file.
ReportingServicesService!library!f7c!7/21/2004-11:36:00:: i INFO:
Initializing RunningRequestsAge to '30' second(s) as specified in
Configuration file.
ReportingServicesService!library!f7c!7/21/2004-11:36:00:: i INFO:
Initializing CleanupCycleMinutes to '10' minute(s) as specified in
Configuration file.
ReportingServicesService!library!f7c!7/21/2004-11:36:00:: i INFO:
Initializing SecureConnectionLevel to '0' as specified in Configuration
file.
ReportingServicesService!library!f7c!7/21/2004-11:36:00:: i INFO:
Initializing DisplayErrorLink to 'True' as specified in Configuration file.
ReportingServicesService!resourceutilities!f7c!7/21/2004-11:36:00:: i INFO:
Running on 2 physical processors, 2 logical processors
ReportingServicesService!resourceutilities!f7c!7/21/2004-11:36:00:: i INFO:
Reporting Services starting SKU: Enterprise
ReportingServicesService!runningjobs!f7c!7/21/2004-11:36:00:: i INFO:
Database Cleanup (NT Service) timer enabled: Cycle: 600 seconds
ReportingServicesService!runningjobs!f7c!7/21/2004-11:36:00:: i INFO:
Running Requests Scavenger timer enabled: Cycle: 60 seconds
ReportingServicesService!runningjobs!f7c!7/21/2004-11:36:00:: i INFO:
Running Requests DB timer enabled: Cycle: 60 seconds
ReportingServicesService!runningjobs!f7c!7/21/2004-11:36:00:: i INFO:
Execution Log Entry Expiration timer enabled: Cycle: 51839 seconds
ReportingServicesService!runningjobs!f7c!7/21/2004-11:36:00:: i INFO: Memory
stats update timer enabled: Cycle: 60 seconds
ReportingServicesService!crypto!f38!7/21/2004-11:36:03:: i INFO:
Initializing crypto as user: NT AUTHORITY\SYSTEM
ReportingServicesService!crypto!f38!7/21/2004-11:36:03:: i INFO: Exporting
public key
ReportingServicesService!crypto!f38!7/21/2004-11:36:04:: i INFO: Performing
sku validation
ReportingServicesService!crypto!f38!7/21/2004-11:36:04:: i INFO: Importing
existing encryption key
ReportingServicesService!dbpolling!f38!07/21/2004-11:36:05:: EventPolling
polling service started
ReportingServicesService!dbpolling!f38!07/21/2004-11:36:05::
NotificationPolling polling service started
ReportingServicesService!dbpolling!f38!07/21/2004-11:36:05:: SchedulePolling
polling service started
ReportingServicesService!dbpolling!1154!7/21/2004-11:36:05:: EventPolling
heartbeat thread started.
ReportingServicesService!dbpolling!880!7/21/2004-11:36:05:: Polling started
ReportingServicesService!dbpolling!1848!7/21/2004-11:36:05::
NotificationPolling heartbeat thread started.
Peter|||Look in the reportserver_<date>.log files. They should provide some clue as
to why the activation is failing.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Peter Kenyon" <p.kenyon.no.spam@.paradise.net.nz> wrote in message
news:urOwhLrbEHA.808@.tk2msftngp13.phx.gbl...
> "Stan" <nospam@.yahoo.com> wrote in message
> news:uA%236RumbEHA.2660@.tk2msftngp13.phx.gbl...
> > Did you try rsactivate?
> >
> Yes, many times :-(
> The message I receive is always:
> Failure starting the web service:
> The Report Server Web service has not generated a public key. The service
> may not have started successfully. Check the log files for more
> information.
> The log files directory is full of hundreds of files, new ones appear
every
> few minutes. Perhaps the service is continuously attempting to start up
and
> failing? The log files don't seem to indicate any error though. Here is a
> typical example:
>
> <Product>Microsoft SQL Server Reporting Services Version
> 8.00.743.00</Product>
> <Locale>en-US</Locale>
> <TimeZone>New Zealand Standard Time</TimeZone>
> <Path>C:\Program Files\Microsoft SQL Server\MSSQL\Reporting
> Services\LogFiles\ReportServerService__07_21_2004_11_35_59.log</Path>
> <SystemName>HMSERVER</SystemName>
> <OSName>Microsoft Windows NT 5.0.2195.0</OSName>
> <OSVersion>5.0.2195.0</OSVersion>
> </Header>
> ReportingServicesService!library!f7c!7/21/2004-11:35:59:: i INFO:
> Initializing ConnectionType to '0' as specified in Configuration file.
> ReportingServicesService!library!f7c!7/21/2004-11:35:59:: i INFO:
> Initializing IsSchedulingService to 'True' as specified in Configuration
> file.
> ReportingServicesService!library!f7c!7/21/2004-11:35:59:: i INFO:
> Initializing IsNotificationService to 'True' as specified in
Configuration
> file.
> ReportingServicesService!library!f7c!7/21/2004-11:35:59:: i INFO:
> Initializing IsEventService to 'True' as specified in Configuration file.
> ReportingServicesService!library!f7c!7/21/2004-11:35:59:: i INFO:
> Initializing PollingInterval to '10' second(s) as specified in
Configuration
> file.
> ReportingServicesService!library!f7c!7/21/2004-11:35:59:: i INFO:
> Initializing MemoryLimit to '60' percent as specified in Configuration
file.
> ReportingServicesService!library!f7c!7/21/2004-11:35:59:: i INFO:
> Initializing RecycleTime to '720' minute(s) as specified in Configuration
> file.
> ReportingServicesService!library!f7c!7/21/2004-11:35:59:: i INFO:
> Initializing MaximumMemoryLimit to '80' percent as specified in
> Configuration file.
> ReportingServicesService!library!f7c!7/21/2004-11:35:59:: i INFO:
> Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in
> Configuration file.
> ReportingServicesService!library!f7c!7/21/2004-11:35:59:: i INFO:
> Initializing MaxQueueThreads to '0' thread(s) as specified in
Configuration
> file.
> ReportingServicesService!library!f7c!7/21/2004-11:36:00:: i INFO:
> Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in
> Configuration file.
> ReportingServicesService!library!f7c!7/21/2004-11:36:00:: i INFO:
> Initializing MaxScheduleWait to '5' second(s) as specified in
Configuration
> file.
> ReportingServicesService!library!f7c!7/21/2004-11:36:00:: i INFO:
> Initializing DatabaseQueryTimeout to '120' second(s) as specified in
> Configuration file.
> ReportingServicesService!library!f7c!7/21/2004-11:36:00:: i INFO:
> Initializing InstanceName to 'MSSQLSERVER' as specified in Configuration
> file.
> ReportingServicesService!library!f7c!7/21/2004-11:36:00:: i INFO:
> Initializing ProcessRecycleOptions to '0' as specified in Configuration
> file.
> ReportingServicesService!library!f7c!7/21/2004-11:36:00:: i INFO:
> Initializing RunningRequestsScavengerCycle to '60' second(s) as specified
in
> Configuration file.
> ReportingServicesService!library!f7c!7/21/2004-11:36:00:: i INFO:
> Initializing RunningRequestsDbCycle to '60' second(s) as specified in
> Configuration file.
> ReportingServicesService!library!f7c!7/21/2004-11:36:00:: i INFO:
> Initializing RunningRequestsAge to '30' second(s) as specified in
> Configuration file.
> ReportingServicesService!library!f7c!7/21/2004-11:36:00:: i INFO:
> Initializing CleanupCycleMinutes to '10' minute(s) as specified in
> Configuration file.
> ReportingServicesService!library!f7c!7/21/2004-11:36:00:: i INFO:
> Initializing SecureConnectionLevel to '0' as specified in Configuration
> file.
> ReportingServicesService!library!f7c!7/21/2004-11:36:00:: i INFO:
> Initializing DisplayErrorLink to 'True' as specified in Configuration
file.
> ReportingServicesService!resourceutilities!f7c!7/21/2004-11:36:00:: i
INFO:
> Running on 2 physical processors, 2 logical processors
> ReportingServicesService!resourceutilities!f7c!7/21/2004-11:36:00:: i
INFO:
> Reporting Services starting SKU: Enterprise
> ReportingServicesService!runningjobs!f7c!7/21/2004-11:36:00:: i INFO:
> Database Cleanup (NT Service) timer enabled: Cycle: 600 seconds
> ReportingServicesService!runningjobs!f7c!7/21/2004-11:36:00:: i INFO:
> Running Requests Scavenger timer enabled: Cycle: 60 seconds
> ReportingServicesService!runningjobs!f7c!7/21/2004-11:36:00:: i INFO:
> Running Requests DB timer enabled: Cycle: 60 seconds
> ReportingServicesService!runningjobs!f7c!7/21/2004-11:36:00:: i INFO:
> Execution Log Entry Expiration timer enabled: Cycle: 51839 seconds
> ReportingServicesService!runningjobs!f7c!7/21/2004-11:36:00:: i INFO:
Memory
> stats update timer enabled: Cycle: 60 seconds
> ReportingServicesService!crypto!f38!7/21/2004-11:36:03:: i INFO:
> Initializing crypto as user: NT AUTHORITY\SYSTEM
> ReportingServicesService!crypto!f38!7/21/2004-11:36:03:: i INFO: Exporting
> public key
> ReportingServicesService!crypto!f38!7/21/2004-11:36:04:: i INFO:
Performing
> sku validation
> ReportingServicesService!crypto!f38!7/21/2004-11:36:04:: i INFO: Importing
> existing encryption key
> ReportingServicesService!dbpolling!f38!07/21/2004-11:36:05:: EventPolling
> polling service started
> ReportingServicesService!dbpolling!f38!07/21/2004-11:36:05::
> NotificationPolling polling service started
> ReportingServicesService!dbpolling!f38!07/21/2004-11:36:05::
SchedulePolling
> polling service started
> ReportingServicesService!dbpolling!1154!7/21/2004-11:36:05:: EventPolling
> heartbeat thread started.
> ReportingServicesService!dbpolling!880!7/21/2004-11:36:05:: Polling
started
> ReportingServicesService!dbpolling!1848!7/21/2004-11:36:05::
> NotificationPolling heartbeat thread started.
> Peter
>
Installatiion SQL SERVER 2000
during installation I had this message error
it's not possible to configure sql server
for error log read C:\WINNT\sqlstp.log.
and this is what I havein this file
################################################## #############################
Avvio del servizio in corso ...
Latin1_General_BIN
-m -Q -T4022 -T3659
Connessione al server in corso ...
driver={sql server};server=PC-BEN;UID=sa;PWD=;database=master
[Microsoft][ODBC SQL Server Driver][Named Pipes]Connessione interrotta.
[Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionRead
(GetOverLappedResult()).
driver={sql server};server=PC-BEN;UID=sa;PWD=;database=master
[Microsoft][ODBC SQL Server Driver][Named Pipes]Connessione interrotta.
[Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionRead
(GetOverLappedResult()).
driver={sql server};server=PC-BEN;UID=sa;PWD=;database=master
[Microsoft][ODBC SQL Server Driver][Named Pipes]Connessione interrotta.
[Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionRead
(GetOverLappedResult()).
Impossibile configurare SQL Server.
################################################## #############################
06:40:00 Process Exit Code: (-1)
06:41:05 Impossibile configurare il server. Per ulteriori informazioni,
esaminare il log degli errori del server e C:\WINNT\sqlstp.log.
06:41:05 Action CleanUpInstall:
06:41:05 C:\DOCUME~1\ADMINI~2.PC-\IMPOST~1\Temp\SqlSetup\Bin\scm.exe
-Silent 1 -Action 4 -Service SQLSERVERAGENT
06:41:05 Process Exit Code: (1060) Il servizio specificato non esiste come
servizio installato.
06:41:05 C:\DOCUME~1\ADMINI~2.PC-\IMPOST~1\Temp\SqlSetup\Bin\scm.exe
-Silent 1 -Action 4 -Service MSSQLSERVER
06:41:05 Process Exit Code: (0)
06:41:05 StatsGenerate returned: 2
06:41:05 StatsGenerate (0x80000000,0x1,0xf000000,0x400,1040,303,0x0,0x1,0 ,0,0
06:41:05 StatsGenerate -1,Administrator)
06:41:05 Installation Failed.
may someone tell me what can I doto finish installation of sqlserver ?
Help
Are you instaling this through Terminal Services Client or actually at the
computer itself?
Nik Marshall-Blank MCSD/MCDBA
Nik Marshall-Blank MCSD/MCDBA
"Ben" <Ben @.discussions.microsoft.com> wrote in message
news:9A241BF4-36C6-4ACD-AAE8-ADBF4D12E553@.microsoft.com...
> during installation I had this message error
> it's not possible to configure sql server
> for error log read C:\WINNT\sqlstp.log.
> and this is what I havein this file
> ################################################## #############################
>
> Avvio del servizio in corso ...
> Latin1_General_BIN
> -m -Q -T4022 -T3659
> Connessione al server in corso ...
> driver={sql server};server=PC-BEN;UID=sa;PWD=;database=master
> [Microsoft][ODBC SQL Server Driver][Named Pipes]Connessione interrotta.
> [Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionRead
> (GetOverLappedResult()).
> driver={sql server};server=PC-BEN;UID=sa;PWD=;database=master
> [Microsoft][ODBC SQL Server Driver][Named Pipes]Connessione interrotta.
> [Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionRead
> (GetOverLappedResult()).
> driver={sql server};server=PC-BEN;UID=sa;PWD=;database=master
> [Microsoft][ODBC SQL Server Driver][Named Pipes]Connessione interrotta.
> [Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionRead
> (GetOverLappedResult()).
> Impossibile configurare SQL Server.
> ################################################## #############################
> 06:40:00 Process Exit Code: (-1)
> 06:41:05 Impossibile configurare il server. Per ulteriori informazioni,
> esaminare il log degli errori del server e C:\WINNT\sqlstp.log.
> 06:41:05 Action CleanUpInstall:
> 06:41:05 C:\DOCUME~1\ADMINI~2.PC-\IMPOST~1\Temp\SqlSetup\Bin\scm.exe
> -Silent 1 -Action 4 -Service SQLSERVERAGENT
> 06:41:05 Process Exit Code: (1060) Il servizio specificato non esiste come
> servizio installato.
> 06:41:05 C:\DOCUME~1\ADMINI~2.PC-\IMPOST~1\Temp\SqlSetup\Bin\scm.exe
> -Silent 1 -Action 4 -Service MSSQLSERVER
> 06:41:05 Process Exit Code: (0)
> 06:41:05 StatsGenerate returned: 2
> 06:41:05 StatsGenerate
> (0x80000000,0x1,0xf000000,0x400,1040,303,0x0,0x1,0 ,0,0
> 06:41:05 StatsGenerate -1,Administrator)
> 06:41:05 Installation Failed.
> may someone tell me what can I doto finish installation of sqlserver ?
> Help
|||thanks for your answer ...
No i'm installing the computer itself...
"Nik Marshall-Blank" wrote:
> Are you instaling this through Terminal Services Client or actually at the
> computer itself?
> --
> Nik Marshall-Blank MCSD/MCDBA
>
> --
> Nik Marshall-Blank MCSD/MCDBA
> "Ben" <Ben @.discussions.microsoft.com> wrote in message
> news:9A241BF4-36C6-4ACD-AAE8-ADBF4D12E553@.microsoft.com...
>
>
it's not possible to configure sql server
for error log read C:\WINNT\sqlstp.log.
and this is what I havein this file
################################################## #############################
Avvio del servizio in corso ...
Latin1_General_BIN
-m -Q -T4022 -T3659
Connessione al server in corso ...
driver={sql server};server=PC-BEN;UID=sa;PWD=;database=master
[Microsoft][ODBC SQL Server Driver][Named Pipes]Connessione interrotta.
[Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionRead
(GetOverLappedResult()).
driver={sql server};server=PC-BEN;UID=sa;PWD=;database=master
[Microsoft][ODBC SQL Server Driver][Named Pipes]Connessione interrotta.
[Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionRead
(GetOverLappedResult()).
driver={sql server};server=PC-BEN;UID=sa;PWD=;database=master
[Microsoft][ODBC SQL Server Driver][Named Pipes]Connessione interrotta.
[Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionRead
(GetOverLappedResult()).
Impossibile configurare SQL Server.
################################################## #############################
06:40:00 Process Exit Code: (-1)
06:41:05 Impossibile configurare il server. Per ulteriori informazioni,
esaminare il log degli errori del server e C:\WINNT\sqlstp.log.
06:41:05 Action CleanUpInstall:
06:41:05 C:\DOCUME~1\ADMINI~2.PC-\IMPOST~1\Temp\SqlSetup\Bin\scm.exe
-Silent 1 -Action 4 -Service SQLSERVERAGENT
06:41:05 Process Exit Code: (1060) Il servizio specificato non esiste come
servizio installato.
06:41:05 C:\DOCUME~1\ADMINI~2.PC-\IMPOST~1\Temp\SqlSetup\Bin\scm.exe
-Silent 1 -Action 4 -Service MSSQLSERVER
06:41:05 Process Exit Code: (0)
06:41:05 StatsGenerate returned: 2
06:41:05 StatsGenerate (0x80000000,0x1,0xf000000,0x400,1040,303,0x0,0x1,0 ,0,0
06:41:05 StatsGenerate -1,Administrator)
06:41:05 Installation Failed.
may someone tell me what can I doto finish installation of sqlserver ?
Help
Are you instaling this through Terminal Services Client or actually at the
computer itself?
Nik Marshall-Blank MCSD/MCDBA
Nik Marshall-Blank MCSD/MCDBA
"Ben" <Ben @.discussions.microsoft.com> wrote in message
news:9A241BF4-36C6-4ACD-AAE8-ADBF4D12E553@.microsoft.com...
> during installation I had this message error
> it's not possible to configure sql server
> for error log read C:\WINNT\sqlstp.log.
> and this is what I havein this file
> ################################################## #############################
>
> Avvio del servizio in corso ...
> Latin1_General_BIN
> -m -Q -T4022 -T3659
> Connessione al server in corso ...
> driver={sql server};server=PC-BEN;UID=sa;PWD=;database=master
> [Microsoft][ODBC SQL Server Driver][Named Pipes]Connessione interrotta.
> [Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionRead
> (GetOverLappedResult()).
> driver={sql server};server=PC-BEN;UID=sa;PWD=;database=master
> [Microsoft][ODBC SQL Server Driver][Named Pipes]Connessione interrotta.
> [Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionRead
> (GetOverLappedResult()).
> driver={sql server};server=PC-BEN;UID=sa;PWD=;database=master
> [Microsoft][ODBC SQL Server Driver][Named Pipes]Connessione interrotta.
> [Microsoft][ODBC SQL Server Driver][Named Pipes]ConnectionRead
> (GetOverLappedResult()).
> Impossibile configurare SQL Server.
> ################################################## #############################
> 06:40:00 Process Exit Code: (-1)
> 06:41:05 Impossibile configurare il server. Per ulteriori informazioni,
> esaminare il log degli errori del server e C:\WINNT\sqlstp.log.
> 06:41:05 Action CleanUpInstall:
> 06:41:05 C:\DOCUME~1\ADMINI~2.PC-\IMPOST~1\Temp\SqlSetup\Bin\scm.exe
> -Silent 1 -Action 4 -Service SQLSERVERAGENT
> 06:41:05 Process Exit Code: (1060) Il servizio specificato non esiste come
> servizio installato.
> 06:41:05 C:\DOCUME~1\ADMINI~2.PC-\IMPOST~1\Temp\SqlSetup\Bin\scm.exe
> -Silent 1 -Action 4 -Service MSSQLSERVER
> 06:41:05 Process Exit Code: (0)
> 06:41:05 StatsGenerate returned: 2
> 06:41:05 StatsGenerate
> (0x80000000,0x1,0xf000000,0x400,1040,303,0x0,0x1,0 ,0,0
> 06:41:05 StatsGenerate -1,Administrator)
> 06:41:05 Installation Failed.
> may someone tell me what can I doto finish installation of sqlserver ?
> Help
|||thanks for your answer ...
No i'm installing the computer itself...
"Nik Marshall-Blank" wrote:
> Are you instaling this through Terminal Services Client or actually at the
> computer itself?
> --
> Nik Marshall-Blank MCSD/MCDBA
>
> --
> Nik Marshall-Blank MCSD/MCDBA
> "Ben" <Ben @.discussions.microsoft.com> wrote in message
> news:9A241BF4-36C6-4ACD-AAE8-ADBF4D12E553@.microsoft.com...
>
>
Monday, March 12, 2012
Install
Hello,
I'm trying install the evalution version of Reportingservices, but I recieve
an error message that says that I must register ASP.NET 1.1 on my web server.
What shall I do?I think that just means you need to run aspnet_regiis -i from a command prompt.
--
Message posted via http://www.sqlmonster.com|||This is from reporting services books online.
To register ASP.NET 1.1.4322, follow these steps:
From a command prompt, run
C:\WINDOWS\Microsoft.NET\Framework\v1.1.4322\aspnet_regiis.exe -i
Give the accounts <Computername>\ASPNET and Network Service (for Windows
Server 2003 systems only) read-write permission to two folders:
C:\WINDOWS\Microsoft.NET\Framework\v1.1.4322\Temporary ASP.NET Files
C:\WINDOWS\Temp
Re-run setup.
During setup, clear the Use Secure Socket Layer checkbox (if you do not have
a certificate for your Web server)
Hope this helps.
Nick Colebourn
"Mickeman" wrote:
> Hello,
> I'm trying install the evalution version of Reportingservices, but I recieve
> an error message that says that I must register ASP.NET 1.1 on my web server.
> What shall I do?
>|||Now it works, thank you for quick answer
Micke
"Nick Colebourn" wrote:
> This is from reporting services books online.
> To register ASP.NET 1.1.4322, follow these steps:
> From a command prompt, run
> C:\WINDOWS\Microsoft.NET\Framework\v1.1.4322\aspnet_regiis.exe -i
> Give the accounts <Computername>\ASPNET and Network Service (for Windows
> Server 2003 systems only) read-write permission to two folders:
> C:\WINDOWS\Microsoft.NET\Framework\v1.1.4322\Temporary ASP.NET Files
> C:\WINDOWS\Temp
> Re-run setup.
> During setup, clear the Use Secure Socket Layer checkbox (if you do not have
> a certificate for your Web server)
>
> Hope this helps.
> Nick Colebourn
> "Mickeman" wrote:
> > Hello,
> > I'm trying install the evalution version of Reportingservices, but I recieve
> > an error message that says that I must register ASP.NET 1.1 on my web server.
> > What shall I do?
> >
I'm trying install the evalution version of Reportingservices, but I recieve
an error message that says that I must register ASP.NET 1.1 on my web server.
What shall I do?I think that just means you need to run aspnet_regiis -i from a command prompt.
--
Message posted via http://www.sqlmonster.com|||This is from reporting services books online.
To register ASP.NET 1.1.4322, follow these steps:
From a command prompt, run
C:\WINDOWS\Microsoft.NET\Framework\v1.1.4322\aspnet_regiis.exe -i
Give the accounts <Computername>\ASPNET and Network Service (for Windows
Server 2003 systems only) read-write permission to two folders:
C:\WINDOWS\Microsoft.NET\Framework\v1.1.4322\Temporary ASP.NET Files
C:\WINDOWS\Temp
Re-run setup.
During setup, clear the Use Secure Socket Layer checkbox (if you do not have
a certificate for your Web server)
Hope this helps.
Nick Colebourn
"Mickeman" wrote:
> Hello,
> I'm trying install the evalution version of Reportingservices, but I recieve
> an error message that says that I must register ASP.NET 1.1 on my web server.
> What shall I do?
>|||Now it works, thank you for quick answer
Micke
"Nick Colebourn" wrote:
> This is from reporting services books online.
> To register ASP.NET 1.1.4322, follow these steps:
> From a command prompt, run
> C:\WINDOWS\Microsoft.NET\Framework\v1.1.4322\aspnet_regiis.exe -i
> Give the accounts <Computername>\ASPNET and Network Service (for Windows
> Server 2003 systems only) read-write permission to two folders:
> C:\WINDOWS\Microsoft.NET\Framework\v1.1.4322\Temporary ASP.NET Files
> C:\WINDOWS\Temp
> Re-run setup.
> During setup, clear the Use Secure Socket Layer checkbox (if you do not have
> a certificate for your Web server)
>
> Hope this helps.
> Nick Colebourn
> "Mickeman" wrote:
> > Hello,
> > I'm trying install the evalution version of Reportingservices, but I recieve
> > an error message that says that I must register ASP.NET 1.1 on my web server.
> > What shall I do?
> >
Instalation SQL Server
In an instalation of sql server appears an error message saying sql server
can't work with directories with more than 39 characters. The operative
system is W2000 Server.
Thank you."Alberto" <alberto@.nospam.com> wrote in message
news:eAJRbaYxDHA.2136@.TK2MSFTNGP10.phx.gbl...
> In an instalation of sql server appears an error message saying sql server
> can't work with directories with more than 39 characters. The operative
> system is W2000 Server.
Does it install with a shorter folder name? You may have found a limitation,
I've never created a folder that long...
Steve|||If I try to change the directory of instalation, the system is locked.
Thanks.
"Steve Thompson" <SteveThompson@.nomail.please> escribió en el mensaje
news:O5ppb9YxDHA.2456@.TK2MSFTNGP12.phx.gbl...
> "Alberto" <alberto@.nospam.com> wrote in message
> news:eAJRbaYxDHA.2136@.TK2MSFTNGP10.phx.gbl...
> > In an instalation of sql server appears an error message saying sql
server
> > can't work with directories with more than 39 characters. The operative
> > system is W2000 Server.
> Does it install with a shorter folder name? You may have found a
limitation,
> I've never created a folder that long...
> Steve
>|||Are you installing with an account that has proper permissions (local
administrator)?
And, that you cannot change the installed folder if you choose the 'Custom'
install path?
Steve
"Alberto" <alberto@.nospam.com> wrote in message
news:u3BFb2gxDHA.1740@.TK2MSFTNGP12.phx.gbl...
> If I try to change the directory of instalation, the system is locked.
> Thanks.
> "Steve Thompson" <SteveThompson@.nomail.please> escribió en el mensaje
> news:O5ppb9YxDHA.2456@.TK2MSFTNGP12.phx.gbl...
> > "Alberto" <alberto@.nospam.com> wrote in message
> > news:eAJRbaYxDHA.2136@.TK2MSFTNGP10.phx.gbl...
> > > In an instalation of sql server appears an error message saying sql
> server
> > > can't work with directories with more than 39 characters. The
operative
> > > system is W2000 Server.
> >
> > Does it install with a shorter folder name? You may have found a
> limitation,
> > I've never created a folder that long...
> >
> > Steve
> >
> >
>
can't work with directories with more than 39 characters. The operative
system is W2000 Server.
Thank you."Alberto" <alberto@.nospam.com> wrote in message
news:eAJRbaYxDHA.2136@.TK2MSFTNGP10.phx.gbl...
> In an instalation of sql server appears an error message saying sql server
> can't work with directories with more than 39 characters. The operative
> system is W2000 Server.
Does it install with a shorter folder name? You may have found a limitation,
I've never created a folder that long...
Steve|||If I try to change the directory of instalation, the system is locked.
Thanks.
"Steve Thompson" <SteveThompson@.nomail.please> escribió en el mensaje
news:O5ppb9YxDHA.2456@.TK2MSFTNGP12.phx.gbl...
> "Alberto" <alberto@.nospam.com> wrote in message
> news:eAJRbaYxDHA.2136@.TK2MSFTNGP10.phx.gbl...
> > In an instalation of sql server appears an error message saying sql
server
> > can't work with directories with more than 39 characters. The operative
> > system is W2000 Server.
> Does it install with a shorter folder name? You may have found a
limitation,
> I've never created a folder that long...
> Steve
>|||Are you installing with an account that has proper permissions (local
administrator)?
And, that you cannot change the installed folder if you choose the 'Custom'
install path?
Steve
"Alberto" <alberto@.nospam.com> wrote in message
news:u3BFb2gxDHA.1740@.TK2MSFTNGP12.phx.gbl...
> If I try to change the directory of instalation, the system is locked.
> Thanks.
> "Steve Thompson" <SteveThompson@.nomail.please> escribió en el mensaje
> news:O5ppb9YxDHA.2456@.TK2MSFTNGP12.phx.gbl...
> > "Alberto" <alberto@.nospam.com> wrote in message
> > news:eAJRbaYxDHA.2136@.TK2MSFTNGP10.phx.gbl...
> > > In an instalation of sql server appears an error message saying sql
> server
> > > can't work with directories with more than 39 characters. The
operative
> > > system is W2000 Server.
> >
> > Does it install with a shorter folder name? You may have found a
> limitation,
> > I've never created a folder that long...
> >
> > Steve
> >
> >
>
Instalation of SQL SERVER 2005
I 'm trying to install SQL server tools and I have this message :
A component that you have specified in the ADD_LOCAL property is already installed. To upgrade the existing component, refer to the template.ini and set the UPGRADE property to the name of the component.
I can't understand what a have to do to resolve this
Thanks
I suspect you have SQL Express already installed on your machine. You will need to uninstall the tools that are installed with Express before you can install the tools that ships with the full edition of SQL Server.
jeff.
Instalation MSDE
When I execute the following instruction
OSQL /USA /P
presents the following error message:
[Microsoft]{ODBC SQL Server Driver][SHARED MEMORY]
SQL Server does not exist or access denied.
[Microsoft]{ODBC SQL Server Driver] Connectionopen
(connect())
Operating system WINDOWS 98 2 Edition
When I verify in the configurations / Panel of Control appeared a new icon
(MSDTC don't remind the acronym). When I execute and requested that selects
the service in what doesn't appear noneEither sa has a non-null password or MSDE is not installed as the default
instance. Use osql /l to list the available servers.
--
Jacco Schalkwijk MCDBA, MCSD, MCSE
Database Administrator
Eurostop Ltd.
"Frank Dulk" <fdulk@.bol.com.br> wrote in message
news:#YYYXxFTDHA.1324@.TK2MSFTNGP11.phx.gbl...
> When I execute the following instruction
> OSQL /USA /P
> presents the following error message:
> [Microsoft]{ODBC SQL Server Driver][SHARED MEMORY]
> SQL Server does not exist or access denied.
> [Microsoft]{ODBC SQL Server Driver] Connectionopen
> (connect())
> Operating system WINDOWS 98 2 Edition
> When I verify in the configurations / Panel of Control appeared a new icon
> (MSDTC don't remind the acronym). When I execute and requested that
selects
> the service in what doesn't appear none
>
OSQL /USA /P
presents the following error message:
[Microsoft]{ODBC SQL Server Driver][SHARED MEMORY]
SQL Server does not exist or access denied.
[Microsoft]{ODBC SQL Server Driver] Connectionopen
(connect())
Operating system WINDOWS 98 2 Edition
When I verify in the configurations / Panel of Control appeared a new icon
(MSDTC don't remind the acronym). When I execute and requested that selects
the service in what doesn't appear noneEither sa has a non-null password or MSDE is not installed as the default
instance. Use osql /l to list the available servers.
--
Jacco Schalkwijk MCDBA, MCSD, MCSE
Database Administrator
Eurostop Ltd.
"Frank Dulk" <fdulk@.bol.com.br> wrote in message
news:#YYYXxFTDHA.1324@.TK2MSFTNGP11.phx.gbl...
> When I execute the following instruction
> OSQL /USA /P
> presents the following error message:
> [Microsoft]{ODBC SQL Server Driver][SHARED MEMORY]
> SQL Server does not exist or access denied.
> [Microsoft]{ODBC SQL Server Driver] Connectionopen
> (connect())
> Operating system WINDOWS 98 2 Edition
> When I verify in the configurations / Panel of Control appeared a new icon
> (MSDTC don't remind the acronym). When I execute and requested that
selects
> the service in what doesn't appear none
>
Friday, February 24, 2012
Inserting SOAP formatted message data into a SQL table -- OPENXML
I have a SOAP formatted message. I am passing this message as a string from
a
C# client to a SQL Stored Procedure.
I would like to read this SOAP formatted message and store the data in the
SOAP message in appropriate columns in a SQL table. How can I achieve this?
Can OPENXML be used for this purpose?
--
ggCould you just store in a nvarchar(max) ?
William Stacey [MVP]
"gudia" <gudia@.discussions.microsoft.com> wrote in message
news:B85E4E76-A4FB-49A7-881A-A1795CE80728@.microsoft.com...
> Is configuring IIS to be used in conjunction with SQLXML a requirement for
> the question I am asking?
> My eventual goal is to insert the data present in the SOAP message into a
> SQL table.
> Please let me know how I can achieve this goal.
> Thanks|||There are a couple of approaches. You could pass the entire SOAP XML doc to
a stored procedure and use OPENXML to shred it into tables, or you could
create an annotated XSD schema that maps the elements/attributes in your
SOAP message to the tables/column in the database and use the SQLXML Bulk
Load component.
Neither of these approaches requires a SQLXML IIS site.
Cheers,
Graeme
Graeme Malcolm
Principal Technologist
Content Master
- a member of CM Group Ltd.
www.contentmaster.com
"gudia" <gudia@.discussions.microsoft.com> wrote in message
news:B85E4E76-A4FB-49A7-881A-A1795CE80728@.microsoft.com...
Is configuring IIS to be used in conjunction with SQLXML a requirement for
the question I am asking?
My eventual goal is to insert the data present in the SOAP message into a
SQL table.
Please let me know how I can achieve this goal.
Thanks
a
C# client to a SQL Stored Procedure.
I would like to read this SOAP formatted message and store the data in the
SOAP message in appropriate columns in a SQL table. How can I achieve this?
Can OPENXML be used for this purpose?
--
ggCould you just store in a nvarchar(max) ?
William Stacey [MVP]
"gudia" <gudia@.discussions.microsoft.com> wrote in message
news:B85E4E76-A4FB-49A7-881A-A1795CE80728@.microsoft.com...
> Is configuring IIS to be used in conjunction with SQLXML a requirement for
> the question I am asking?
> My eventual goal is to insert the data present in the SOAP message into a
> SQL table.
> Please let me know how I can achieve this goal.
> Thanks|||There are a couple of approaches. You could pass the entire SOAP XML doc to
a stored procedure and use OPENXML to shred it into tables, or you could
create an annotated XSD schema that maps the elements/attributes in your
SOAP message to the tables/column in the database and use the SQLXML Bulk
Load component.
Neither of these approaches requires a SQLXML IIS site.
Cheers,
Graeme
Graeme Malcolm
Principal Technologist
Content Master
- a member of CM Group Ltd.
www.contentmaster.com
"gudia" <gudia@.discussions.microsoft.com> wrote in message
news:B85E4E76-A4FB-49A7-881A-A1795CE80728@.microsoft.com...
Is configuring IIS to be used in conjunction with SQLXML a requirement for
the question I am asking?
My eventual goal is to insert the data present in the SOAP message into a
SQL table.
Please let me know how I can achieve this goal.
Thanks
Inserting SOAP formatted message data into a SQL table -- OPEN
I have displaying my SOAP message below. Could you show me what T-SQL
statement using OPENXML or otherwise I can use to import the data in this
SOAP message into various columns in a SQL table.
My SQL table has the following columns:
LogEntry varchar(255)
Message varchar(255)
Title varchar(255)
Category varchar(50)
Priority int
EventID int
Severity varchar(255)
MachineName varchar(50)
TimeStampVal datetime
ErrorMessages varchar(255)
ExtendedProperties varchar(255)
AppDomainName varchar(50)
ProcessID int
ProcessName varchar(255)
ThreadName varchar(50)
<SOAP-ENV:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlns:SOAP-ENC="http://schemas.xmlsoap.org/soap/encoding/"
xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/"
xmlns:clr="http://schemas.microsoft.com/soap/encoding/clr/1.0"
SOAP-ENV:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/">
<SOAP-ENV:Body>
<a1:LogEntry id="ref-1"
xmlns:a1="http://schemas.microsoft.com/clr/nsassem/Microsoft.Practices.Enter
priseLibrary.Logging/Microsoft.Practices.EnterpriseLibrary.Logging%2C%20Vers
ion%3D1.0.0. 0%2C%20Culture%3Dneutral%2C%20PublicKeyT
oken%3Dnull">
<message id="ref-3">Msg successfully populated</message>
<title id="ref-4">Title1</title>
<category id="ref-5">Cat1</category>
<priority>100</priority>
<eventId>16</eventId>
<severity>Information</severity>
<machineName id="ref-6">MACH1</machineName>
<timeStamp>2005-05-20T15:24:18.4850496-05:00</timeStamp>
<errorMessages xsi:null="1"/>
<extendedProperties xsi:null="1"/>
<appDomainName id="ref-7">B1.exe</appDomainName>
<processId id="ref-8">3932</processId>
<processName id="ref-9">C:\B1\bin\Debug\B1.exe</processName>
<threadName xsi:null="1"/>
<win32ThreadId id="ref-10">244</win32ThreadId>
</a1:LogEntry>
</SOAP-ENV:Body>
</SOAP-ENV:Envelope>
--
gg
"Graeme Malcolm" wrote:
> There are a couple of approaches. You could pass the entire SOAP XML doc t
o
> a stored procedure and use OPENXML to shred it into tables, or you could
> create an annotated XSD schema that maps the elements/attributes in your
> SOAP message to the tables/column in the database and use the SQLXML Bulk
> Load component.
> Neither of these approaches requires a SQLXML IIS site.
> Cheers,
> Graeme
> --
> Graeme Malcolm
> Principal Technologist
> Content Master
> - a member of CM Group Ltd.
> www.contentmaster.com
>
> "gudia" <gudia@.discussions.microsoft.com> wrote in message
> news:B85E4E76-A4FB-49A7-881A-A1795CE80728@.microsoft.com...
> Is configuring IIS to be used in conjunction with SQLXML a requirement for
> the question I am asking?
> My eventual goal is to insert the data present in the SOAP message into a
> SQL table.
> Please let me know how I can achieve this goal.
> Thanks
>
>Here's one way (I wasn't sure what you want in the LogEntry column, since
that's an XML element that contains all the others - so I used the id
attribute). This example uses a temporary table with the columns you
specified and I've hardcoded the SOAP message as a variable - in reality
you'd pass it to a stored procedure as a parameter. I suggest you take some
time to examine the documentation on OPENXML in Books Online to tweak this
to do exactly what you want it to.
USE Tempdb
CREATE TABLE #TestTable
(
LogEntry varchar(255),
Message varchar(255),
Title varchar(255),
Category varchar(50),
Priority int,
EventID int,
Severity varchar(255),
MachineName varchar(50),
TimeStampVal datetime,
ErrorMessages varchar(255),
ExtendedProperties varchar(255),
AppDomainName varchar(50),
ProcessID int,
ProcessName varchar(255),
ThreadName varchar(50)
)
DECLARE @.doc nvarchar(2000)
SET @.doc = '<SOAP-ENV:Envelope
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlns:SOAP-ENC="http://schemas.xmlsoap.org/soap/encoding/"
xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/"
xmlns:clr="http://schemas.microsoft.com/soap/encoding/clr/1.0"
SOAP-ENV:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/">
<SOAP-ENV:Body>
<a1:LogEntry id="ref-1"
xmlns:a1="http://schemas.microsoft.com/clr/nsassem/Microsoft.Practices.Enter
priseLibrary.Logging/Microsoft.Practices.EnterpriseLibrary.Logging%2C%20Vers
ion%3D1.0.0. 0%2C%20Culture%3Dneutral%2C%20PublicKeyT
oken%3Dnull">
<message id="ref-3">Msg successfully populated</message>
<title id="ref-4">Title1</title>
<category id="ref-5">Cat1</category>
<priority>100</priority>
<eventId>16</eventId>
<severity>Information</severity>
<machineName id="ref-6">MACH1</machineName>
<timeStamp>2005-05-20T15:24:18.4850496-05:00</timeStamp>
<errorMessages xsi:null="1"/>
<extendedProperties xsi:null="1"/>
<appDomainName id="ref-7">B1.exe</appDomainName>
<processId id="ref-8">3932</processId>
<processName id="ref-9">C:\B1\bin\Debug\B1.exe</processName>
<threadName xsi:null="1"/>
<win32ThreadId id="ref-10">244</win32ThreadId>
</a1:LogEntry>
</SOAP-ENV:Body>
</SOAP-ENV:Envelope>
'
DECLARE @.hDoc int
EXEC sp_xml_preparedocument @.hDoc OUTPUT, @.doc, '<ns
xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/"
xmlns:a1="http://schemas.microsoft.com/clr/nsassem/Microsoft.Practices.Enter
priseLibrary.Logging/Microsoft.Practices.EnterpriseLibrary.Logging%2C%20Vers
ion%3D1.0.0. 0%2C%20Culture%3Dneutral%2C%20PublicKeyT
oken%3Dnull"/>'
INSERT #TestTable
SELECT * FROM OPENXML(@.hDoc, 'SOAP-ENV:Envelope/SOAP-ENV:Body/a1:LogEntry',
2)
WITH
(
LogEntry varchar(255) '@.id',
message varchar(255),
title varchar(255),
category varchar(50),
priority int,
eventId int,
severity varchar(255),
machineName varchar(50),
timeStampVal datetime,
errorMessages varchar(255),
extendedProperties varchar(255),
appDomainName varchar(50),
processId int,
processName varchar(255),
threadName varchar(50)
)
SELECT * FROM #TestTable
DROP TABLE #TestTable
Graeme Malcolm
Principal Technologist
Content Master
- a member of CM Group Ltd.
www.contentmaster.com
"gudia" <gudia@.discussions.microsoft.com> wrote in message
news:B85C3731-29C4-4503-9A4A-237B7F83A5B7@.microsoft.com...
I have displaying my SOAP message below. Could you show me what T-SQL
statement using OPENXML or otherwise I can use to import the data in this
SOAP message into various columns in a SQL table.
My SQL table has the following columns:
LogEntry varchar(255)
Message varchar(255)
Title varchar(255)
Category varchar(50)
Priority int
EventID int
Severity varchar(255)
MachineName varchar(50)
TimeStampVal datetime
ErrorMessages varchar(255)
ExtendedProperties varchar(255)
AppDomainName varchar(50)
ProcessID int
ProcessName varchar(255)
ThreadName varchar(50)
<SOAP-ENV:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlns:SOAP-ENC="http://schemas.xmlsoap.org/soap/encoding/"
xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/"
xmlns:clr="http://schemas.microsoft.com/soap/encoding/clr/1.0"
SOAP-ENV:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/">
<SOAP-ENV:Body>
<a1:LogEntry id="ref-1"
xmlns:a1="http://schemas.microsoft.com/clr/nsassem/Microsoft.Practices.Enter
priseLibrary.Logging/Microsoft.Practices.EnterpriseLibrary.Logging%2C%20Vers
ion%3D1.0.0. 0%2C%20Culture%3Dneutral%2C%20PublicKeyT
oken%3Dnull">
<message id="ref-3">Msg successfully populated</message>
<title id="ref-4">Title1</title>
<category id="ref-5">Cat1</category>
<priority>100</priority>
<eventId>16</eventId>
<severity>Information</severity>
<machineName id="ref-6">MACH1</machineName>
<timeStamp>2005-05-20T15:24:18.4850496-05:00</timeStamp>
<errorMessages xsi:null="1"/>
<extendedProperties xsi:null="1"/>
<appDomainName id="ref-7">B1.exe</appDomainName>
<processId id="ref-8">3932</processId>
<processName id="ref-9">C:\B1\bin\Debug\B1.exe</processName>
<threadName xsi:null="1"/>
<win32ThreadId id="ref-10">244</win32ThreadId>
</a1:LogEntry>
</SOAP-ENV:Body>
</SOAP-ENV:Envelope>
--
gg
"Graeme Malcolm" wrote:
> There are a couple of approaches. You could pass the entire SOAP XML doc
> to
> a stored procedure and use OPENXML to shred it into tables, or you could
> create an annotated XSD schema that maps the elements/attributes in your
> SOAP message to the tables/column in the database and use the SQLXML Bulk
> Load component.
> Neither of these approaches requires a SQLXML IIS site.
> Cheers,
> Graeme
> --
> Graeme Malcolm
> Principal Technologist
> Content Master
> - a member of CM Group Ltd.
> www.contentmaster.com
>
> "gudia" <gudia@.discussions.microsoft.com> wrote in message
> news:B85E4E76-A4FB-49A7-881A-A1795CE80728@.microsoft.com...
> Is configuring IIS to be used in conjunction with SQLXML a requirement for
> the question I am asking?
> My eventual goal is to insert the data present in the SOAP message into a
> SQL table.
> Please let me know how I can achieve this goal.
> Thanks
>
>|||Thanks so much Graeme. That worked.
Appreciate your help.
"Graeme Malcolm" wrote:
> Here's one way (I wasn't sure what you want in the LogEntry column, since
> that's an XML element that contains all the others - so I used the id
> attribute). This example uses a temporary table with the columns you
> specified and I've hardcoded the SOAP message as a variable - in reality
> you'd pass it to a stored procedure as a parameter. I suggest you take so
me
> time to examine the documentation on OPENXML in Books Online to tweak this
> to do exactly what you want it to.
> USE Tempdb
> CREATE TABLE #TestTable
> (
> LogEntry varchar(255),
> Message varchar(255),
> Title varchar(255),
> Category varchar(50),
> Priority int,
> EventID int,
> Severity varchar(255),
> MachineName varchar(50),
> TimeStampVal datetime,
> ErrorMessages varchar(255),
> ExtendedProperties varchar(255),
> AppDomainName varchar(50),
> ProcessID int,
> ProcessName varchar(255),
> ThreadName varchar(50)
> )
> DECLARE @.doc nvarchar(2000)
> SET @.doc = '<SOAP-ENV:Envelope
> xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
> xmlns:xsd="http://www.w3.org/2001/XMLSchema"
> xmlns:SOAP-ENC="http://schemas.xmlsoap.org/soap/encoding/"
> xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/"
> xmlns:clr="http://schemas.microsoft.com/soap/encoding/clr/1.0"
> SOAP-ENV:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/">
> <SOAP-ENV:Body>
> <a1:LogEntry id="ref-1"
> xmlns:a1="http://schemas.microsoft.com/clr/nsassem/Microsoft.Practices.Ent
erpriseLibrary.Logging/Microsoft.Practices.EnterpriseLibrary.Logging%2C%20Ve
rsion%3D1.0.0. 0%2C%20Culture%3Dneutral%2C%20PublicKeyT
oken%3Dnull">
> <message id="ref-3">Msg successfully populated</message>
> <title id="ref-4">Title1</title>
> <category id="ref-5">Cat1</category>
> <priority>100</priority>
> <eventId>16</eventId>
> <severity>Information</severity>
> <machineName id="ref-6">MACH1</machineName>
> <timeStamp>2005-05-20T15:24:18.4850496-05:00</timeStamp>
> <errorMessages xsi:null="1"/>
> <extendedProperties xsi:null="1"/>
> <appDomainName id="ref-7">B1.exe</appDomainName>
> <processId id="ref-8">3932</processId>
> <processName id="ref-9">C:\B1\bin\Debug\B1.exe</processName>
> <threadName xsi:null="1"/>
> <win32ThreadId id="ref-10">244</win32ThreadId>
> </a1:LogEntry>
> </SOAP-ENV:Body>
> </SOAP-ENV:Envelope>
> '
> DECLARE @.hDoc int
> EXEC sp_xml_preparedocument @.hDoc OUTPUT, @.doc, '<ns
> xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/"
> xmlns:a1="http://schemas.microsoft.com/clr/nsassem/Microsoft.Practices.Ent
erpriseLibrary.Logging/Microsoft.Practices.EnterpriseLibrary.Logging%2C%20Ve
rsion%3D1.0.0. 0%2C%20Culture%3Dneutral%2C%20PublicKeyT
oken%3Dnull"/>'
> INSERT #TestTable
> SELECT * FROM OPENXML(@.hDoc, 'SOAP-ENV:Envelope/SOAP-ENV:Body/a1:LogEntry'
,
> 2)
> WITH
> (
> LogEntry varchar(255) '@.id',
> message varchar(255),
> title varchar(255),
> category varchar(50),
> priority int,
> eventId int,
> severity varchar(255),
> machineName varchar(50),
> timeStampVal datetime,
> errorMessages varchar(255),
> extendedProperties varchar(255),
> appDomainName varchar(50),
> processId int,
> processName varchar(255),
> threadName varchar(50)
> )
> SELECT * FROM #TestTable
> DROP TABLE #TestTable
> --
> Graeme Malcolm
> Principal Technologist
> Content Master
> - a member of CM Group Ltd.
> www.contentmaster.com
>
> "gudia" <gudia@.discussions.microsoft.com> wrote in message
> news:B85C3731-29C4-4503-9A4A-237B7F83A5B7@.microsoft.com...
> I have displaying my SOAP message below. Could you show me what T-SQL
> statement using OPENXML or otherwise I can use to import the data in this
> SOAP message into various columns in a SQL table.
> My SQL table has the following columns:
> LogEntry varchar(255)
> Message varchar(255)
> Title varchar(255)
> Category varchar(50)
> Priority int
> EventID int
> Severity varchar(255)
> MachineName varchar(50)
> TimeStampVal datetime
> ErrorMessages varchar(255)
> ExtendedProperties varchar(255)
> AppDomainName varchar(50)
> ProcessID int
> ProcessName varchar(255)
> ThreadName varchar(50)
> <SOAP-ENV:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
> xmlns:xsd="http://www.w3.org/2001/XMLSchema"
> xmlns:SOAP-ENC="http://schemas.xmlsoap.org/soap/encoding/"
> xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/"
> xmlns:clr="http://schemas.microsoft.com/soap/encoding/clr/1.0"
> SOAP-ENV:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/">
> <SOAP-ENV:Body>
> <a1:LogEntry id="ref-1"
> xmlns:a1="http://schemas.microsoft.com/clr/nsassem/Microsoft.Practices.Ent
erpriseLibrary.Logging/Microsoft.Practices.EnterpriseLibrary.Logging%2C%20Ve
rsion%3D1.0.0. 0%2C%20Culture%3Dneutral%2C%20PublicKeyT
oken%3Dnull">
> <message id="ref-3">Msg successfully populated</message>
> <title id="ref-4">Title1</title>
> <category id="ref-5">Cat1</category>
> <priority>100</priority>
> <eventId>16</eventId>
> <severity>Information</severity>
> <machineName id="ref-6">MACH1</machineName>
> <timeStamp>2005-05-20T15:24:18.4850496-05:00</timeStamp>
> <errorMessages xsi:null="1"/>
> <extendedProperties xsi:null="1"/>
> <appDomainName id="ref-7">B1.exe</appDomainName>
> <processId id="ref-8">3932</processId>
> <processName id="ref-9">C:\B1\bin\Debug\B1.exe</processName>
> <threadName xsi:null="1"/>
> <win32ThreadId id="ref-10">244</win32ThreadId>
> </a1:LogEntry>
> </SOAP-ENV:Body>
> </SOAP-ENV:Envelope>
> --
> gg
>
> "Graeme Malcolm" wrote:
>
>
>
statement using OPENXML or otherwise I can use to import the data in this
SOAP message into various columns in a SQL table.
My SQL table has the following columns:
LogEntry varchar(255)
Message varchar(255)
Title varchar(255)
Category varchar(50)
Priority int
EventID int
Severity varchar(255)
MachineName varchar(50)
TimeStampVal datetime
ErrorMessages varchar(255)
ExtendedProperties varchar(255)
AppDomainName varchar(50)
ProcessID int
ProcessName varchar(255)
ThreadName varchar(50)
<SOAP-ENV:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlns:SOAP-ENC="http://schemas.xmlsoap.org/soap/encoding/"
xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/"
xmlns:clr="http://schemas.microsoft.com/soap/encoding/clr/1.0"
SOAP-ENV:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/">
<SOAP-ENV:Body>
<a1:LogEntry id="ref-1"
xmlns:a1="http://schemas.microsoft.com/clr/nsassem/Microsoft.Practices.Enter
priseLibrary.Logging/Microsoft.Practices.EnterpriseLibrary.Logging%2C%20Vers
ion%3D1.0.0. 0%2C%20Culture%3Dneutral%2C%20PublicKeyT
oken%3Dnull">
<message id="ref-3">Msg successfully populated</message>
<title id="ref-4">Title1</title>
<category id="ref-5">Cat1</category>
<priority>100</priority>
<eventId>16</eventId>
<severity>Information</severity>
<machineName id="ref-6">MACH1</machineName>
<timeStamp>2005-05-20T15:24:18.4850496-05:00</timeStamp>
<errorMessages xsi:null="1"/>
<extendedProperties xsi:null="1"/>
<appDomainName id="ref-7">B1.exe</appDomainName>
<processId id="ref-8">3932</processId>
<processName id="ref-9">C:\B1\bin\Debug\B1.exe</processName>
<threadName xsi:null="1"/>
<win32ThreadId id="ref-10">244</win32ThreadId>
</a1:LogEntry>
</SOAP-ENV:Body>
</SOAP-ENV:Envelope>
--
gg
"Graeme Malcolm" wrote:
> There are a couple of approaches. You could pass the entire SOAP XML doc t
o
> a stored procedure and use OPENXML to shred it into tables, or you could
> create an annotated XSD schema that maps the elements/attributes in your
> SOAP message to the tables/column in the database and use the SQLXML Bulk
> Load component.
> Neither of these approaches requires a SQLXML IIS site.
> Cheers,
> Graeme
> --
> Graeme Malcolm
> Principal Technologist
> Content Master
> - a member of CM Group Ltd.
> www.contentmaster.com
>
> "gudia" <gudia@.discussions.microsoft.com> wrote in message
> news:B85E4E76-A4FB-49A7-881A-A1795CE80728@.microsoft.com...
> Is configuring IIS to be used in conjunction with SQLXML a requirement for
> the question I am asking?
> My eventual goal is to insert the data present in the SOAP message into a
> SQL table.
> Please let me know how I can achieve this goal.
> Thanks
>
>Here's one way (I wasn't sure what you want in the LogEntry column, since
that's an XML element that contains all the others - so I used the id
attribute). This example uses a temporary table with the columns you
specified and I've hardcoded the SOAP message as a variable - in reality
you'd pass it to a stored procedure as a parameter. I suggest you take some
time to examine the documentation on OPENXML in Books Online to tweak this
to do exactly what you want it to.
USE Tempdb
CREATE TABLE #TestTable
(
LogEntry varchar(255),
Message varchar(255),
Title varchar(255),
Category varchar(50),
Priority int,
EventID int,
Severity varchar(255),
MachineName varchar(50),
TimeStampVal datetime,
ErrorMessages varchar(255),
ExtendedProperties varchar(255),
AppDomainName varchar(50),
ProcessID int,
ProcessName varchar(255),
ThreadName varchar(50)
)
DECLARE @.doc nvarchar(2000)
SET @.doc = '<SOAP-ENV:Envelope
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlns:SOAP-ENC="http://schemas.xmlsoap.org/soap/encoding/"
xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/"
xmlns:clr="http://schemas.microsoft.com/soap/encoding/clr/1.0"
SOAP-ENV:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/">
<SOAP-ENV:Body>
<a1:LogEntry id="ref-1"
xmlns:a1="http://schemas.microsoft.com/clr/nsassem/Microsoft.Practices.Enter
priseLibrary.Logging/Microsoft.Practices.EnterpriseLibrary.Logging%2C%20Vers
ion%3D1.0.0. 0%2C%20Culture%3Dneutral%2C%20PublicKeyT
oken%3Dnull">
<message id="ref-3">Msg successfully populated</message>
<title id="ref-4">Title1</title>
<category id="ref-5">Cat1</category>
<priority>100</priority>
<eventId>16</eventId>
<severity>Information</severity>
<machineName id="ref-6">MACH1</machineName>
<timeStamp>2005-05-20T15:24:18.4850496-05:00</timeStamp>
<errorMessages xsi:null="1"/>
<extendedProperties xsi:null="1"/>
<appDomainName id="ref-7">B1.exe</appDomainName>
<processId id="ref-8">3932</processId>
<processName id="ref-9">C:\B1\bin\Debug\B1.exe</processName>
<threadName xsi:null="1"/>
<win32ThreadId id="ref-10">244</win32ThreadId>
</a1:LogEntry>
</SOAP-ENV:Body>
</SOAP-ENV:Envelope>
'
DECLARE @.hDoc int
EXEC sp_xml_preparedocument @.hDoc OUTPUT, @.doc, '<ns
xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/"
xmlns:a1="http://schemas.microsoft.com/clr/nsassem/Microsoft.Practices.Enter
priseLibrary.Logging/Microsoft.Practices.EnterpriseLibrary.Logging%2C%20Vers
ion%3D1.0.0. 0%2C%20Culture%3Dneutral%2C%20PublicKeyT
oken%3Dnull"/>'
INSERT #TestTable
SELECT * FROM OPENXML(@.hDoc, 'SOAP-ENV:Envelope/SOAP-ENV:Body/a1:LogEntry',
2)
WITH
(
LogEntry varchar(255) '@.id',
message varchar(255),
title varchar(255),
category varchar(50),
priority int,
eventId int,
severity varchar(255),
machineName varchar(50),
timeStampVal datetime,
errorMessages varchar(255),
extendedProperties varchar(255),
appDomainName varchar(50),
processId int,
processName varchar(255),
threadName varchar(50)
)
SELECT * FROM #TestTable
DROP TABLE #TestTable
Graeme Malcolm
Principal Technologist
Content Master
- a member of CM Group Ltd.
www.contentmaster.com
"gudia" <gudia@.discussions.microsoft.com> wrote in message
news:B85C3731-29C4-4503-9A4A-237B7F83A5B7@.microsoft.com...
I have displaying my SOAP message below. Could you show me what T-SQL
statement using OPENXML or otherwise I can use to import the data in this
SOAP message into various columns in a SQL table.
My SQL table has the following columns:
LogEntry varchar(255)
Message varchar(255)
Title varchar(255)
Category varchar(50)
Priority int
EventID int
Severity varchar(255)
MachineName varchar(50)
TimeStampVal datetime
ErrorMessages varchar(255)
ExtendedProperties varchar(255)
AppDomainName varchar(50)
ProcessID int
ProcessName varchar(255)
ThreadName varchar(50)
<SOAP-ENV:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlns:SOAP-ENC="http://schemas.xmlsoap.org/soap/encoding/"
xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/"
xmlns:clr="http://schemas.microsoft.com/soap/encoding/clr/1.0"
SOAP-ENV:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/">
<SOAP-ENV:Body>
<a1:LogEntry id="ref-1"
xmlns:a1="http://schemas.microsoft.com/clr/nsassem/Microsoft.Practices.Enter
priseLibrary.Logging/Microsoft.Practices.EnterpriseLibrary.Logging%2C%20Vers
ion%3D1.0.0. 0%2C%20Culture%3Dneutral%2C%20PublicKeyT
oken%3Dnull">
<message id="ref-3">Msg successfully populated</message>
<title id="ref-4">Title1</title>
<category id="ref-5">Cat1</category>
<priority>100</priority>
<eventId>16</eventId>
<severity>Information</severity>
<machineName id="ref-6">MACH1</machineName>
<timeStamp>2005-05-20T15:24:18.4850496-05:00</timeStamp>
<errorMessages xsi:null="1"/>
<extendedProperties xsi:null="1"/>
<appDomainName id="ref-7">B1.exe</appDomainName>
<processId id="ref-8">3932</processId>
<processName id="ref-9">C:\B1\bin\Debug\B1.exe</processName>
<threadName xsi:null="1"/>
<win32ThreadId id="ref-10">244</win32ThreadId>
</a1:LogEntry>
</SOAP-ENV:Body>
</SOAP-ENV:Envelope>
--
gg
"Graeme Malcolm" wrote:
> There are a couple of approaches. You could pass the entire SOAP XML doc
> to
> a stored procedure and use OPENXML to shred it into tables, or you could
> create an annotated XSD schema that maps the elements/attributes in your
> SOAP message to the tables/column in the database and use the SQLXML Bulk
> Load component.
> Neither of these approaches requires a SQLXML IIS site.
> Cheers,
> Graeme
> --
> Graeme Malcolm
> Principal Technologist
> Content Master
> - a member of CM Group Ltd.
> www.contentmaster.com
>
> "gudia" <gudia@.discussions.microsoft.com> wrote in message
> news:B85E4E76-A4FB-49A7-881A-A1795CE80728@.microsoft.com...
> Is configuring IIS to be used in conjunction with SQLXML a requirement for
> the question I am asking?
> My eventual goal is to insert the data present in the SOAP message into a
> SQL table.
> Please let me know how I can achieve this goal.
> Thanks
>
>|||Thanks so much Graeme. That worked.
Appreciate your help.
"Graeme Malcolm" wrote:
> Here's one way (I wasn't sure what you want in the LogEntry column, since
> that's an XML element that contains all the others - so I used the id
> attribute). This example uses a temporary table with the columns you
> specified and I've hardcoded the SOAP message as a variable - in reality
> you'd pass it to a stored procedure as a parameter. I suggest you take so
me
> time to examine the documentation on OPENXML in Books Online to tweak this
> to do exactly what you want it to.
> USE Tempdb
> CREATE TABLE #TestTable
> (
> LogEntry varchar(255),
> Message varchar(255),
> Title varchar(255),
> Category varchar(50),
> Priority int,
> EventID int,
> Severity varchar(255),
> MachineName varchar(50),
> TimeStampVal datetime,
> ErrorMessages varchar(255),
> ExtendedProperties varchar(255),
> AppDomainName varchar(50),
> ProcessID int,
> ProcessName varchar(255),
> ThreadName varchar(50)
> )
> DECLARE @.doc nvarchar(2000)
> SET @.doc = '<SOAP-ENV:Envelope
> xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
> xmlns:xsd="http://www.w3.org/2001/XMLSchema"
> xmlns:SOAP-ENC="http://schemas.xmlsoap.org/soap/encoding/"
> xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/"
> xmlns:clr="http://schemas.microsoft.com/soap/encoding/clr/1.0"
> SOAP-ENV:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/">
> <SOAP-ENV:Body>
> <a1:LogEntry id="ref-1"
> xmlns:a1="http://schemas.microsoft.com/clr/nsassem/Microsoft.Practices.Ent
erpriseLibrary.Logging/Microsoft.Practices.EnterpriseLibrary.Logging%2C%20Ve
rsion%3D1.0.0. 0%2C%20Culture%3Dneutral%2C%20PublicKeyT
oken%3Dnull">
> <message id="ref-3">Msg successfully populated</message>
> <title id="ref-4">Title1</title>
> <category id="ref-5">Cat1</category>
> <priority>100</priority>
> <eventId>16</eventId>
> <severity>Information</severity>
> <machineName id="ref-6">MACH1</machineName>
> <timeStamp>2005-05-20T15:24:18.4850496-05:00</timeStamp>
> <errorMessages xsi:null="1"/>
> <extendedProperties xsi:null="1"/>
> <appDomainName id="ref-7">B1.exe</appDomainName>
> <processId id="ref-8">3932</processId>
> <processName id="ref-9">C:\B1\bin\Debug\B1.exe</processName>
> <threadName xsi:null="1"/>
> <win32ThreadId id="ref-10">244</win32ThreadId>
> </a1:LogEntry>
> </SOAP-ENV:Body>
> </SOAP-ENV:Envelope>
> '
> DECLARE @.hDoc int
> EXEC sp_xml_preparedocument @.hDoc OUTPUT, @.doc, '<ns
> xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/"
> xmlns:a1="http://schemas.microsoft.com/clr/nsassem/Microsoft.Practices.Ent
erpriseLibrary.Logging/Microsoft.Practices.EnterpriseLibrary.Logging%2C%20Ve
rsion%3D1.0.0. 0%2C%20Culture%3Dneutral%2C%20PublicKeyT
oken%3Dnull"/>'
> INSERT #TestTable
> SELECT * FROM OPENXML(@.hDoc, 'SOAP-ENV:Envelope/SOAP-ENV:Body/a1:LogEntry'
,
> 2)
> WITH
> (
> LogEntry varchar(255) '@.id',
> message varchar(255),
> title varchar(255),
> category varchar(50),
> priority int,
> eventId int,
> severity varchar(255),
> machineName varchar(50),
> timeStampVal datetime,
> errorMessages varchar(255),
> extendedProperties varchar(255),
> appDomainName varchar(50),
> processId int,
> processName varchar(255),
> threadName varchar(50)
> )
> SELECT * FROM #TestTable
> DROP TABLE #TestTable
> --
> Graeme Malcolm
> Principal Technologist
> Content Master
> - a member of CM Group Ltd.
> www.contentmaster.com
>
> "gudia" <gudia@.discussions.microsoft.com> wrote in message
> news:B85C3731-29C4-4503-9A4A-237B7F83A5B7@.microsoft.com...
> I have displaying my SOAP message below. Could you show me what T-SQL
> statement using OPENXML or otherwise I can use to import the data in this
> SOAP message into various columns in a SQL table.
> My SQL table has the following columns:
> LogEntry varchar(255)
> Message varchar(255)
> Title varchar(255)
> Category varchar(50)
> Priority int
> EventID int
> Severity varchar(255)
> MachineName varchar(50)
> TimeStampVal datetime
> ErrorMessages varchar(255)
> ExtendedProperties varchar(255)
> AppDomainName varchar(50)
> ProcessID int
> ProcessName varchar(255)
> ThreadName varchar(50)
> <SOAP-ENV:Envelope xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
> xmlns:xsd="http://www.w3.org/2001/XMLSchema"
> xmlns:SOAP-ENC="http://schemas.xmlsoap.org/soap/encoding/"
> xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/"
> xmlns:clr="http://schemas.microsoft.com/soap/encoding/clr/1.0"
> SOAP-ENV:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/">
> <SOAP-ENV:Body>
> <a1:LogEntry id="ref-1"
> xmlns:a1="http://schemas.microsoft.com/clr/nsassem/Microsoft.Practices.Ent
erpriseLibrary.Logging/Microsoft.Practices.EnterpriseLibrary.Logging%2C%20Ve
rsion%3D1.0.0. 0%2C%20Culture%3Dneutral%2C%20PublicKeyT
oken%3Dnull">
> <message id="ref-3">Msg successfully populated</message>
> <title id="ref-4">Title1</title>
> <category id="ref-5">Cat1</category>
> <priority>100</priority>
> <eventId>16</eventId>
> <severity>Information</severity>
> <machineName id="ref-6">MACH1</machineName>
> <timeStamp>2005-05-20T15:24:18.4850496-05:00</timeStamp>
> <errorMessages xsi:null="1"/>
> <extendedProperties xsi:null="1"/>
> <appDomainName id="ref-7">B1.exe</appDomainName>
> <processId id="ref-8">3932</processId>
> <processName id="ref-9">C:\B1\bin\Debug\B1.exe</processName>
> <threadName xsi:null="1"/>
> <win32ThreadId id="ref-10">244</win32ThreadId>
> </a1:LogEntry>
> </SOAP-ENV:Body>
> </SOAP-ENV:Envelope>
> --
> gg
>
> "Graeme Malcolm" wrote:
>
>
>
Sunday, February 19, 2012
Inserting of Duplicate Records Error Message
I would like to know what options I have with regards to trapping a duplicate record
before it tries to post to a SQL database. I have set the column to unique in SQL. But
when I try to use ASP and post a duplicate record I get a system error. I would like to
just create a referential error to notify the user that they cannot post a duplicate record
please try again. Any help would be greatly appreciated.
before it tries to post to a SQL database. I have set the column to unique in SQL. But
when I try to use ASP and post a duplicate record I get a system error. I would like to
just create a referential error to notify the user that they cannot post a duplicate record
please try again. Any help would be greatly appreciated.
RTRefer toTry... Catch... Block in the code
Does this helps?
Subscribe to:
Posts (Atom)