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 SSRS 2005 in web server and cluster environment.

Hi,

I am installing SSRS 2005 with the following scenario:

- Report Server and Report Manager will be installed on web server

- The repository databases (ReportServer and ReportServerTempDB) will be hosted in SQL2005 cluster server.

Both servers are running Win2003 SP1, SQL/SSRS 2005 SP1

When I try to browse the ReportServer virtual directory from IIS on the web server, the system keep asking username and password. After 3 times trials and it failed eventhough the username and password is correct.

The error message is:

HTTP Error 401.1 - Unauthorized: Access is denied due to invalid credentials.
Internet Information Services (IIS)

I've been searching on the web and found couple of articles talking about this issue. I've tried some of them like: http://support.microsoft.com/kb/887993 or even this one: http://groups.google.ca/group/microsoft.public.sqlserver.reportingsvcs/browse_frm/thread/991c9178ceab8f58/8f1a447aa60ad837?lnk=st&q=reporting+services+the+server+is+not+responding&rnum=3&hl=en#8f1a447aa60ad837

But this doesn't work.

I've checked both event viewer both web server and SQL server, but I can't see any information that tell me what had happened.

I also look at BOL, but doesn't help much.

Is there anyone can help me or point me to the right direction? Is there any guide document that explains step-by-step how to install SSRS in my scenario or similiar?

Many Thanks,

Usman Tjiudri

I have the exact same issue in a identical envirnonment configuration. Did you get this resolved?

I`m looking at a few articles re Kerberos....

|||Hi,

Yes, finally I got this issue resolved.
After looking for answer almost everywhere, I finally turn to Microsoft Support and they gave me a very quick response (less than 24 hours).
Before I talk about the solution, I need to clarify something here - my environment is Win2003 Server R2 (not Win2003 SP1 as mentioned in previous email) - may be there's a SP1 for R2.
The issue is caused by IIS. Apparently R2 has different version of IIS with normal Win2003 Server.
You need to uninstall completely IIS on your server (may be you need to backup IIS metadata) and install IIS for R2. You can get the software from R2 disc.
If you still can't solve the issue, log it to Microsoft Support.

Let me know how it goes.

Hope This Help,
Usman Tjiudri

Installing SSRS 2005 in web server and cluster environment.

Hi,

I am installing SSRS 2005 with the following scenario:

- Report Server and Report Manager will be installed on web server

- The repository databases (ReportServer and ReportServerTempDB) will be hosted in SQL2005 cluster server.

Both servers are running Win2003 SP1, SQL/SSRS 2005 SP1

When I try to browse the ReportServer virtual directory from IIS on the web server, the system keep asking username and password. After 3 times trials and it failed eventhough the username and password is correct.

The error message is:

HTTP Error 401.1 - Unauthorized: Access is denied due to invalid credentials.
Internet Information Services (IIS)

I've been searching on the web and found couple of articles talking about this issue. I've tried some of them like: http://support.microsoft.com/kb/887993 or even this one: http://groups.google.ca/group/microsoft.public.sqlserver.reportingsvcs/browse_frm/thread/991c9178ceab8f58/8f1a447aa60ad837?lnk=st&q=reporting+services+the+server+is+not+responding&rnum=3&hl=en#8f1a447aa60ad837

But this doesn't work.

I've checked both event viewer both web server and SQL server, but I can't see any information that tell me what had happened.

I also look at BOL, but doesn't help much.

Is there anyone can help me or point me to the right direction? Is there any guide document that explains step-by-step how to install SSRS in my scenario or similiar?

Many Thanks,

Usman Tjiudri

I have the exact same issue in a identical envirnonment configuration. Did you get this resolved?

I`m looking at a few articles re Kerberos....

|||Hi,

Yes, finally I got this issue resolved.
After looking for answer almost everywhere, I finally turn to Microsoft Support and they gave me a very quick response (less than 24 hours).
Before I talk about the solution, I need to clarify something here - my environment is Win2003 Server R2 (not Win2003 SP1 as mentioned in previous email) - may be there's a SP1 for R2.
The issue is caused by IIS. Apparently R2 has different version of IIS with normal Win2003 Server.
You need to uninstall completely IIS on your server (may be you need to backup IIS metadata) and install IIS for R2. You can get the software from R2 disc.
If you still can't solve the issue, log it to Microsoft Support.

