Cannot Re-attach SQL Server

I was attempting to use the Copy Database Wizard, and halfway through
the connection was broken. The database was unattached by the wizard,
and now when I try and reattach it I keep getting Error 5105 about the
path to the ndf file being incorrect. It is correct, I even pasted it
into Explorer but SQL just cannot find it. Any ideas?
Thanks.Hi
You do not say how you are attaching this, but try using sp_attach_db in
Query analyser if you are using Enterprise Manager to do this.
John
"cbsd.james" wrote:

> I was attempting to use the Copy Database Wizard, and halfway through
> the connection was broken. The database was unattached by the wizard,
> and now when I try and reattach it I keep getting Error 5105 about the
> path to the ndf file being incorrect. It is correct, I even pasted it
> into Explorer but SQL just cannot find it. Any ideas?
> Thanks.
>

Cannot Re-attach SQL Server

I was attempting to use the Copy Database Wizard, and halfway through
the connection was broken. The database was unattached by the wizard,
and now when I try and reattach it I keep getting Error 5105 about the
path to the ndf file being incorrect. It is correct, I even pasted it
into Explorer but SQL just cannot find it. Any ideas?
Thanks.Hi
You do not say how you are attaching this, but try using sp_attach_db in
Query analyser if you are using Enterprise Manager to do this.
John
"cbsd.james" wrote:
> I was attempting to use the Copy Database Wizard, and halfway through
> the connection was broken. The database was unattached by the wizard,
> and now when I try and reattach it I keep getting Error 5105 about the
> path to the ndf file being incorrect. It is correct, I even pasted it
> into Explorer but SQL just cannot find it. Any ideas?
> Thanks.
>sql

Cannot limit results with ReportViewer

Hello,
I have been attempting to set up a report using the ReportViewer
control in VS2005. The report graphs the TOP X number of records based
on certain criteria. Naturally, I modified the report with a filter
for the TOP N results. This works, however, in the case of ties on the
last entry, all tied instances will get graphed. In my case, this may
be alot of entries causing the bar graph image to display unreadable
data since there are too many result to graph.
So, I attempted the following with no success since the server is SQL
2000 and not SQL 2005:
- Using the TOP keyword in the select query does not work with a
parameter (ie SELECT TOP @.rowcount FROM...) since I am using SQL 2000.
- I cannot use a stored procedure and use the "SET ROWCOUNT" command
with the select query.
- I cannot use the LIMIT keyword in SQL 2000.
Can anyone come up with a solution, other than upgrading to SQL 2005?
Thanks in advance,
Andrewcheck this one......
SELECT w1.CATEGORYID, w1.UNITSINSTOCK,COUNT(*) As Rank
FROM
(SELECT CATEGORYID, UNITSINSTOCK
FROM PRODUCTS
GROUP BY CATEGORYID, UNITSINSTOCK ) AS w1
INNER JOIN
(SELECT CATEGORYID, UNITSINSTOCK
FROM PRODUCTS
GROUP BY CATEGORYID, UNITSINSTOCK ) AS w2
ON w1.CATEGORYID = w2.CATEGORYID
AND w1.UNITSINSTOCK <= w2.UNITSINSTOCK
GROUP BY w1.CATEGORYID, w1.UNITSINSTOCK
HAVING COUNT(*) <=@.parameter
ORDER BY w1.CATEGORYID,w1.UNITSINSTOCK DESC
Regards
Dinesh
therealbigcoops@.gmail.com wrote:
> Hello,
> I have been attempting to set up a report using the ReportViewer
> control in VS2005. The report graphs the TOP X number of records based
> on certain criteria. Naturally, I modified the report with a filter
> for the TOP N results. This works, however, in the case of ties on the
> last entry, all tied instances will get graphed. In my case, this may
> be alot of entries causing the bar graph image to display unreadable
> data since there are too many result to graph.
> So, I attempted the following with no success since the server is SQL
> 2000 and not SQL 2005:
> - Using the TOP keyword in the select query does not work with a
> parameter (ie SELECT TOP @.rowcount FROM...) since I am using SQL 2000.
> - I cannot use a stored procedure and use the "SET ROWCOUNT" command
> with the select query.
> - I cannot use the LIMIT keyword in SQL 2000.
> Can anyone come up with a solution, other than upgrading to SQL 2005?
> Thanks in advance,
> Andrew

Cannot install SQL Server Express

I'm attempting an new installation on an Athlon 64 3300 system running XP Pro using the default install options. Get the message "SQL Server service failed to start..." and the installer starts Rolling Back the installation leaving me with a bunch of log files that mean nothing to me.

