Instance/sqlservr.exe problem

Hi! I have SQL 2000 server with several instance. Every instance start own
sqlservr.exe task on Task Manager. Now one of sqlservr.exe is take 100% CPU
time, but I don't know to which instance it belongs?
regards, Tomatoma
DBCC MEMORYSTATUS on the both instances
"toma" <toma@.kolumbus.fi> wrote in message
news:ab32h.43057$8W7.25630@.reader1.news.jippii.net...
> Hi! I have SQL 2000 server with several instance. Every instance start own
> sqlservr.exe task on Task Manager. Now one of sqlservr.exe is take 100%
> CPU time, but I don't know to which instance it belongs?
> regards, Toma
>|||From Task Manager, you can find the process ID of the sqlservr.exe process.
If the ProcessID column is not displayed, Go to Views -> Select Columns...
and click on PID.
In the errorlog of a SQL instance, the process ID of that instance is
reported at the beginning of the errorlog. Alternatively, you can query the
process ID of the instance with SERVERPROPERTY('ProcessID').
Linchi
"toma" wrote:

> Hi! I have SQL 2000 server with several instance. Every instance start own
> sqlservr.exe task on Task Manager. Now one of sqlservr.exe is take 100% CP
U
> time, but I don't know to which instance it belongs?
> regards, Toma
>
>|||You can get the PID you see in Task Manager by executing the
following on an instance:
SELECT SERVERPROPERTY('ProcessID')
-Sue
On Wed, 1 Nov 2006 17:37:38 +0200, "toma" <toma@.kolumbus.fi>
wrote:

>Hi! I have SQL 2000 server with several instance. Every instance start own
>sqlservr.exe task on Task Manager. Now one of sqlservr.exe is take 100% CPU
>time, but I don't know to which instance it belongs?
>regards, Toma
>

Instance/sqlservr.exe problem

Hi! I have SQL 2000 server with several instance. Every instance start own
sqlservr.exe task on Task Manager. Now one of sqlservr.exe is take 100% CPU
time, but I don't know to which instance it belongs?
regards, Toma
toma
DBCC MEMORYSTATUS on the both instances
"toma" <toma@.kolumbus.fi> wrote in message
news:ab32h.43057$8W7.25630@.reader1.news.jippii.net ...
> Hi! I have SQL 2000 server with several instance. Every instance start own
> sqlservr.exe task on Task Manager. Now one of sqlservr.exe is take 100%
> CPU time, but I don't know to which instance it belongs?
> regards, Toma
>
|||From Task Manager, you can find the process ID of the sqlservr.exe process.
If the ProcessID column is not displayed, Go to Views -> Select Columns...
and click on PID.
In the errorlog of a SQL instance, the process ID of that instance is
reported at the beginning of the errorlog. Alternatively, you can query the
process ID of the instance with SERVERPROPERTY('ProcessID').
Linchi
"toma" wrote:

> Hi! I have SQL 2000 server with several instance. Every instance start own
> sqlservr.exe task on Task Manager. Now one of sqlservr.exe is take 100% CPU
> time, but I don't know to which instance it belongs?
> regards, Toma
>
>
|||You can get the PID you see in Task Manager by executing the
following on an instance:
SELECT SERVERPROPERTY('ProcessID')
-Sue
On Wed, 1 Nov 2006 17:37:38 +0200, "toma" <toma@.kolumbus.fi>
wrote:

>Hi! I have SQL 2000 server with several instance. Every instance start own
>sqlservr.exe task on Task Manager. Now one of sqlservr.exe is take 100% CPU
>time, but I don't know to which instance it belongs?
>regards, Toma
>

Instance/sqlservr.exe problem

