Count Records in a Group

Hello All.
I'm running SSRS 2005 on top of a sql2000 database.
I need to create a report that counts the number of invoices salesreps
process per month.
The fields I have selected are;
SalesRep ID Invoice No Invoice Date
1 5467 2/22/2006 3:06:17 PM
5 4526 2/22/2006 3:29:56 PM
8 6589 6/14/2005 4:20:26 PM
5 8569 2/22/2006 3:29:56 PM
5 2563 6/10/2007 8:29:56 AM
5 1523 2/22/2006 3:29:56 PM
8 9876 8/23/2006 5:29:56 PM
1 7563 4/23/2006 1:29:56 PM
What i want to do is group by Salesrep ID, then show the total number of
invoices that rep did per month;
SalesRep ID Month TotalInvoices Processed
1 Jan 4
Feb 2
Mar 5
5 Jan 5
Feb 6
Mar 3
8 Jan 2
Feb 10
Mar 20 ... and so on.
I'm not sure exactly how to do this. Also how do I convert the date format
into just showing the month, not every minute of every day?
Any help is much appreciated.
Thanks.You want to do this with the sql statement. Since you didn't show your SQL I
had to make up names.
select a.salesrepid, datepart(month, a.invoicedate) as month, count(*) as
invoices_count from yourtable a
group by a.salesrepid, datepart(month, a.invoicedate)
order by a.salesrepid, month
Note this gives you month by number which is what you need in order to order
it properly, if you want by month name then add that in and still order by
the month number to keep in in the proper order.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Damon Johnson" <DamonJohnson@.discussions.microsoft.com> wrote in message
news:410E3C42-D07E-4388-97A7-E6278586890F@.microsoft.com...
> Hello All.
> I'm running SSRS 2005 on top of a sql2000 database.
> I need to create a report that counts the number of invoices salesreps
> process per month.
> The fields I have selected are;
> SalesRep ID Invoice No Invoice Date
>
> 1 5467 2/22/2006 3:06:17 PM
> 5 4526 2/22/2006 3:29:56 PM
> 8 6589 6/14/2005 4:20:26 PM
> 5 8569 2/22/2006 3:29:56 PM
> 5 2563 6/10/2007 8:29:56 AM
> 5 1523 2/22/2006 3:29:56 PM
> 8 9876 8/23/2006 5:29:56 PM
> 1 7563 4/23/2006 1:29:56 PM
> What i want to do is group by Salesrep ID, then show the total number of
> invoices that rep did per month;
> SalesRep ID Month TotalInvoices Processed
> 1 Jan 4
> Feb 2
> Mar 5
> 5 Jan 5
> Feb 6
> Mar 3
> 8 Jan 2
> Feb 10
> Mar 20 ... and so on.
>
> I'm not sure exactly how to do this. Also how do I convert the date format
> into just showing the month, not every minute of every day?
> Any help is much appreciated.
> Thanks.
>|||Thank you soo much Bruce.
Here is the statement;
SELECT TOP 100 PERCENT dbo.invoice_hdr.salesrep_id,
dbo.invoice_hdr.order_date
FROM dbo.contacts INNER JOIN
dbo.invoice_hdr ON dbo.contacts.id =dbo.invoice_hdr.salesrep_id
"Bruce L-C [MVP]" wrote:
> You want to do this with the sql statement. Since you didn't show your SQL I
> had to make up names.
> select a.salesrepid, datepart(month, a.invoicedate) as month, count(*) as
> invoices_count from yourtable a
> group by a.salesrepid, datepart(month, a.invoicedate)
> order by a.salesrepid, month
> Note this gives you month by number which is what you need in order to order
> it properly, if you want by month name then add that in and still order by
> the month number to keep in in the proper order.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Damon Johnson" <DamonJohnson@.discussions.microsoft.com> wrote in message
> news:410E3C42-D07E-4388-97A7-E6278586890F@.microsoft.com...
> > Hello All.
> >
> > I'm running SSRS 2005 on top of a sql2000 database.
> >
> > I need to create a report that counts the number of invoices salesreps
> > process per month.
> >
> > The fields I have selected are;
> >
> > SalesRep ID Invoice No Invoice Date
> >
> >
> > 1 5467 2/22/2006 3:06:17 PM
> > 5 4526 2/22/2006 3:29:56 PM
> > 8 6589 6/14/2005 4:20:26 PM
> > 5 8569 2/22/2006 3:29:56 PM
> > 5 2563 6/10/2007 8:29:56 AM
> > 5 1523 2/22/2006 3:29:56 PM
> > 8 9876 8/23/2006 5:29:56 PM
> > 1 7563 4/23/2006 1:29:56 PM
> >
> > What i want to do is group by Salesrep ID, then show the total number of
> > invoices that rep did per month;
> >
> > SalesRep ID Month TotalInvoices Processed
> > 1 Jan 4
> > Feb 2
> > Mar 5
> >
> > 5 Jan 5
> > Feb 6
> > Mar 3
> >
> > 8 Jan 2
> > Feb 10
> > Mar 20 ... and so on.
> >
> >
> > I'm not sure exactly how to do this. Also how do I convert the date format
> > into just showing the month, not every minute of every day?
> >
> > Any help is much appreciated.
> > Thanks.
> >
>
>|||Bruce that worked perfectly!!
Thanks again!
"Damon Johnson" wrote:
> Thank you soo much Bruce.
> Here is the statement;
> SELECT TOP 100 PERCENT dbo.invoice_hdr.salesrep_id,
> dbo.invoice_hdr.order_date
> FROM dbo.contacts INNER JOIN
> dbo.invoice_hdr ON dbo.contacts.id => dbo.invoice_hdr.salesrep_id
> "Bruce L-C [MVP]" wrote:
> > You want to do this with the sql statement. Since you didn't show your SQL I
> > had to make up names.
> >
> > select a.salesrepid, datepart(month, a.invoicedate) as month, count(*) as
> > invoices_count from yourtable a
> > group by a.salesrepid, datepart(month, a.invoicedate)
> > order by a.salesrepid, month
> >
> > Note this gives you month by number which is what you need in order to order
> > it properly, if you want by month name then add that in and still order by
> > the month number to keep in in the proper order.
> >
> >
> > --
> > Bruce Loehle-Conger
> > MVP SQL Server Reporting Services
> >
> >
> > "Damon Johnson" <DamonJohnson@.discussions.microsoft.com> wrote in message
> > news:410E3C42-D07E-4388-97A7-E6278586890F@.microsoft.com...
> > > Hello All.
> > >
> > > I'm running SSRS 2005 on top of a sql2000 database.
> > >
> > > I need to create a report that counts the number of invoices salesreps
> > > process per month.
> > >
> > > The fields I have selected are;
> > >
> > > SalesRep ID Invoice No Invoice Date
> > >
> > >
> > > 1 5467 2/22/2006 3:06:17 PM
> > > 5 4526 2/22/2006 3:29:56 PM
> > > 8 6589 6/14/2005 4:20:26 PM
> > > 5 8569 2/22/2006 3:29:56 PM
> > > 5 2563 6/10/2007 8:29:56 AM
> > > 5 1523 2/22/2006 3:29:56 PM
> > > 8 9876 8/23/2006 5:29:56 PM
> > > 1 7563 4/23/2006 1:29:56 PM
> > >
> > > What i want to do is group by Salesrep ID, then show the total number of
> > > invoices that rep did per month;
> > >
> > > SalesRep ID Month TotalInvoices Processed
> > > 1 Jan 4
> > > Feb 2
> > > Mar 5
> > >
> > > 5 Jan 5
> > > Feb 6
> > > Mar 3
> > >
> > > 8 Jan 2
> > > Feb 10
> > > Mar 20 ... and so on.
> > >
> > >
> > > I'm not sure exactly how to do this. Also how do I convert the date format
> > > into just showing the month, not every minute of every day?
> > >
> > > Any help is much appreciated.
> > > Thanks.
> > >
> >
> >
> >|||First, you do not need TOP 100 percent. That means you want all the records
which is what you get without the TOP syntax.
SELECT a.salesrep_id, datepart(month,b.order_date) as Month,
datename(month,b.order_date) as Month_Name,count(*) as invoices_count
FROM dbo.contacts a INNER JOIN dbo.invoice_hdr b ON a.id =b.salesrep_id
where b.order_date >= @.STARTDATE and b.order_date < @.ENDDATE
group by a.salesrep_id, datepart(month,b.order_date)
order by a.salesrep_id, month
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Damon Johnson" <DamonJohnson@.discussions.microsoft.com> wrote in message
news:8C3A09EC-3B59-4263-BD46-82880D31C84B@.microsoft.com...
> Thank you soo much Bruce.
> Here is the statement;
> SELECT TOP 100 PERCENT dbo.invoice_hdr.salesrep_id,
> dbo.invoice_hdr.order_date
> FROM dbo.contacts INNER JOIN
> dbo.invoice_hdr ON dbo.contacts.id => dbo.invoice_hdr.salesrep_id
> "Bruce L-C [MVP]" wrote:
>> You want to do this with the sql statement. Since you didn't show your
>> SQL I
>> had to make up names.
>> select a.salesrepid, datepart(month, a.invoicedate) as month, count(*) as
>> invoices_count from yourtable a
>> group by a.salesrepid, datepart(month, a.invoicedate)
>> order by a.salesrepid, month
>> Note this gives you month by number which is what you need in order to
>> order
>> it properly, if you want by month name then add that in and still order
>> by
>> the month number to keep in in the proper order.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>>
>> "Damon Johnson" <DamonJohnson@.discussions.microsoft.com> wrote in message
>> news:410E3C42-D07E-4388-97A7-E6278586890F@.microsoft.com...
>> > Hello All.
>> >
>> > I'm running SSRS 2005 on top of a sql2000 database.
>> >
>> > I need to create a report that counts the number of invoices salesreps
>> > process per month.
>> >
>> > The fields I have selected are;
>> >
>> > SalesRep ID Invoice No Invoice Date
>> >
>> >
>> > 1 5467 2/22/2006 3:06:17 PM
>> > 5 4526 2/22/2006 3:29:56 PM
>> > 8 6589 6/14/2005 4:20:26 PM
>> > 5 8569 2/22/2006 3:29:56 PM
>> > 5 2563 6/10/2007 8:29:56 AM
>> > 5 1523 2/22/2006 3:29:56 PM
>> > 8 9876 8/23/2006 5:29:56 PM
>> > 1 7563 4/23/2006 1:29:56 PM
>> >
>> > What i want to do is group by Salesrep ID, then show the total number
>> > of
>> > invoices that rep did per month;
>> >
>> > SalesRep ID Month TotalInvoices Processed
>> > 1 Jan 4
>> > Feb 2
>> > Mar 5
>> >
>> > 5 Jan 5
>> > Feb 6
>> > Mar 3
>> >
>> > 8 Jan 2
>> > Feb 10
>> > Mar 20 ... and so on.
>> >
>> >
>> > I'm not sure exactly how to do this. Also how do I convert the date
>> > format
>> > into just showing the month, not every minute of every day?
>> >
>> > Any help is much appreciated.
>> > Thanks.
>> >
>>|||OK Bruce I think this is my last request.
the DATENAME(month, invoice_date) returns the month only.
How do i get it to return the month and year. I will be setting this up as a
parameter query;
Between @.StartDate and @.EndDate
and want the user to put in May 07 and June 07
thanks again.
"Bruce L-C [MVP]" wrote:
> First, you do not need TOP 100 percent. That means you want all the records
> which is what you get without the TOP syntax.
> SELECT a.salesrep_id, datepart(month,b.order_date) as Month,
> datename(month,b.order_date) as Month_Name,count(*) as invoices_count
> FROM dbo.contacts a INNER JOIN dbo.invoice_hdr b ON a.id => b.salesrep_id
> where b.order_date >= @.STARTDATE and b.order_date < @.ENDDATE
> group by a.salesrep_id, datepart(month,b.order_date)
> order by a.salesrep_id, month
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "Damon Johnson" <DamonJohnson@.discussions.microsoft.com> wrote in message
> news:8C3A09EC-3B59-4263-BD46-82880D31C84B@.microsoft.com...
> > Thank you soo much Bruce.
> > Here is the statement;
> >
> > SELECT TOP 100 PERCENT dbo.invoice_hdr.salesrep_id,
> > dbo.invoice_hdr.order_date
> > FROM dbo.contacts INNER JOIN
> > dbo.invoice_hdr ON dbo.contacts.id => > dbo.invoice_hdr.salesrep_id
> >
> > "Bruce L-C [MVP]" wrote:
> >
> >> You want to do this with the sql statement. Since you didn't show your
> >> SQL I
> >> had to make up names.
> >>
> >> select a.salesrepid, datepart(month, a.invoicedate) as month, count(*) as
> >> invoices_count from yourtable a
> >> group by a.salesrepid, datepart(month, a.invoicedate)
> >> order by a.salesrepid, month
> >>
> >> Note this gives you month by number which is what you need in order to
> >> order
> >> it properly, if you want by month name then add that in and still order
> >> by
> >> the month number to keep in in the proper order.
> >>
> >>
> >> --
> >> Bruce Loehle-Conger
> >> MVP SQL Server Reporting Services
> >>
> >>
> >> "Damon Johnson" <DamonJohnson@.discussions.microsoft.com> wrote in message
> >> news:410E3C42-D07E-4388-97A7-E6278586890F@.microsoft.com...
> >> > Hello All.
> >> >
> >> > I'm running SSRS 2005 on top of a sql2000 database.
> >> >
> >> > I need to create a report that counts the number of invoices salesreps
> >> > process per month.
> >> >
> >> > The fields I have selected are;
> >> >
> >> > SalesRep ID Invoice No Invoice Date
> >> >
> >> >
> >> > 1 5467 2/22/2006 3:06:17 PM
> >> > 5 4526 2/22/2006 3:29:56 PM
> >> > 8 6589 6/14/2005 4:20:26 PM
> >> > 5 8569 2/22/2006 3:29:56 PM
> >> > 5 2563 6/10/2007 8:29:56 AM
> >> > 5 1523 2/22/2006 3:29:56 PM
> >> > 8 9876 8/23/2006 5:29:56 PM
> >> > 1 7563 4/23/2006 1:29:56 PM
> >> >
> >> > What i want to do is group by Salesrep ID, then show the total number
> >> > of
> >> > invoices that rep did per month;
> >> >
> >> > SalesRep ID Month TotalInvoices Processed
> >> > 1 Jan 4
> >> > Feb 2
> >> > Mar 5
> >> >
> >> > 5 Jan 5
> >> > Feb 6
> >> > Mar 3
> >> >
> >> > 8 Jan 2
> >> > Feb 10
> >> > Mar 20 ... and so on.
> >> >
> >> >
> >> > I'm not sure exactly how to do this. Also how do I convert the date
> >> > format
> >> > into just showing the month, not every minute of every day?
> >> >
> >> > Any help is much appreciated.
> >> > Thanks.
> >> >
> >>
> >>
> >>
>
>