Let me know how it goes.

Hope This Help,
Usman Tjiudri

sql

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

Installing SQL Server Desktop Engine & Enterprise Manager

I downloaded and successfully installed SQL Server 2000 Desktop edition via
"MSDE2000A.exe".
Then, thinking I needed "sql2ksp3.exe" to install Enterprise Manager, I
attempted to install that.
But, I got an error message: "SQL Server 2000 is not installed on this
machine. Setup will now exit".
So, obviously the error message is wrong, as I did install SQL Server 2000.
So, don't know what to do.
One thing that may be affecting this is that when doing the S.S. 2000
install, I had to do it via a DOS window in order to set a flag for what's
called an "SA" password. And I was thinking that maybe that's affecting the
subsequent attempt to install Enterprise Manager?
I'm running WinXP Professional with SP2 on my PC.
A thought...since I really don't have SQL Server 2000 installed, but instead
the Desktop version, maybe "sql2ksp3.ext" is the wrong file?
Thanks.Hi,
Did you install MSDE SP3?
From the file name "sql2ksp3.exe", I think it's not the appropariate
release. The SP3 name for MSDE is sql2kdesksp3.exe.
You can download it from:
http://www.microsoft.com/downloads/details.aspx?familyid=90DCD52C-0488-4E46-
AFBF-ACACE5369FA3&displaylang=en
If you have any other questions or concerns, please feel free to let me
know.
Charles Wang
Microsoft Online Community Support
======================================================When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
======================================================This posting is provided "AS IS" with no warranties, a
nd confers no rights.
======================================================|||andyboy wrote on Thu, 3 Aug 2006 13:29:02 -0700:
> I downloaded and successfully installed SQL Server 2000 Desktop edition
> via "MSDE2000A.exe".
> Then, thinking I needed "sql2ksp3.exe" to install Enterprise Manager, I
> attempted to install that.
That's Service Pack 3 for SQL Server 2000. Enterprise Manager comes on the
SQL Server CD.
> But, I got an error message: "SQL Server 2000 is not installed on this
> machine. Setup will now exit".
> So, obviously the error message is wrong, as I did install SQL Server
> 2000. So, don't know what to do.
You installed SQL Server 2000 Desktop (MSDE). That is not the same as the
"proper" SQL Server (Standard and Enterprise).
> One thing that may be affecting this is that when doing the S.S. 2000
> install, I had to do it via a DOS window in order to set a flag for what's
> called an "SA" password. And I was thinking that maybe that's affecting
> the subsequent attempt to install Enterprise Manager?
> I'm running WinXP Professional with SP2 on my PC.
> A thought...since I really don't have SQL Server 2000 installed, but
> instead the Desktop version, maybe "sql2ksp3.ext" is the wrong file?
> Thanks.
If you want Enterprise Manager, you'll need to buy SQL Server. The
Desktop/MSDE version doesn't come with a GUI management tool. I'm not sure
if the SQL Server Express 2005 Management Studio GUI will work with Desktop
2000, if it does then you could use that.
Dan|||ok, thanks and 2 things:
1) the link you posted to get 'sql2kdesksp3.exe' isn't valid.
2) can I install Enterprise Manager with the desktop sql server?
"Charles Wang[MSFT]" wrote:
> Hi,
> Did you install MSDE SP3?
> From the file name "sql2ksp3.exe", I think it's not the appropariate
> release. The SP3 name for MSDE is sql2kdesksp3.exe.
> You can download it from:
> http://www.microsoft.com/downloads/details.aspx?familyid=90DCD52C-0488-4E46-
> AFBF-ACACE5369FA3&displaylang=en
> If you have any other questions or concerns, please feel free to let me
> know.
> Charles Wang
> Microsoft Online Community Support
> ======================================================> When responding to posts, please "Reply to Group" via
> your newsreader so that others may learn and benefit
> from this issue.
> ======================================================> This posting is provided "AS IS" with no warranties, a
> nd confers no rights.
> ======================================================>|||and I did successfully install sql server version 8.00.760.
so, is that the desktop version of sql server, or is it the 'full' version?
and if it's the full version, I'd prefer to leave it installed, I guess, and
then install Enterprise Manager for it.
so, how do I do that?
thanks.
"Charles Wang[MSFT]" wrote:
> Hi,
> Did you install MSDE SP3?
> From the file name "sql2ksp3.exe", I think it's not the appropariate
> release. The SP3 name for MSDE is sql2kdesksp3.exe.
> You can download it from:
> http://www.microsoft.com/downloads/details.aspx?familyid=90DCD52C-0488-4E46-
> AFBF-ACACE5369FA3&displaylang=en
> If you have any other questions or concerns, please feel free to let me
> know.
> Charles Wang
> Microsoft Online Community Support
> ======================================================> When responding to posts, please "Reply to Group" via
> your newsreader so that others may learn and benefit
> from this issue.
> ======================================================> This posting is provided "AS IS" with no warranties, a
> nd confers no rights.
> ======================================================>|||Hi,
Thanks for your post.
I tried the link again and can get access the web. The sql2kdesksp3.exe
package for downloading locates under the page below.
I recommend that you check wheter or not the url is devided into two lines.
If so, you need to combine the two lines into one line url.
You can install SQL Enterprise Mnager with MSDE2000, however, you need to
install it with named instance.
It's only allowed only one default instance installed on one server.
Sincerely yours,
Charles Wang
Microsoft Online Community Support|||Hi ,
I am interested in this issue. Would you mind letting me know the result of
the suggestions? If you need further assistance, feel free to let me know.
I will be more than happy to be of assistance.
Have a great day!
Charles Wang
Microsoft Online Community Support