I'm not savvy enough to solve this one. Can anyone help?

Microsoft SQL Server 2005 9.00.2047.00
==============================
OS Version : Microsoft Windows XP Professional Service Pack 2 (Build 2600)
Time : Thu Oct 19 20:09:10 2006
Machine : SR1365CL
Product : Microsoft SQL Server Setup Support Files (English)
Product Version : 9.00.2047.00
Install : Successful
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0001_SR1365CL_SQLSupport_1.log
--
Machine : SR1365CL
Product : Microsoft SQL Server Native Client
Product Version : 9.00.2047.00
Install : Successful
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0001_SR1365CL_SQLNCLI_1.log
--
Machine : SR1365CL
Product : Microsoft SQL Server VSS Writer
Product Version : 9.00.2047.00
Install : Successful
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0001_SR1365CL_SqlWriter_1.log
--
Machine : SR1365CL
Product : MSXML 6.0 Parser
Product Version : 6.00.3883.8
Install : Successful
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0001_SR1365CL_MSXML6_1.log
--
Machine : SR1365CL
Product : SQL Server Database Services
Error : The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually."
--
Machine : SR1365CL
Product : Microsoft SQL Server 2005 Express Edition
Product Version : 9.1.2047.00
Install : Failed
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0001_SR1365CL_SQL.log
Last Action : InstallFinalize
Error String : The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually."
The error is (1067) The process terminated unexpectedly.
Error Number : 29503
--

What does the event log tell you ? There should be an entry about the starting service. There might be permission or service account problem.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de
|||

My ERRORLOG shows this error:

2006-10-19 20:14:59.51 spid5s Starting up database 'mssqlsystemresource'.
2006-10-19 20:14:59.51 spid5s The resource database build version is 9.00.2047. This is an informational message only. No user action is required.
2006-10-19 20:14:59.65 spid5s Error: 15209, Severity: 16, State: 1.
2006-10-19 20:14:59.65 spid5s An error occurred during encryption.

This KB article gave me the information necessary to complete the install although the .\Protect folder did not yet exist.

http://support.microsoft.com/default.aspx?scid=kb%3Ben-us%3B920114

Problem solved. Thanks for the nudge in the right direction, Jens.

John

|||

I also found this thread VERY helpful, and I would just like to add two comments:

1) This applies to intel 32bit processors as well.

2) When you attempt to check the security tab for folder C:\Documents and Settings\NetworkService\Application Data\Microsoft\Protect, you may notice that there is no security tab. In that case you are using "simple file sharing", which will need to be disabled. Disable by: control panel-> folder options->view and uncheck "use simple file sharing (Recommended)" at bottom. Then, follow KB920114.

Jim

|||I am getting exactly the same error as above. I followed the directions in KB920114, but the Network Service already had full authority. So there is nothing for me to change. Needless to say, it doesn't work. Any other ideas?

Cannot install SQL Server Express

I'm attempting an new installation on an Athlon 64 3300 system running XP Pro using the default install options. Get the message "SQL Server service failed to start..." and the installer starts Rolling Back the installation leaving me with a bunch of log files that mean nothing to me.

I'm not savvy enough to solve this one. Can anyone help?

Microsoft SQL Server 2005 9.00.2047.00
==============================
OS Version : Microsoft Windows XP Professional Service Pack 2 (Build 2600)
Time : Thu Oct 19 20:09:10 2006
Machine : SR1365CL
Product : Microsoft SQL Server Setup Support Files (English)
Product Version : 9.00.2047.00
Install : Successful
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0001_SR1365CL_SQLSupport_1.log
--
Machine : SR1365CL
Product : Microsoft SQL Server Native Client
Product Version : 9.00.2047.00
Install : Successful
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0001_SR1365CL_SQLNCLI_1.log
--
Machine : SR1365CL
Product : Microsoft SQL Server VSS Writer
Product Version : 9.00.2047.00
Install : Successful
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0001_SR1365CL_SqlWriter_1.log
--
Machine : SR1365CL
Product : MSXML 6.0 Parser
Product Version : 6.00.3883.8
Install : Successful
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0001_SR1365CL_MSXML6_1.log
--
Machine : SR1365CL
Product : SQL Server Database Services
Error : The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually."
--
Machine : SR1365CL
Product : Microsoft SQL Server 2005 Express Edition
Product Version : 9.1.2047.00
Install : Failed
Log File : C:\Program Files\Microsoft SQL Server\90\Setup Bootstrap\LOG\Files\SQLSetup0001_SR1365CL_SQL.log
Last Action : InstallFinalize
Error String : The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, "How to: View SQL Server 2005 Setup Log Files" and "Starting SQL Server Manually."
The error is (1067) The process terminated unexpectedly.
Error Number : 29503
--