Hi! I have SQL 2000 server with several instance. Every instance start own
sqlservr.exe task on Task Manager. Now one of sqlservr.exe is take 100% CPU
time, but I don't know to which instance it belongs?
regards, Tomatoma
DBCC MEMORYSTATUS on the both instances
"toma" <toma@.kolumbus.fi> wrote in message
news:ab32h.43057$8W7.25630@.reader1.news.jippii.net...
> Hi! I have SQL 2000 server with several instance. Every instance start own
> sqlservr.exe task on Task Manager. Now one of sqlservr.exe is take 100%
> CPU time, but I don't know to which instance it belongs?
> regards, Toma
>|||From Task Manager, you can find the process ID of the sqlservr.exe process.
If the ProcessID column is not displayed, Go to Views -> Select Columns...
and click on PID.
In the errorlog of a SQL instance, the process ID of that instance is
reported at the beginning of the errorlog. Alternatively, you can query the
process ID of the instance with SERVERPROPERTY('ProcessID').
Linchi
"toma" wrote:
> Hi! I have SQL 2000 server with several instance. Every instance start own
> sqlservr.exe task on Task Manager. Now one of sqlservr.exe is take 100% CPU
> time, but I don't know to which instance it belongs?
> regards, Toma
>
>|||You can get the PID you see in Task Manager by executing the
following on an instance:
SELECT SERVERPROPERTY('ProcessID')
-Sue
On Wed, 1 Nov 2006 17:37:38 +0200, "toma" <toma@.kolumbus.fi>
wrote:
>Hi! I have SQL 2000 server with several instance. Every instance start own
>sqlservr.exe task on Task Manager. Now one of sqlservr.exe is take 100% CPU
>time, but I don't know to which instance it belongs?
>regards, Toma
>

Installing SQLExpress on XPHome

The software install hangs when the install goes out to check for my machine configuration.

No error codes or anything. I have to go to task manager to stop the install. It may can take two or three times to End Task before the setup actually stops.

Thanks for any help.

Check out the Setup log files located at C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files for more information about setup problems. You should also check the summary.txt file that is one directory up as that frequently points to the log where you will find the problem listed.

Regards,
Mike

|||

I think I have the same problem, the installer doesn't go further than "checking installed IIS" and I think I have found the correct log.

In the end of the file it says something about IIS, it looks like this:

<EndFunc Name='Write_sqlWellKnownAccountNames' Return='0' GetLastError='1008'>
PerfTime Stop: Write_sqlWellKnownAccountNames : Fri Apr 07 20:53:08 2006
<EndFunc Name='LaunchFunction' Return='0' GetLastError='1008'>
Action ended 20:53:08: Write_sqlWellKnownAccountNames.D20239D7_E87C_40C9_9837_E70B8D4882C2. Return value 1.
MSI (c) (74:44) [20:53:08:906]: Doing action: CheckIIS.D20239D7_E87C_40C9_9837_E70B8D4882C2
Action 20:53:08: CheckIIS.D20239D7_E87C_40C9_9837_E70B8D4882C2. Detecting Installed IIS
Action start 20:53:08: CheckIIS.D20239D7_E87C_40C9_9837_E70B8D4882C2.
MSI (c) (74:24) [20:53:08:906]: Invoking remote custom action. DLL: C:\DOCUME~1\Simon\LOKALA~1\Temp\MSI17.tmp, Entrypoint: CheckIIS
<Func Name='LaunchFunction'>
Function=CheckIIS
MSI (c) (74!34) [20:53:08:921]: PROPERTY CHANGE: Modifying InitStatus property. Its current value is '16'. Its new value: '20'.
<Func Name='SetCAContext'>
<EndFunc Name='SetCAContext' Return='T' GetLastError='203'>
Doing Action: CheckIIS
PerfTime Start: CheckIIS : Fri Apr 07 20:53:08 2006
<Func Name='CheckIIS'>
Action 20:53:08: CheckIIS. Detecting Installed IIS
MSI (c) (74!34) [20:53:08:937]: PROPERTY CHANGE: Adding IISCHECKED property. Its value is '0'.
MSI (c) (74!34) [20:53:08:937]: PROPERTY CHANGE: Adding SqlASPNETInstalled property. Its value is '1'.
Skipping RS Feature Dependency Check
<Func Name='GetXMLAttributeValue'>
Error to find XML node /configuration/system.web/compilation
<EndFunc Name='GetXMLAttributeValue' Return='2' GetLastError='0'>
Failed to get ModuleID_RS_Server when getting the ASP Temp directory.

However, I don't know what to do about it. Do you know anything else about the problem after reading this? How should I do to install SQL Server Express?

|||

The end of my log-file looks identical to yours... I dont't seem to figure it out either..
Anybody?
Thanks!

EDIT:

After uninstalling, cleaning registry and restarting for about 40 times I found an old CD with SQL Server 2000 Evaluation Copy.

When trying to install this I get the error "A previous program installation created pending file operations on the installation machine. You must restart the computer before running setup."