Count Or Running Totals Really Not Sure !

Hi, Still working on this **** report, its getting to be beyond a joke now. Its format just changed again (you all know the score).

The first problem i want to deal with is to get a count of the short stops we are having.

I have set up a running total that is like so

Field to summarize = tblDowntime.DTCLevel3
Type of Summary = Count

Evaluate

Formula = {tblDowntime.Duration} < 900 (this in seconds so Less than 15 Mins)

Reset

Change of field = tblCoilData.BatchName (this is the works order Number)

Before I put this in i get the correct values except no short stops data so:

Rod Number, Rod Weight, Scrap, EC Stops, Coil Weight

This gives me normally 4 results as follows

544124, 1,9882, 0.00, ,19882
544125, 1,9452, 44, , , 19408
544126, 1,9452, 44, , , 19408
544127, 1,9452, 44, , , 19408

When i put the running total into my report i get

544124, 1,9882, 0.00, 1,19882
544124, 1,9882, 0.00, 2,19882
544124, 1,9882, 0.00, 2,19882
544125, 1,9452, 44, 0, 19408
544126, 1,9452, 44, 0 , 19408
544127, 1,9452, 44, 0 , 19408

I cant understand why it would do this. i know that on Rod Number 544124 there were 2 short stops, i only want to show it like the top version with a total of the short stops

How is this done

Regards

SteveSo you only want one row per rod number? Are you grouping on that and printing in the group footer?|||No, i am not grouping it is just in details, i tried to group but then it screwed my totals for coil wieght. instead of doing 8 Ton per day we ended up with 40 Ton (mmm That looked good but was way out)

Regards

Steve|||Hi, Thanks for your reply i realised that i was not surpressing the details of the report causing me to get some strange results

Regards

Steve

Count of criteria like Male and Female in One field data

Hi,

Please solve this problem using instead of subreport in Crystal Reports

I think using only running filed.
My Porblem is .......

In One field data has Male and Female in different rows ( in different dates)
I want calculate the count of Male and female
Here we are using database is in Access.

Display Format is

Date count of Male Count of Female

Here i want display the count of male or female depend on data ( so Date is group field)

Please Help me......Hi,

You could create a formula to your report as follows. This should be placed in the details section.

shared numbervar cntfem;
shared numbervar cntmale;

If {table.field} = 'Male' Then
cntmale := cntmale + 1;

If {table.field} = 'Female' Then
cntfem := cntfem + 1;

Create a formula for both male and female in the summary section showing the results

e.g. formula male
shared numbervar cntmale;

and forula female
shared numbervar cntfem;

If you are not interested in the grand total, but a sub total use a function to clear clear the count at a section header. Use the supress property on the function to prevent it from printing on your report.

shared numbervar cntfem := 0;
shared numbervar cntmale := 0;

This works if you are displaying the detailed data in your report, i.e. you dont have a query like
select c, d, sum(a), sum(b)
from table
group by c, d

- Jukkasql

Could not start the SQL Server Reporting Services