What does the event log tell you ? There should be an entry about the starting service. There might be permission or service account problem.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de|||

My ERRORLOG shows this error:

2006-10-19 20:14:59.51 spid5s Starting up database 'mssqlsystemresource'.
2006-10-19 20:14:59.51 spid5s The resource database build version is 9.00.2047. This is an informational message only. No user action is required.
2006-10-19 20:14:59.65 spid5s Error: 15209, Severity: 16, State: 1.
2006-10-19 20:14:59.65 spid5s An error occurred during encryption.

This KB article gave me the information necessary to complete the install although the .\Protect folder did not yet exist.

http://support.microsoft.com/default.aspx?scid=kb%3Ben-us%3B920114

Problem solved. Thanks for the nudge in the right direction, Jens.

John

|||

I also found this thread VERY helpful, and I would just like to add two comments:

1) This applies to intel 32bit processors as well.

2) When you attempt to check the security tab for folder C:\Documents and Settings\NetworkService\Application Data\Microsoft\Protect, you may notice that there is no security tab. In that case you are using "simple file sharing", which will need to be disabled. Disable by: control panel-> folder options->view and uncheck "use simple file sharing (Recommended)" at bottom. Then, follow KB920114.

Jim

|||I am getting exactly the same error as above. I followed the directions in KB920114, but the Network Service already had full authority. So there is nothing for me to change. Needless to say, it doesn't work. Any other ideas?

Cannot insert into partitioned view

I'm attempting to insert data into a partitioned view, the member tables and
view adhere to all the requirements stated in BOL. However on Insert I get
an error stating:
Server: Msg 550, Level 16, State 1, Line 1
The attempted insert or update failed because the target view either
specifies WITH CHECK OPTION or spans a view that specifies WITH CHECK OPTION
and one or more rows resulting from the operation did not qualify under the
CHECK OPTION constraint.
The statement has been terminated.
I have verified that the partitioned view does not have WITH CHECK OPTION
set, why would I receive this error?
Possible that you have data that is outside the view's partition
specification? Try insert in batches, smaller and smaller when you hit the
failing batch, to locate the records and check on them.
"mkelly" <mkelly@.discussions.microsoft.com> wrote in message
news:149486BA-772F-425B-9D5B-EEEC59DE95E4@.microsoft.com...
> I'm attempting to insert data into a partitioned view, the member tables
and
> view adhere to all the requirements stated in BOL. However on Insert I
get
> an error stating:
> Server: Msg 550, Level 16, State 1, Line 1
> The attempted insert or update failed because the target view either
> specifies WITH CHECK OPTION or spans a view that specifies WITH CHECK
OPTION
> and one or more rows resulting from the operation did not qualify under
the
> CHECK OPTION constraint.
> The statement has been terminated.
> I have verified that the partitioned view does not have WITH CHECK OPTION
> set, why would I receive this error?
>
|||That was it, I was missing an additional piece of date limiting criteria.
Thanks for pointing that out!

Cannot insert into partitioned view

I'm attempting to insert data into a partitioned view, the member tables and
view adhere to all the requirements stated in BOL. However on Insert I get
an error stating:
Server: Msg 550, Level 16, State 1, Line 1
The attempted insert or update failed because the target view either
specifies WITH CHECK OPTION or spans a view that specifies WITH CHECK OPTION
and one or more rows resulting from the operation did not qualify under the
CHECK OPTION constraint.
The statement has been terminated.
I have verified that the partitioned view does not have WITH CHECK OPTION
set, why would I receive this error?Possible that you have data that is outside the view's partition
specification? Try insert in batches, smaller and smaller when you hit the
failing batch, to locate the records and check on them.
"mkelly" <mkelly@.discussions.microsoft.com> wrote in message
news:149486BA-772F-425B-9D5B-EEEC59DE95E4@.microsoft.com...
> I'm attempting to insert data into a partitioned view, the member tables
and
> view adhere to all the requirements stated in BOL. However on Insert I
get
> an error stating:
> Server: Msg 550, Level 16, State 1, Line 1
> The attempted insert or update failed because the target view either
> specifies WITH CHECK OPTION or spans a view that specifies WITH CHECK
OPTION
> and one or more rows resulting from the operation did not qualify under
the
> CHECK OPTION constraint.
> The statement has been terminated.
> I have verified that the partitioned view does not have WITH CHECK OPTION
> set, why would I receive this error?
>|||That was it, I was missing an additional piece of date limiting criteria.
Thanks for pointing that out!

