Error Reporting: Installation on SQL 2005 on x64

I installed SQL 2005 on x64 machine and notice that my Y: drive (data drive) has these additional directories (shown below). I know those files are components of “Microsoft Application Error Reporting”. They are shared among multiple applications, hence them being in “common files”. After disabling the error reporting using Microsoft SQL Server 2005->Configuration Tools->Error and Usage Reporting, can I get rid of those directories or specify which directory that it should go to? Has anyone seen this before? Thanks.

The following had been installed to the drive that we did not specify in the installation of SQL 2005. Is there any way to redirect these file back the window directory?

Volume in drive Y is New Volume
Volume Serial Number is 882B-9F43
NULL
Directory of y:\program files\common files\microsoft shared\dw
NULL
06/01/2006 11:26 AM <DIR> .
06/01/2006 11:26 AM <DIR> ..
06/01/2006 11:26 AM <DIR> 1028
06/01/2006 11:26 AM <DIR> 1031
06/01/2006 11:26 AM <DIR> 1033
06/01/2006 11:26 AM <DIR> 1036
06/01/2006 11:26 AM <DIR> 1040
06/01/2006 11:26 AM <DIR> 1041
06/01/2006 11:26 AM <DIR> 1042
06/01/2006 11:26 AM <DIR> 2052
06/01/2006 11:26 AM <DIR> 3082
04/25/2005 01:44 PM 1,030,336 DW20.EXE
04/25/2005 01:44 PM 496,328 DWDCW20.DLL
04/25/2005 01:44 PM 489,672 DWTRIG20.EXE
3 File(s) 2,016,336 bytes
11 Dir(s) 85,983,068,160 bytes free
NULL

I'm pretty sure this is a setup bug where some components are not defaulting to the system drive, or sql drive, but to the drive where you launched setup from. I'm guessing you launched setup from the Y: drive. Don't know if there's a simple way to move them, but you can always uninstall, then reinstall, but this time launch setup from the drive you want these components installed on.sql

Error reattaching database following it being marked as Suspect

I am using SQL Server 2000 with SP3 (product version
8.00.760).
A database in this installation was marked as 'SUSPECT'
whilst I was excuting a DELETE SQL statement using the SQL
Query Analyzer tool.
Using Enterprise Manager I was subsequently unable to
access the database, and so thought the easiest option
would be to restore it from a BAK file that had been
created a few hours earlier as data modiefied in the time
between was not vital. I detached the database before
attemping this, and then discovered the only backup
available is a differential one and it will not restore.
Therefore, I was hoping to reattached the database and
reset the 'SUSPECT' flag, so I could at least access the
data again. However, when I attempt to attach the MDF
file (the associated LDF file is in the same location) I
get the following errors:
Error 9001: The log for database 'MY_DATABASE' is
not available.
and:
Attaching the database has failed.
I have also tried attaching the database using the
sp_attach_single_file_db stored procdure:
EXEC sp_attach_single_file_db @.dbname
= 'MY_DATABASE',
@.physname = 'C:\Program Files\Microsoft SQL
Server\MSSQL\Data\MY_DATABASE_Data.MDF'
which return the following error message:
Server: Msg 9001, Level 21, State 4, Line 1
The log for database 'ORBIT_REPORTS' is not
available.
And also tried using the sp_attach_db stored procedure:
EXEC sp_attach_db @.dbname = 'MY_DATABASE',
@.filename1 = 'C:\Program Files\Microsoft SQL
Server\MSSQL\Data\MY_DATABASE_Data.MDF',
@.filename2 = 'C:\Program Files\Microsoft SQL
Server\MSSQL\Data\MY_DATABASE_Log.LDF'
but still get the following error:
Server: Msg 9001, Level 21, State 1, Line 1
The log for database 'ORBIT_REPORTS' is not
available.
Both files _do_ exist in the directory:
'C:\Program Files\Microsoft SQL Server\MSSQL\Data\
Can anyone help?If you have a diff backup you should have a copy of a full backup (since
diff backup wont start until it knows a full backup exists).
Is the database called Orbits_reports?
If you have SQL 2K...right click database -all tasks and attach DB...does
the files come up as red? Have you got the correct permissions for a file?
Have you renamed a file?
Regards
Z
"Ian Munday" <ian.munday@.uk.pwc.com> wrote in message
news:078201c37c64$18bdc690$a001280a@.phx.gbl...
> I am using SQL Server 2000 with SP3 (product version
> 8.00.760).
> A database in this installation was marked as 'SUSPECT'
> whilst I was excuting a DELETE SQL statement using the SQL
> Query Analyzer tool.
> Using Enterprise Manager I was subsequently unable to
> access the database, and so thought the easiest option
> would be to restore it from a BAK file that had been
> created a few hours earlier as data modiefied in the time
> between was not vital. I detached the database before
> attemping this, and then discovered the only backup
> available is a differential one and it will not restore.
> Therefore, I was hoping to reattached the database and
> reset the 'SUSPECT' flag, so I could at least access the
> data again. However, when I attempt to attach the MDF
> file (the associated LDF file is in the same location) I
> get the following errors:
> Error 9001: The log for database 'MY_DATABASE' is
> not available.
> and:
> Attaching the database has failed.
>
> I have also tried attaching the database using the
> sp_attach_single_file_db stored procdure:
> EXEC sp_attach_single_file_db @.dbname
> = 'MY_DATABASE',
> @.physname = 'C:\Program Files\Microsoft SQL
> Server\MSSQL\Data\MY_DATABASE_Data.MDF'
> which return the following error message:
> Server: Msg 9001, Level 21, State 4, Line 1
> The log for database 'ORBIT_REPORTS' is not
> available.
> And also tried using the sp_attach_db stored procedure:
> EXEC sp_attach_db @.dbname = 'MY_DATABASE',
> @.filename1 = 'C:\Program Files\Microsoft SQL
> Server\MSSQL\Data\MY_DATABASE_Data.MDF',
> @.filename2 = 'C:\Program Files\Microsoft SQL
> Server\MSSQL\Data\MY_DATABASE_Log.LDF'
> but still get the following error:
> Server: Msg 9001, Level 21, State 1, Line 1
> The log for database 'ORBIT_REPORTS' is not
> available.
> Both files _do_ exist in the directory:
> 'C:\Program Files\Microsoft SQL Server\MSSQL\Data\
>
> Can anyone help?