I am running SQL Server 2005 Enterprise and cannot get the Reporting
Service to start. When trying to start the Reporting Service from the
Control Pannel/Administrative Tools/Services I get the following error:
[ERROR]
Microsoft Management Console
Could not start the SQL Server Reporting Services (MSSQLSERVER) service
on Local Computer. The service did not return an error. This could be
an internal Windows error or an internal service error. If the problem
persists, contact your system administrator.
[/ERROR]
When I try to connect to the service from the Microsoft SQL Server
Management Studio, I get the following error (In an attempt to seperate
error msg, using <error> tags):
[ERROR]
TITLE: Connect to Server
--
Cannot connect to YAMHILL.
ADDITIONAL INFORMATION:
Client found response content type of 'text/html; charset=utf-8', but
expected 'text/xml'.
The request failed with the error message:
--
<html>
<head>
<title>
SQL Server Reporting Services
</title><meta name="Generator" content="Microsoft SQL Server
Reporting Services 9.00.1399.00" />
<meta name="HTTP Status" content="500" />
<meta name="ProductLocaleID" content="9" />
<meta name="CountryLocaleID" content="1033" />
<meta name="StackTrace" content=" at
Microsoft.ReportingServices.Diagnostics.AuthenticationExtensionFactory.get_A
uthenticationExtension()
at
Microsoft.ReportingServices.Diagnostics.UserUtil.GetUserNameFromExtension()
at
Microsoft.ReportingServices.Diagnostics.UserUtil.GetCurrentUserName()
at
Microsoft.ReportingServices.WebServer.Global.ShouldRejectAntiDos()
at
Microsoft.ReportingServices.WebServer.Global.Application_AuthenticateRequest
(Object
sender, EventArgs e)" />
<style>
BODY {FONT-FAMILY:Verdana; FONT-WEIGHT:normal; FONT-SIZE: 8pt;
COLOR:black}
H1 {FONT-FAMILY:Verdana; FONT-WEIGHT:700; FONT-SIZE:15pt}
LI {FONT-FAMILY:Verdana; FONT-WEIGHT:normal; FONT-SIZE:8pt;
DISPLAY:inline}
.ProductInfo {FONT-FAMILY:Verdana; FONT-WEIGHT:bold; FONT-SIZE: 8pt;
COLOR:gray}
A:link {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#3366CC;
TEXT-DECORATION:none}
A:hover {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#FF3300;
TEXT-DECORATION:underline}
A:visited {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#3366CC;
TEXT-DECORATION:none}
A:visited:hover {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; color:#FF3300;
TEXT-DECORATION:underline}
</style>
</head><body bgcolor="white">
<h1>
Reporting Services Error<hr width="100%" size="1" color="silver" />
</h1><ul>
<li>The report server has encountered a configuration error. See the
report server log files for more information.
(rsServerConfigurationError) <a
href="http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.Reportin
gServices.Diagnostics.Utilities.ErrorStrings&EvtID=rsServerConfigurationErro
r& ProdName=Microsoft%20SQL%20Server%20Repo
rting%20Services&ProdVer=9.00.1399
.00"
target="_blank">Get Online Help</a></li>
</ul><hr width="100%" size="1" color="silver" /><span
class="ProductInfo">SQL Server Reporting Services</span>
</body>
</html>
--. (Microsoft.SqlServer.Management.UI.RSClient)
BUTTONS:
OK
--
[/ERROR]
Thanks in advance...Any help is appreciated.
AntoineHi Antoine.
Were you able to get around this? I have having the same problem.
Thanks.
"jonathan_antoine@.excite.com" wrote:

> I am running SQL Server 2005 Enterprise and cannot get the Reporting
> Service to start. When trying to start the Reporting Service from the
> Control Pannel/Administrative Tools/Services I get the following error:
> [ERROR]
> Microsoft Management Console
> Could not start the SQL Server Reporting Services (MSSQLSERVER) service
> on Local Computer. The service did not return an error. This could be
> an internal Windows error or an internal service error. If the problem
> persists, contact your system administrator.
> [/ERROR]
> When I try to connect to the service from the Microsoft SQL Server
> Management Studio, I get the following error (In an attempt to seperate
> error msg, using <error> tags):
> [ERROR]
> TITLE: Connect to Server
> --
> Cannot connect to YAMHILL.
> --
> ADDITIONAL INFORMATION:
> Client found response content type of 'text/html; charset=utf-8', but
> expected 'text/xml'.
> The request failed with the error message:
> --
> <html>
> <head>
> <title>
> SQL Server Reporting Services
> </title><meta name="Generator" content="Microsoft SQL Server
> Reporting Services 9.00.1399.00" />
> <meta name="HTTP Status" content="500" />
> <meta name="ProductLocaleID" content="9" />
> <meta name="CountryLocaleID" content="1033" />
> <meta name="StackTrace" content=" at
> Microsoft.ReportingServices.Diagnostics.AuthenticationExtensionFactory.get
_AuthenticationExtension()
> at
> Microsoft.ReportingServices.Diagnostics.UserUtil.GetUserNameFromExtension(
)
> at
> Microsoft.ReportingServices.Diagnostics.UserUtil.GetCurrentUserName()
> at
> Microsoft.ReportingServices.WebServer.Global.ShouldRejectAntiDos()
> at
> Microsoft.ReportingServices.WebServer.Global.Application_AuthenticateReque
st(Object
> sender, EventArgs e)" />
> <style>
> BODY {FONT-FAMILY:Verdana; FONT-WEIGHT:normal; FONT-SIZE: 8pt;
> COLOR:black}
> H1 {FONT-FAMILY:Verdana; FONT-WEIGHT:700; FONT-SIZE:15pt}
> LI {FONT-FAMILY:Verdana; FONT-WEIGHT:normal; FONT-SIZE:8pt;
> DISPLAY:inline}
> .ProductInfo {FONT-FAMILY:Verdana; FONT-WEIGHT:bold; FONT-SIZE: 8p
t;
> COLOR:gray}
> A:link {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#3366CC;
> TEXT-DECORATION:none}
> A:hover {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#FF3300;
> TEXT-DECORATION:underline}
> A:visited {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#3366CC;
> TEXT-DECORATION:none}
> A:visited:hover {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; color:#FF330
0;
> TEXT-DECORATION:underline}
> </style>
> </head><body bgcolor="white">
> <h1>
> Reporting Services Error<hr width="100%" size="1" color="silver" />
> </h1><ul>
> <li>The report server has encountered a configuration error. See the
> report server log files for more information.
> (rsServerConfigurationError) <a
> href="http://links.10026.com/?link=http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.Report
ingServices.Diagnostics.Utilities.ErrorStrings&EvtID=rsServerConfigurationEr
ror& ProdName=Microsoft%20SQL%20Server%20Repo
rting%20Services&ProdVer=9.00.13
99.00"
> target="_blank">Get Online Help</a></li>
> </ul><hr width="100%" size="1" color="silver" /><span
> class="ProductInfo">SQL Server Reporting Services</span>
> </body>
> </html>
> --. (Microsoft.SqlServer.Management.UI.RSClient)
> --
> BUTTONS:
> OK
> --
> [/ERROR]
> Thanks in advance...Any help is appreciated.
> Antoine
>|||"jonathan_antoine@.excite.com" wrote:

> I am running SQL Server 2005 Enterprise and cannot get the Reporting
> Service to start. When trying to start the Reporting Service from the
> Control Pannel/Administrative Tools/Services I get the following error:
> [ERROR]
> Microsoft Management Console
> Could not start the SQL Server Reporting Services (MSSQLSERVER) service
> on Local Computer. The service did not return an error. This could be
> an internal Windows error or an internal service error. If the problem
> persists, contact your system administrator.
> [/ERROR]
> When I try to connect to the service from the Microsoft SQL Server
> Management Studio, I get the following error (In an attempt to seperate
> error msg, using <error> tags):
> [ERROR]
> TITLE: Connect to Server
> --
> Cannot connect to YAMHILL.
> --
> ADDITIONAL INFORMATION:
> Client found response content type of 'text/html; charset=utf-8', but
> expected 'text/xml'.
> The request failed with the error message:
> --
> <html>
> <head>
> <title>
> SQL Server Reporting Services
> </title><meta name="Generator" content="Microsoft SQL Server
> Reporting Services 9.00.1399.00" />
> <meta name="HTTP Status" content="500" />
> <meta name="ProductLocaleID" content="9" />
> <meta name="CountryLocaleID" content="1033" />
> <meta name="StackTrace" content=" at
> Microsoft.ReportingServices.Diagnostics.AuthenticationExtensionFactory.get
_AuthenticationExtension()
> at
> Microsoft.ReportingServices.Diagnostics.UserUtil.GetUserNameFromExtension(
)
> at
> Microsoft.ReportingServices.Diagnostics.UserUtil.GetCurrentUserName()
> at
> Microsoft.ReportingServices.WebServer.Global.ShouldRejectAntiDos()
> at
> Microsoft.ReportingServices.WebServer.Global.Application_AuthenticateReque
st(Object
> sender, EventArgs e)" />
> <style>
> BODY {FONT-FAMILY:Verdana; FONT-WEIGHT:normal; FONT-SIZE: 8pt;
> COLOR:black}
> H1 {FONT-FAMILY:Verdana; FONT-WEIGHT:700; FONT-SIZE:15pt}
> LI {FONT-FAMILY:Verdana; FONT-WEIGHT:normal; FONT-SIZE:8pt;
> DISPLAY:inline}
> .ProductInfo {FONT-FAMILY:Verdana; FONT-WEIGHT:bold; FONT-SIZE: 8p
t;
> COLOR:gray}
> A:link {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#3366CC;
> TEXT-DECORATION:none}
> A:hover {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#FF3300;
> TEXT-DECORATION:underline}
> A:visited {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#3366CC;
> TEXT-DECORATION:none}
> A:visited:hover {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; color:#FF330
0;
> TEXT-DECORATION:underline}
> </style>
> </head><body bgcolor="white">
> <h1>
> Reporting Services Error<hr width="100%" size="1" color="silver" />
> </h1><ul>
> <li>The report server has encountered a configuration error. See the
> report server log files for more information.
> (rsServerConfigurationError) <a
> href="http://links.10026.com/?link=http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.Report
ingServices.Diagnostics.Utilities.ErrorStrings&EvtID=rsServerConfigurationEr
ror& ProdName=Microsoft%20SQL%20Server%20Repo
rting%20Services&ProdVer=9.00.13
99.00"
> target="_blank">Get Online Help</a></li>
> </ul><hr width="100%" size="1" color="silver" /><span
> class="ProductInfo">SQL Server Reporting Services</span>
> </body>
> </html>
> --. (Microsoft.SqlServer.Management.UI.RSClient)
> --
> BUTTONS:
> OK
> --
> [/ERROR]
> Thanks in advance...Any help is appreciated.
> Antoine
I'm having a similar problem, I can't get the Reporting Service to run (SQL
2K5, Win2K Server). Trying to start the service with the configuration tool
throws a timeout error, trying to start the service through the Control Pane
l
throws essentially the same error you posted. I've checked the service
login, it's LocalSystem. Is there a config file where I can change the
timeout? I have had no luck on Google, these message boards, or MS SQL help
.
This is very frustrating! I never had any problems like this with MySQL.
OK, I know mysql doesn't have a reporting module, but installation was much
quicker and smoother, there's one file with all configuration parameters,
it's well-documented, and oh yeah faster, lower-impact, and free.
Any advice is appreciated! I don't know what to try.sql