Cannot insert into partitioned view

I'm attempting to insert data into a partitioned view, the member tables and
view adhere to all the requirements stated in BOL. However on Insert I get
an error stating:
Server: Msg 550, Level 16, State 1, Line 1
The attempted insert or update failed because the target view either
specifies WITH CHECK OPTION or spans a view that specifies WITH CHECK OPTION
and one or more rows resulting from the operation did not qualify under the
CHECK OPTION constraint.
The statement has been terminated.
I have verified that the partitioned view does not have WITH CHECK OPTION
set, why would I receive this error?Possible that you have data that is outside the view's partition
specification? Try insert in batches, smaller and smaller when you hit the
failing batch, to locate the records and check on them.
"mkelly" <mkelly@.discussions.microsoft.com> wrote in message
news:149486BA-772F-425B-9D5B-EEEC59DE95E4@.microsoft.com...
> I'm attempting to insert data into a partitioned view, the member tables
and
> view adhere to all the requirements stated in BOL. However on Insert I
get
> an error stating:
> Server: Msg 550, Level 16, State 1, Line 1
> The attempted insert or update failed because the target view either
> specifies WITH CHECK OPTION or spans a view that specifies WITH CHECK
OPTION
> and one or more rows resulting from the operation did not qualify under
the
> CHECK OPTION constraint.
> The statement has been terminated.
> I have verified that the partitioned view does not have WITH CHECK OPTION
> set, why would I receive this error?
>|||That was it, I was missing an additional piece of date limiting criteria.
Thanks for pointing that out!

Cannot get SQL 2005 RS up and running

I am attempting a migration to RS 2005. I restored the ReportServer and tempdb databases over to the new server. The config manager says the ReportService service is running. When I try to view the reports in a browser I get a report server is not responding error.

Thanks Richard

What error do you get when you go to http://localhost/reportserver?

|||

The report server has encountered a configuration error. See the report server log files for more information. (rsServerConfigurationError)

For more information about this error navigate to the report server on the local server machine, or enable remote errors|||What is the error you are getting when you try to change it?|||

Make sure ASP.NET is registed properly. Run aspnet_regiis -i -enable.

If the problem persists, can you enable remote errors to reveal more error message?

|||I posted to you in the other thread...ASPNET_REGIIS.exe is not recognized.|||aspnet_regiis.exe is under %SystemDrive%\WINDOWS\Microsoft.NET\Framework\v2.0.50727. By "not recognized" did you mean you can't find it? If so please check if ASP.NET is installed, and reinstall .Net framework if necessary.|||

It would not recognize it. I reinstalled and now I get another error. Is something else corrupt should I reinstall everything (ack!)?

Error:

The report server cannot open a connection to the report server database. A connection to the database is required for all requests and processing. (rsReportServerDatabaseUnavailable) Get Online Help

Cannot open database "ReportsServer" requested by the login. The login failed. Login failed for user 'ComputerName\ASPNET'.

|||

I still don't understand what you mean by "would not recognize" the command. Is it not found? Did you get an error when you ran it? Can you paste the command you ran and the error message?

For the new error, go to configuration tool and redo the "Database connection" panel.

|||

When executing the .exe it was throwing an error that said it was not recognized. I ran it from the command line within the folder it resides in. I used the -enable this time and it worked, but I had to drill into the folder, not just use the full line command. I am not sure what was up with that. I already did the reconfig and I get the new error...

Error:

The feature: "Using other editions of SQL Server for report data sources and/or the report server database" is not supported in this edition of Reporting Services. (rsOperationNotSupported) Get Online Help

|||

The report server edition needs to be compatible with the SQL server edition. See this link for a compatibility matrix http://blogs.msdn.com/bimusings/archive/2006/03/03/543088.aspx.

|||

Perhaps we can chat offline<sending email>, as I got the dl's off productsweb.

|||

I have no idea what RS is, but I know it's preventing me from installing CRM 3.0.

When I attempt to load http:\\localserver\reportserver I get the following error.

Reporting Services Error
--
The Report Server Windows service 'ReportServer' is not running. The service must be running to use Report Server. (rsReportServerServiceUnavailable) Get Online Help

--
SQL Server Reporting Services

No clue what I'm doing and any help would be appreciated it!