Errors when trying to run SQL

Ok, whenever I try to connect, I get the following Error messages:

"SQL Server Registration failed because of the connection failure displayed below.
SQL Server does not exist or access denied.
ConnectionOpen (Connect())"

"An Error 1069 occured while performing this service operation on the
MSSQLServer Service"

I even went as far as uninstalling and reinstalling, but to no avail. Does anyone have an idea what's causing this? It was working fine and then all the sudden one day I start getting these messages and it won't work.

Thanks!
SmittyYou using sql server security ot trusted connection?

Do you have a dba, or are you it?

Does anyone else have sa priviliges to the box?|||Thanks for replying Brett...

It's my own personal computer at home so I'm the SA and no one else uses it nor has the ability to. It is the 120-day evaluation edition that I got with the text book that I use for school. I don't understand, it worked fine then it didn't... :confused:

Smitty|||You past the 120 days?

I think it messes with the registry...

You can by a full blown version for $49.00

It just can't be used for production systems...

http://www.microsoft.com/sql/howtobuy/development.asp|||I suppose that's most like the case :( Guess I'll need to buy it sooner or later heh..

Thanks Brett,

Smitty|||If its for study purpose then you can uninstall the SQL and remove all registry keys referred to SQL Server, reboot and reinstall Evaluation edition.|||Thank you Satya,

My instructor told me to do the same. :D

Errors in log when running data-driven subscriptions