Could not start the SQL Server Reporting Services

I am running SQL Server 2005 Enterprise and cannot get the Reporting
Service to start. When trying to start the Reporting Service from the
Control Pannel/Administrative Tools/Services I get the following error:
[ERROR]
Microsoft Management Console
Could not start the SQL Server Reporting Services (MSSQLSERVER) service
on Local Computer. The service did not return an error. This could be
an internal Windows error or an internal service error. If the problem
persists, contact your system administrator.
[/ERROR]
When I try to connect to the service from the Microsoft SQL Server
Management Studio, I get the following error (In an attempt to seperate
error msg, using <error> tags):
[ERROR]
TITLE: Connect to Server
--
Cannot connect to YAMHILL.
--
ADDITIONAL INFORMATION:
Client found response content type of 'text/html; charset=utf-8', but
expected 'text/xml'.
The request failed with the error message:
--
<html>
<head>
<title>
SQL Server Reporting Services
</title><meta name="Generator" content="Microsoft SQL Server
Reporting Services 9.00.1399.00" />
<meta name="HTTP Status" content="500" />
<meta name="ProductLocaleID" content="9" />
<meta name="CountryLocaleID" content="1033" />
<meta name="StackTrace" content=" at
Microsoft.ReportingServices.Diagnostics.AuthenticationExtensionFactory.get_AuthenticationExtension()
at
Microsoft.ReportingServices.Diagnostics.UserUtil.GetUserNameFromExtension()
at
Microsoft.ReportingServices.Diagnostics.UserUtil.GetCurrentUserName()
at
Microsoft.ReportingServices.WebServer.Global.ShouldRejectAntiDos()
at
Microsoft.ReportingServices.WebServer.Global.Application_AuthenticateRequest(Object
sender, EventArgs e)" />
<style>
BODY {FONT-FAMILY:Verdana; FONT-WEIGHT:normal; FONT-SIZE: 8pt;
COLOR:black}
H1 {FONT-FAMILY:Verdana; FONT-WEIGHT:700; FONT-SIZE:15pt}
LI {FONT-FAMILY:Verdana; FONT-WEIGHT:normal; FONT-SIZE:8pt;
DISPLAY:inline}
.ProductInfo {FONT-FAMILY:Verdana; FONT-WEIGHT:bold; FONT-SIZE: 8pt;
COLOR:gray}
A:link {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#3366CC;
TEXT-DECORATION:none}
A:hover {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#FF3300;
TEXT-DECORATION:underline}
A:visited {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#3366CC;
TEXT-DECORATION:none}
A:visited:hover {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; color:#FF3300;
TEXT-DECORATION:underline}
</style>
</head><body bgcolor="white">
<h1>
Reporting Services Error<hr width="100%" size="1" color="silver" />
</h1><ul>
<li>The report server has encountered a configuration error. See the
report server log files for more information.
(rsServerConfigurationError) <a
href="http://links.10026.com/?link=http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings&EvtID=rsServerConfigurationError&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=9.00.1399.00"
target="_blank">Get Online Help</a></li>
</ul><hr width="100%" size="1" color="silver" /><span
class="ProductInfo">SQL Server Reporting Services</span>
</body>
</html>
--. (Microsoft.SqlServer.Management.UI.RSClient)
--
BUTTONS:
OK
--
[/ERROR]
Thanks in advance...Any help is appreciated.
AntoineHi Antoine.
Were you able to get around this? I have having the same problem.
Thanks.
"jonathan_antoine@.excite.com" wrote:
> I am running SQL Server 2005 Enterprise and cannot get the Reporting
> Service to start. When trying to start the Reporting Service from the
> Control Pannel/Administrative Tools/Services I get the following error:
> [ERROR]
> Microsoft Management Console
> Could not start the SQL Server Reporting Services (MSSQLSERVER) service
> on Local Computer. The service did not return an error. This could be
> an internal Windows error or an internal service error. If the problem
> persists, contact your system administrator.
> [/ERROR]
> When I try to connect to the service from the Microsoft SQL Server
> Management Studio, I get the following error (In an attempt to seperate
> error msg, using <error> tags):
> [ERROR]
> TITLE: Connect to Server
> --
> Cannot connect to YAMHILL.
> --
> ADDITIONAL INFORMATION:
> Client found response content type of 'text/html; charset=utf-8', but
> expected 'text/xml'.
> The request failed with the error message:
> --
> <html>
> <head>
> <title>
> SQL Server Reporting Services
> </title><meta name="Generator" content="Microsoft SQL Server
> Reporting Services 9.00.1399.00" />
> <meta name="HTTP Status" content="500" />
> <meta name="ProductLocaleID" content="9" />
> <meta name="CountryLocaleID" content="1033" />
> <meta name="StackTrace" content=" at
> Microsoft.ReportingServices.Diagnostics.AuthenticationExtensionFactory.get_AuthenticationExtension()
> at
> Microsoft.ReportingServices.Diagnostics.UserUtil.GetUserNameFromExtension()
> at
> Microsoft.ReportingServices.Diagnostics.UserUtil.GetCurrentUserName()
> at
> Microsoft.ReportingServices.WebServer.Global.ShouldRejectAntiDos()
> at
> Microsoft.ReportingServices.WebServer.Global.Application_AuthenticateRequest(Object
> sender, EventArgs e)" />
> <style>
> BODY {FONT-FAMILY:Verdana; FONT-WEIGHT:normal; FONT-SIZE: 8pt;
> COLOR:black}
> H1 {FONT-FAMILY:Verdana; FONT-WEIGHT:700; FONT-SIZE:15pt}
> LI {FONT-FAMILY:Verdana; FONT-WEIGHT:normal; FONT-SIZE:8pt;
> DISPLAY:inline}
> .ProductInfo {FONT-FAMILY:Verdana; FONT-WEIGHT:bold; FONT-SIZE: 8pt;
> COLOR:gray}
> A:link {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#3366CC;
> TEXT-DECORATION:none}
> A:hover {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#FF3300;
> TEXT-DECORATION:underline}
> A:visited {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#3366CC;
> TEXT-DECORATION:none}
> A:visited:hover {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; color:#FF3300;
> TEXT-DECORATION:underline}
> </style>
> </head><body bgcolor="white">
> <h1>
> Reporting Services Error<hr width="100%" size="1" color="silver" />
> </h1><ul>
> <li>The report server has encountered a configuration error. See the
> report server log files for more information.
> (rsServerConfigurationError) <a
> href="http://links.10026.com/?link=http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings&EvtID=rsServerConfigurationError&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=9.00.1399.00"
> target="_blank">Get Online Help</a></li>
> </ul><hr width="100%" size="1" color="silver" /><span
> class="ProductInfo">SQL Server Reporting Services</span>
> </body>
> </html>
> --. (Microsoft.SqlServer.Management.UI.RSClient)
> --
> BUTTONS:
> OK
> --
> [/ERROR]
> Thanks in advance...Any help is appreciated.
> Antoine
>|||"jonathan_antoine@.excite.com" wrote:
> I am running SQL Server 2005 Enterprise and cannot get the Reporting
> Service to start. When trying to start the Reporting Service from the
> Control Pannel/Administrative Tools/Services I get the following error:
> [ERROR]
> Microsoft Management Console
> Could not start the SQL Server Reporting Services (MSSQLSERVER) service
> on Local Computer. The service did not return an error. This could be
> an internal Windows error or an internal service error. If the problem
> persists, contact your system administrator.
> [/ERROR]
> When I try to connect to the service from the Microsoft SQL Server
> Management Studio, I get the following error (In an attempt to seperate
> error msg, using <error> tags):
> [ERROR]
> TITLE: Connect to Server
> --
> Cannot connect to YAMHILL.
> --
> ADDITIONAL INFORMATION:
> Client found response content type of 'text/html; charset=utf-8', but
> expected 'text/xml'.
> The request failed with the error message:
> --
> <html>
> <head>
> <title>
> SQL Server Reporting Services
> </title><meta name="Generator" content="Microsoft SQL Server
> Reporting Services 9.00.1399.00" />
> <meta name="HTTP Status" content="500" />
> <meta name="ProductLocaleID" content="9" />
> <meta name="CountryLocaleID" content="1033" />
> <meta name="StackTrace" content=" at
> Microsoft.ReportingServices.Diagnostics.AuthenticationExtensionFactory.get_AuthenticationExtension()
> at
> Microsoft.ReportingServices.Diagnostics.UserUtil.GetUserNameFromExtension()
> at
> Microsoft.ReportingServices.Diagnostics.UserUtil.GetCurrentUserName()
> at
> Microsoft.ReportingServices.WebServer.Global.ShouldRejectAntiDos()
> at
> Microsoft.ReportingServices.WebServer.Global.Application_AuthenticateRequest(Object
> sender, EventArgs e)" />
> <style>
> BODY {FONT-FAMILY:Verdana; FONT-WEIGHT:normal; FONT-SIZE: 8pt;
> COLOR:black}
> H1 {FONT-FAMILY:Verdana; FONT-WEIGHT:700; FONT-SIZE:15pt}
> LI {FONT-FAMILY:Verdana; FONT-WEIGHT:normal; FONT-SIZE:8pt;
> DISPLAY:inline}
> .ProductInfo {FONT-FAMILY:Verdana; FONT-WEIGHT:bold; FONT-SIZE: 8pt;
> COLOR:gray}
> A:link {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#3366CC;
> TEXT-DECORATION:none}
> A:hover {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#FF3300;
> TEXT-DECORATION:underline}
> A:visited {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#3366CC;
> TEXT-DECORATION:none}
> A:visited:hover {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; color:#FF3300;
> TEXT-DECORATION:underline}
> </style>
> </head><body bgcolor="white">
> <h1>
> Reporting Services Error<hr width="100%" size="1" color="silver" />
> </h1><ul>
> <li>The report server has encountered a configuration error. See the
> report server log files for more information.
> (rsServerConfigurationError) <a
> href="http://links.10026.com/?link=http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings&EvtID=rsServerConfigurationError&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=9.00.1399.00"
> target="_blank">Get Online Help</a></li>
> </ul><hr width="100%" size="1" color="silver" /><span
> class="ProductInfo">SQL Server Reporting Services</span>
> </body>
> </html>
> --. (Microsoft.SqlServer.Management.UI.RSClient)
> --
> BUTTONS:
> OK
> --
> [/ERROR]
> Thanks in advance...Any help is appreciated.
> Antoine
I'm having a similar problem, I can't get the Reporting Service to run (SQL
2K5, Win2K Server). Trying to start the service with the configuration tool
throws a timeout error, trying to start the service through the Control Panel
throws essentially the same error you posted. I've checked the service
login, it's LocalSystem. Is there a config file where I can change the
timeout? I have had no luck on Google, these message boards, or MS SQL help.
This is very frustrating! I never had any problems like this with MySQL.
OK, I know MySQL doesn't have a reporting module, but installation was much
quicker and smoother, there's one file with all configuration parameters,
it's well-documented, and oh yeah faster, lower-impact, and free.
Any advice is appreciated! I don't know what to try.