error pending file

I've uninstall my previous sql2000 developer edition with leave some dll file undeleted.

once I tried to reinstall the sqlserver, the installation setup stop the process with message: A previous installation created pending file operations on the installation machine.
you must restart the computer before running setup.

I fail in continueing setup although i've restart the pc.

What should i do to handle this?

Regards,

BHT

Hhh.... please someone help me...

I don't want to reinstall the O/S as previously i've done. headache and waisting my days.

Regards,

BHT

http://support.microsoft.com/default.aspx?scid=kb%3ben-us%3b312995&Product=sql

Jens K. Suessmeyer.

http://www.sqlserver2005.de

|||

Hi Jens,

At last I saved. Thank you for your help.

Trully it is very suffer when become a begginer. (

Regards,

BHT

Error opening reports on web browser

Hi All

i am very new to using sql reporting services. After installation of reporting services and configuration i get this error on the browser.

Can anyone highlight the problem in the configuration?

my system is configured as

Windows 2003 SP1 server

MSSQL 2005 sp1

Server Error in '/Reports' Application.
--

The current identity (NT AUTHORITY\NETWORK SERVICE) does not have write access to 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files'.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Web.HttpException: The current identity (NT AUTHORITY\NETWORK SERVICE) does not have write access to 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files'.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[HttpException (0x80004005): The current identity (NT AUTHORITY\NETWORK SERVICE) does not have write access to 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files'.]
System.Web.HttpRuntime.SetUpCodegenDirectory(CompilationSection compilationSection) +3474107
System.Web.HttpRuntime.HostingInit(HostingEnvironmentFlags hostingFlags) +226

[HttpException (0x80004005): The current identity (NT AUTHORITY\NETWORK SERVICE) does not have write access to 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET Files'.]
System.Web.HttpRuntime.FirstRequestInit(HttpContext context) +3426839
System.Web.HttpRuntime.EnsureFirstRequestInit(HttpContext context) +88
System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr) +149

--
Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.42

thanks

ga

Hello ga,

I think what you need to do is to install your version of ASP.Net. You can acomplish this by following these steps.

Navigate to 'C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727' via a command prompt.
Type aspnet_regiis.exe -i and hit enter.
You may need to restart your server, but I can't remember for sure.

Hope this helps.

Jarret

|||

ga,

Did this fix your issue?

Jarret

|||

Jarret

Thanks a lot for the tip!

ga

|||

Glad I could help, can you mark this one as answered so others can view the solution?

Jarret

sql

Error on VB Sample which is delivered by installation.

Hi,

after i try to build the web application "Web Development - Data Entry Form" i get the following error message. I already change the variable username to system which is defined in Machine.Config.

The Error messega is like following:
SQL Server does not exist or access denied.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: SQL Server does not exist or access denied.

Thanks,The username you see in machine.config is most likely not the username you want to provide in the connection string in your application. You need to provide a valid username and password for your SQL server. If you did not install the db server yourself, you should be able to get valid login info from the person who installed it.

If the db server is local, you might be able to get away with the following for your connection string: "server=localhost;TrustedConnection=true;database=YOUR_DB"

Error on installing SP3a - Analysis Services components

While trying to complete the installation of
sql2kasp3.exe, my system gives me the follwoing error -
An error occurred during the move data process - 145
Window header is Severe.
Any ideas?
TIAI did some more looking around and found the Knowledge
Base had an article - 814462 - that addresses this issue.
It recommends fixing a registry key value under
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\OLAP
Server\Uninstall Info.
I do not have this entry in my registry.
What's up?
>--Original Message--
>While trying to complete the installation of
>sql2kasp3.exe, my system gives me the follwoing error -
>An error occurred during the move data process - 145
>Window header is Severe.
>Any ideas?
>TIA
>.
>|||Well, like it says to create the registry key value if it doesn't exist, you
can also create the Uninstall Info key itself...
--
Aaron Bertrand
SQL Server MVP
http://www.aspfaq.com/
"Rich Bergstedt" <split_hare@.sbcglobal.net> wrote in message
news:3d4d01c3e300$9ec8f0e0$a501280a@.phx.gbl...
> I did some more looking around and found the Knowledge
> Base had an article - 814462 - that addresses this issue.
> It recommends fixing a registry key value under
> HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\OLAP
> Server\Uninstall Info.
> I do not have this entry in my registry.
> What's up?
> >--Original Message--
> >While trying to complete the installation of
> >sql2kasp3.exe, my system gives me the follwoing error -
> >An error occurred during the move data process - 145
> >Window header is Severe.
> >
> >Any ideas?
> >
> >TIA
> >.
> >|||Stupid me.
I never installed Analysis Services when I installed the
eval package.
Now, I am working fine thanks.
>--Original Message--
>Well, like it says to create the registry key value if
it doesn't exist, you
>can also create the Uninstall Info key itself...
>--
>Aaron Bertrand
>SQL Server MVP
>http://www.aspfaq.com/
>
>
>"Rich Bergstedt" <split_hare@.sbcglobal.net> wrote in
message
>news:3d4d01c3e300$9ec8f0e0$a501280a@.phx.gbl...
>> I did some more looking around and found the Knowledge
>> Base had an article - 814462 - that addresses this
issue.
>> It recommends fixing a registry key value under
>> HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\OLAP
>> Server\Uninstall Info.
>> I do not have this entry in my registry.
>> What's up?
>> >--Original Message--
>> >While trying to complete the installation of
>> >sql2kasp3.exe, my system gives me the follwoing
error -
>> >An error occurred during the move data process - 145
>> >Window header is Severe.
>> >
>> >Any ideas?
>> >
>> >TIA
>> >.
>> >
>
>.
>

error number 1612

I'm doing a reinstall of SQL 2005 Standard Edition but I get this cryptic error message in the installation log file when it tries to install Integration Services or Notification Services. How do I resolve this? I've spent countless hours un-installing and re-installing the product.I looked at the log file and the message says 'The installation source for this product is not available. Verify that the source exists and that you can access it.' It seems to be a problem with the Windows Installer. How do I fix this?|||

Someone else posted a similar problem in the past day. If you're not using the original media to do the reinstall, please try that. If you are, please post again and I'll find a Setup developer and get specific advice from him about this problem.

Paul

|||Thanks for replying, Paul. I am using the original media for the reinstall and I have submitted a more detailed post of this problem in this section under the subject heading 'Cannot install SSIS or Notification services'.

Error message on installation

I have both developer and enterprise edition of SQL 2005. I originally installed developer then did an uninstall and tried to install enterprise. Everytime it starts to install I get the following error description:

EventType : sql90setup P1 : installtoolsaction.10 P2 : 0x643
P3 : sqls__installpackageaction__perform P4 : 0x643
P5 :packageengine_installpackageaction.cpp@.167
P6 :setup.exe@.2005.90.1399.0 P7 : none

It bombs when it tries to install the client tools.

The first time I installed it worked fine but trying to reinstall has caused this error to occur everytime.

I have tried full uninstall/reboots and nothing seems to help. It is coming from an unzipped ISO but I don't see why that would be a problem.

Any Suggestions ?

I had the same problem Installing SQL 2005. Well I don't remember if the error was that one. However I reinstall the OS (Windows 2003) and then after installing SP1 I installed SQL 2005 without any problem.

Hope this helps

Al

|||

Actually I think the problem is i did not have both ISO's unzipped in the same path since there are two.

Error message after SQL SP3a.

Hi there;
I was trying to apply SQL SP3a on my windows 2000 server
(SP4), but the installation failed and when I rebooted my
server the SQL agent failed to start and I get the
following error:
SQLAGENT.exe - Entry Point Not Found
the procedure entry point SFMapi0GetProfiles could not be
located in the dynamic link library SEMMAP.dll
Now, I tried replying SQLSP3a, but that keeps on failing
and I keep getting this error message.
Any Idea .. Please help me.
Thank you.What's the error you get when upgrading to SP3a?
--
Michiel Wories, SQL Server PM
This posting is provided "AS IS" with no warranties, and confers no rights.
--
"HUBCO" <anonymous@.discussions.microsoft.com> wrote in message
news:021601c395bd$4e33efd0$a101280a@.phx.gbl...
> Hi there;
> I was trying to apply SQL SP3a on my windows 2000 server
> (SP4), but the installation failed and when I rebooted my
> server the SQL agent failed to start and I get the
> following error:
> SQLAGENT.exe - Entry Point Not Found
> the procedure entry point SFMapi0GetProfiles could not be
> located in the dynamic link library SEMMAP.dll
> Now, I tried replying SQLSP3a, but that keeps on failing
> and I keep getting this error message.
> Any Idea .. Please help me.
> Thank you.

Error Message : Your SQL server installation is either corrupt or

Hi all,
I recently upgraded to visual studio 2005 professional from VB6 and sql
server 2000.
I got the latest updates and rebooted my machine and when it boots up i get
the following error message " Your SQL server installation is either corrupt
or has been tampered with (unknown package id). Please rerun setup.
OK - did that. The same error message reappeared. I have then removed visual
studio and sql server 2005 developer edition and sql server 2000 and then
rebooted mahcine. Same error message. Have reinstalled everything and the
same thing keeps reoccuring - DO i need to remove some registry entries or a
file of the machine so that this message dissapears.
TIA JustinOpen up your browser and visit the following site, it'll sove your issue
probably.
http://support.microsoft.com/default.aspx?scid=kb;en-us;290301
--
Ekrem Ã?nsoy
MCBDA, MCTS: SQL Server 2005, MCITP:DBA, MCSD.Net, MCSE, MCT
"Justin" <Justin@.discussions.microsoft.com> wrote in message
news:68E56E56-EFF1-4F14-B887-2EE0ED8F5B45@.microsoft.com...
> Hi all,
> I recently upgraded to visual studio 2005 professional from VB6 and sql
> server 2000.
> I got the latest updates and rebooted my machine and when it boots up i
> get
> the following error message " Your SQL server installation is either
> corrupt
> or has been tampered with (unknown package id). Please rerun setup.
> OK - did that. The same error message reappeared. I have then removed
> visual
> studio and sql server 2005 developer edition and sql server 2000 and then
> rebooted mahcine. Same error message. Have reinstalled everything and the
> same thing keeps reoccuring - DO i need to remove some registry entries or
> a
> file of the machine so that this message dissapears.
> TIA Justin