The following messages are displayed in one of the RS logs when running a
data-driven subscription:
ReportingServicesService!processing!820!12/17/2004-05:03:03:: e ERROR: There
is no data for the field at position 277.
ReportingServicesService!processing!820!12/17/2004-05:03:03:: e ERROR: There
is no data for the field at position 278.
ReportingServicesService!processing!820!12/17/2004-05:03:03:: e ERROR: There
is no data for the field at position 279.
What do they mean? What is the position referring to? The data-driven
subscription uses a query that selects a subset of the records in a table.
Thanks.I believe it is referring to the fields in the query. Does you query return
280 columns? How did you create the DD subscription, via Report Manager or
SOAP? If it was via soap, it is possible that your field list is not
identical to what is returned from the query. If you run the query through
PrepareQuery you should get an appropriate field listing.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"PD" <PD@.discussions.microsoft.com> wrote in message
news:E5E8B150-0891-4154-9C9B-7532FB911E7F@.microsoft.com...
> The following messages are displayed in one of the RS logs when running a
> data-driven subscription:
> ReportingServicesService!processing!820!12/17/2004-05:03:03:: e ERROR:
> There
> is no data for the field at position 277.
> ReportingServicesService!processing!820!12/17/2004-05:03:03:: e ERROR:
> There
> is no data for the field at position 278.
> ReportingServicesService!processing!820!12/17/2004-05:03:03:: e ERROR:
> There
> is no data for the field at position 279.
> What do they mean? What is the position referring to? The data-driven
> subscription uses a query that selects a subset of the records in a table.
> Thanks.|||The query only returns 1 column from a table with 4 columns total. I created
the subscription using the Report Manager.
"Daniel Reib [MSFT]" wrote:
> I believe it is referring to the fields in the query. Does you query return
> 280 columns? How did you create the DD subscription, via Report Manager or
> SOAP? If it was via soap, it is possible that your field list is not
> identical to what is returned from the query. If you run the query through
> PrepareQuery you should get an appropriate field listing.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "PD" <PD@.discussions.microsoft.com> wrote in message
> news:E5E8B150-0891-4154-9C9B-7532FB911E7F@.microsoft.com...
> > The following messages are displayed in one of the RS logs when running a
> > data-driven subscription:
> >
> > ReportingServicesService!processing!820!12/17/2004-05:03:03:: e ERROR:
> > There
> > is no data for the field at position 277.
> > ReportingServicesService!processing!820!12/17/2004-05:03:03:: e ERROR:
> > There
> > is no data for the field at position 278.
> > ReportingServicesService!processing!820!12/17/2004-05:03:03:: e ERROR:
> > There
> > is no data for the field at position 279.
> >
> > What do they mean? What is the position referring to? The data-driven
> > subscription uses a query that selects a subset of the records in a table.
> >
> > Thanks.
>
>|||Hmmm. Can you send a little more of the log file. Perhaps that will shed
some light.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"PD" <PD@.discussions.microsoft.com> wrote in message
news:1C6EA567-4DF7-40C1-8713-FCD68ABC32DF@.microsoft.com...
> The query only returns 1 column from a table with 4 columns total. I
> created
> the subscription using the Report Manager.
> "Daniel Reib [MSFT]" wrote:
>> I believe it is referring to the fields in the query. Does you query
>> return
>> 280 columns? How did you create the DD subscription, via Report Manager
>> or
>> SOAP? If it was via soap, it is possible that your field list is not
>> identical to what is returned from the query. If you run the query
>> through
>> PrepareQuery you should get an appropriate field listing.
>> --
>> -Daniel
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "PD" <PD@.discussions.microsoft.com> wrote in message
>> news:E5E8B150-0891-4154-9C9B-7532FB911E7F@.microsoft.com...
>> > The following messages are displayed in one of the RS logs when running
>> > a
>> > data-driven subscription:
>> >
>> > ReportingServicesService!processing!820!12/17/2004-05:03:03:: e ERROR:
>> > There
>> > is no data for the field at position 277.
>> > ReportingServicesService!processing!820!12/17/2004-05:03:03:: e ERROR:
>> > There
>> > is no data for the field at position 278.
>> > ReportingServicesService!processing!820!12/17/2004-05:03:03:: e ERROR:
>> > There
>> > is no data for the field at position 279.
>> >
>> > What do they mean? What is the position referring to? The data-driven
>> > subscription uses a query that selects a subset of the records in a
>> > table.
>> >
>> > Thanks.
>>|||Daniel,
I have the same problem. The error occurs when I run as a scheduled report
... the report runs fine all other times.
Here is an excerpt from my log file. See the error message after RenderFirst.
aspnet_wp!library!504!12/20/2004-15:41:07:: i INFO: Call to GetPermissions:/
aspnet_wp!library!504!12/20/2004-15:41:07:: i INFO: Call to
GetSystemPermissions
aspnet_wp!library!4b4!12/20/2004-15:42:16:: i INFO: Call to GetPermissions:/
aspnet_wp!library!4b4!12/20/2004-15:42:16:: i INFO: Call to
GetSystemPermissions
aspnet_wp!library!504!12/20/2004-15:42:33:: i INFO: Call to
GetPermissions:/Dashboards
aspnet_wp!library!504!12/20/2004-15:42:33:: i INFO: Call to
GetSystemPermissions
aspnet_wp!library!4b4!12/20/2004-15:42:35:: i INFO: Call to
GetPermissions:/Dashboards/PatientVolumeActivity
aspnet_wp!library!4b4!12/20/2004-15:42:35:: i INFO: Call to
GetSystemPermissions
aspnet_wp!library!4b4!12/20/2004-15:42:36:: i INFO: Call to RenderFirst(
'/Dashboards/PatientVolumeActivity' )
aspnet_wp!processing!b18!12/20/2004-15:42:37:: e ERROR: There is no data for
the field at position 3.
aspnet_wp!library!4b4!12/20/2004-15:42:37:: i INFO: Initializing
EnableExecutionLogging to 'True' as specified in Server system properties.
aspnet_wp!webserver!4b4!12/20/2004-15:42:37:: i INFO: Processed report.
Report='/Dashboards/PatientVolumeActivity', Stream=''
aspnet_wp!chunks!4b4!12/20/2004-15:42:38:: i INFO: ###
GetReportChunk('C_3_S', 1), chunk was not found!
this=d27cd042-e1ce-45c5-bc6a-2211ddca2424
aspnet_wp!chunks!504!12/20/2004-15:42:38:: i INFO: ###
GetReportChunk('C_50_S', 1), chunk was not found!
this=d27cd042-e1ce-45c5-bc6a-2211ddca2424
aspnet_wp!webserver!4b4!12/20/2004-15:42:38:: i INFO: Processed report.
Report='/Dashboards/PatientVolumeActivity', Stream='C_3_S'
aspnet_wp!webserver!504!12/20/2004-15:42:38:: i INFO: Processed report.
Report='/Dashboards/PatientVolumeActivity', Stream='C_50_S'
aspnet_wp!chunks!504!12/20/2004-15:42:38:: i INFO: ###
GetReportChunk('C_111_S', 1), chunk was not found!
this=d27cd042-e1ce-45c5-bc6a-2211ddca2424
aspnet_wp!chunks!4b4!12/20/2004-15:42:38:: i INFO: ###
GetReportChunk('C_140_S', 1), chunk was not found!
this=d27cd042-e1ce-45c5-bc6a-2211ddca2424
aspnet_wp!webserver!504!12/20/2004-15:42:38:: i INFO: Processed report.
Report='/Dashboards/PatientVolumeActivity', Stream='C_111_S'
aspnet_wp!webserver!4b4!12/20/2004-15:42:38:: i INFO: Processed report.
Report='/Dashboards/PatientVolumeActivity', Stream='C_140_S'
aspnet_wp!library!504!12/20/2004-15:42:40:: i INFO: Call to
GetPermissions:/Dashboards/PatientVolumeActivity
aspnet_wp!library!504!12/20/2004-15:42:40:: i INFO: Call to
GetSystemPermissions
"Daniel Reib [MSFT]" wrote:
> Hmmm. Can you send a little more of the log file. Perhaps that will shed
> some light.
> --
> -Daniel
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "PD" <PD@.discussions.microsoft.com> wrote in message
> news:1C6EA567-4DF7-40C1-8713-FCD68ABC32DF@.microsoft.com...
> > The query only returns 1 column from a table with 4 columns total. I
> > created
> > the subscription using the Report Manager.
> >
> > "Daniel Reib [MSFT]" wrote:
> >
> >> I believe it is referring to the fields in the query. Does you query
> >> return
> >> 280 columns? How did you create the DD subscription, via Report Manager
> >> or
> >> SOAP? If it was via soap, it is possible that your field list is not
> >> identical to what is returned from the query. If you run the query
> >> through
> >> PrepareQuery you should get an appropriate field listing.
> >>
> >> --
> >> -Daniel
> >> This posting is provided "AS IS" with no warranties, and confers no
> >> rights.
> >>
> >>
> >> "PD" <PD@.discussions.microsoft.com> wrote in message
> >> news:E5E8B150-0891-4154-9C9B-7532FB911E7F@.microsoft.com...
> >> > The following messages are displayed in one of the RS logs when running
> >> > a
> >> > data-driven subscription:
> >> >
> >> > ReportingServicesService!processing!820!12/17/2004-05:03:03:: e ERROR:
> >> > There
> >> > is no data for the field at position 277.
> >> > ReportingServicesService!processing!820!12/17/2004-05:03:03:: e ERROR:
> >> > There
> >> > is no data for the field at position 278.
> >> > ReportingServicesService!processing!820!12/17/2004-05:03:03:: e ERROR:
> >> > There
> >> > is no data for the field at position 279.
> >> >
> >> > What do they mean? What is the position referring to? The data-driven
> >> > subscription uses a query that selects a subset of the records in a
> >> > table.
> >> >
> >> > Thanks.
> >>
> >>
> >>
>
>