Installing SQL Server Desktop Engine & Enterprise Manager

I downloaded and successfully installed SQL Server 2000 Desktop edition via
"MSDE2000A.exe".
Then, thinking I needed "sql2ksp3.exe" to install Enterprise Manager, I
attempted to install that.
But, I got an error message: "SQL Server 2000 is not installed on this
machine. Setup will now exit".
So, obviously the error message is wrong, as I did install SQL Server 2000.
So, don't know what to do.
One thing that may be affecting this is that when doing the S.S. 2000
install, I had to do it via a DOS window in order to set a flag for what's
called an "SA" password. And I was thinking that maybe that's affecting the
subsequent attempt to install Enterprise Manager?
I'm running WinXP Professional with SP2 on my PC.
A thought...since I really don't have SQL Server 2000 installed, but instead
the Desktop version, maybe "sql2ksp3.ext" is the wrong file?
Thanks.Hi,
Did you install MSDE SP3?
From the file name "sql2ksp3.exe", I think it's not the appropariate
release. The SP3 name for MSDE is sql2kdesksp3.exe.
You can download it from:
http://www.microsoft.com/downloads/...D52C-0488-4E46-
AFBF-ACACE5369FA3&displaylang=en
If you have any other questions or concerns, please feel free to let me
know.
Charles Wang
Microsoft Online Community Support
========================================
==============
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
========================================
==============
This posting is provided "AS IS" with no warranties, a
nd confers no rights.
========================================
==============|||andyboy wrote on Thu, 3 Aug 2006 13:29:02 -0700:

> I downloaded and successfully installed SQL Server 2000 Desktop edition
> via "MSDE2000A.exe".
> Then, thinking I needed "sql2ksp3.exe" to install Enterprise Manager, I
> attempted to install that.
That's Service Pack 3 for SQL Server 2000. Enterprise Manager comes on the
SQL Server CD.

> But, I got an error message: "SQL Server 2000 is not installed on this
> machine. Setup will now exit".
> So, obviously the error message is wrong, as I did install SQL Server
> 2000. So, don't know what to do.
You installed SQL Server 2000 Desktop (MSDE). That is not the same as the
"proper" SQL Server (Standard and Enterprise).

