"Tree View" with a SQL Server Database

We need to present hierarchical data on a web page, the same way the
tree view shows files in Windows Explorer. Here's the catch: that
tree view needs to be bound to a SQL Server database. How can this be
done?Simplist is an adjacency list. Store the parent ID along with each record,
also store the "full path" in a text string, such as 0001/0004/0007/0002
(the second node of the seventh node of the 4th node of the 1st node of the
tree). I use a function to generate a number for the string (below)
because each "path node" has to be the same length in order to perform a
correct "select" of the tree order. You also need a "sibling number" if you
want to order your nodes in an arbitrary way.

ALTER FUNCTION dbo.func_Get_Padded_Number8
(
@.number INTEGER
)
RETURNS VARCHAR(8)
AS
BEGIN
DECLARE @.Value VARCHAR(8)
DECLARE @.Length INTEGER

/*
Convert the number and get its string length
*/

SET @.Value = CONVERT ( VARCHAR ( 8 ), @.number )
SET @.Length = LEN ( @.Value )

/*
If the length is less than 8, pad it
*/
IF LEN ( @.Value ) < 8
BEGIN
SET @.Value = REPLACE ( SPACE ( 8 - @.Length ), ' ', '0' ) + @.Value
END

RETURN @.Value
END

Adding a new node is simple given the parent, you just find the highest
sibling number of the parent and increment it then insert a node, building
the path string by taking the parent and adding "/00n" (where n is the
sibling number). Listing all of the nodes in the tree structure can be done
easily like this:

SELECT dbo.Adjacency.ID, (a unique ID)
dbo.Adjacency.ID_Parent, (the unique ID of the parent of
this node)
dbo.Adjacency.ID_Index, (the sibling number of this child)
LEN(dbo.Adjacency.Path) / 9 AS Depth, (the depth of the
node, useful for building your tree structure afterwards)
FROM dbo.Adjacency
ORDER BY dbo.Adjacency.Path

Hope this helps some.

<imani_technology_spam@.yahoo.com> wrote in message
news:8be6e8.0312030710.3b40bc89@.posting.google.com ...
> We need to present hierarchical data on a web page, the same way the
> tree view shows files in Windows Explorer. Here's the catch: that
> tree view needs to be bound to a SQL Server database. How can this be
> done?|||This helps a lot. Thanks. I wonder if there is a practical graphical
solution in addition to the text-based solution?

"Robin Tucker" <idontwanttobespammedanymore@.reallyidont.com> wrote in message news:<bqn6dt$o7l$1$830fa7b3@.news.demon.co.uk>...
> Simplist is an adjacency list. Store the parent ID along with each record,
> also store the "full path" in a text string, such as 0001/0004/0007/0002
> (the second node of the seventh node of the 4th node of the 1st node of the
> tree). I use a function to generate a number for the string (below)
> because each "path node" has to be the same length in order to perform a
> correct "select" of the tree order. You also need a "sibling number" if you
> want to order your nodes in an arbitrary way.
> ALTER FUNCTION dbo.func_Get_Padded_Number8
> (
> @.number INTEGER
> )
> RETURNS VARCHAR(8)
> AS
> BEGIN
> DECLARE @.Value VARCHAR(8)
> DECLARE @.Length INTEGER
> /*
> Convert the number and get its string length
> */
> SET @.Value = CONVERT ( VARCHAR ( 8 ), @.number )
> SET @.Length = LEN ( @.Value )
> /*
> If the length is less than 8, pad it
> */
> IF LEN ( @.Value ) < 8
> BEGIN
> SET @.Value = REPLACE ( SPACE ( 8 - @.Length ), ' ', '0' ) + @.Value
> END
> RETURN @.Value
> END
> Adding a new node is simple given the parent, you just find the highest
> sibling number of the parent and increment it then insert a node, building
> the path string by taking the parent and adding "/00n" (where n is the
> sibling number). Listing all of the nodes in the tree structure can be done
> easily like this:
> SELECT dbo.Adjacency.ID, (a unique ID)
> dbo.Adjacency.ID_Parent, (the unique ID of the parent of
> this node)
> dbo.Adjacency.ID_Index, (the sibling number of this child)
> LEN(dbo.Adjacency.Path) / 9 AS Depth, (the depth of the
> node, useful for building your tree structure afterwards)
> FROM dbo.Adjacency
> ORDER BY dbo.Adjacency.Path
> Hope this helps some.
> <imani_technology_spam@.yahoo.com> wrote in message
> news:8be6e8.0312030710.3b40bc89@.posting.google.com ...
> > We need to present hierarchical data on a web page, the same way the
> > tree view shows files in Windows Explorer. Here's the catch: that
> > tree view needs to be bound to a SQL Server database. How can this be
> > done?|||Hi

I posted this a short time ago!
http://tinyurl.com/xw5s

John

<imani_technology_spam@.yahoo.com> wrote in message
news:8be6e8.0312050907.644b5abe@.posting.google.com ...
> This helps a lot. Thanks. I wonder if there is a practical graphical
> solution in addition to the text-based solution?
> "Robin Tucker" <idontwanttobespammedanymore@.reallyidont.com> wrote in
message news:<bqn6dt$o7l$1$830fa7b3@.news.demon.co.uk>...
> > Simplist is an adjacency list. Store the parent ID along with each
record,
> > also store the "full path" in a text string, such as 0001/0004/0007/0002
> > (the second node of the seventh node of the 4th node of the 1st node of
the
> > tree). I use a function to generate a number for the string (below)
> > because each "path node" has to be the same length in order to perform a
> > correct "select" of the tree order. You also need a "sibling number" if
you
> > want to order your nodes in an arbitrary way.
> > ALTER FUNCTION dbo.func_Get_Padded_Number8
> > (
> > @.number INTEGER
> > )
> > RETURNS VARCHAR(8)
> > AS
> > BEGIN
> > DECLARE @.Value VARCHAR(8)
> > DECLARE @.Length INTEGER
> > /*
> > Convert the number and get its string length
> > */
> > SET @.Value = CONVERT ( VARCHAR ( 8 ), @.number )
> > SET @.Length = LEN ( @.Value )
> > /*
> > If the length is less than 8, pad it
> > */
> > IF LEN ( @.Value ) < 8
> > BEGIN
> > SET @.Value = REPLACE ( SPACE ( 8 - @.Length ), ' ', '0' ) +
@.Value
> > END
> > RETURN @.Value
> > END
> > Adding a new node is simple given the parent, you just find the highest
> > sibling number of the parent and increment it then insert a node,
building
> > the path string by taking the parent and adding "/00n" (where n is the
> > sibling number). Listing all of the nodes in the tree structure can be
done
> > easily like this:
> > SELECT dbo.Adjacency.ID, (a unique ID)
> > dbo.Adjacency.ID_Parent, (the unique ID of the parent
of
> > this node)
> > dbo.Adjacency.ID_Index, (the sibling number of this
child)
> > LEN(dbo.Adjacency.Path) / 9 AS Depth, (the depth of
the
> > node, useful for building your tree structure afterwards)
> > FROM dbo.Adjacency
> > ORDER BY dbo.Adjacency.Path
> > Hope this helps some.
> > <imani_technology_spam@.yahoo.com> wrote in message
> > news:8be6e8.0312030710.3b40bc89@.posting.google.com ...
> > > We need to present hierarchical data on a web page, the same way the
> > > tree view shows files in Windows Explorer. Here's the catch: that
> > > tree view needs to be bound to a SQL Server database. How can this be
> > > done?

"The connection could not be made to the report server......"

My test system is fine (windows 2003, VS.NET, RS). I could suffer the page
https://myserver/reports by using a browser. However, when creating a report
project, I couldn't deploy and got the error message : "The connection could
not be made to the report server https://myserver/reportserver".
Please help me.I am also having similar problems -- I tried reseting the proxy settings in
IE but not helping
"Vu Dawson" wrote:
> My test system is fine (windows 2003, VS.NET, RS). I could suffer the page
> https://myserver/reports by using a browser. However, when creating a report
> project, I couldn't deploy and got the error message : "The connection could
> not be made to the report server https://myserver/reportserver".
> Please help me.|||I was researching this error msg. I don't know if this applies to you.
When you open the browser and navigate to https://myserver/reportserver do
you get a https certificate prompt (yes/no/install cert?). This was the issue
for me... click on Install Certficate and try deploying again.
Good luck!
"Peter" wrote:
> I am also having similar problems -- I tried reseting the proxy settings in
> IE but not helping
> "Vu Dawson" wrote:
> > My test system is fine (windows 2003, VS.NET, RS). I could suffer the page
> > https://myserver/reports by using a browser. However, when creating a report
> > project, I couldn't deploy and got the error message : "The connection could
> > not be made to the report server https://myserver/reportserver".
> > Please help me.

"SQL Server does not exist or access denied." after installing XP SP2

Hi!

I just installed Windows XP Service Pack 2 on my pc and I cannot make my asp.net applications access any database any more.

I tried starting the application up from the debugger in vs.net, but I got the same behaviour: I can open the login page but as soon as the application tries to connect to SQLServer I get the "SQL Server does not exist or access denied." error message.

I'm trying to connect with trusted_connection.

Can you guys help me out?Try this Microsoft KB article:

http://support.microsoft.com/default.aspx?kbid=839269|||Hi TechMickey,

Did you find a solution to the problem? As you remember I have the same problem and it is still not working.|||Hi bws,