Could not start SQL Agent

Hello.
I have SQL Server MSDE running Windows 2000.
When I start SQL Agent gives me the following error:"Could not start
the SQLAgent$SPSQL service on Local Computer. The service did not
return an error..."
An
Can anyone help me?
Thanks.
ticha
Posted via http://www.webservertalk.com
View this thread: http://www.webservertalk.com/message930459.html
Hi
Look in the Windows Event Log and the Agent log file in the LOGs directory.
You may get more information there.
Regards
Mike
"ticha" wrote:

> Hello.
> I have SQL Server MSDE running Windows 2000.
> When I start SQL Agent gives me the following error:"Could not start
> the SQLAgent$SPSQL service on Local Computer. The service did not
> return an error..."
> An
> Can anyone help me?
> Thanks.
>
> --
> ticha
> Posted via http://www.webservertalk.com
> View this thread: http://www.webservertalk.com/message930459.html
>

Could not set working set size to 1168512 KB

hello,
We're running W2000 sp4 fr/ SQL 2000 SP3 fr and get error 17122 in the
application event log every time SQL is brought up. The error text
reads
"initdata: Warning: Could not set working set size to 1168512 KB".
What does
this really mean, is it harmful and how can I correct it? Thanks for
any info.
Thanks
A.S
Hi,
Not a real problem, this is only a warning due to incompatibility with
PAE/AWE !
Just disable the "reserve physical memory for SQLServer" by :
sp_configure 'set working set size',0
go
reconfigure with override
go
See http://support.microsoft.com/kb/822164/en-us
Guillaume.
"Zizou-Real" wrote:

> hello,
> We're running W2000 sp4 fr/ SQL 2000 SP3 fr and get error 17122 in the
> application event log every time SQL is brought up. The error text
> reads
> "initdata: Warning: Could not set working set size to 1168512 KB".
> What does
> this really mean, is it harmful and how can I correct it? Thanks for
> any info.
>
> Thank’s
> A.S
>
>
sql

Could not run BEGIN TRANSACTION in database whatever because the database is read-only.

I had a databases running on SQL Server (EVALUATION VERSION).

I moved it to another system running:

-Windows 2000 Server
-IIS 5.0
-BlueDragon Server
-MSDE

I applied all of the latest service packs, security updates, etc...
Intalled SQL Server Web Data Administrator and .NET framework.

I attached the database using sp_attach_db:
>osql U sa
>password
>Sp_attach_db whatever',
>@.filename1 = C:\Program Files\Microsoft SQL
Server\MSSQL\Data\CollaborationTools.mdf',
>@.filename2 = C:\Program Files\Microsoft SQL
Server\MSSQL\Data\CollaborationTools.ldf'
>go

I added my datasource using the ODBC Admin Tool...
Verified it using the BlueDragon Admin Datasources page...

But now I'm getting the error message:

'Could not run BEGIN TRANSACTION in database 'whatever' because the
database is read-only.'

Any help/guidance would be appreciated.
Thanks very much.

Shaunokay, thanks for the guidance...

here's what i did:

i went to the location of the .mdf and .ldf files and made sure the
read only attribute wasn't checked.

i then entered the following commands via the cmd prompt:

>osql U sa
>password
>USE master
>EXEC sp_dboption collaboration', read only', FALSE'
>go

I verified by viewing the database properties in the Web Data
Administrator. The Status of the Database now reads Normal' not
Standby'.

Thanks very much.

-shaun|||"SS" <stiznoit@.yahoo.com> wrote in message
news:dab7211.0404141325.6df43251@.posting.google.co m...
> But now I'm getting the error message:
> 'Could not run BEGIN TRANSACTION in database 'whatever' because the
> database is read-only.'

Unless I'm missing something, it's pretty obvious. For some reason database
"whatever" has the read-only flag set.

See db_options to reset.

And since of course since it's read only, there's no point in allowing a
transaction since you can't do anything in it anyway.

> Any help/guidance would be appreciated.
> Thanks very much.
> Shaun|||okay, thanks for the guidance...

here's what i did:

i went to the location of the .mdf and .ldf files and made sure the
read only attribute wasn't checked.

i then entered the following commands via the cmd prompt:

>osql U sa
>password
>USE master
>EXEC sp_dboption collaboration', read only', FALSE'
>go

I verified by viewing the database properties in the Web Data
Administrator. The Status of the Database now reads Normal' not
Standby'.

Thanks very much.

-shaun

Could not run BEGIN TRANSACTION in database whatever because the database is read-only.

I had a databases running on SQL Server (EVALUATION VERSION).

I moved it to another system running:

-Windows 2000 Server
-IIS 5.0
-BlueDragon Server
-MSDE

I applied all of the latest service packs, security updates, etc...
Intalled SQL Server Web Data Administrator and .NET framework.

I attached the database using sp_attach_db:
>osql U sa
>password
>Sp_attach_db whatever',
>@.filename1 = C:\Program Files\Microsoft SQL
Server\MSSQL\Data\CollaborationTools.mdf',
>@.filename2 = C:\Program Files\Microsoft SQL
Server\MSSQL\Data\CollaborationTools.ldf'
>go

I added my datasource using the ODBC Admin Tool...
Verified it using the BlueDragon Admin Datasources page...

But now I'm getting the error message:

'Could not run BEGIN TRANSACTION in database 'whatever' because the
database is read-only.'

Any help/guidance would be appreciated.
Thanks very much.

Shaun"SS" <stiznoit@.yahoo.com> wrote in message
news:dab7211.0404141325.6df43251@.posting.google.co m...
> But now I'm getting the error message:
> 'Could not run BEGIN TRANSACTION in database 'whatever' because the
> database is read-only.'

Unless I'm missing something, it's pretty obvious. For some reason database
"whatever" has the read-only flag set.

See db_options to reset.

And since of course since it's read only, there's no point in allowing a
transaction since you can't do anything in it anyway.

> Any help/guidance would be appreciated.
> Thanks very much.
> Shaunsql

Could not open FCB for invalid file ID 5120

I was just running a query and got the following error.
Could not open FCB for invalid file ID 5120 in database
<dbname>. Table or database may be corrupted..
Any ideas?
Hi,
Execute the DBCC CHECKDB with REPAIR_REBUILD option. If you still have
issues then take a full database backup and you may need to try the option
REPAIR_ALLOW_DATA_LOSS with DBCC CHECKDB.
Thanks
Hari
MCDBA
<anonymous@.discussions.microsoft.com> wrote in message
news:299dc01c465ab$06520cb0$a501280a@.phx.gbl...
> I was just running a query and got the following error.
> Could not open FCB for invalid file ID 5120 in database
> <dbname>. Table or database may be corrupted..
> Any ideas?
|||I did this just before I ran the query.
I repaired all of the errors found and then ran the query.

>--Original Message--
>Hi,
>Execute the DBCC CHECKDB with REPAIR_REBUILD option. If
you still have
>issues then take a full database backup and you may need
to try the option
>REPAIR_ALLOW_DATA_LOSS with DBCC CHECKDB.
>
>--
>Thanks
>Hari
>MCDBA
><anonymous@.discussions.microsoft.com> wrote in message
>news:299dc01c465ab$06520cb0$a501280a@.phx.gbl...
>
>.
>
|||If the AUTO SHRINK is enabled on this database, then disable it.
Otherwise do not issue DBCC SHRINKFILE statement while SHRINKDATABASE is working.
Also confirm what is the level of service pack on SQL?
As there is no confirmation of version used, check whether this KBA http://support.microsoft.com/default...b;EN-US;276043 is any help.
"anonymous@.discussions.microsoft.com" wrote:

> I did this just before I ran the query.
> I repaired all of the errors found and then ran the query.
> you still have
> to try the option
>
|||Can you explain the advice below about shrinkdatabase and shrinkfile? Can
you also explain how autoshrink could cause the invalid FCB message?
Thanks.
Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"SatyaSKJ" <SatyaSKJ@.discussions.microsoft.com> wrote in message
news:961E7787-C82B-44D3-8653-56D9BCFD3CC2@.microsoft.com...
> If the AUTO SHRINK is enabled on this database, then disable it.
> Otherwise do not issue DBCC SHRINKFILE statement while SHRINKDATABASE is
working.
> Also confirm what is the level of service pack on SQL?
> As there is no confirmation of version used, check whether this KBA
http://support.microsoft.com/default...b;EN-US;276043 is any help.[vbcol=seagreen]
>
> "anonymous@.discussions.microsoft.com" wrote:
|||This is very bad advice.
Microsoft does not recommend you run repair blindly without working out the
root cause of your problem and the consequences of running repair. Running
REPAIR_ALLOW_DATA_LOSS (as its name suggests) deletes data with no heed to
whatever business logic is inherent in your database. Even running
REPAIR_REBUILD without first working out what happened is very foolish and
is just a band-aid until the problem occurs again.
Regards.
Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:uv3QnuaZEHA.1248@.TK2MSFTNGP11.phx.gbl...
> Hi,
> Execute the DBCC CHECKDB with REPAIR_REBUILD option. If you still have
> issues then take a full database backup and you may need to try the option
> REPAIR_ALLOW_DATA_LOSS with DBCC CHECKDB.
>
> --
> Thanks
> Hari
> MCDBA
> <anonymous@.discussions.microsoft.com> wrote in message
> news:299dc01c465ab$06520cb0$a501280a@.phx.gbl...
>

Could not open FCB for invalid file ID 5120

I was just running a query and got the following error.
Could not open FCB for invalid file ID 5120 in database
<dbname>. Table or database may be corrupted..
Any ideas?Hi,
Execute the DBCC CHECKDB with REPAIR_REBUILD option. If you still have
issues then take a full database backup and you may need to try the option
REPAIR_ALLOW_DATA_LOSS with DBCC CHECKDB.
Thanks
Hari
MCDBA
<anonymous@.discussions.microsoft.com> wrote in message
news:299dc01c465ab$06520cb0$a501280a@.phx
.gbl...
> I was just running a query and got the following error.
> Could not open FCB for invalid file ID 5120 in database
> <dbname>. Table or database may be corrupted..
> Any ideas?|||I did this just before I ran the query.
I repaired all of the errors found and then ran the query.

>--Original Message--
>Hi,
>Execute the DBCC CHECKDB with REPAIR_REBUILD option. If
you still have
>issues then take a full database backup and you may need
to try the option
>REPAIR_ALLOW_DATA_LOSS with DBCC CHECKDB.
>
>--
>Thanks
>Hari
>MCDBA
><anonymous@.discussions.microsoft.com> wrote in message
> news:299dc01c465ab$06520cb0$a501280a@.phx
.gbl...
>
>.
>|||Can you explain the advice below about shrinkdatabase and shrinkfile? Can
you also explain how autoshrink could cause the invalid FCB message?
Thanks.
Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"SatyaSKJ" <SatyaSKJ@.discussions.microsoft.com> wrote in message
news:961E7787-C82B-44D3-8653-56D9BCFD3CC2@.microsoft.com...
> If the AUTO SHRINK is enabled on this database, then disable it.
> Otherwise do not issue DBCC SHRINKFILE statement while SHRINKDATABASE is
working.
> Also confirm what is the level of service pack on SQL?
> As there is no confirmation of version used, check whether this KBA
http://support.microsoft.com/defaul...kb;EN-US;276043 is any help.[vbcol=seagreen]
>
> "anonymous@.discussions.microsoft.com" wrote:
>|||This is very bad advice.
Microsoft does not recommend you run repair blindly without working out the
root cause of your problem and the consequences of running repair. Running
REPAIR_ALLOW_DATA_LOSS (as its name suggests) deletes data with no heed to
whatever business logic is inherent in your database. Even running
REPAIR_REBUILD without first working out what happened is very foolish and
is just a band-aid until the problem occurs again.
Regards.
Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:uv3QnuaZEHA.1248@.TK2MSFTNGP11.phx.gbl...
> Hi,
> Execute the DBCC CHECKDB with REPAIR_REBUILD option. If you still have
> issues then take a full database backup and you may need to try the option
> REPAIR_ALLOW_DATA_LOSS with DBCC CHECKDB.
>
> --
> Thanks
> Hari
> MCDBA
> <anonymous@.discussions.microsoft.com> wrote in message
> news:299dc01c465ab$06520cb0$a501280a@.phx
.gbl...
>

Could not open FCB for invalid file ID 5120

I was just running a query and got the following error.
Could not open FCB for invalid file ID 5120 in database
<dbname>. Table or database may be corrupted..
Any ideas?Hi,
Execute the DBCC CHECKDB with REPAIR_REBUILD option. If you still have
issues then take a full database backup and you may need to try the option
REPAIR_ALLOW_DATA_LOSS with DBCC CHECKDB.
Thanks
Hari
MCDBA
<anonymous@.discussions.microsoft.com> wrote in message
news:299dc01c465ab$06520cb0$a501280a@.phx.gbl...
> I was just running a query and got the following error.
> Could not open FCB for invalid file ID 5120 in database
> <dbname>. Table or database may be corrupted..
> Any ideas?|||I did this just before I ran the query.
I repaired all of the errors found and then ran the query.
>--Original Message--
>Hi,
>Execute the DBCC CHECKDB with REPAIR_REBUILD option. If
you still have
>issues then take a full database backup and you may need
to try the option
>REPAIR_ALLOW_DATA_LOSS with DBCC CHECKDB.
>
>--
>Thanks
>Hari
>MCDBA
><anonymous@.discussions.microsoft.com> wrote in message
>news:299dc01c465ab$06520cb0$a501280a@.phx.gbl...
>> I was just running a query and got the following error.
>> Could not open FCB for invalid file ID 5120 in database
>> <dbname>. Table or database may be corrupted..
>> Any ideas?
>
>.
>|||If the AUTO SHRINK is enabled on this database, then disable it.
Otherwise do not issue DBCC SHRINKFILE statement while SHRINKDATABASE is working.
Also confirm what is the level of service pack on SQL?
As there is no confirmation of version used, check whether this KBA http://support.microsoft.com/default.aspx?scid=kb;EN-US;276043 is any help.
"anonymous@.discussions.microsoft.com" wrote:
> I did this just before I ran the query.
> I repaired all of the errors found and then ran the query.
> >--Original Message--
> >Hi,
> >
> >Execute the DBCC CHECKDB with REPAIR_REBUILD option. If
> you still have
> >issues then take a full database backup and you may need
> to try the option
> >REPAIR_ALLOW_DATA_LOSS with DBCC CHECKDB.
> >
> >
> >--
> >Thanks
> >Hari
> >MCDBA
> ><anonymous@.discussions.microsoft.com> wrote in message
> >news:299dc01c465ab$06520cb0$a501280a@.phx.gbl...
> >> I was just running a query and got the following error.
> >>
> >> Could not open FCB for invalid file ID 5120 in database
> >> <dbname>. Table or database may be corrupted..
> >>
> >> Any ideas?
> >
> >
> >.
> >
>|||Can you explain the advice below about shrinkdatabase and shrinkfile? Can
you also explain how autoshrink could cause the invalid FCB message?
Thanks.
--
Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"SatyaSKJ" <SatyaSKJ@.discussions.microsoft.com> wrote in message
news:961E7787-C82B-44D3-8653-56D9BCFD3CC2@.microsoft.com...
> If the AUTO SHRINK is enabled on this database, then disable it.
> Otherwise do not issue DBCC SHRINKFILE statement while SHRINKDATABASE is
working.
> Also confirm what is the level of service pack on SQL?
> As there is no confirmation of version used, check whether this KBA
http://support.microsoft.com/default.aspx?scid=kb;EN-US;276043 is any help.
>
> "anonymous@.discussions.microsoft.com" wrote:
> > I did this just before I ran the query.
> > I repaired all of the errors found and then ran the query.
> >
> > >--Original Message--
> > >Hi,
> > >
> > >Execute the DBCC CHECKDB with REPAIR_REBUILD option. If
> > you still have
> > >issues then take a full database backup and you may need
> > to try the option
> > >REPAIR_ALLOW_DATA_LOSS with DBCC CHECKDB.
> > >
> > >
> > >--
> > >Thanks
> > >Hari
> > >MCDBA
> > ><anonymous@.discussions.microsoft.com> wrote in message
> > >news:299dc01c465ab$06520cb0$a501280a@.phx.gbl...
> > >> I was just running a query and got the following error.
> > >>
> > >> Could not open FCB for invalid file ID 5120 in database
> > >> <dbname>. Table or database may be corrupted..
> > >>
> > >> Any ideas?
> > >
> > >
> > >.
> > >
> >|||This is very bad advice.
Microsoft does not recommend you run repair blindly without working out the
root cause of your problem and the consequences of running repair. Running
REPAIR_ALLOW_DATA_LOSS (as its name suggests) deletes data with no heed to
whatever business logic is inherent in your database. Even running
REPAIR_REBUILD without first working out what happened is very foolish and
is just a band-aid until the problem occurs again.
Regards.
--
Paul Randal
Dev Lead, Microsoft SQL Server Storage Engine
This posting is provided "AS IS" with no warranties, and confers no rights.
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:uv3QnuaZEHA.1248@.TK2MSFTNGP11.phx.gbl...
> Hi,
> Execute the DBCC CHECKDB with REPAIR_REBUILD option. If you still have
> issues then take a full database backup and you may need to try the option
> REPAIR_ALLOW_DATA_LOSS with DBCC CHECKDB.
>
> --
> Thanks
> Hari
> MCDBA
> <anonymous@.discussions.microsoft.com> wrote in message
> news:299dc01c465ab$06520cb0$a501280a@.phx.gbl...
> > I was just running a query and got the following error.
> >
> > Could not open FCB for invalid file ID 5120 in database
> > <dbname>. Table or database may be corrupted..
> >
> > Any ideas?
>