> One thing that may be affecting this is that when doing the S.S. 2000
> install, I had to do it via a DOS window in order to set a flag for what's
> called an "SA" password. And I was thinking that maybe that's affecting
> the subsequent attempt to install Enterprise Manager?
> I'm running WinXP Professional with SP2 on my PC.
> A thought...since I really don't have SQL Server 2000 installed, but
> instead the Desktop version, maybe "sql2ksp3.ext" is the wrong file?
> Thanks.
If you want Enterprise Manager, you'll need to buy SQL Server. The
Desktop/MSDE version doesn't come with a GUI management tool. I'm not sure
if the SQL Server Express 2005 Management Studio GUI will work with Desktop
2000, if it does then you could use that.
Dan|||ok, thanks and 2 things:
1) the link you posted to get 'sql2kdesksp3.exe' isn't valid.
2) can I install Enterprise Manager with the desktop sql server?
"Charles Wang[MSFT]" wrote:

> Hi,
> Did you install MSDE SP3?
> From the file name "sql2ksp3.exe", I think it's not the appropariate
> release. The SP3 name for MSDE is sql2kdesksp3.exe.
> You can download it from:
> [url]http://www.microsoft.com/downloads/details.aspx?familyid=90DCD52C-0488-4E46-[/ur
l]
> AFBF-ACACE5369FA3&displaylang=en
> If you have any other questions or concerns, please feel free to let me
> know.
> Charles Wang
> Microsoft Online Community Support
> ========================================
==============
> When responding to posts, please "Reply to Group" via
> your newsreader so that others may learn and benefit
> from this issue.
> ========================================
==============
> This posting is provided "AS IS" with no warranties, a
> nd confers no rights.
> ========================================
==============
>|||and I did successfully install sql server version 8.00.760.
so, is that the desktop version of sql server, or is it the 'full' version?
and if it's the full version, I'd prefer to leave it installed, I guess, and
then install Enterprise Manager for it.
so, how do I do that?
thanks.
"Charles Wang[MSFT]" wrote:

> Hi,
> Did you install MSDE SP3?
> From the file name "sql2ksp3.exe", I think it's not the appropariate
> release. The SP3 name for MSDE is sql2kdesksp3.exe.
> You can download it from:
> [url]http://www.microsoft.com/downloads/details.aspx?familyid=90DCD52C-0488-4E46-[/ur
l]
> AFBF-ACACE5369FA3&displaylang=en
> If you have any other questions or concerns, please feel free to let me
> know.
> Charles Wang
> Microsoft Online Community Support
> ========================================
==============
> When responding to posts, please "Reply to Group" via
> your newsreader so that others may learn and benefit
> from this issue.
> ========================================
==============
> This posting is provided "AS IS" with no warranties, a
> nd confers no rights.
> ========================================
==============
>|||Hi,
Thanks for your post.
I tried the link again and can get access the web. The sql2kdesksp3.exe
package for downloading locates under the page below.
I recommend that you check wheter or not the url is devided into two lines.
If so, you need to combine the two lines into one line url.
You can install SQL Enterprise Mnager with MSDE2000, however, you need to
install it with named instance.
It's only allowed only one default instance installed on one server.
Sincerely yours,
Charles Wang
Microsoft Online Community Support|||Hi ,
I am interested in this issue. Would you mind letting me know the result of
the suggestions? If you need further assistance, feel free to let me know.
I will be more than happy to be of assistance.
Have a great day!
Charles Wang
Microsoft Online Community Support

Installing SQL Server 2005 on same machine as an existing SQL Sever 2000 instance

Given than once SQL Server 2005 is installed, SQL Server Studio has tobe used instead of Enterprise manager, can both SQL 2000 and 2005 beused on the same machine, be it development or production? (The secondone to be installed probably would be a named instance.)
Any experiance of doing this or a pointer to a Microsoft recommendation would be appreciated.

The SQL Server 2005 Books Online (downloaded version) has a section onWorkingwith Multiple Versions of SQL Server which indicates that SQL 2005 canbe installed as a named instance alongside SQL Server 7 and/or SQLServer 2000.
Some feedback from where this has been done would be very much appreciated.
|||From various training material for SQL 2005, it would seem that it ispreferable to have at least 512 Mb of RAM above that required by theoperating system. Whilst it will install (with protest) on a machinewith a total of 256 Mb RAM, a minimum realistic amount of memory forits host server would be 1 Gb of RAM.

