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 when rebuilding indexes

We have SQL Server 2005 set up and we are seeing the following error messages
in our logs from Daily maintenance Plan.
Please comment on the severity of these errors.
Thanks,
mkb
================================================ Executing the query "ALTER INDEX [AllUserData_PK] ON [dbo].[AllUserData]
REBUILD WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF,
ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, SORT_IN_TEMPDB = OFF, ONLINE = OFF )
" failed with the following error: "SQL Server detected a logical
consistency-based I/O error: incorrect pageid (expected 1:2676; actual
14616:395852048). It occurred during a read of page (1:2676) in database ID
13 at offset 0x000000014e8000 in file 'C:\\Program Files\\Microsoft SQL
Server\\MSSQL.1\\MSSQL\\DATA\\SP_IntranetMySites_WebApp.mdf'. Additional
messages in the SQL Server error log or system event log may provide more
detail. This is a severe error condition that threatens database integrity
and must be corrected immediately. Complete a full database consistency check
(DBCC CHECKDB). This error can be caused by many factors; for more
information, see SQL Server Books Online.
The statement has been terminated.". Possible failure reasons: Problems with
the query, "ResultSet" property not set correctly, parameters not set
correctly, or connection not established correctly.
===================================================
Executing the query "ALTER INDEX [AllUserData_PK] ON [dbo].[AllUserData]
REORGANIZE WITH ( LOB_COMPACTION = OFF )
" failed with the following error: "SQL Server detected a logical
consistency-based I/O error: incorrect pageid (expected 1:2653; actual
47686:707280961). It occurred during a read of page (1:2653) in database ID
13 at offset 0x000000014ba000 in file 'C:\\Program Files\\Microsoft SQL
Server\\MSSQL.1\\MSSQL\\DATA\\SP_IntranetMySites_WebApp.mdf'. Additional
messages in the SQL Server error log or system event log may provide more
detail. This is a severe error condition that threatens database integrity
and must be corrected immediately. Complete a full database consistency check
(DBCC CHECKDB). This error can be caused by many factors; for more
information, see SQL Server Books Online.". Possible failure reasons:
Problems with the query, "ResultSet" property not set correctly, parameters
not set correctly, or connection not established correctly.
====================================================
Executing the query "DBCC CHECKDB WITH NO_INFOMSGS
" failed with the following error: "An internal error occurred in DBCC that
prevented further processing. Contact Customer Support Services.
Check terminated. A failure was detected while collecting facts. Possibly
tempdb out of space or a system table is inconsistent. Check previous
errors.". Possible failure reasons: Problems with the query, "ResultSet"
property not set correctly, parameters not set correctly, or connection not
established correctly.
===================================================Hi
It seems that there is some corruption in the database. Have you had any
hardware issues? Is there any other information in the SQL Server log or
Windows Event Logs?
You could try dropping the index and running DBCC CHECKDB again. If it works
then re-create the index and run it again. If you don't find out what caused
this then it could happen again.
John
"MKBOBBA" wrote:
> We have SQL Server 2005 set up and we are seeing the following error messages
> in our logs from Daily maintenance Plan.
> Please comment on the severity of these errors.
> Thanks,
> mkb
> ================================================> Executing the query "ALTER INDEX [AllUserData_PK] ON [dbo].[AllUserData]
> REBUILD WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF,
> ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, SORT_IN_TEMPDB = OFF, ONLINE => OFF )
> " failed with the following error: "SQL Server detected a logical
> consistency-based I/O error: incorrect pageid (expected 1:2676; actual
> 14616:395852048). It occurred during a read of page (1:2676) in database ID
> 13 at offset 0x000000014e8000 in file 'C:\\Program Files\\Microsoft SQL
> Server\\MSSQL.1\\MSSQL\\DATA\\SP_IntranetMySites_WebApp.mdf'. Additional
> messages in the SQL Server error log or system event log may provide more
> detail. This is a severe error condition that threatens database integrity
> and must be corrected immediately. Complete a full database consistency check
> (DBCC CHECKDB). This error can be caused by many factors; for more
> information, see SQL Server Books Online.
> The statement has been terminated.". Possible failure reasons: Problems with
> the query, "ResultSet" property not set correctly, parameters not set
> correctly, or connection not established correctly.
>
> ===================================================> Executing the query "ALTER INDEX [AllUserData_PK] ON [dbo].[AllUserData]
> REORGANIZE WITH ( LOB_COMPACTION = OFF )
> " failed with the following error: "SQL Server detected a logical
> consistency-based I/O error: incorrect pageid (expected 1:2653; actual
> 47686:707280961). It occurred during a read of page (1:2653) in database ID
> 13 at offset 0x000000014ba000 in file 'C:\\Program Files\\Microsoft SQL
> Server\\MSSQL.1\\MSSQL\\DATA\\SP_IntranetMySites_WebApp.mdf'. Additional
> messages in the SQL Server error log or system event log may provide more
> detail. This is a severe error condition that threatens database integrity
> and must be corrected immediately. Complete a full database consistency check
> (DBCC CHECKDB). This error can be caused by many factors; for more
> information, see SQL Server Books Online.". Possible failure reasons:
> Problems with the query, "ResultSet" property not set correctly, parameters
> not set correctly, or connection not established correctly.
> ====================================================> Executing the query "DBCC CHECKDB WITH NO_INFOMSGS
> " failed with the following error: "An internal error occurred in DBCC that
> prevented further processing. Contact Customer Support Services.
> Check terminated. A failure was detected while collecting facts. Possibly
> tempdb out of space or a system table is inconsistent. Check previous
> errors.". Possible failure reasons: Problems with the query, "ResultSet"
> property not set correctly, parameters not set correctly, or connection not
> established correctly.
> ===================================================>|||And I forgot to add.. Make sure you have a good backup before doing this! You
could try restoring a backup on a different machine to try your tests out
before working on live (providing you have the hardware!)
John
"MKBOBBA" wrote:
> We have SQL Server 2005 set up and we are seeing the following error messages
> in our logs from Daily maintenance Plan.
> Please comment on the severity of these errors.
> Thanks,
> mkb
> ================================================> Executing the query "ALTER INDEX [AllUserData_PK] ON [dbo].[AllUserData]
> REBUILD WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF,
> ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, SORT_IN_TEMPDB = OFF, ONLINE => OFF )
> " failed with the following error: "SQL Server detected a logical
> consistency-based I/O error: incorrect pageid (expected 1:2676; actual
> 14616:395852048). It occurred during a read of page (1:2676) in database ID
> 13 at offset 0x000000014e8000 in file 'C:\\Program Files\\Microsoft SQL
> Server\\MSSQL.1\\MSSQL\\DATA\\SP_IntranetMySites_WebApp.mdf'. Additional
> messages in the SQL Server error log or system event log may provide more
> detail. This is a severe error condition that threatens database integrity
> and must be corrected immediately. Complete a full database consistency check
> (DBCC CHECKDB). This error can be caused by many factors; for more
> information, see SQL Server Books Online.
> The statement has been terminated.". Possible failure reasons: Problems with
> the query, "ResultSet" property not set correctly, parameters not set
> correctly, or connection not established correctly.
>
> ===================================================> Executing the query "ALTER INDEX [AllUserData_PK] ON [dbo].[AllUserData]
> REORGANIZE WITH ( LOB_COMPACTION = OFF )
> " failed with the following error: "SQL Server detected a logical
> consistency-based I/O error: incorrect pageid (expected 1:2653; actual
> 47686:707280961). It occurred during a read of page (1:2653) in database ID
> 13 at offset 0x000000014ba000 in file 'C:\\Program Files\\Microsoft SQL
> Server\\MSSQL.1\\MSSQL\\DATA\\SP_IntranetMySites_WebApp.mdf'. Additional
> messages in the SQL Server error log or system event log may provide more
> detail. This is a severe error condition that threatens database integrity
> and must be corrected immediately. Complete a full database consistency check
> (DBCC CHECKDB). This error can be caused by many factors; for more
> information, see SQL Server Books Online.". Possible failure reasons:
> Problems with the query, "ResultSet" property not set correctly, parameters
> not set correctly, or connection not established correctly.
> ====================================================> Executing the query "DBCC CHECKDB WITH NO_INFOMSGS
> " failed with the following error: "An internal error occurred in DBCC that
> prevented further processing. Contact Customer Support Services.
> Check terminated. A failure was detected while collecting facts. Possibly
> tempdb out of space or a system table is inconsistent. Check previous
> errors.". Possible failure reasons: Problems with the query, "ResultSet"
> property not set correctly, parameters not set correctly, or connection not
> established correctly.
> ===================================================>

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.
> >>
> >>
> >>
>
>