no, I just removed sp2 :-(|||So you took the drastic step. I disabled the firewall but without improvement. I will do like you, get rid of the whole sp2-thing. until I see a solution.

"SQL Server does not exist or access denied", again...

I'm have that darn problem...

Here is our setup:

Remote clustered SQL Server 2000 running on a Windows Server 2003 Enterprise Edition box.

Local IIS 5.1 web server (my development box) running on Windows XP Tablet Edition.

I'm using Visual Studio.Net 2003 and using ASP.Net 1.1.4322.

I have an ASP.Net application that hits the remote SQL Server. When I'm on my development box and viewing my ASP.Net project locally via IE, the application retrieves values from the remote SQL Server with no problems. If I get onto another machine, launch IE, and then hit my development box's web server (which is running the asp.net app), I get the dreaded "SQL Server does not exist or access is denied" msg.

In my ASP.Net app, I have impersonate set to true and the website is set only to windows authentication. The remote SQL Server is set to SQL and Windows authentication.

I'm at a loss on what to do, any help would be greatly appreciated.

Thanks,

ExitusLSU

Hi,

This seems to be firewall issue.
Check it after disabling firewall.
http://bhatiaworld.blogspot.com/2005/12/dot-net-error-aspnet-website-or-web.html|||

I also forgot to mention my connection string. It is:

"Data Source=<server name>;Integrated Security=SSPI;Initial Catalog=<database name>"

I've tried using the IP address, but that didn't work.

Thanks,

ExitusLSU

"SQL Server does not exist or access denied" error when trying to connect from a Windows S

Hi!

I understand that this topic is one of the most discussed topics ever. However i could not find the relevant information after going through (almost) all the posts so far. Hence this post.

I am getting the 'SQL Server does not exist or access denied' error when I am trying to access SQL Server from a WINDOWS SERVICE. SQL Server and the Windows service are running on two different machines. (When they are on the same machine, it works). All the solutions I found so far are related to web apps. What should I do in the case of a windows service? My connection string uses SQL server authentication. (I tried with windows authentication. Its not working either.). Under what login does windows services run and how can I add it to valid SQL server logins?

what version of sql server you are using SQL 2000 or SQL 2005. If sql 2005 have you enabled remote connection on sql server|||I am using SQL Server 2000. My Connection String is "Data Source=Proficio3;Initial Catalog=PRO-TMS_2.5;User ID=service_login;Password=service"|||

Hi,

Please try to check if the SQL Server you're connecting to is the default instance on that server. If not, you will need to add instance name after the server name like:

Data Source=Proficio3\SQLInstance

"Server has not yet been opened" - XP

I have the "Crystal Reports Viewer Control" in one of my VB 6.0 applications. The report was working great on the Windows 2000 OS, but when I moved the application to Windows XP it now gives the error "Server has not yet been opened". I have made sure that a system DSN has been created for the ODBC connection. I have connected to the DSN using the "Crystal SQL Connectivity Test Utility - SQLCON32". I even tried registering or re-registering many of the crystal dependencies. I have Crystal Reports 8.5 Professional Edition loaded and the report works fine if I open it with the Professional Edition, but not the viewer. I am baffled.

Code;
'* Start creating the crystal report for the crystal viewer.
Set crystal = New CRAXDRT.Application
Set sRPT = crystal.OpenReport(App.Path & "\DailyIS.rpt")
sRPT.DiscardSavedData
DoEvents
sRPT.Database.Tables(1).SetLogOnInfo "oracle", gDSN, gUserID, gPassWord
sRPT.Database.SetDataSource RS
crViewer.ReportSource = sRPT

crViewer.ViewReport '* (Where the error pops up)


Any ideas what my Windows XP issue might be?'* Start creating the crystal report for the crystal viewer.
Set crystal = New CRAXDRT.Application
Set sRPT = crystal.OpenReport(App.Path & "\DailyIS.rpt")
sRPT.DiscardSavedData
DoEvents

sRPT.Database.SetDataSource RS
crViewer.ReportSource = sRPT
crViewer.ViewReport '* (Where the error pops up)


if you are set ADODB.recordset in CR you don't need

sRPT.Database.Tables(1).SetLogOnInfo "oracle", gDSN, gUserID, gPassWord|||Thank you hensa22 for that information. I commented out that line of code and ran the report in Windows 2000 and received the message "Server has not yet been opened.", but the report displays with that line of code left in. In Windows XP I receive the message "Server has not yet been opened." with or without the code.

"Orphaned" maintenance plan

Warning ahead of time - I'm a total idiot about this stuff.
Server is Windows Server 2003
SQL Enterprise Manager version is 8.0
I had been having a problem getting backups to auto delete and so
followed the instructions in a Microsoft KB article and set the
recovery mode to Full for all of the DBs. That solved the problem for
almost every database in the system.
However, apparently at some point several of the databases used a
maintenance plan called "DB Maintenance Plan2" which no longer exists
on the system. (There is currently only a single maintenance plan on
the system.) How can I find out where this is coming from and delete
it?
This was the error in the Events log:
SQL Server Scheduled Job 'DB Backup Job for DB Maintenance Plan 'DB
Maintenance Plan2'' (0x8AB900BBC4CB7E409DCF47CACB85233E) - Status:
Failed - Invoked on: 2007-04-04 03:00:00 - Message: The job failed.
The Job was invoked by Schedule 5 (Schedule 1). The last step to run
was step 1 (Step 1).
Please talk in baby steps - thanks.
Julie
Hi Julie
"Kaidi" wrote:

> Warning ahead of time - I'm a total idiot about this stuff.
> Server is Windows Server 2003
> SQL Enterprise Manager version is 8.0
> I had been having a problem getting backups to auto delete and so
> followed the instructions in a Microsoft KB article and set the
> recovery mode to Full for all of the DBs. That solved the problem for
> almost every database in the system.
> However, apparently at some point several of the databases used a
> maintenance plan called "DB Maintenance Plan2" which no longer exists
> on the system. (There is currently only a single maintenance plan on
> the system.) How can I find out where this is coming from and delete
> it?
> This was the error in the Events log:
> SQL Server Scheduled Job 'DB Backup Job for DB Maintenance Plan 'DB
> Maintenance Plan2'' (0x8AB900BBC4CB7E409DCF47CACB85233E) - Status:
> Failed - Invoked on: 2007-04-04 03:00:00 - Message: The job failed.
> The Job was invoked by Schedule 5 (Schedule 1). The last step to run
> was step 1 (Step 1).
> Please talk in baby steps - thanks.
> Julie
>
I am not sure if it is the job you are looking for or not! But if you start
SQL Enterprise Manager, and open up the Node for the SQL Server Instance, you
will see a node for management under which is SQL Server Agent and then Jobs.
There should be a job called "DB Backup Job for DB Maintenance Plan 'DB
Maintenance Plan2' " which will have a red cross next to it because it has
failed. Right click the job and choose delete from the menu to remove the
job. Usually when a maintenance plan is deleted the associated jobs should be
deleted.
John
|||Followup, for anyone who happens to hit this post on a usenet search.
(I hate finding my problem with no solution.
There's an SP called sp_delete_job that you can use with either a job
name or a job id and it takes care of the cleanup required to remove
the maintenance plan completely from your system.
Do *not* simply delete the job rows that are causing the problem from
the msdb.sysjobs table. Unfortunately, that is what I did, and it's
taken me a couple of hours to track down all of the pieces/references
to the job in other tables. I'm just hoping to heck I got them all...I
went manually through all of the delete commands in the sp_delete_job
procedure, and praying that it worked!
:P
Julie
On Apr 4, 12:04 pm, "Kaidi" <julie.sie...@.gmail.com> wrote:
> Warning ahead of time - I'm a total idiot about this stuff.
> Server is Windows Server 2003
> SQL Enterprise Manager version is 8.0
> I had been having a problem getting backups to auto delete and so
> followed the instructions in a Microsoft KB article and set the
> recovery mode to Full for all of the DBs. That solved the problem for
> almost every database in the system.
> However, apparently at some point several of the databases used amaintenance plancalled "DB MaintenancePlan2" which no longer exists
> on the system. (There is currently only a singlemaintenance planon
> the system.) How can I find out where this is coming from and delete
> it?
> This was the error in the Events log:
> SQL Server Scheduled Job 'DB Backup Job for DBMaintenance Plan'DB
> MaintenancePlan2'' (0x8AB900BBC4CB7E409DCF47CACB85233E) - Status:
> Failed - Invoked on: 2007-04-04 03:00:00 - Message: The job failed.
> The Job was invoked by Schedule 5 (Schedule 1). The last step to run
> was step 1 (Step 1).
> Please talk in baby steps - thanks.
> Julie
|||Hi Julie
"Kaidi" wrote:

> Followup, for anyone who happens to hit this post on a usenet search.
> (I hate finding my problem with no solution.
I had replied to this!

> There's an SP called sp_delete_job that you can use with either a job
> name or a job id and it takes care of the cleanup required to remove
> the maintenance plan completely from your system.
> Do *not* simply delete the job rows that are causing the problem from
> the msdb.sysjobs table. Unfortunately, that is what I did, and it's
> taken me a couple of hours to track down all of the pieces/references
> to the job in other tables. I'm just hoping to heck I got them all...I
> went manually through all of the delete commands in the sp_delete_job
> procedure, and praying that it worked!
You did not mention this in your original post. It is never recommended to
hack the system tables.

> :P
> Julie
>
John
|||On Apr 7, 6:56 am, John Bell <jbellnewspo...@.hotmail.com> wrote:
> Hi Julie
> "Kaidi" wrote:
> I had replied to this!
>
No replies came up in this thread at Google, John - sorry!

> You did not mention this in your original post. It is never recommended to
> hack the system tables.
> John
When I posted originally, I hadn't DONE that yet, but didn't see any
replies.
There are 3 dbs that are backing up through the orphan, at 1gb each
when squished as small as they can go - the HD fills up and if I miss
deleting them, it shuts my client's biz down entirely. I'm gonna be
gone for a month, and they clueless with regards to the server and
have no IT person, so I had to do SOMETHING. Obviously, that something
wasn't a great choice! (Wish I'd seen whatever your post was - lol)
While the orphan is still generating a couple of "Unable to retrieve
steps" errors in the event log, it's at least no longer creating
backups. I think the job order or whatever that'd be called (hey, I'm
a graphic designer and a hack vbscript/javascript programmer - lol)
must be cached somewhere. I'll track it down eventually.
You have *no idea* how sorry I am that I haven't seen your reply! :D
Thanks again,
Julie

"Orphaned" maintenance plan

Warning ahead of time - I'm a total idiot about this stuff.
Server is Windows Server 2003
SQL Enterprise Manager version is 8.0
I had been having a problem getting backups to auto delete and so
followed the instructions in a Microsoft KB article and set the
recovery mode to Full for all of the DBs. That solved the problem for
almost every database in the system.
However, apparently at some point several of the databases used a
maintenance plan called "DB Maintenance Plan2" which no longer exists
on the system. (There is currently only a single maintenance plan on
the system.) How can I find out where this is coming from and delete
it?
This was the error in the Events log:
SQL Server Scheduled Job 'DB Backup Job for DB Maintenance Plan 'DB
Maintenance Plan2'' (0x8AB900BBC4CB7E409DCF47CACB85233E) - Status:
Failed - Invoked on: 2007-04-04 03:00:00 - Message: The job failed.
The Job was invoked by Schedule 5 (Schedule 1). The last step to run
was step 1 (Step 1).
Please talk in baby steps - thanks.
JulieHi Julie
"Kaidi" wrote:

> Warning ahead of time - I'm a total idiot about this stuff.
> Server is Windows Server 2003
> SQL Enterprise Manager version is 8.0
> I had been having a problem getting backups to auto delete and so
> followed the instructions in a Microsoft KB article and set the
> recovery mode to Full for all of the DBs. That solved the problem for
> almost every database in the system.
> However, apparently at some point several of the databases used a
> maintenance plan called "DB Maintenance Plan2" which no longer exists
> on the system. (There is currently only a single maintenance plan on
> the system.) How can I find out where this is coming from and delete
> it?
> This was the error in the Events log:
> SQL Server Scheduled Job 'DB Backup Job for DB Maintenance Plan 'DB
> Maintenance Plan2'' (0x8AB900BBC4CB7E409DCF47CACB85233E) - Status:
> Failed - Invoked on: 2007-04-04 03:00:00 - Message: The job failed.
> The Job was invoked by Schedule 5 (Schedule 1). The last step to run
> was step 1 (Step 1).
> Please talk in baby steps - thanks.
> Julie
>
I am not sure if it is the job you are looking for or not! But if you start
SQL Enterprise Manager, and open up the Node for the SQL Server Instance, yo
u
will see a node for management under which is SQL Server Agent and then Jobs
.
There should be a job called "DB Backup Job for DB Maintenance Plan 'DB
Maintenance Plan2' " which will have a red cross next to it because it has
failed. Right click the job and choose delete from the menu to remove the
job. Usually when a maintenance plan is deleted the associated jobs should b
e
deleted.
John|||Followup, for anyone who happens to hit this post on a usenet search.
(I hate finding my problem with no solution.
There's an SP called sp_delete_job that you can use with either a job
name or a job id and it takes care of the cleanup required to remove
the maintenance plan completely from your system.
Do *not* simply delete the job rows that are causing the problem from
the msdb.sysjobs table. Unfortunately, that is what I did, and it's
taken me a couple of hours to track down all of the pieces/references
to the job in other tables. I'm just hoping to heck I got them all...I
went manually through all of the delete commands in the sp_delete_job
procedure, and praying that it worked!
:P
Julie
On Apr 4, 12:04 pm, "Kaidi" <julie.sie...@.gmail.com> wrote:
> Warning ahead of time - I'm a total idiot about this stuff.
> Server is Windows Server 2003
> SQL Enterprise Manager version is 8.0
> I had been having a problem getting backups to auto delete and so
> followed the instructions in a Microsoft KB article and set the
> recovery mode to Full for all of the DBs. That solved the problem for
> almost every database in the system.
> However, apparently at some point several of the databases used amaintenan
ce plancalled "DB MaintenancePlan2" which no longer exists
> on the system. (There is currently only a singlemaintenance planon
> the system.) How can I find out where this is coming from and delete
> it?
> This was the error in the Events log:
> SQL Server Scheduled Job 'DB Backup Job for DBMaintenance Plan'DB
> MaintenancePlan2'' (0x8AB900BBC4CB7E409DCF47CACB85233E) - Status:
> Failed - Invoked on: 2007-04-04 03:00:00 - Message: The job failed.
> The Job was invoked by Schedule 5 (Schedule 1). The last step to run
> was step 1 (Step 1).
> Please talk in baby steps - thanks.
> Julie|||Hi Julie
"Kaidi" wrote:

> Followup, for anyone who happens to hit this post on a usenet search.
> (I hate finding my problem with no solution.
I had replied to this!

> There's an SP called sp_delete_job that you can use with either a job
> name or a job id and it takes care of the cleanup required to remove
> the maintenance plan completely from your system.
> Do *not* simply delete the job rows that are causing the problem from
> the msdb.sysjobs table. Unfortunately, that is what I did, and it's
> taken me a couple of hours to track down all of the pieces/references
> to the job in other tables. I'm just hoping to heck I got them all...I
> went manually through all of the delete commands in the sp_delete_job
> procedure, and praying that it worked!
You did not mention this in your original post. It is never recommended to
hack the system tables.

> :P
> Julie
>
John|||On Apr 7, 6:56 am, John Bell <jbellnewspo...@.hotmail.com> wrote:
> Hi Julie
> "Kaidi" wrote:
> I had replied to this!
>
No replies came up in this thread at Google, John - sorry!

> You did not mention this in your original post. It is never recommended to
> hack the system tables.
> John
When I posted originally, I hadn't DONE that yet, but didn't see any
replies.
There are 3 dbs that are backing up through the orphan, at 1gb each
when squished as small as they can go - the HD fills up and if I miss
deleting them, it shuts my client's biz down entirely. I'm gonna be
gone for a month, and they clueless with regards to the server and
have no IT person, so I had to do SOMETHING. Obviously, that something
wasn't a great choice! (Wish I'd seen whatever your post was - lol)
While the orphan is still generating a couple of "Unable to retrieve
steps" errors in the event log, it's at least no longer creating
backups. I think the job order or whatever that'd be called (hey, I'm
a graphic designer and a hack vbscript/javascript programmer - lol)
must be cached somewhere. I'll track it down eventually.
You have *no idea* how sorry I am that I haven't seen your reply! :D
Thanks again,
Julie

"Orphaned" maintenance plan

Warning ahead of time - I'm a total idiot about this stuff.
Server is Windows Server 2003
SQL Enterprise Manager version is 8.0
I had been having a problem getting backups to auto delete and so
followed the instructions in a Microsoft KB article and set the
recovery mode to Full for all of the DBs. That solved the problem for
almost every database in the system.
However, apparently at some point several of the databases used a
maintenance plan called "DB Maintenance Plan2" which no longer exists
on the system. (There is currently only a single maintenance plan on
the system.) How can I find out where this is coming from and delete
it?
This was the error in the Events log:
SQL Server Scheduled Job 'DB Backup Job for DB Maintenance Plan 'DB
Maintenance Plan2'' (0x8AB900BBC4CB7E409DCF47CACB85233E) - Status:
Failed - Invoked on: 2007-04-04 03:00:00 - Message: The job failed.
The Job was invoked by Schedule 5 (Schedule 1). The last step to run
was step 1 (Step 1).
Please talk in baby steps - thanks.
JulieHi Julie
"Kaidi" wrote:
> Warning ahead of time - I'm a total idiot about this stuff.
> Server is Windows Server 2003
> SQL Enterprise Manager version is 8.0
> I had been having a problem getting backups to auto delete and so
> followed the instructions in a Microsoft KB article and set the
> recovery mode to Full for all of the DBs. That solved the problem for
> almost every database in the system.
> However, apparently at some point several of the databases used a
> maintenance plan called "DB Maintenance Plan2" which no longer exists
> on the system. (There is currently only a single maintenance plan on
> the system.) How can I find out where this is coming from and delete
> it?
> This was the error in the Events log:
> SQL Server Scheduled Job 'DB Backup Job for DB Maintenance Plan 'DB
> Maintenance Plan2'' (0x8AB900BBC4CB7E409DCF47CACB85233E) - Status:
> Failed - Invoked on: 2007-04-04 03:00:00 - Message: The job failed.
> The Job was invoked by Schedule 5 (Schedule 1). The last step to run
> was step 1 (Step 1).
> Please talk in baby steps - thanks.
> Julie
>
I am not sure if it is the job you are looking for or not! But if you start
SQL Enterprise Manager, and open up the Node for the SQL Server Instance, you
will see a node for management under which is SQL Server Agent and then Jobs.
There should be a job called "DB Backup Job for DB Maintenance Plan 'DB
Maintenance Plan2' " which will have a red cross next to it because it has
failed. Right click the job and choose delete from the menu to remove the
job. Usually when a maintenance plan is deleted the associated jobs should be
deleted.
John|||Followup, for anyone who happens to hit this post on a usenet search.
(I hate finding my problem with no solution.
There's an SP called sp_delete_job that you can use with either a job
name or a job id and it takes care of the cleanup required to remove
the maintenance plan completely from your system.
Do *not* simply delete the job rows that are causing the problem from
the msdb.sysjobs table. Unfortunately, that is what I did, and it's
taken me a couple of hours to track down all of the pieces/references
to the job in other tables. I'm just hoping to heck I got them all...I
went manually through all of the delete commands in the sp_delete_job
procedure, and praying that it worked!
:P
Julie
On Apr 4, 12:04 pm, "Kaidi" <julie.sie...@.gmail.com> wrote:
> Warning ahead of time - I'm a total idiot about this stuff.
> Server is Windows Server 2003
> SQL Enterprise Manager version is 8.0
> I had been having a problem getting backups to auto delete and so
> followed the instructions in a Microsoft KB article and set the
> recovery mode to Full for all of the DBs. That solved the problem for
> almost every database in the system.
> However, apparently at some point several of the databases used amaintenance plancalled "DB MaintenancePlan2" which no longer exists
> on the system. (There is currently only a singlemaintenance planon
> the system.) How can I find out where this is coming from and delete
> it?
> This was the error in the Events log:
> SQL Server Scheduled Job 'DB Backup Job for DBMaintenance Plan'DB
> MaintenancePlan2'' (0x8AB900BBC4CB7E409DCF47CACB85233E) - Status:
> Failed - Invoked on: 2007-04-04 03:00:00 - Message: The job failed.
> The Job was invoked by Schedule 5 (Schedule 1). The last step to run
> was step 1 (Step 1).
> Please talk in baby steps - thanks.
> Julie|||Hi Julie
"Kaidi" wrote:
> Followup, for anyone who happens to hit this post on a usenet search.
> (I hate finding my problem with no solution.
I had replied to this!
> There's an SP called sp_delete_job that you can use with either a job
> name or a job id and it takes care of the cleanup required to remove
> the maintenance plan completely from your system.
> Do *not* simply delete the job rows that are causing the problem from
> the msdb.sysjobs table. Unfortunately, that is what I did, and it's
> taken me a couple of hours to track down all of the pieces/references
> to the job in other tables. I'm just hoping to heck I got them all...I
> went manually through all of the delete commands in the sp_delete_job
> procedure, and praying that it worked!
You did not mention this in your original post. It is never recommended to
hack the system tables.
> :P
> Julie
>
John|||On Apr 7, 6:56 am, John Bell <jbellnewspo...@.hotmail.com> wrote:
> Hi Julie
> "Kaidi" wrote:
> > Followup, for anyone who happens to hit this post on a usenet search.
> > (I hate finding my problem with no solution.
> I had replied to this!
>
No replies came up in this thread at Google, John - sorry!
> > Do *not* simply delete the job rows that are causing the problem from
> > the msdb.sysjobs table. Unfortunately, that is what I did, and it's
> > taken me a couple of hours to track down all of the pieces/references
> > to the job in other tables. I'm just hoping to heck I got them all...I
> > went manually through all of the delete commands in the sp_delete_job
> > procedure, and praying that it worked!
> You did not mention this in your original post. It is never recommended to
> hack the system tables.
> John
When I posted originally, I hadn't DONE that yet, but didn't see any
replies.
There are 3 dbs that are backing up through the orphan, at 1gb each
when squished as small as they can go - the HD fills up and if I miss
deleting them, it shuts my client's biz down entirely. I'm gonna be
gone for a month, and they clueless with regards to the server and
have no IT person, so I had to do SOMETHING. Obviously, that something
wasn't a great choice! (Wish I'd seen whatever your post was - lol)
While the orphan is still generating a couple of "Unable to retrieve
steps" errors in the event log, it's at least no longer creating
backups. I think the job order or whatever that'd be called (hey, I'm
a graphic designer and a hack vbscript/javascript programmer - lol)
must be cached somewhere. I'll track it down eventually.
You have *no idea* how sorry I am that I haven't seen your reply! :D
Thanks again,
Julie

"ORA-03114: not connected to ORACLE".

In a windows service (.NET) on unplugging network cable it use to loose
connection to oracle database.
Once the network connection was up it was found that the service was unable
to restore its connection to oracle database.
The conclusion that we drew after doing R&D was that, the connection pool
was keeping the bad connection in connection pool on network disconnection
which resulted in the service to use those bad connection and keep throwing
exception “not connected to Oracle”.
On Microsoft site there is a mention of Hot Fix. Where can we get this?
http://support.microsoft.com/default...b;en-us;830173
Is there any way we can solve this problem without applying the HOT FIX.
Architect
eBusiness & Intranet
You will need to contact Microsoft PSS Developer Support (contact information
is on the kb article you referenced.) There are two versions of the hotfix,
..NET RTM and .NET 1.1 SP1.
"WEB_CMA" wrote:
> In a windows service (.NET) on unplugging network cable it use to loose
> connection to oracle database.
> Once the network connection was up it was found that the service was unable
> to restore its connection to oracle database.
> The conclusion that we drew after doing R&D was that, the connection pool
> was keeping the bad connection in connection pool on network disconnection
> which resulted in the service to use those bad connection and keep throwing
> exception “not connected to Oracle”.
> On Microsoft site there is a mention of Hot Fix. Where can we get this?
> http://support.microsoft.com/default...b;en-us;830173
>
> Is there any way we can solve this problem without applying the HOT FIX.
> --
> Architect
> eBusiness & Intranet
>

"ORA-03114: not connected to ORACLE".

In a windows service (.NET) on unplugging network cable it use to loose
connection to oracle database.
Once the network connection was up it was found that the service was unable
to restore its connection to oracle database.
The conclusion that we drew after doing R&D was that, the connection pool
was keeping the bad connection in connection pool on network disconnection
which resulted in the service to use those bad connection and keep throwing
exception “not connected to Oracle”.
On Microsoft site there is a mention of Hot Fix. Where can we get this'
http://support.microsoft.com/defaul...kb;en-us;830173
Is there any way we can solve this problem without applying the HOT FIX.
Architect
eBusiness & IntranetYou will need to contact Microsoft PSS Developer Support (contact informatio
n
is on the kb article you referenced.) There are two versions of the hotfix,
.NET RTM and .NET 1.1 SP1.
"WEB_CMA" wrote:
> In a windows service (.NET) on unplugging network cable it use to loose
> connection to oracle database.
> Once the network connection was up it was found that the service was unabl
e
> to restore its connection to oracle database.
> The conclusion that we drew after doing R&D was that, the connection pool
> was keeping the bad connection in connection pool on network disconnection
> which resulted in the service to use those bad connection and keep throwin
g
> exception “not connected to Oracle”.
> On Microsoft site there is a mention of Hot Fix. Where can we get this'
> http://support.microsoft.com/defaul...kb;en-us;830173
>
> Is there any way we can solve this problem without applying the HOT FIX.
> --
> Architect
> eBusiness & Intranet
>

"Net Send" from SQL2000 on Windows 2003.

Hi all.
The following command don't work on ours SQL server anymore. Not sure why,
but could it be that the command "Net Send" is removed for NT 2000?
Any ideas.
Thanks
Geir
DECLARE @.Message varchar(255)
Set @.Message = 'net send USER Message to OLNY from SAM : . TEST, TEST, Price
to low!. Order 6555 '
EXEC master.. xp_cmdshell @.Message, no_outputHi
Is your SQL Server Service Account a Domain account? If not, change it to a
domain account.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Geir Holme" <geir@.multicase.no> wrote in message
news:%23lrHkVOxFHA.3720@.TK2MSFTNGP11.phx.gbl...
> Hi all.
> The following command don't work on ours SQL server anymore. Not sure why,
> but could it be that the command "Net Send" is removed for NT 2000?
> Any ideas.
> Thanks
> Geir
> DECLARE @.Message varchar(255)
> Set @.Message = 'net send USER Message to OLNY from SAM : . TEST, TEST,
> Price to low!. Order 6555 '
> EXEC master.. xp_cmdshell @.Message, no_output
>|||Hi
See this example written by Tibor
USE master
GO
CREATE PROC sp_dbm_notify_users @.msg VARCHAR(255) AS
/ ****************************************
***********************************
****/
/* This procedure does a NET SEND to all connected computers.
*/
/* Requires that the messenger service is running on the client.
*/
/* The bat file is a sample showing how a message can be sent from the OS.
A */
/* shortcut to the bat file can be placed on the desktop, for instance
*/
/* The procedure takes the following parameter:
*/
/* @.msg VARCHAR(255) (required): The message to be sent
*/
/* Written by Tibor Karaszi and Brje Carlsson 1999. www.dbmaint.com
*/
/* Tested on verion 6.5, 7.0 and 8.0.
*/
/ ****************************************
***********************************
****/
SET NOCOUNT ON
--Get version number and verify supported version
DECLARE @.ver VARCHAR(7)
SELECT @.ver = CASE
WHEN CHARINDEX('6.50', @.@.VERSION) > 0 THEN '6.50'
WHEN CHARINDEX('7.00', @.@.VERSION) > 0 THEN '7.00'
WHEN CHARINDEX('8.00', @.@.VERSION) > 0 THEN '8.00'
ELSE 'Unknown'
END
IF @.ver = 'Unknown'
BEGIN
RAISERROR('Unsupported version of SQL Server.',16,1)
RETURN -101
END
--Declare variables section
DECLARE loop_name INSENSITIVE CURSOR FOR
SELECT DISTINCT LTRIM(RTRIM(hostname))
FROM master..sysprocesses
WHERE DATALENGTH(LTRIM(RTRIM(hostname))) > 0
OPEN loop_name
DECLARE @.host_name VARCHAR(30)
DECLARE @.exec_str VARCHAR(255)
FETCH NEXT FROM loop_name INTO @.host_name
WHILE (@.@.fetch_status = 0)
BEGIN
SELECT @.exec_str = 'master..xp_cmdshell "NET SEND ' + @.host_name + ' '
+ @.msg + '"'
EXEC( @.exec_str)
FETCH NEXT FROM loop_name INTO @.host_name
END
DEALLOCATE loop_name
GO
/* Sample Execution:
EXEC sp_dbm_notify_users 'SQL Server will shut down in 30 minutes!'
*/

"Geir Holme" <geir@.multicase.no> wrote in message
news:%23lrHkVOxFHA.3720@.TK2MSFTNGP11.phx.gbl...
> Hi all.
> The following command don't work on ours SQL server anymore. Not sure why,
> but could it be that the command "Net Send" is removed for NT 2000?
> Any ideas.
> Thanks
> Geir
> DECLARE @.Message varchar(255)
> Set @.Message = 'net send USER Message to OLNY from SAM : . TEST, TEST,
> Price to low!. Order 6555 '
> EXEC master.. xp_cmdshell @.Message, no_output
>|||it's possible that your messenger service may be shut down (check start ->
run-> services.msc -> messenger).
Regards,
Mary
"Geir Holme" <geir@.multicase.no> wrote in message
news:%23lrHkVOxFHA.3720@.TK2MSFTNGP11.phx.gbl...
> Hi all.
> The following command don't work on ours SQL server anymore. Not sure why,
> but could it be that the command "Net Send" is removed for NT 2000?
> Any ideas.
> Thanks
> Geir
> DECLARE @.Message varchar(255)
> Set @.Message = 'net send USER Message to OLNY from SAM : . TEST, TEST,
> Price to low!. Order 6555 '
> EXEC master.. xp_cmdshell @.Message, no_output
>

"Lock Pages in Memory" Service Account and SQL Agent

Microsoft recommends using the Lock Pages in Memory privilege for SQl
Server 2005 x64 running on Windows Server 2003 R2 x64.
If granting this privilege allows this user to Lock Pages in Memory,
should SQL Agent be changed to use a different service account that
does not have this privilege? (both SQL and Agent use the same account
currently)
I am thinking that if both SQL Server and SQL Agent are running under
a account with this privilege if they will conflict. Is this the case?Perhaps you are talking about this on BOL
"Although it is not required, we recommend locking pages in memory when
using 64-bit operating systems. For 32-bit operating systems, Lock pages in
memory permission must be granted before AWE is configured for SQL Server."
I do not see why there could be a conflict if both services are using the
same Windows account and this account has the Lock pages in memory permission
granted. It should be Ok.
(BOL note from
Enabling Memory Support for Over 4 GB of Physical Memory
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/34950321-2bfd-4679-8f1b-0a0a440eb443.htm
)
Hope this helps,
Ben Nevarez
"Neufusion" wrote:
> Microsoft recommends using the Lock Pages in Memory privilege for SQl
> Server 2005 x64 running on Windows Server 2003 R2 x64.
> If granting this privilege allows this user to Lock Pages in Memory,
> should SQL Agent be changed to use a different service account that
> does not have this privilege? (both SQL and Agent use the same account
> currently)
> I am thinking that if both SQL Server and SQL Agent are running under
> a account with this privilege if they will conflict. Is this the case?
>|||The main SQL Server service is specifically designed for managing large
amounts of memory and has an option to use AWE but the SQL Agent only works
like any other regular program as far as memory management's concerned
(Virtual Memory). Therefore there's no reason to think both services would
make large AWE allocations at startup.
Regards,
Greg Linwood
SQL Server MVP
http://blogs.sqlserver.org.au/blogs/greg_linwood
Benchmark your query performance
http://www.SQLBenchmarkPro.com
"Neufusion" <mikeymiller@.gmail.com> wrote in message
news:9a4a6b46-f949-4c38-a277-9757134c0714@.d21g2000prg.googlegroups.com...
> Microsoft recommends using the Lock Pages in Memory privilege for SQl
> Server 2005 x64 running on Windows Server 2003 R2 x64.
> If granting this privilege allows this user to Lock Pages in Memory,
> should SQL Agent be changed to use a different service account that
> does not have this privilege? (both SQL and Agent use the same account
> currently)
> I am thinking that if both SQL Server and SQL Agent are running under
> a account with this privilege if they will conflict. Is this the case?|||If I remember correctly, the "Lock pages in memory" setting only applies to
Enterprise, not Standard edition. not sure which you are running
--
Kevin3NF
SQL Server dude
You want fries with that?
http://kevin3nf.blogspot.com/
I only check the newsgroups during work hours, M-F.
Hit my blog and the contact links if necessary...I may be available.
"Neufusion" <mikeymiller@.gmail.com> wrote in message
news:9a4a6b46-f949-4c38-a277-9757134c0714@.d21g2000prg.googlegroups.com...
> Microsoft recommends using the Lock Pages in Memory privilege for SQl
> Server 2005 x64 running on Windows Server 2003 R2 x64.
> If granting this privilege allows this user to Lock Pages in Memory,
> should SQL Agent be changed to use a different service account that
> does not have this privilege? (both SQL and Agent use the same account
> currently)
> I am thinking that if both SQL Server and SQL Agent are running under
> a account with this privilege if they will conflict. Is this the case?|||This was true for SQL 2000 but not SQL 2005
Regards,
Greg Linwood
SQL Server MVP
http://blogs.sqlserver.org.au/blogs/greg_linwood
Benchmark your query performance
http://www.SQLBenchmarkPro.com
"Kevin3NF" <kevin@.SPAMTRAP.3nf-inc.com> wrote in message
news:Oh8WQgnYIHA.3964@.TK2MSFTNGP03.phx.gbl...
> If I remember correctly, the "Lock pages in memory" setting only applies
> to Enterprise, not Standard edition. not sure which you are running
> --
> Kevin3NF
> SQL Server dude
> You want fries with that?
> http://kevin3nf.blogspot.com/
> I only check the newsgroups during work hours, M-F.
> Hit my blog and the contact links if necessary...I may be available.
>
> "Neufusion" <mikeymiller@.gmail.com> wrote in message
> news:9a4a6b46-f949-4c38-a277-9757134c0714@.d21g2000prg.googlegroups.com...
>> Microsoft recommends using the Lock Pages in Memory privilege for SQl
>> Server 2005 x64 running on Windows Server 2003 R2 x64.
>> If granting this privilege allows this user to Lock Pages in Memory,
>> should SQL Agent be changed to use a different service account that
>> does not have this privilege? (both SQL and Agent use the same account
>> currently)
>> I am thinking that if both SQL Server and SQL Agent are running under
>> a account with this privilege if they will conflict. Is this the case?
>|||http://support.microsoft.com/kb/918483/en-us
Note For 64-bit systems, SQL Server 2005 Enterprise Edition is the only
edition that is designed to use lock pages in memory.
Am I misreading? I have a 3 node, 2 instance cluster my customer is about
to upgrade for this very reason...
--
Kevin3NF
SQL Server dude
You want fries with that?
http://kevin3nf.blogspot.com/
I only check the newsgroups during work hours, M-F.
Hit my blog and the contact links if necessary...I may be available.
"Greg Linwood" <g_linwood@.hotmail.com> wrote in message
news:utExsLrYIHA.4196@.TK2MSFTNGP04.phx.gbl...
> This was true for SQL 2000 but not SQL 2005
> Regards,
> Greg Linwood
> SQL Server MVP
> http://blogs.sqlserver.org.au/blogs/greg_linwood
> Benchmark your query performance
> http://www.SQLBenchmarkPro.com
> "Kevin3NF" <kevin@.SPAMTRAP.3nf-inc.com> wrote in message
> news:Oh8WQgnYIHA.3964@.TK2MSFTNGP03.phx.gbl...
>> If I remember correctly, the "Lock pages in memory" setting only applies
>> to Enterprise, not Standard edition. not sure which you are running
>> --
>> Kevin3NF
>> SQL Server dude
>> You want fries with that?
>> http://kevin3nf.blogspot.com/
>> I only check the newsgroups during work hours, M-F.
>> Hit my blog and the contact links if necessary...I may be available.
>>
>> "Neufusion" <mikeymiller@.gmail.com> wrote in message
>> news:9a4a6b46-f949-4c38-a277-9757134c0714@.d21g2000prg.googlegroups.com...
>> Microsoft recommends using the Lock Pages in Memory privilege for SQl
>> Server 2005 x64 running on Windows Server 2003 R2 x64.
>> If granting this privilege allows this user to Lock Pages in Memory,
>> should SQL Agent be changed to use a different service account that
>> does not have this privilege? (both SQL and Agent use the same account
>> currently)
>> I am thinking that if both SQL Server and SQL Agent are running under
>> a account with this privilege if they will conflict. Is this the case?
>>
>

"key not valid for use in the specified state"

I upgraded to Windows 2003 SP1, and now I keep getting the message: "Key not
valid for use in the specified state" on any page of the Report Manager that
I try to access.
I've tried deleting and recreating the keys with no success. The search that
I've done in the MS Site have all pointed me to EFS errors. Anybody have any
ideas where I should go next?
Thanks.
DerrickI had that problem 6 months ago. After opening a support call with MS
and after many attempts to fix it, in the end the only process that
worked was to completely erase all traces of RS from the system and then
do a fresh install. Below is a list of the steps to take (note
especially step 5 - this was the deciding factor for me on the reinstall
fixing the problem)
1. Backup your existing solution files, such as .sln, .rdl, .rds files.
2. If the machine is a domain controller, do not install Reporting
Service on it. Use another machine instead.
3. Run Setup.exe of the SQL Server 2000 Reporting Services to launch the
Setup window.
4. Click "Remove Microsoft SQL Server 2000 Reporting Service" button in
the Setup window.
5. From Explorer, navigate to x:\Documents and Settings\<service
account>\Application Data\Microsoft\Crypto\RSA\S-1-5-20 and delete all
files located in this folder.
6. Delete all Reporting services related files under this folder
"x:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services" if present
7. Delete all Reporting Services Virtual Directories (ReportServer and
Reports) from IIS Manager if present.
8. Delete all Reporting Services Databases (ReportServer and
ReportServerTempDB) from SQL Server Enterprise Manager if present.
9. Re-boot the machine and log on using an Administrators group account.
10. Reinstall SQL Server 2000 Reporting Service on the machine.
brian smith
Derrick Powell wrote:
> I upgraded to Windows 2003 SP1, and now I keep getting the message: "Key not
> valid for use in the specified state" on any page of the Report Manager that
> I try to access.
> I've tried deleting and recreating the keys with no success. The search that
> I've done in the MS Site have all pointed me to EFS errors. Anybody have any
> ideas where I should go next?
> Thanks.
> Derrick
>

"Invalid authorization specification"

Hello,

I have a web application (ISAPI) that accesses a SQL Server 2000 (sp3) database in the same machine as the Web Server (IIS 6). Windows 2003 Standard Edition is the operating System. So, when users access the aplication through the web it runs ok until display the error message "Invalid authorization specification" or, sometimes, another message about failure to inform ODBC DSN, although I dont use ODBC.

When the error occurs, the user press F5 in the browser and the operation goes ok. It's an intermitent and curious error.

Can somebody help me?

Thanks in advance.

Ado.I have no clue

http://www.easysoft.com/products/9999/faq_answer.phtml?ID=123&product=2002

ok, now with the pot shots...

"Insufficient memory available" on SQL 2000

Hi All,
We have SQL 2000 ent and Windows 2003 , in a few day , restart many
time the error message in event log is "Error: 17803, Severity: 20, State:
14
Insufficient memory available."
i try open SQL profiler and use performance monitor , but i don't know how
to fix ? in profiler display error log , but i don't know is server problem
or application problem , how to check the problem ? help
SQL 2000 Ent ,enable AWE
Windows 2003 ent enable PAE
RAM : 16 GB
In Profiler error :
" 2007-09-18 04:54:49.51 spid56 BPool::Map: no remappable address found."
"2007-09-18 04:54:49.54 spid56 Buffer Distribution: Stolen=122023
Free=949769 Procedures=7
Inram=0 Dirty=236616 Kept=0
I/O=0, Latched=194, Other=107327"
"2007-09-18 04:54:49.54 spid56 Buffer Counts: Commited=1415936
Target=1415936 Hashed=344137
InternalReservation=360 ExternalReservation=0 Min Free=128 Visible= 191272"
"2007-09-18 04:54:49.54 spid56 Procedure Cache: TotalProcs=6
TotalPages=7 InUsePages=4"
"2007-09-18 04:54:49.54 spid56 Dynamic Memory Manager: Stolen=122029 OS
Reserved=3168
OS Committed=3112
OS In Use=3108
Query Plan=96903 Optimizer=1
General=24144
Utilities=160 Connection=3834 "
"2007-09-18 04:54:49.54 spid56 Dynamic Memory Manager: Stolen=122029 OS
Reserved=3168
OS Committed=3112
OS In Use=3108
Query Plan=96903 Optimizer=1
General=24144
Utilities=160 Connection=3834"
"2007-09-18 04:54:49.54 spid56 Query Memory Manager: Grants=0 Waiting=0
Maximum=52143 Available=52143"
"Error: 701, Severity: 17, State: 132"
"2007-09-18 04:54:49.56 spid56 BPool::Map: no remappable address found."
"2007-09-18 04:54:49.59 spid56 Buffer Distribution: Stolen=122022
Free=949770 Procedures=7
Inram=0 Dirty=236616 Kept=0
I/O=0, Latched=194, Other=107327"
"2007-09-18 04:54:49.59 spid56 Buffer Counts: Commited=1415936
Target=1415936 Hashed=344137
InternalReservation=360 ExternalReservation=0 Min Free=128 Visible= 191272"
"2007-09-18 04:54:49.59 spid56 Procedure Cache: TotalProcs=6
TotalPages=7 InUsePages=4"
......
how to fix this , i need restart the server mant time on everyday , HELP !!!Check out the following stuff from System Monitor:
Memory: Available MBytes
Memory: Page Faults\sec
MSSQL$<instance_name>: Buffer Manager: Buffer cache hit ratio
MSSQL$<instance_name>: Buffer Manager: Page life expectancy
MSSQL$<instance_name>: General Statistics: User Connections
Physical Disk: % Disk Time
Physical Disk: Disk Read Bytes\sec
Physical Disk: Disk Write Bytes\sec
Physical Disk: Avg. Disk Queue Length
Processor: % Processor Time
System: Processor Queue Length
Did you restarted your Windows Server after setting up PAE and same for SQL
Server's AWE setting. You need to restart your SQL Server service to take
effect this setting.
Please let me know the values of the counters above. (Don't analyze only for
2-3 mins. Give them at least 1 hour to work and do it in peak-hours)
Ekrem Önsoy
"pcnetnet" <pcnetnet@.yahoo.com.hk> wrote in message
news:e3Te6Yh%23HHA.5160@.TK2MSFTNGP05.phx.gbl...
> Hi All,
> We have SQL 2000 ent and Windows 2003 , in a few day , restart many
> time the error message in event log is "Error: 17803, Severity: 20,
> State:
> 14
> Insufficient memory available."
> i try open SQL profiler and use performance monitor , but i don't know how
> to fix ? in profiler display error log , but i don't know is server
> problem
> or application problem , how to check the problem ? help
> SQL 2000 Ent ,enable AWE
> Windows 2003 ent enable PAE
> RAM : 16 GB
> In Profiler error :
> " 2007-09-18 04:54:49.51 spid56 BPool::Map: no remappable address
> found."
> "2007-09-18 04:54:49.54 spid56 Buffer Distribution: Stolen=122023
> Free=949769 Procedures=7
> Inram=0 Dirty=236616 Kept=0
> I/O=0, Latched=194, Other=107327"
> "2007-09-18 04:54:49.54 spid56 Buffer Counts: Commited=1415936
> Target=1415936 Hashed=344137
> InternalReservation=360 ExternalReservation=0 Min Free=128 Visible=> 191272"
> "2007-09-18 04:54:49.54 spid56 Procedure Cache: TotalProcs=6
> TotalPages=7 InUsePages=4"
> "2007-09-18 04:54:49.54 spid56 Dynamic Memory Manager: Stolen=122029
> OS
> Reserved=3168
> OS Committed=3112
> OS In Use=3108
> Query Plan=96903 Optimizer=1
> General=24144
> Utilities=160 Connection=3834 "
> "2007-09-18 04:54:49.54 spid56 Dynamic Memory Manager: Stolen=122029
> OS
> Reserved=3168
> OS Committed=3112
> OS In Use=3108
> Query Plan=96903 Optimizer=1
> General=24144
> Utilities=160 Connection=3834"
> "2007-09-18 04:54:49.54 spid56 Query Memory Manager: Grants=0
> Waiting=0
> Maximum=52143 Available=52143"
> "Error: 701, Severity: 17, State: 132"
> "2007-09-18 04:54:49.56 spid56 BPool::Map: no remappable address
> found."
> "2007-09-18 04:54:49.59 spid56 Buffer Distribution: Stolen=122022
> Free=949770 Procedures=7
> Inram=0 Dirty=236616 Kept=0
> I/O=0, Latched=194, Other=107327"
> "2007-09-18 04:54:49.59 spid56 Buffer Counts: Commited=1415936
> Target=1415936 Hashed=344137
> InternalReservation=360 ExternalReservation=0 Min Free=128 Visible=> 191272"
> "2007-09-18 04:54:49.59 spid56 Procedure Cache: TotalProcs=6
> TotalPages=7 InUsePages=4"
> ......
> how to fix this , i need restart the server mant time on everyday , HELP
> !!!
>
>
>
>|||pcnetnet (pcnetnet@.yahoo.com.hk) writes:
> We have SQL 2000 ent and Windows 2003 , in a few day , restart
> many time the error message in event log is "Error: 17803, Severity:
> 20, State: 14 Insufficient memory available." i try open SQL profiler
> and use performance monitor , but i don't know how to fix ? in profiler
> display error log , but i don't know is server problem or application
> problem , how to check the problem ? help
That looks really bad. I was about to suggest that you should open a
case with Microsoft, but as I searched in Books Online for error
17803, I found something interesting: it's listed in a section for
for error codes listed by Open Data Services. So maybe this is due
to a memory leak in an extended stored procedure?
Do you if there are any extended stored procedures installed on your
system (beside those that ship with SQL Server)? Would it be possible
to keep them from running for a while to see if the problem goes away.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx|||Hi ekrem,
i have restart the server to take the effect , but the same case, i have
the momitor file , how to post to this ?
"Ekrem Önsoy" <ekrem@.btegitim.com> wrote in message
news:4F41E891-DC4A-4D2C-89C3-52441BDB998A@.microsoft.com...
> Check out the following stuff from System Monitor:
> Memory: Available MBytes
> Memory: Page Faults\sec
> MSSQL$<instance_name>: Buffer Manager: Buffer cache hit ratio
> MSSQL$<instance_name>: Buffer Manager: Page life expectancy
> MSSQL$<instance_name>: General Statistics: User Connections
> Physical Disk: % Disk Time
> Physical Disk: Disk Read Bytes\sec
> Physical Disk: Disk Write Bytes\sec
> Physical Disk: Avg. Disk Queue Length
> Processor: % Processor Time
> System: Processor Queue Length
> Did you restarted your Windows Server after setting up PAE and same for
> SQL Server's AWE setting. You need to restart your SQL Server service to
> take effect this setting.
> Please let me know the values of the counters above. (Don't analyze only
> for 2-3 mins. Give them at least 1 hour to work and do it in peak-hours)
>
> --
> Ekrem Önsoy
>
> "pcnetnet" <pcnetnet@.yahoo.com.hk> wrote in message
> news:e3Te6Yh%23HHA.5160@.TK2MSFTNGP05.phx.gbl...
>> Hi All,
>> We have SQL 2000 ent and Windows 2003 , in a few day , restart
>> many
>> time the error message in event log is "Error: 17803, Severity: 20,
>> State:
>> 14
>> Insufficient memory available."
>> i try open SQL profiler and use performance monitor , but i don't know
>> how
>> to fix ? in profiler display error log , but i don't know is server
>> problem
>> or application problem , how to check the problem ? help
>> SQL 2000 Ent ,enable AWE
>> Windows 2003 ent enable PAE
>> RAM : 16 GB
>> In Profiler error :
>> " 2007-09-18 04:54:49.51 spid56 BPool::Map: no remappable address
>> found."
>> "2007-09-18 04:54:49.54 spid56 Buffer Distribution: Stolen=122023
>> Free=949769 Procedures=7
>> Inram=0 Dirty=236616 Kept=0
>> I/O=0, Latched=194, Other=107327"
>> "2007-09-18 04:54:49.54 spid56 Buffer Counts: Commited=1415936
>> Target=1415936 Hashed=344137
>> InternalReservation=360 ExternalReservation=0 Min Free=128 Visible=>> 191272"
>> "2007-09-18 04:54:49.54 spid56 Procedure Cache: TotalProcs=6
>> TotalPages=7 InUsePages=4"
>> "2007-09-18 04:54:49.54 spid56 Dynamic Memory Manager: Stolen=122029
>> OS
>> Reserved=3168
>> OS Committed=3112
>> OS In Use=3108
>> Query Plan=96903 Optimizer=1
>> General=24144
>> Utilities=160 Connection=3834 "
>> "2007-09-18 04:54:49.54 spid56 Dynamic Memory Manager: Stolen=122029
>> OS
>> Reserved=3168
>> OS Committed=3112
>> OS In Use=3108
>> Query Plan=96903 Optimizer=1
>> General=24144
>> Utilities=160 Connection=3834"
>> "2007-09-18 04:54:49.54 spid56 Query Memory Manager: Grants=0
>> Waiting=0
>> Maximum=52143 Available=52143"
>> "Error: 701, Severity: 17, State: 132"
>> "2007-09-18 04:54:49.56 spid56 BPool::Map: no remappable address
>> found."
>> "2007-09-18 04:54:49.59 spid56 Buffer Distribution: Stolen=122022
>> Free=949770 Procedures=7
>> Inram=0 Dirty=236616 Kept=0
>> I/O=0, Latched=194, Other=107327"
>> "2007-09-18 04:54:49.59 spid56 Buffer Counts: Commited=1415936
>> Target=1415936 Hashed=344137
>> InternalReservation=360 ExternalReservation=0 Min Free=128 Visible=>> 191272"
>> "2007-09-18 04:54:49.59 spid56 Procedure Cache: TotalProcs=6
>> TotalPages=7 InUsePages=4"
>> ......
>> how to fix this , i need restart the server mant time on everyday , HELP
>> !!!
>>
>>
>>
>>
>|||Attach file to your message and send it.
I hope it's not a big issue as Erland mentioned.
--
Ekrem Önsoy
"Pcnetnet" <pcnetnet@.yahoo.com.hk> wrote in message
news:%232SKRom%23HHA.748@.TK2MSFTNGP04.phx.gbl...
> Hi ekrem,
> i have restart the server to take the effect , but the same case, i
> have the momitor file , how to post to this ?
> "Ekrem Önsoy" <ekrem@.btegitim.com> wrote in message
> news:4F41E891-DC4A-4D2C-89C3-52441BDB998A@.microsoft.com...
>> Check out the following stuff from System Monitor:
>> Memory: Available MBytes
>> Memory: Page Faults\sec
>> MSSQL$<instance_name>: Buffer Manager: Buffer cache hit ratio
>> MSSQL$<instance_name>: Buffer Manager: Page life expectancy
>> MSSQL$<instance_name>: General Statistics: User Connections
>> Physical Disk: % Disk Time
>> Physical Disk: Disk Read Bytes\sec
>> Physical Disk: Disk Write Bytes\sec
>> Physical Disk: Avg. Disk Queue Length
>> Processor: % Processor Time
>> System: Processor Queue Length
>> Did you restarted your Windows Server after setting up PAE and same for
>> SQL Server's AWE setting. You need to restart your SQL Server service to
>> take effect this setting.
>> Please let me know the values of the counters above. (Don't analyze only
>> for 2-3 mins. Give them at least 1 hour to work and do it in peak-hours)
>>
>> --
>> Ekrem Önsoy
>>
>> "pcnetnet" <pcnetnet@.yahoo.com.hk> wrote in message
>> news:e3Te6Yh%23HHA.5160@.TK2MSFTNGP05.phx.gbl...
>> Hi All,
>> We have SQL 2000 ent and Windows 2003 , in a few day , restart
>> many
>> time the error message in event log is "Error: 17803, Severity: 20,
>> State:
>> 14
>> Insufficient memory available."
>> i try open SQL profiler and use performance monitor , but i don't know
>> how
>> to fix ? in profiler display error log , but i don't know is server
>> problem
>> or application problem , how to check the problem ? help
>> SQL 2000 Ent ,enable AWE
>> Windows 2003 ent enable PAE
>> RAM : 16 GB
>> In Profiler error :
>> " 2007-09-18 04:54:49.51 spid56 BPool::Map: no remappable address
>> found."
>> "2007-09-18 04:54:49.54 spid56 Buffer Distribution: Stolen=122023
>> Free=949769 Procedures=7
>> Inram=0 Dirty=236616 Kept=0
>> I/O=0, Latched=194, Other=107327"
>> "2007-09-18 04:54:49.54 spid56 Buffer Counts: Commited=1415936
>> Target=1415936 Hashed=344137
>> InternalReservation=360 ExternalReservation=0 Min Free=128 Visible=>> 191272"
>> "2007-09-18 04:54:49.54 spid56 Procedure Cache: TotalProcs=6
>> TotalPages=7 InUsePages=4"
>> "2007-09-18 04:54:49.54 spid56 Dynamic Memory Manager: Stolen=122029
>> OS
>> Reserved=3168
>> OS Committed=3112
>> OS In Use=3108
>> Query Plan=96903 Optimizer=1
>> General=24144
>> Utilities=160 Connection=3834 "
>> "2007-09-18 04:54:49.54 spid56 Dynamic Memory Manager: Stolen=122029
>> OS
>> Reserved=3168
>> OS Committed=3112
>> OS In Use=3108
>> Query Plan=96903 Optimizer=1
>> General=24144
>> Utilities=160 Connection=3834"
>> "2007-09-18 04:54:49.54 spid56 Query Memory Manager: Grants=0
>> Waiting=0
>> Maximum=52143 Available=52143"
>> "Error: 701, Severity: 17, State: 132"
>> "2007-09-18 04:54:49.56 spid56 BPool::Map: no remappable address
>> found."
>> "2007-09-18 04:54:49.59 spid56 Buffer Distribution: Stolen=122022
>> Free=949770 Procedures=7
>> Inram=0 Dirty=236616 Kept=0
>> I/O=0, Latched=194, Other=107327"
>> "2007-09-18 04:54:49.59 spid56 Buffer Counts: Commited=1415936
>> Target=1415936 Hashed=344137
>> InternalReservation=360 ExternalReservation=0 Min Free=128 Visible=>> 191272"
>> "2007-09-18 04:54:49.59 spid56 Procedure Cache: TotalProcs=6
>> TotalPages=7 InUsePages=4"
>> ......
>> how to fix this , i need restart the server mant time on everyday , HELP
>> !!!
>>
>>
>>
>>
>|||Did you ever get a fix to your problem? We are also running SQL 2000 sp4
with the awe hot fix. We are on windows 2003 sp2. We've had this happen
several times on a production server. We tried killing some spids that we
thought might be causing the problem - but that didn't help. We had to
reboot the server.
We have a case open with microsoft - but so far they are telling us its
beyond SQL Server's scope. SQL Server is using all the memory except for a
little we have set aside (1 gb out of 4 gb) for the OS, etc.
Let me know what you found.
"pcnetnet" wrote:
> Hi All,
> We have SQL 2000 ent and Windows 2003 , in a few day , restart many
> time the error message in event log is "Error: 17803, Severity: 20, State:
> 14
> Insufficient memory available."
> i try open SQL profiler and use performance monitor , but i don't know how
> to fix ? in profiler display error log , but i don't know is server problem
> or application problem , how to check the problem ? help
> SQL 2000 Ent ,enable AWE
> Windows 2003 ent enable PAE
> RAM : 16 GB
> In Profiler error :
> " 2007-09-18 04:54:49.51 spid56 BPool::Map: no remappable address found."
> "2007-09-18 04:54:49.54 spid56 Buffer Distribution: Stolen=122023
> Free=949769 Procedures=7
> Inram=0 Dirty=236616 Kept=0
> I/O=0, Latched=194, Other=107327"
> "2007-09-18 04:54:49.54 spid56 Buffer Counts: Commited=1415936
> Target=1415936 Hashed=344137
> InternalReservation=360 ExternalReservation=0 Min Free=128 Visible=> 191272"
> "2007-09-18 04:54:49.54 spid56 Procedure Cache: TotalProcs=6
> TotalPages=7 InUsePages=4"
> "2007-09-18 04:54:49.54 spid56 Dynamic Memory Manager: Stolen=122029 OS
> Reserved=3168
> OS Committed=3112
> OS In Use=3108
> Query Plan=96903 Optimizer=1
> General=24144
> Utilities=160 Connection=3834 "
> "2007-09-18 04:54:49.54 spid56 Dynamic Memory Manager: Stolen=122029 OS
> Reserved=3168
> OS Committed=3112
> OS In Use=3108
> Query Plan=96903 Optimizer=1
> General=24144
> Utilities=160 Connection=3834"
> "2007-09-18 04:54:49.54 spid56 Query Memory Manager: Grants=0 Waiting=0
> Maximum=52143 Available=52143"
> "Error: 701, Severity: 17, State: 132"
> "2007-09-18 04:54:49.56 spid56 BPool::Map: no remappable address found."
> "2007-09-18 04:54:49.59 spid56 Buffer Distribution: Stolen=122022
> Free=949770 Procedures=7
> Inram=0 Dirty=236616 Kept=0
> I/O=0, Latched=194, Other=107327"
> "2007-09-18 04:54:49.59 spid56 Buffer Counts: Commited=1415936
> Target=1415936 Hashed=344137
> InternalReservation=360 ExternalReservation=0 Min Free=128 Visible=> 191272"
> "2007-09-18 04:54:49.59 spid56 Procedure Cache: TotalProcs=6
> TotalPages=7 InUsePages=4"
> .......
> how to fix this , i need restart the server mant time on everyday , HELP !!!
>
>
>
>
>

"Full-Text Index Table" is disabled?

I'm trying to do some local development so I installed Full-Text Indexing as
part of the SQL 2000 Developer Edition on my Windows XP machine.
The MS Search Service is running but the option is still disabled in EM when
I right-click on a table.
Thanks, Dave.
http://www.indexserverfaq.com/tablenotenabled.htm
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Dave" <Dave@.discussions.microsoft.com> wrote in message
news:BE6EABAB-0F45-40B2-9C9C-1A29A1A8746B@.microsoft.com...
> I'm trying to do some local development so I installed Full-Text Indexing
> as
> part of the SQL 2000 Developer Edition on my Windows XP machine.
> The MS Search Service is running but the option is still disabled in EM
> when
> I right-click on a table.
> Thanks, Dave.

"File not created" from sp_trace_create

I am getting a return code of 12 (""File not created"") from sp_trace_create.

I have checked to ensure that the path is valid. I am using Windows Authentication and the Windows Administrator account.

SQL Server is using the Windows userid that I created for SQL Server. I have verified (at least tried to verify) that the user for SQL Server has access to the folder containing it.

The following is the relevant portion of what I am attempting.

DECLARE @.RC int, @.TraceId int
Exec @.RC = sp_trace_create @.TraceId OUTPUT, 0, N'C:\TraceFile'


I have tried other paths that also do not work.I used a path that was for a FAT partition and that worked, so it was a file permission problem. I don't know how to determine what path would be valid for the SQL Server account but that is a different question.

"File and Print Sharing for Microsoft Networks"

In Win 2k or above, how to check PC that is
installed "File and Print Sharing for Microsoft Networks"
by programming or Windows API?
hi,
"Allcomp" <fa097770@.nospam.skynet.be> ha scritto nel messaggio
news:40c41274$0$9536$a0ced6e1@.news.skynet.be...
> Hello,
> I am interested too, but I don't have a suscription. Do yuu have another
> solution too?
> Do you know if it it possible to install this service if it is not enabled
> on the computer (to allow a user to install MSDE without having to
> understand anything on his computer)?
unfortunately not...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.8.0 - DbaMgr ver 0.54.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply

"Error!" msg during "setup support files" installation

Windows 2003 Server. Asp.Net 1.1. Sql Server 2000 Sp3a.
"Error!" msg during "setup support files" installation.
Unable to install Reporting Services. Found a couple of users experiencing
the same problem, but no solution :( Any ideas?
/ChrisFirst, check the error log in Event Viewer and see if you can find any
EventID number for your error. That can pinpoint what the error really is.
If it's error 25619, then check if the DTC service is running? Go check in
services.msc for "Distributed Transaction Coordinator".
Even if it says "started", it might not be. I've had some troubles with
installing RS, and the DTC was the culprit.
It's been discussed in this thread:
http://groups.google.com/groups?hl=en&lr=&threadm=89FD4D17-1F6A-4BCF-A15E-CF098C5A68D7%40microsoft.com&rnum=1
In this thread, Pitroda asks about a password for Network Service. Just
leave the password blank, at least that worked for me.
Kaisa M. Lindahl
"Chris Leaf" <ChrisLeaf@.discussions.microsoft.com> wrote in message
news:E6F567CB-08C9-4B49-8544-9DB32826CC09@.microsoft.com...
> Windows 2003 Server. Asp.Net 1.1. Sql Server 2000 Sp3a.
> "Error!" msg during "setup support files" installation.
> Unable to install Reporting Services. Found a couple of users experiencing
> the same problem, but no solution :( Any ideas?
> /Chris|||Event log says:
"Product: Microsoft SQL Server 2000 Reporting Services Enterprise Edition --
Please install SQL Server by running setup.exe."
and
"Product: Microsoft SQL Server 2000 Reporting Services Enterprise Edition --
Installation failed."
install log ends with:
<Func Name='SqlSetupFilesComp::Install'>
<Func Name='BootstrapPackageLogic'>
<Func Name='InstallBootstrapPackage'>
/I "D:\Setup\bootmsi.dat" REBOOT="ReallySuppress"
ADDLOCAL="BootstrapFiles,WatsonFiles,ParsFiles1033,HelpFiles1028,HelpFiles1031,HelpFiles1033,HelpFiles1036,HelpFiles1040,HelpFiles1041,HelpFiles1042,HelpFiles2052,HelpFiles3082,WatsonFiles1033" /qn
<EndFunc Name='InstallBootstrapPackage' Return='1603' GetLastError='183'>
<EndFunc Name='BootstrapPackageLogic' Return='1603' GetLastError='183'>
SqlSetupFilesComp BootstrapPackageLogic() failed : (1603)
{n:\rosetta\dev\src\everettsetup\sqlcu\dll\customcomps.cpp:565}
SCU_SetupMgr::svc() caught exception: SqlSetupFilesComp
BootstrapPackageLogic() failed : (1603)
{n:\rosetta\dev\src\everettsetup\sqlcu\dll\customcomps.cpp:565}. SetupMgr:
state=ERROR, cancel_state=0, is_done=0, ActionRequired=1, NeedReboot=0,
custom_props={AutoStart=true
HandleReboots=false
ModuleDir=D:
QuietMode=false
Unattended=false
WorkDir=D:
}} {n:\rosetta\dev\src\everettsetup\sqlcu\dll\scusetupmgr.cpp:428}
ScuProgressDlg::SetupFinished()
ScuProgressDlg::DialogProc() installation done... waiting for setup mgr
<EndFunc Name='UpdateComponents' Return='1602' GetLastError='0'>
DTC is running..
Thanks for your response.
"Kaisa M. Lindahl" wrote:
> First, check the error log in Event Viewer and see if you can find any
> EventID number for your error. That can pinpoint what the error really is.
> If it's error 25619, then check if the DTC service is running? Go check in
> services.msc for "Distributed Transaction Coordinator".
> Even if it says "started", it might not be. I've had some troubles with
> installing RS, and the DTC was the culprit.
> It's been discussed in this thread:
> http://groups.google.com/groups?hl=en&lr=&threadm=89FD4D17-1F6A-4BCF-A15E-CF098C5A68D7%40microsoft.com&rnum=1
> In this thread, Pitroda asks about a password for Network Service. Just
> leave the password blank, at least that worked for me.
> Kaisa M. Lindahl
> "Chris Leaf" <ChrisLeaf@.discussions.microsoft.com> wrote in message
> news:E6F567CB-08C9-4B49-8544-9DB32826CC09@.microsoft.com...
> > Windows 2003 Server. Asp.Net 1.1. Sql Server 2000 Sp3a.
> >
> > "Error!" msg during "setup support files" installation.
> > Unable to install Reporting Services. Found a couple of users experiencing
> > the same problem, but no solution :( Any ideas?
> >
> > /Chris
>
>