Could not load the package "\MSDB\....."

Hi,

I have a intermittent problem with my ssis packages. I have a couple of packages running on a schedule with SQL Server Agent wich sometimes gives me the following errors in agent history:

Message
Executed as user: MyDomain\SQLAgentServiceAccount. Microsoft (R) SQL Server Execute Package Utility Version 9.00.1399.06 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 21:05:00 Could not load package "\MSDB\MyPackageName" because of error 0x80040E37. Description: Table/view either does not exist or contains errors. Source: Microsoft SQL Native Client Started: 21:05:00 Finished: 21:05:00 Elapsed: 0.047 seconds. Process Exit Code 5. The step failed.

When the package does'nt fails it gives me the following message:

Message
Executed as user: MyDomain\SQLAgentServiceAccount. Microsoft (R) SQL Server Execute Package Utility Version 9.00.1399.06 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 21:10:00 DTExec: The package execution returned DTSER_SUCCESS (0). Started: 21:10:00 Finished: 21:10:02 Elapsed: 1.312 seconds. Process Exit Code 0. The step succeeded.

The jobs moves data between the sql server that executes the code and a SQL 2000 database on another server. Does anyone recognize this error?

http://www.eggheadcafe.com/forumarchives/SQLServerdts/Nov2005/post24522953.asp

This is the same error, but not necessarily the same problem. Does your package reference tables that might need to be wrapped with [] or prefixed with the schema?

Could not get the data of the row from the OLE DB provider 'SQLOLE

We are running SQL2000 SP3 on two servers. One is Server 2003 the other is
Server 2000. Both servers are linked to one another. The 2003 server is
running DTC. We are running several lightweight jobs that are occasionally,
and more often than we like, having the following error:
Could not get the data of the row from the OLE DB provider 'SQLOLEDB'.
[SQLSTATE 42000] (Error 7346) [SQLSTATE 01000] (Error 7312) OLE DB error
trace [OLE/DB Provider 'SQLOLEDB' IRowset::GetData returned 0x80040e23].
[SQLSTATE 01000] (Error 7300). The step failed.
The sp basically set variables with data from both the primary server A and
the linked server B using views. This part is successful. The next step is
updating information in server B via a view. This appears to be where the
job is creating the above error. The last part of the sp is another update
entirely on the local server A.
I appreciate your help...
Thanks...Hi
Error 7312 is "Could not set up parameter for remote server '%.*ls'."
I have sometimes seen this error when a remote server has a deadlock or when
a lock can not be acquired to satisfy the request. Have a look at what is
happening on the linked server when this occurs.
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/
"ChrisD" <ChrisD@.discussions.microsoft.com> wrote in message
news:D508BC5E-178C-4518-BF00-D17BA13143DF@.microsoft.com...
> We are running SQL2000 SP3 on two servers. One is Server 2003 the other
is
> Server 2000. Both servers are linked to one another. The 2003 server is
> running DTC. We are running several lightweight jobs that are
occasionally,
> and more often than we like, having the following error:
> Could not get the data of the row from the OLE DB provider 'SQLOLEDB'.
> [SQLSTATE 42000] (Error 7346) [SQLSTATE 01000] (Error 7312) OLE DB
error
> trace [OLE/DB Provider 'SQLOLEDB' IRowset::GetData returned 0x80040e23].
> [SQLSTATE 01000] (Error 7300). The step failed.
> The sp basically set variables with data from both the primary server A
and
> the linked server B using views. This part is successful. The next step
is
> updating information in server B via a view. This appears to be where the
> job is creating the above error. The last part of the sp is another
update
> entirely on the local server A.
> I appreciate your help...
> Thanks...
>

Could not get the data of the row from the OLE DB provider 'SQLOLE

I am running SQL2000 on two different machines. One is 2003 server, the
other is 2000 server. DTC is setup on the 2003 server. Both servers are
linked to one another. I am running several small jobs that simply execute a
sp. I am consistantly getting the following error message:
Could not get the data of the row from the OLE DB provider 'SQLOLEDB'.
[SQLSTATE 42000] (Error 7346) [SQLSTATE 01000] (Error 7312) OLE DB error
trace [OLE/DB Provider 'SQLOLEDB' IRowset::GetData returned 0x80040e23].
[SQLSTATE 01000] (Error 7300). The step failed.
The sp that is running to cause this is error is one of two that consist of
Several varialbes that get their set values from select statements with
views back into Server B and some of them are setting values from the local
server A.
The error occurs after these are set, and when I try to do one of the two
following updates.
One is an update From Server A via a view into Server B. There are no date
values being passed or updated, but the view does include date fields.
The second update is all on the local server. Updating a source table flag.
Any help would be greatly appreciated.
Thanks...
You might want to post your actual T-SQL statements and some configuration
values.
Sincerely,
Anthony Thomas

"ChrisD" <ChrisD@.discussions.microsoft.com> wrote in message
news:1E63096F-95DF-480E-9BFB-6B36BEE44901@.microsoft.com...
I am running SQL2000 on two different machines. One is 2003 server, the
other is 2000 server. DTC is setup on the 2003 server. Both servers are
linked to one another. I am running several small jobs that simply execute
a
sp. I am consistantly getting the following error message:
Could not get the data of the row from the OLE DB provider 'SQLOLEDB'.
[SQLSTATE 42000] (Error 7346) [SQLSTATE 01000] (Error 7312) OLE DB error
trace [OLE/DB Provider 'SQLOLEDB' IRowset::GetData returned 0x80040e23].
[SQLSTATE 01000] (Error 7300). The step failed.
The sp that is running to cause this is error is one of two that consist of
Several varialbes that get their set values from select statements with
views back into Server B and some of them are setting values from the local
server A.
The error occurs after these are set, and when I try to do one of the two
following updates.
One is an update From Server A via a view into Server B. There are no date
values being passed or updated, but the view does include date fields.
The second update is all on the local server. Updating a source table flag.
Any help would be greatly appreciated.
Thanks...

Could not get the data of the row from the OLE DB provider 'SQLOLE

I am running SQL2000 on two different machines. One is 2003 server, the
other is 2000 server. DTC is setup on the 2003 server. Both servers are
linked to one another. I am running several small jobs that simply execute
a
sp. I am consistantly getting the following error message:
Could not get the data of the row from the OLE DB provider 'SQLOLEDB'.
[SQLSTATE 42000] (Error 7346) [SQLSTATE 01000] (Error 7312) OLE D
B error
trace [OLE/DB Provider 'SQLOLEDB' IRowset::GetData returned 0x80040e23].
[SQLSTATE 01000] (Error 7300). The step failed.
The sp that is running to cause this is error is one of two that consist of
Several varialbes that get their set values from select statements with
views back into Server B and some of them are setting values from the local
server A.
The error occurs after these are set, and when I try to do one of the two
following updates.
One is an update From Server A via a view into Server B. There are no date
values being passed or updated, but the view does include date fields.
The second update is all on the local server. Updating a source table flag.
Any help would be greatly appreciated.
Thanks...You might want to post your actual T-SQL statements and some configuration
values.
Sincerely,
Anthony Thomas
"ChrisD" <ChrisD@.discussions.microsoft.com> wrote in message
news:1E63096F-95DF-480E-9BFB-6B36BEE44901@.microsoft.com...
I am running SQL2000 on two different machines. One is 2003 server, the
other is 2000 server. DTC is setup on the 2003 server. Both servers are
linked to one another. I am running several small jobs that simply execute
a
sp. I am consistantly getting the following error message:
Could not get the data of the row from the OLE DB provider 'SQLOLEDB'.
[SQLSTATE 42000] (Error 7346) [SQLSTATE 01000] (Error 7312) OLE D
B error
trace [OLE/DB Provider 'SQLOLEDB' IRowset::GetData returned 0x80040e23].
[SQLSTATE 01000] (Error 7300). The step failed.
The sp that is running to cause this is error is one of two that consist of
Several varialbes that get their set values from select statements with
views back into Server B and some of them are setting values from the local
server A.
The error occurs after these are set, and when I try to do one of the two
following updates.
One is an update From Server A via a view into Server B. There are no date
values being passed or updated, but the view does include date fields.
The second update is all on the local server. Updating a source table flag.
Any help would be greatly appreciated.
Thanks...

Could not get the data of the row from the OLE DB provider 'SQLOLE