integrate report manager in an asp.net application

I thought I can probably find out how the report manager works and create a similar application so that I can define my own things in there.

Looks like there is no sample where I could get a lead. Now I have decided if I can include the report manager in a new aspx page in my application and disable the stuff which is not required by the user to look at it.

I can definitely include the report manager url in the Iframe but how do I disable the stuff from the report manager.

Please help, I am having real hard time.

Thanks in advance.

There is no way that I know of to customize report manager and include its functionality in your own app like you would a control.

Have you looked at the report viewer web control? If you need to integrate report viewing and report export capability in your asp.net application, it is very powerful. You could use this, along with the available Web services in reporting services to build your own version of the report manager in asp.net with most, if not all of the same functionality.

A link to the report viewer control:

http://msdn2.microsoft.com/en-us/library/ms251671(VS.80).aspx

A link to the web services provided by report server:

http://msdn2.microsoft.com/en-us/library/ms154697.aspx

integrate report manager in an asp.net application

I thought I can probably find out how the report manager works and create a similar application so that I can define my own things in there.

Looks like there is no sample where I could get a lead. Now I have decided if I can include the report manager in a new aspx page in my application and disable the stuff which is not required by the user to look at it.

I can definitely include the report manager url in the Iframe but how do I disable the stuff from the report manager.

Please help, I am having real hard time.

Thanks in advance.

There is no way that I know of to customize report manager and include its functionality in your own app like you would a control.

Have you looked at the report viewer web control? If you need to integrate report viewing and report export capability in your asp.net application, it is very powerful. You could use this, along with the available Web services in reporting services to build your own version of the report manager in asp.net with most, if not all of the same functionality.

A link to the report viewer control:

http://msdn2.microsoft.com/en-us/library/ms251671(VS.80).aspx

A link to the web services provided by report server:

http://msdn2.microsoft.com/en-us/library/ms154697.aspx

installing sql server 2000

Hello,
im new to sql server 2000. After I install it on my xp machine, I tried
starting
the server by clicking on the service manager. I got the following error.
"service could not start due to logon failure". I then went into enterprise
manager, selected the service group, and selected new server registration.
In there I was told the instance of my server is already registered. Does
anyone know what I can do next?
Hello,
The SQL server needs to do "log on" an account of
administrator, verifies that your account has the necessary privileges
or places the correct account in the properties of the service, for
that you have to go to the services of your PC and look for
service MSSQLSERVER then in properties go to the tab Log On, and select the
option "Log on as: This account " then fill the box with the correct
account...
greetings, Cesar
"Angel b1" wrote:

> Hello,
> im new to sql server 2000. After I install it on my xp machine, I tried
> starting
> the server by clicking on the service manager. I got the following error.
> "service could not start due to logon failure". I then went into enterprise
> manager, selected the service group, and selected new server registration.
> In there I was told the instance of my server is already registered. Does
> anyone know what I can do next?
>
>

installing sql server 2000

Hello,
im new to sql server 2000. After I install it on my xp machine, I tried
starting
the server by clicking on the service manager. I got the following error.
"service could not start due to logon failure". I then went into enterprise
manager, selected the service group, and selected new server registration.
In there I was told the instance of my server is already registered. Does
anyone know what I can do next?Hello,
The SQL server needs to do "log on" an account of
administrator, verifies that your account has the necessary privileges
or places the correct account in the properties of the service, for
that you have to go to the services of your PC and look for
service MSSQLSERVER then in properties go to the tab Log On, and select the
option "Log on as: This account " then fill the box with the correct
account...
greetings, Cesar
"Angel b1" wrote:
> Hello,
> im new to sql server 2000. After I install it on my xp machine, I tried
> starting
> the server by clicking on the service manager. I got the following error.
> "service could not start due to logon failure". I then went into enterprise
> manager, selected the service group, and selected new server registration.
> In there I was told the instance of my server is already registered. Does
> anyone know what I can do next?
>
>