When I restart I see no improvent...

Does this help helping us?

Thanks

/Martin

|||

I am having the exact same problem , it hangs where

it says checking IIs . I have been trying to get this

running for hours now . Microsoft please help us

I need this program to work very soon .....

Best wishes to all

TWS

Installing SQLExpress on XPHome

The software install hangs when the install goes out to check for my machine configuration.

No error codes or anything. I have to go to task manager to stop the install. It may can take two or three times to End Task before the setup actually stops.

Thanks for any help.

Check out the Setup log files located at C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files for more information about setup problems. You should also check the summary.txt file that is one directory up as that frequently points to the log where you will find the problem listed.

Regards,
Mike

|||

I think I have the same problem, the installer doesn't go further than "checking installed IIS" and I think I have found the correct log.

In the end of the file it says something about IIS, it looks like this:

<EndFunc Name='Write_sqlWellKnownAccountNames' Return='0' GetLastError='1008'>
PerfTime Stop: Write_sqlWellKnownAccountNames : Fri Apr 07 20:53:08 2006
<EndFunc Name='LaunchFunction' Return='0' GetLastError='1008'>
Action ended 20:53:08: Write_sqlWellKnownAccountNames.D20239D7_E87C_40C9_9837_E70B8D4882C2. Return value 1.
MSI (c) (74:44) [20:53:08:906]: Doing action: CheckIIS.D20239D7_E87C_40C9_9837_E70B8D4882C2
Action 20:53:08: CheckIIS.D20239D7_E87C_40C9_9837_E70B8D4882C2. Detecting Installed IIS
Action start 20:53:08: CheckIIS.D20239D7_E87C_40C9_9837_E70B8D4882C2.
MSI (c) (74:24) [20:53:08:906]: Invoking remote custom action. DLL: C:\DOCUME~1\Simon\LOKALA~1\Temp\MSI17.tmp, Entrypoint: CheckIIS
<Func Name='LaunchFunction'>
Function=CheckIIS
MSI (c) (74!34) [20:53:08:921]: PROPERTY CHANGE: Modifying InitStatus property. Its current value is '16'. Its new value: '20'.
<Func Name='SetCAContext'>
<EndFunc Name='SetCAContext' Return='T' GetLastError='203'>
Doing Action: CheckIIS
PerfTime Start: CheckIIS : Fri Apr 07 20:53:08 2006
<Func Name='CheckIIS'>
Action 20:53:08: CheckIIS. Detecting Installed IIS
MSI (c) (74!34) [20:53:08:937]: PROPERTY CHANGE: Adding IISCHECKED property. Its value is '0'.
MSI (c) (74!34) [20:53:08:937]: PROPERTY CHANGE: Adding SqlASPNETInstalled property. Its value is '1'.
Skipping RS Feature Dependency Check
<Func Name='GetXMLAttributeValue'>
Error to find XML node /configuration/system.web/compilation
<EndFunc Name='GetXMLAttributeValue' Return='2' GetLastError='0'>
Failed to get ModuleID_RS_Server when getting the ASP Temp directory.

However, I don't know what to do about it. Do you know anything else about the problem after reading this? How should I do to install SQL Server Express?

|||

The end of my log-file looks identical to yours... I dont't seem to figure it out either..
Anybody?
Thanks!

EDIT:

After uninstalling, cleaning registry and restarting for about 40 times I found an old CD with SQL Server 2000 Evaluation Copy.

When trying to install this I get the error "A previous program installation created pending file operations on the installation machine. You must restart the computer before running setup."

When I restart I see no improvent...

Does this help helping us?

Thanks

/Martin

|||

I am having the exact same problem , it hangs where

it says checking IIs . I have been trying to get this

running for hours now . Microsoft please help us

I need this program to work very soon .....

Best wishes to all

TWS

sql

Integrated Auth and SQL servers

I'm building a reporting server that will grab data off of a an old HP3000, all of that is being done in a background task (non asp.net) and uploaded to an sql server.

I'm using a web interface to allow people within the company to view the data. This will be in a single domain, behind a firewall, and will not be accessable from outside of the company.

In IIS, I have anonymous login unchecked and only Integrated Windows Auth checked. The pertinate parts of my web.config look like this:

<authenticationmode="Windows"/>

<identityimpersonate="true"/>

<authorization>

<allowusers="*"/>