I am running SQL2000 on two different machines. One is 2003 server, the
other is 2000 server. DTC is setup on the 2003 server. Both servers are
linked to one another. I am running several small jobs that simply execute a
sp. I am consistantly getting the following error message:
Could not get the data of the row from the OLE DB provider 'SQLOLEDB'.
[SQLSTATE 42000] (Error 7346) [SQLSTATE 01000] (Error 7312) OLE DB error
trace [OLE/DB Provider 'SQLOLEDB' IRowset::GetData returned 0x80040e23].
[SQLSTATE 01000] (Error 7300). The step failed.
The sp that is running to cause this is error is one of two that consist of
Several varialbes that get their set values from select statements with
views back into Server B and some of them are setting values from the local
server A.
The error occurs after these are set, and when I try to do one of the two
following updates.
One is an update From Server A via a view into Server B. There are no date
values being passed or updated, but the view does include date fields.
The second update is all on the local server. Updating a source table flag.
Any help would be greatly appreciated.
Thanks...You might want to post your actual T-SQL statements and some configuration
values.
Sincerely,
Anthony Thomas
"ChrisD" <ChrisD@.discussions.microsoft.com> wrote in message
news:1E63096F-95DF-480E-9BFB-6B36BEE44901@.microsoft.com...
I am running SQL2000 on two different machines. One is 2003 server, the
other is 2000 server. DTC is setup on the 2003 server. Both servers are
linked to one another. I am running several small jobs that simply execute
a
sp. I am consistantly getting the following error message:
Could not get the data of the row from the OLE DB provider 'SQLOLEDB'.
[SQLSTATE 42000] (Error 7346) [SQLSTATE 01000] (Error 7312) OLE DB error
trace [OLE/DB Provider 'SQLOLEDB' IRowset::GetData returned 0x80040e23].
[SQLSTATE 01000] (Error 7300). The step failed.
The sp that is running to cause this is error is one of two that consist of
Several varialbes that get their set values from select statements with
views back into Server B and some of them are setting values from the local
server A.
The error occurs after these are set, and when I try to do one of the two
following updates.
One is an update From Server A via a view into Server B. There are no date
values being passed or updated, but the view does include date fields.
The second update is all on the local server. Updating a source table flag.
Any help would be greatly appreciated.
Thanks...

Could not get into server instance

Hi,
I ran Enterprise manager, but I could not get into my
server. It said that it was not running or to check '
the config, which is fine and is Windows Only Authentication.
Here is the weird and scary part. ZoneAlarm had an alert
at the same time. The alert was asking for Management Console
to use USERINIT.EXE to access 192.5.6.30DNS.
This resolves to a.gtld-servers.net which is part of Verisign.
I refused this outbound access and kept retrying to get into
my server in Enterprise. No luck. I then decided to go ahead
and give outbound access. Next time I tried to get into
my server I was able to.
Does anyone know what's up?
I figured that maybe I should change all my logins?
But, does this show that there is a breach of my system?
There has been another odd thing where WSCRIPT.EXE has
been asking for access to DNS servers. That I keep blocked.
I am pretty sure that is a trojan, but do you think this is this related ?
Thanks for any advice.
FoxAs a very first step -- scan your computer for virus or Trojans, I think you
may have a serious exploit on your hands.
Steve
"Fox" <fox @. connexions .net> wrote in message
news:e9HspB2wDHA.2408@.tk2msftngp13.phx.gbl...

quote:

---

> Hi,
> I ran Enterprise manager, but I could not get into my
> server. It said that it was not running or to check '
> the config, which is fine and is Windows Only Authentication.
> Here is the weird and scary part. ZoneAlarm had an alert
> at the same time. The alert was asking for Management Console
> to use USERINIT.EXE to access 192.5.6.30DNS.
> This resolves to a.gtld-servers.net which is part of Verisign.
> I refused this outbound access and kept retrying to get into
> my server in Enterprise. No luck. I then decided to go ahead
> and give outbound access. Next time I tried to get into
> my server I was able to.
> Does anyone know what's up?
> I figured that maybe I should change all my logins?
> But, does this show that there is a breach of my system?
> There has been another odd thing where WSCRIPT.EXE has
> been asking for access to DNS servers. That I keep blocked.
> I am pretty sure that is a trojan, but do you think this is this related ?
> Thanks for any advice.
> Fox
>

---

|||I have already scanned several times and have come up with nothing.
I changed all logins related to admin.
A few weeks ago I found entries in my firewall to allow 3 IPs
access. I saw them in there once before and deleted them.
This time I block them entirely from access. It seems I've been
playing a cat and mouse game for a while. But I cannot find
the source and a re-install is out of the question. There were
a few other things that happend earlier this year. I don't
know what to do next to try to find the source of this.
Regards,
Fox
"Steve Thompson" <SteveThompson@.nomail.please> wrote in message
news:eZcXtC$wDHA.3116@.TK2MSFTNGP11.phx.gbl...

quote:

---

> As a very first step -- scan your computer for virus or Trojans, I think

---

you

quote:

---

> may have a serious exploit on your hands.
> Steve
>
> "Fox" <fox @. connexions .net> wrote in message
> news:e9HspB2wDHA.2408@.tk2msftngp13.phx.gbl...
?[QUOTE]
>

---

|||What are you using as a firewall?
Is this a "live" SQL Server on the internet?
What type of applications are connecting to this Server?
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.

Could not find stored procedure.....SQL 2000

We are setting up a new server to replace a currently running SQL 2000
server. After restoring the database from a backup, when we attempt to log in
using a custom application, we get an error message stating "[Microsoft][ODBC
SQL Server Driver][SQL Server]Cound not find stored procedure
'drs_AuthenticateCurrentUser'. I can see that stored procedure listed in the
Stored Procedures subfolder in the restored database. I ran the restore from
Enterprise Manager just using the wizzard and had no issues when restoring.
Any ideas?
What user are you connecting as? What is that user's default database? Are
you sure you're executing in the right database? (A common problem is that
a connection string without a database specified would default to a user's
default database, but if the database is dropped/re-created/renamed...) Who
is the owner of the stored procedure? If it is dbo, did you try EXEC
dbo.drs_AuthenticateCurrentUser instead of EXEC drs_AuthenticateCurrentUser?
It is always a good idea to prefix object names both when creating and when
executing.
Aaron Bertrand
SQL Server MVP
"Jason Carter" <JasonCarter@.discussions.microsoft.com> wrote in message
news:0A96F5C3-EB54-46B7-A7B2-3EBAD3E9842B@.microsoft.com...
> We are setting up a new server to replace a currently running SQL 2000
> server. After restoring the database from a backup, when we attempt to log
> in
> using a custom application, we get an error message stating
> "[Microsoft][ODBC
> SQL Server Driver][SQL Server]Cound not find stored procedure
> 'drs_AuthenticateCurrentUser'. I can see that stored procedure listed in
> the
> Stored Procedures subfolder in the restored database. I ran the restore
> from
> Enterprise Manager just using the wizzard and had no issues when
> restoring.
> Any ideas?
|||Thanks for the reply Aaron....
I have tried a number of users including sa. sa's default database is
'master', but the other users I have tried have their default databases set
to MTCCashRecon which is where the stored procedure is located. I have also
verified the permissions for each of those users in that database is the same
as the ones on the old server. The owner of the stored procedure is dbo. I
have not tried to manually execute that procedure; I have only lanched this
from the application. I am nowhere near a SQL DBA and kind of got forced into
this one. I do not have access to the code and do not know if the stored proc
is being called as dbo.drs_authenticateCurrentUser or if it is being called
simply by the name; although I can say that the database was simply restored
from a .BAK file and I would have hoped that it would have just worked.
I have considered using the Data Transformation Sets to get the stored
procedures from the old server, but am not sure how that affects the old
server since it is still in use; does it lock the server or move any stored
procedures vs. just copying them.

Could not find stored procedure.....SQL 2000

We are setting up a new server to replace a currently running SQL 2000
server. After restoring the database from a backup, when we attempt to log i
n
using a custom application, we get an error message stating "[Microsoft]
[ODBC
SQL Server Driver][SQL Server]Cound not find stored procedure
'drs_AuthenticateCurrentUser'. I can see that stored procedure listed in the
Stored Procedures subfolder in the restored database. I ran the restore from
Enterprise Manager just using the wizzard and had no issues when restoring.
Any ideas?What user are you connecting as? What is that user's default database? Are
you sure you're executing in the right database? (A common problem is that
a connection string without a database specified would default to a user's
default database, but if the database is dropped/re-created/renamed...) Who
is the owner of the stored procedure? If it is dbo, did you try EXEC
dbo.drs_AuthenticateCurrentUser instead of EXEC drs_AuthenticateCurrentUser?
It is always a good idea to prefix object names both when creating and when
executing.
Aaron Bertrand
SQL Server MVP
"Jason Carter" <JasonCarter@.discussions.microsoft.com> wrote in message
news:0A96F5C3-EB54-46B7-A7B2-3EBAD3E9842B@.microsoft.com...
> We are setting up a new server to replace a currently running SQL 2000
> server. After restoring the database from a backup, when we attempt to log
> in
> using a custom application, we get an error message stating
> "[Microsoft][ODBC
> SQL Server Driver][SQL Server]Cound not find stored procedure
> 'drs_AuthenticateCurrentUser'. I can see that stored procedure listed in
> the
> Stored Procedures subfolder in the restored database. I ran the restore
> from
> Enterprise Manager just using the wizzard and had no issues when
> restoring.
> Any ideas?|||Thanks for the reply Aaron....
I have tried a number of users including sa. sa's default database is
'master', but the other users I have tried have their default databases set
to MTCCashRecon which is where the stored procedure is located. I have also
verified the permissions for each of those users in that database is the sam
e
as the ones on the old server. The owner of the stored procedure is dbo. I
have not tried to manually execute that procedure; I have only lanched this
from the application. I am nowhere near a SQL DBA and kind of got forced int
o
this one. I do not have access to the code and do not know if the stored pro
c
is being called as dbo.drs_authenticateCurrentUser or if it is being called
simply by the name; although I can say that the database was simply restored
from a .BAK file and I would have hoped that it would have just worked.
I have considered using the Data Transformation Sets to get the stored
procedures from the old server, but am not sure how that affects the old
server since it is still in use; does it lock the server or move any stored
procedures vs. just copying them.