installing sql server 2000

Hello,
im new to sql server 2000. After I install it on my xp machine, I tried
starting
the server by clicking on the service manager. I got the following error.
"service could not start due to logon failure". I then went into enterprise
manager, selected the service group, and selected new server registration.
In there I was told the instance of my server is already registered. Does
anyone know what I can do next?Hello,
The SQL server needs to do "log on" an account of
administrator, verifies that your account has the necessary privileges
or places the correct account in the properties of the service, for
that you have to go to the services of your PC and look for
service MSSQLSERVER then in properties go to the tab Log On, and select the
option "Log on as: This account " then fill the box with the correct
account...
greetings, Cesar
"Angel b1" wrote:

> Hello,
> im new to sql server 2000. After I install it on my xp machine, I tried
> starting
> the server by clicking on the service manager. I got the following error.
> "service could not start due to logon failure". I then went into enterpri
se
> manager, selected the service group, and selected new server registration.
> In there I was told the instance of my server is already registered. Does
> anyone know what I can do next?
>
>

Installing SQL Server

I want to install SQL Server Enterprise Manager but get an error message. It's the following error message: Your platform is not supported. I'm using XP professional. What kind of SQL Server must I use now??

RegardsHere is a list of the different system requirements for running the different versions of SQL Server:

? SQL Server 2000 Enterprise Edition and Standard Edition can run on the following operating systems:
Windows Server? 2003, Standard Edition1
Windows Server 2003, Enterprise Edition1
Windows Server 2003, Datacenter Edition1
Windows® 2000 Server
Windows 2000 Advanced Server
Windows 2000 Datacenter Server
Windows NT® Server version 4.0 with Service Pack 5 (SP5) or later
Windows NT Server 4.0, Enterprise Edition, with SP5 or later

? SQL Server 2000 Evaluation Edition and Developer Edition can run on the following operating systems:
Operating systems listed above for Enterprise and Standard Editions
Windows XP Professional
Windows XP Home Edition
Windows 2000 Professional
Windows NT Workstation 4.0 with SP5 or later

? SQL Server 2000 Personal Edition2 and SQL Server 2000 Desktop Engine (MSDE) can run on the following operating systems:
Operating systems listed above for Enterprise, Standard, Evaluation, and Developer Editions
Windows Server 2003, Web Edition1 (MSDE only)
Windows 98
Windows Millennium Edition (Windows Me)

You can find more info here:

http://www.microsoft.com/sql/evaluation/sysreqs/2000/default.asp

Regards
Basia

Installing SQL Reporting Services on 2 Tiers

I would like to install the Report Manager on a web tier and the Reporting
Services on an applications tier behind a firewall. The install program
automatically installs Report Manager and Services on the same box, but it
seems that the Manager is only a UI for calling the Services which are web
services. We would like to call the services from the web tier through 443
on the firewall to the application tier. Can anyone provide assistance on if
and how we could install Reporting Services as mentioned above?
Thanks!Report Manager and Reporting Services are both asp.net application. As you
noted Report Manager is essentially a portal. Report Manager and Reporting
Services must be on the same box. However, Reporting Services and the
database do not need to be on the same box.
So, if you are planning on using Report Manager portal as the UI to
Reporting Services, then what you want to do is not possible (separating the
two). If, however, you are planning on using your own web page then it is
possible. There are two ways to integrate, web services and URL integration.
URL integration however only works if the Report Server is visible to the
client, which, again, is not what you want. You would need to use web
services to integrate with your own web site.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"ChrisG" <ChrisG@.discussions.microsoft.com> wrote in message
news:8D6B764F-3365-406C-B65A-BF9477F947A5@.microsoft.com...
>I would like to install the Report Manager on a web tier and the Reporting
> Services on an applications tier behind a firewall. The install program
> automatically installs Report Manager and Services on the same box, but it
> seems that the Manager is only a UI for calling the Services which are web
> services. We would like to call the services from the web tier through
> 443
> on the firewall to the application tier. Can anyone provide assistance on
> if
> and how we could install Reporting Services as mentioned above?
> Thanks!

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.