<denyusers="?"/>

</authorization>

My connection string looks like this:

publicstaticstring SqlServerConnect = "Integrated Security=SSPI;Initial Catalog=[name of database];Data Source=[sqlserver IP]";

The website (for now) is on my local development computer. When I run the program everything works fine, when I attempt to view the web page on another computer, I get the following error

Server Error in '/reports' Application.

Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'.

I'm at a loss as to how to fix this. I dont really want each user to have to enter any log in information, frankly, the permissions dont even matter in this case. My main problem is with the sql connection and trying to get adequate permissions to run queries.

Any help would be apprieciated

<deny users="?" /> denyANONYMOUS user. Ifthe permissions dont even matter and you dont really want each user to have to enter any log in information, then you can remove this <deny users="?" /> in web.config <authorization> section.

|||

Xiaohong wrote:

<deny users="?" /> denyANONYMOUS user. Ifthe permissions dont even matter and you dont really want each user to have to enter any log in information, then you can remove this <deny users="?" /> in web.config <authorization> section.

This all gets back to the security problem with the sql connection. It generates error messages when it gets to the sqlCommand.Fill(dataset) part. If I dont do some kind of authentication, the sqlconnect returns an error message. I just need enough permissions to connect to the sql server

Installing SQL 2000 on a Windows 2003 Server

I am trying to determine why I can not install SQL 2000 on
a new Windows 2003 Server.
In Task Manager I do se the wowexec running, but it does
nothing, does not access memory or cpu usage.
It just sits there and does nothing.
Has anyone installed SQL on 2003 Server?
Yes,i has.
But if you install SQL 2000 to Windows 2003,it's recommended that you should
be install sql 2000 sp3 up.
"Paul" <anonymous@.discussions.microsoft.com> wrote in message
news:8f5601c432db$a62c1530$a301280a@.phx.gbl...
> I am trying to determine why I can not install SQL 2000 on
> a new Windows 2003 Server.
> In Task Manager I do se the wowexec running, but it does
> nothing, does not access memory or cpu usage.
> It just sits there and does nothing.
> Has anyone installed SQL on 2003 Server?
|||You should have the right version of W2K3, I think the Enterprise and Standard edition allow SQL 2K installation not the Web Edition. Also make sure you install SQL 2K SP3a later.

Installing SQL 2000 on a Windows 2003 Server

I am trying to determine why I can not install SQL 2000 on
a new Windows 2003 Server.
In Task Manager I do se the wowexec running, but it does
nothing, does not access memory or cpu usage.
It just sits there and does nothing.
Has anyone installed SQL on 2003 Server?Yes,i has.
But if you install SQL 2000 to Windows 2003,it's recommended that you should
be install sql 2000 sp3 up.
"Paul" <anonymous@.discussions.microsoft.com> wrote in message
news:8f5601c432db$a62c1530$a301280a@.phx.gbl...
> I am trying to determine why I can not install SQL 2000 on
> a new Windows 2003 Server.
> In Task Manager I do se the wowexec running, but it does
> nothing, does not access memory or cpu usage.
> It just sits there and does nothing.
> Has anyone installed SQL on 2003 Server?|||You should have the right version of W2K3, I think the Enterprise and Standa
rd edition allow SQL 2K installation not the Web Edition. Also make sure you
install SQL 2K SP3a later.

Installing SQL 2000 on a Windows 2003 Server

I am trying to determine why I can not install SQL 2000 on
a new Windows 2003 Server.
In Task Manager I do se the wowexec running, but it does
nothing, does not access memory or cpu usage.
It just sits there and does nothing.
Has anyone installed SQL on 2003 Server?Yes,i has.
But if you install SQL 2000 to Windows 2003,it's recommended that you should
be install sql 2000 sp3 up.
"Paul" <anonymous@.discussions.microsoft.com> wrote in message
news:8f5601c432db$a62c1530$a301280a@.phx.gbl...
> I am trying to determine why I can not install SQL 2000 on
> a new Windows 2003 Server.
> In Task Manager I do se the wowexec running, but it does
> nothing, does not access memory or cpu usage.
> It just sits there and does nothing.
> Has anyone installed SQL on 2003 Server?|||You should have the right version of W2K3, I think the Enterprise and Standard edition allow SQL 2K installation not the Web Edition. Also make sure you install SQL 2K SP3a later.