error handling flow: installed

Showing posts with label installed. Show all posts

Thursday, March 29, 2012

Error loading resource string in SP2

After I installed the SP2 and reboot the server, when I try to print the a
report, it keep pop up the error message say"Error loading resource string",
after I click many times, I got the printer properties window, many text in
the button are disappear, but I still could print it out.
Any idea?
ThanksMy guess is that you had the beta of SP2. If so then you need to clear out
then per Brian Welcker (MS): You need to clean out any older versions of the
controls from your C:\WINDOWS\Downloaded Program Files directory.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"msnews.microsoft.com" <huangxiaohua@.hotmail.com> wrote in message
news:uYZWGkxSFHA.2304@.tk2msftngp13.phx.gbl...
> After I installed the SP2 and reboot the server, when I try to print the a
> report, it keep pop up the error message say"Error loading resource
string",
> after I click many times, I got the printer properties window, many text
in
> the button are disappear, but I still could print it out.
> Any idea?
> Thanks
>

Error loading http://localhost/ReportServer

Hi!

I've installed the Report Server but when I try to go to http://localhost/ReportServer I get the following error:

Reporting Services Error

An internal error occurred on the report server. See the error log for more details. (rsInternalError)

And the log in the c:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles\SQLDUMPER_ERRORLOG.log file is this:

12/01/06 12:51:40, ERROR , SQLDUMPER_UNKNOWN_APP.EXE, AdjustTokenPrivileges () failed (00000514)
12/01/06 12:51:40, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Input parameters: 4 supplied
12/01/06 12:51:40, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ProcessID = 5344
12/01/06 12:51:40, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ThreadId = 0
12/01/06 12:51:40, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Flags = 0x0
12/01/06 12:51:40, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, MiniDumpFlags = 0x0
12/01/06 12:51:40, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, SqlInfoPtr = 0x0A0F2A04
12/01/06 12:51:40, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, DumpDir = <NULL>
12/01/06 12:51:40, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ExceptionRecordPtr = 0x00000000
12/01/06 12:51:40, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ContextPtr = 0x00000000
12/01/06 12:51:40, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ExtraFile = <NULL>
12/01/06 12:51:40, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, InstanceName = <NULL>
12/01/06 12:51:40, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ServiceName = <NULL>
12/01/06 12:51:40, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 11 not used
12/01/06 12:51:42, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 7 not used
12/01/06 12:51:42, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, MiniDump completed: C:\Archivos de programa\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles\SQLDmpr0058.mdmp
12/01/06 12:51:42, ACTION, aspnet_wp.exe, Watson Invoke: No

Does anybody have which could be the problem?

Thanks in advance! :)

Tomas,

I have the exact same problem. Did you ever solve your problem?

|||

Hi Chuck,

Yes, I solved this problem deleting from the web.config (folders ReportServer and/or ReportManaget) this:

xmlns=http://schemas.microsoft.com/.NetConfiguration/v2.0

If you have more problems (I had :) ) tell me and I'll try to help you: eltommy@.gmail.com

Good luck!!!

|||

Hi Tomás

I′m having the same problem

When I go to Initialization in Configure Reporting Server the error is :

There was an error while switching panels. The most likely cause is an error retrieving VMI properties. The exceptions details are:

An internal error occurred on the report server. See the error log for more details. (rsInternalError)

I didn′t found the line that you mentioned

Bellow is my web.config. I tried to erase :xmlns="urn:schemas-microsoft-com:asm.v1, but I haven′t success.

Thanks in advance

Consuelo

<?xml version="1.0" encoding="utf-8"?>
<configuration>
<configSections>
<section name="MicrosoftWebControls" type="System.Configuration.NameValueSectionHandler, System, Version=2.0.3600.0, Culture=neutral, PublicKeyToken=b77a5c561934e089, processorArchitecture=MSIL"/>
<section name="RStrace" type="Microsoft.ReportingServices.Diagnostics.RSTraceSectionHandler,Microsoft.ReportingServices.Diagnostics"/>
<section name="UIConfig" type="Microsoft.ReportingServices.UI.UIConfigSectionHandler,ReportingServicesWebUserInterface"/>
</configSections>
<system.net>
<defaultProxy enabled="false"/>
</system.net>
<system.web>
<pages validateRequest="false"/>
<compilation defaultLanguage="c#" debug="false"/>
<customErrors mode="Off"/>
<authentication mode="Windows"/>
<identity impersonate="true"/>
<trace enabled="false" requestLimit="10" pageOutput="false" traceMode="SortByTime" localOnly="true"/>
<sessionState mode="InProc" cookieless="false" timeout="20"/>
<globalization requestEncoding="utf-8" responseEncoding="utf-8"/>
<httpRuntime executionTimeout="9000"/>
<securityPolicy>
<trustLevel name="RosettaMgr" policyFile="rsmgrpolicy.config"/>
</securityPolicy>
<trust level="RosettaMgr" originUrl=""/>
<httpHandlers>
<add verb="*" path="Reserved.ReportViewerWebControl.axd" type="Microsoft.Reporting.WebForms.HttpHandler, ReportingServicesWebUserInterface, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91"/>
</httpHandlers>
</system.web>
<appSettings>
<add key="ReportViewerServerConnection" value="Microsoft.ReportingServices.UI.WebControlConnection, ReportingServicesWebUserInterface, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91"/>
<add key="ReportViewerTemporaryStorage" value="Microsoft.ReportingServices.UI.ReportViewerTemporaryStorage, ReportingServicesWebUserInterface, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91"/>
</appSettings>
<RStrace>
<add name="FileName" value="ReportServerWebApp_"/>
<add name="Prefix" value="tid, time"/>
<add name="TraceListeners" value="debugwindow, file"/>
<add name="TraceFileMode" value="unique"/>
<add name="Components" value="all"/>
</RStrace>
<system.diagnostics>
<switches>

<add name="DefaultTraceSwitch" value="3"/>
</switches>
</system.diagnostics>
<runtime>
<assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">
<dependentAssembly>
<assemblyIdentity name="Microsoft.ReportingServices.Interfaces" publicKeyToken="89845dcd8080cc91" culture="neutral"/>
<bindingRedirect oldVersion="8.0.242.0" newVersion="9.0.242.0"/>
</dependentAssembly>
</assemblyBinding>
</runtime>
</configuration>

|||

I found a solution

I was with SQL SERVER 2000 and 2005 installed. I desinstalled both and erased ReportServer and Reports folders in IIS, after that installed just SQL SERVER 2005. Now it′s ok.

|||I'm very happy about you Consuelo, this kind of issues are very stressing and in your case it was difficult to find the solution. Congratulations!!! :)sql

Error loading http://localhost/ReportServer

Hi!

I've installed the Report Server but when I try to go to http://localhost/ReportServer I get the following error:

Reporting Services Error

An internal error occurred on the report server. See the error log for more details. (rsInternalError)

And the log in the c:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles\SQLDUMPER_ERRORLOG.log file is this:

Does anybody have which could be the problem?

Thanks in advance! :)

Tomas,

I have the exact same problem. Did you ever solve your problem?

|||

Hi Chuck,

Yes, I solved this problem deleting from the web.config (folders ReportServer and/or ReportManaget) this:

xmlns=http://schemas.microsoft.com/.NetConfiguration/v2.0

If you have more problems (I had :) ) tell me and I'll try to help you: eltommy@.gmail.com

Good luck!!!

|||

Hi Tomás

I′m having the same problem

When I go to Initialization in Configure Reporting Server the error is :

There was an error while switching panels. The most likely cause is an error retrieving VMI properties. The exceptions details are:

An internal error occurred on the report server. See the error log for more details. (rsInternalError)

I didn′t found the line that you mentioned

Bellow is my web.config. I tried to erase :xmlns="urn:schemas-microsoft-com:asm.v1, but I haven′t success.

Thanks in advance

Consuelo

|||

I found a solution

I was with SQL SERVER 2000 and 2005 installed. I desinstalled both and erased ReportServer and Reports folders in IIS, after that installed just SQL SERVER 2005. Now it′s ok.

|||I'm very happy about you Consuelo, this kind of issues are very stressing and in your case it was difficult to find the solution. Congratulations!!! :)

Error installing SQL2005 SP2

I'm trying to install SP2 for SQL 2005 on Win 2003 sp1. Right now 2005 is installed as a named instance with a 2000 instance running on the same box.

I get this in the log files:

<Func Name='LaunchFunction'>
Function=Do_sqlPerfmon2
<Func Name='GetCAContext'>
<EndFunc Name='GetCAContext' Return='T' GetLastError='0'>
Doing Action: Do_sqlPerfmon2
PerfTime Start: Do_sqlPerfmon2 : Wed May 23 10:09:03 2007
<Func Name='Do_sqlPerfmon2'>
Error copying file(C:\Program Files\Microsoft SQL Server\90\DTS\Binn\DTSSVCPERF.INI) to file(C:\Program Files\Microsoft SQL Server\90\DTS\Binn\perf-DTSSVCPERF.INI). Error code 2
MSI (s) (5C!64) [10:09:03:671]: Transforming table Error.

MSI (s) (5C!64) [10:09:03:688]: Transforming table Error.

MSI (s) (5C!64) [10:09:03:688]: Note: 1: 2262 2: Error 3: -2147287038
Error Code: 1603
MSI (s) (5C!64) [10:09:03:723]: Transforming table Error.

MSI (s) (5C!64) [10:09:03:740]: Transforming table Error.

MSI (s) (5C!64) [10:09:03:740]: Note: 1: 2262 2: Error 3: -2147287038
MSI (s) (5C!64) [10:09:03:740]: Product: Microsoft SQL Server 2005 Integration Services -- Error 29528. The setup has encountered an unexpected error while Installing performance counters. The error is: The system cannot find the file specified.

Error 29528. The setup has encountered an unexpected error while Installing performance counters. The error is: The system cannot find the file specified.

<EndFunc Name='LaunchFunction' Return='1603' GetLastError='0'>
MSI (s) (5C:38) [10:09:03:757]: User policy value 'DisableRollback' is 0
MSI (s) (5C:38) [10:09:03:757]: Machine policy value 'DisableRollback' is 0
Action ended 10:09:03: InstallFinalize. Return value 3.

Can you please check to see if you have the appropriate permissions for the DTSSVCPERF.INI. The error seems to indicate there is a problem copying the file.

Error copying file(C:\Program Files\Microsoft SQL Server\90\DTS\Binn\DTSSVCPERF.INI) to file(C:\Program Files\Microsoft SQL Server\90\DTS\Binn\perf- DTSSVCPERF.INI). Error code 2

|||upon closer inspection I seem to be missing that file for some reason... how do I get it back?
|||Do you have any other server where in you can check to see if you can copy it from there?. I am not sure how the file went missing in the first place. If you dont have any other server then I would suggest that you perform a fresh installation of SQL 2005 on a test box and copy it to your production server.

Error installing SQL Server Management Studio Express

Yesterday I successfully installed Microsoft Visual Basic 2005 Express Edition which included SQL Server 2005 Express. Today I noticed I needed to download the Management Studio seperate download. I downloaded SQLServer2005_SSMSEE.msi and executed it and get the following error:

Error reading from file C:\...\SQLServer2005_SSMSEE.msi. Verify that the file exists and that you can access it..

Solved my own problem. Once I moved the msi to C:\ the installation worked. Apparently the path it was in was too long causing it to be unreadable. c:\xxxx\xxxx\SQLServer2005_SSMSEE.msiSQLServer2005_SSMSEE.msi.

Make sure you download the management tools for Express as well - it will make your life easier.

Buck Woody

Tuesday, March 27, 2012

Error installing SQL Server Management Studio Express

Error reading from file C:\...\SQLServer2005_SSMSEE.msi. Verify that the file exists and that you can access it..

Make sure you download the management tools for Express as well - it will make your life easier.

Buck Woody

sql

Error installing SQL Server 2005 Express Manager

Hello everyone,

My name is Pete and I'm new to this forum. Today, I installed Microsoft .Net Framework 2.0 and SQL Server 2005 Express June CTP. The following error pops up when I attempt to install SQL Server 2005 Express Manager:

"The installer encountered an unexpected error installing this package. This may indicate a problem with this package. The error code is 2755"

I've downloaded this package several times and reinstalled it with no such luck.

Did anyone experience this same problem when you tried to install SQL Server Express Manager?

Thank you for your answers

PeterHi Pete,

I suggest you try downloading the package again. We've had a couple of reports similar to this.

Dan|||Hello Dan,

I downloaded and installed this package several times with no such luck. Below is the acutal text of the error:

"The installer has encountered an unexpected error installing this package. This may indicate a problem with this package. The error code is 2755"

The following URL is the source of the package:

http://www.microsoft.com/downloads/details.aspx?FamilyId=C7A5CC62-EC54-4299-85FC-BA05C181ED55&displaylang=en

If you can point me in the right direction as to where I can get a 'working' copy of this package, then that would be great.

Thank you for your answers.

Peter|||
Hi Dan,

I was able to successfully install SQL Server 2005 Express Manager. The resolution was to copy to the ExpressManager.msi file to the local disk, such as C:, then install it. It didn't work when I tried to install it from a network and or UNC name.

Pete

Error installing SQL Server 2000

I think the problem is the Security Update KB824141 installed in Windows 2000 Server. T
ry to unistall it. (I found about this problem when I was searching in Google, but I di
d not test this solution. This solution was provided by http://examnotes.net/arch/

71/2003/10/959891).
If it fixes the problem, please, post it here.
(Sorry if my english is bad, I'm brasilian.)
God bless you.
-- PsyClown wrote: --
The installation is going fine untill it was finished copying files to the d
isk and starts setting up the server.
"First of the all the following error eccures: (ill try translating it from
danish to english)
The system dll file kernel32.dll was moved in the memory. The program will n
ot run correcly. The moving eccured, because the dll file C:\WINNT\system32\
MPR.dll used it in the adressarea, there otherwise was reversed for Windows
dll files.
The deliver of the dll file should be contacted to get a new dll file."
And then I get another error wich I can't remember now.
Well I've tried closing all unused programs before installing, but it doesn'
t help a bit and i've tried searching for something that could help me, with
out any results.
I hope someone can help me.It worked after I uninstalled the update.
thx for the help
*** Sent via Developersdex http://www.examnotes.net ***
Don't just participate in USENET...get rewarded for it!

Error installing SQL 2008 July CTP

During my first install.

- on a XP SP2 machine.

- no SQL 2000 or 2005 installed.

- Uninstalled SQL 2005 workstation components.

Error:

TITLE: Microsoft SQL Server 2008 Setup

Upgrade Failed due to the following Error.The error code is :-2147467259.Message:Unspecified error

For help, click: http://go.microsoft.com/fwlink?LinkID=20476&ProdName=Microsoft+SQL+Server&ProdVer=10.0.1049.14&EvtSrc=setup.rll&EvtID=29547&EvtType=sqlca%5csqlxmlca.cpp%40Do_sqlCopyXML%40Do_sqlCopyXML%40x80004005

From that link:

Details
ID: 29547
Source: setup.rll

We're sorry
There is no additional information about this issue in the Error and Event Log Messages or Knowledge Base databases at this time. You can use the links in the Support area to determine whether any additional information might be available elsewhere.

It appeared to be during:

workstation components, booksonline step:

--"upgrading Microsoft Report Server"

Image here:

Further on this:

-- My 1st install had all components selected: SQL DB Engine, SSIS, SSRS, SSAS, Workstation Components.

I did a second install with only DB engine selected - this completed successfully.

I then tried something install workstation components as standalone, and had what appears to be exactly the same error.

From the summary log:

--
Machine : WANDERER
Product : Workstation Components, Books Online and Development Tools
Error : Upgrade Failed due to the following Error.The error code is :-2147467259.Message:Unspecified error
--
Machine : WANDERER
Product : Microsoft SQL Server 2008 Tools
Product Version : 10.0.1049.14
Install : Failed
Log File : C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\LOG\Files\SQLSetup0005_WANDERER_Tools.log
Last Action : InstallFinalize
Error String : Upgrade Failed due to the following Error.The error code is :-2147467259.Message:Unspecified error
Error Number : 29547
--

And from the LOG install, the following ERROR or FAIL message:

--1:

<Func Name='GetXMLAttributeValue'>
Error to find XML node /configuration/system.web/compilation
<EndFunc Name='GetXMLAttributeValue' Return='2' GetLastError='0'>
Failed to get ModuleID_RS_Server when getting the ASP Temp directory.

--2:

<Func Name='Do_sqlCopyXML'>
_LoadXMLFile(C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\devenv.exe.config).IID_IXMLDOMDocument->load returned

2147500037.
Error Code: -2147467259
Windows Error Text: Unspecified error
Source File Name: sqlca\sqlxmlca.cpp
Compiler Timestamp: Tue Jul 24 04:08:57 2007
Function Name: Do_sqlCopyXML
Source Line

Number: 863

- Context --

Setting status of unmanaged components and removing unmanaged resources

Error Code: -2147467259
MSI (s) (3C!18) [19:49:54:703]: Product: Microsoft SQL Server 2008 Tools -- Error 29547. Upgrade Failed due to the following

Error.The error code is :-2147467259.Message:Unspecified error

Error 29547. Upgrade Failed due to the following Error.The error code is :-2147467259.Message:Unspecified error
<EndFunc Name='LaunchFunction' Return='-2147467259' GetLastError='203'>

--3:

MSI (s) (3C:00) [19:50:07:562]: Product: Microsoft SQL Server 2008 Tools -- Installation failed.

I've naturally allowe the error reports tog et sent in.

anyone have any suggestions as to possible problem/resolutions?

|||I had a problem on a re-install, and found the error output equally unsatisfying.
I decided that my best chance was for a complete installation. The chances were not good that something this fragile would work in a partial install situation.
I had three main issues. Some of these issues may apply to your problem.
The service control program conflict really threw me.
1) SQL Server uninstall may not remove a registry key indicating that it is still installed.
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\Instance Names\SQL
2) SQL Server uninstall may not remove the service control program, which shows up in Control Panel|Services.
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MSSQLSERVER
3) Data (even the ssrs database) from a previous server may fail the installation.
C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data
Good Luck
|||Hi Regan,

We have had the same problem. We removed all of SQL Server 2005 and then installed SQL Server 2008. All went well until the install of the Workstation Components which failed with error -2147467259 which a number of forum users have encountered. We then tried installing the various tools components using the individual .msi installers. This failed with a variety of error messages.
We next selected Control Panel, Programs and Features, Microsoft SQL Server 2008, Change and WorkStation Components. This makes it possible to update the Work Station components. The update failed with the same -214... error until, as suggested by another forum member, we removed Business Intelligence Development Studio from the update. Actually, as we did it, we only installed the Management Tools. The installation now completed without errors and SQL 2008 seems to be running properly.|||

Robbiex wrote:
Hi Regan,
We have had the same problem. We removed all of SQL Server 2005 and then installed SQL Server 2008. All went well until the install of the Workstation Components which failed with error -2147467259 which a number of forum users have encountered. We then tried installing the various tools components using the individual .msi installers. This failed with a variety of error messages.
We next selected Control Panel, Programs and Features, Microsoft SQL Server 2008, Change and WorkStation Components. This makes it possible to update the Work Station components. The update failed with the same -214... error until, as suggested by another forum member, we removed Business Intelligence Development Studio from the update. Actually, as we did it, we only installed the Management Tools. The installation now completed without errors and SQL 2008 seems to be running properly.

Thanks Robbie. I've phased across to testing using the new virtual server setup (after the 2GB download), and I plan to hold off a CTP or 2 for a hopefully more stable installer...

Error installing SQL 2008 July CTP

During my first install.

- on a XP SP2 machine.

- no SQL 2000 or 2005 installed.

- Uninstalled SQL 2005 workstation components.

Error:

TITLE: Microsoft SQL Server 2008 Setup

Upgrade Failed due to the following Error.The error code is :-2147467259.Message:Unspecified error

From that link:

Details
ID: 29547
Source: setup.rll

It appeared to be during:

workstation components, booksonline step:

--"upgrading Microsoft Report Server"

Image here:

Further on this:

-- My 1st install had all components selected: SQL DB Engine, SSIS, SSRS, SSAS, Workstation Components.

I did a second install with only DB engine selected - this completed successfully.

I then tried something install workstation components as standalone, and had what appears to be exactly the same error.

From the summary log:

And from the LOG install, the following ERROR or FAIL message:

--1:

--2:

<Func Name='Do_sqlCopyXML'>
_LoadXMLFile(C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\devenv.exe.config).IID_IXMLDOMDocument->load returned

2147500037.
Error Code: -2147467259
Windows Error Text: Unspecified error
Source File Name: sqlca\sqlxmlca.cpp
Compiler Timestamp: Tue Jul 24 04:08:57 2007
Function Name: Do_sqlCopyXML
Source Line

Number: 863

- Context --

Setting status of unmanaged components and removing unmanaged resources

Error Code: -2147467259
MSI (s) (3C!18) [19:49:54:703]: Product: Microsoft SQL Server 2008 Tools -- Error 29547. Upgrade Failed due to the following

Error.The error code is :-2147467259.Message:Unspecified error

Error 29547. Upgrade Failed due to the following Error.The error code is :-2147467259.Message:Unspecified error
<EndFunc Name='LaunchFunction' Return='-2147467259' GetLastError='203'>

--3:

MSI (s) (3C:00) [19:50:07:562]: Product: Microsoft SQL Server 2008 Tools -- Installation failed.

I've naturally allowe the error reports tog et sent in.

anyone have any suggestions as to possible problem/resolutions?

Robbiex wrote:
Hi Regan,
We have had the same problem. We removed all of SQL Server 2005 and then installed SQL Server 2008. All went well until the install of the Workstation Components which failed with error -2147467259 which a number of forum users have encountered. We then tried installing the various tools components using the individual .msi installers. This failed with a variety of error messages.
We next selected Control Panel, Programs and Features, Microsoft SQL Server 2008, Change and WorkStation Components. This makes it possible to update the Work Station components. The update failed with the same -214... error until, as suggested by another forum member, we removed Business Intelligence Development Studio from the update. Actually, as we did it, we only installed the Management Tools. The installation now completed without errors and SQL 2008 seems to be running properly.

Thanks Robbie. I've phased across to testing using the new virtual server setup (after the 2GB download), and I plan to hold off a CTP or 2 for a hopefully more stable installer...

sql

Monday, March 26, 2012

Error installing MSDE (Yes, another ;) )

Hi all,
Hope someone will be able to help me out with this one.
First, i'm using a Dell Inspiron 5100 laptop with WinXP Pro installed.
I'm trying to install MSDE2000A with a cmd like "setup SAPWD=xxxx /l* .\log.txt"
Everything seem to works fine until there's about 5sec left.
At this point there's a MessageBox popping-up saying "Setup failed to configure the server. Refer to the server error logs and setup error logs for more information."
I've look at my log.txt file, and search for words like "error" or "failed" like stated by a MVP in a previous post. The only hit i've got was for "failed", like in "Setup failed to config..."

the previous line might seem interesting to some : "Execut
ing "C:\Program Files\Microsoft SQL Server\80\Tools\Binn\cnfgsvr.exe -V 1 -M 1 -U sa -I "MSSQLSERVER" -Q "French_CI_AS""
After i've take a look at the server logs in ...\Microsoft SQL Server\MSSQL\LOG\ and Found...
(there's a few lines before, dont think they are interesting... )
2004-05-06 16:05:01.78 spid3 Warning ******************
2004-05-06 16:05:01.78 spid3 SQL Server started in single user mode. Updates allowed to system catalogs.
2004-05-06 16:05:01.78 spid3 Starting up database 'master'.
2004-05-06 16:05:02.24 server Using 'SSNETLIB.DLL' version '8.0.766'.
2004-05-06 16:05:02.24 spid5 Starting up database 'model'.
2004-05-06 16:05:02.29 spid3 Server name is 'JOLAPTOP'.
2004-05-06 16:05:02.29 spid3 Skipping startup of clean database id 5
2004-05-06 16:05:02.29 spid3 Skipping startup of clean database id 6
2004-05-06 16:05:02.29 spid3 Starting up database 'msdb'.
2004-05-06 16:05:03.02 spid5 Clearing tempdb database.
2004-05-06 16:05:04.83 spid5 Starting up database 'tempdb'.
2004-05-06 16:05:05.04 spid3 Warning ******************
2004-05-06 16:05:05.04 spid3 Attempting to change default collation to French_CI_AS.
2004-05-06 16:05:05.12 server SQL server listening on Shared Memory.
2004-05-06 16:05:05.12 server SQL Server is ready for client connections
2004-05-06 16:05:10.31 spid3 Clustered index restored for master.sysdatabases.
(here there's alot of 'index restored for msdb.xxxx' and 'Non-clustered index restored for tempdb.xxx' )...
2004-05-06 16:05:17.32 spid3 index restored for msdb.sysjobsteps.
2004-05-06 16:05:18.68 spid3 Default collation successfully changed.
2004-05-06 16:05:18.69 spid3 Recovery complete.
2004-05-06 16:05:18.69 spid3 SQL global counter collection task is created.
2004-05-06 16:05:18.75 spid3 Warning: override, autoexec procedures skipped.
2004-05-06 16:05:24.16 spid3 SQL Server is terminating due to 'stop' request from Service Control Manager.
Then i've look at the event System log and found an entry similar to the last line of the server log...
Event Type:Information
Event Source:Service Control Manager
Event Category:None
Event ID:7035
Date:2004-05-06
Time:16:05:23
User:xxxxxxxxxxxxxxx
Computer:xxxxxxxx
Description:
The MSSQLSERVER service was successfully sent a stop control.
I've made some searches on google and nothing come up, i've read the posts here and didnt find any answers...
I can't figure this out. Any help would be appreciated ;)
P.S. There's a folder called 'C:\Program Files\Microsoft SQL Server\80\Tools\Binn\cnfgsvr' on my Computer, MSDE seems to be installed but is not working.
Thanks for your help !
Jonathan
hi Jonathan,
"Jonathan" <anonymous@.discussions.microsoft.com> ha scritto nel messaggio
news:A09AB00D-B6F1-4E5F-B639-7FDDC468477F@.microsoft.com...
> Hi all,
> Hope someone will be able to help me out with this one.
> First, i'm using a Dell Inspiron 5100 laptop with WinXP Pro installed.
> I'm trying to install MSDE2000A with a cmd like "setup SAPWD=xxxx /l*
..\log.txt"
> Everything seem to works fine until there's about 5sec left.
> At this point there's a MessageBox popping-up saying "Setup failed to
configure the server. Refer to the server error logs and setup error logs
for more information."
> I've look at my log.txt file, and search for words like "error" or
"failed" like stated by a MVP in a previous post. The only hit i've got was
for "failed", like in "Setup failed to config..."

the previous line
might seem interesting to some : "Executing "C:\Program Files\Microsoft SQL
Server\80\Tools\Binn\cnfgsvr.exe -V 1 -M 1 -U sa -I "MSSQLSERVER" -Q
"French_CI_AS""
>
> After i've take a look at the server logs in ...\Microsoft SQL
Server\MSSQL\LOG\ and Found...
> (there's a few lines before, dont think they are interesting... )
> 2004-05-06 16:05:01.78 spid3 Warning ******************
> 2004-05-06 16:05:01.78 spid3 SQL Server started in single user mode.
Updates allowed to system catalogs.
> 2004-05-06 16:05:01.78 spid3 Starting up database 'master'.
> 2004-05-06 16:05:02.24 server Using 'SSNETLIB.DLL' version '8.0.766'.
> 2004-05-06 16:05:02.24 spid5 Starting up database 'model'.
> 2004-05-06 16:05:02.29 spid3 Server name is 'JOLAPTOP'.
> 2004-05-06 16:05:02.29 spid3 Skipping startup of clean database id 5
> 2004-05-06 16:05:02.29 spid3 Skipping startup of clean database id 6
> 2004-05-06 16:05:02.29 spid3 Starting up database 'msdb'.
> 2004-05-06 16:05:03.02 spid5 Clearing tempdb database.
> 2004-05-06 16:05:04.83 spid5 Starting up database 'tempdb'.
> 2004-05-06 16:05:05.04 spid3 Warning ******************
> 2004-05-06 16:05:05.04 spid3 Attempting to change default collation to
French_CI_AS.
> 2004-05-06 16:05:05.12 server SQL server listening on Shared Memory.
> 2004-05-06 16:05:05.12 server SQL Server is ready for client
connections
> 2004-05-06 16:05:10.31 spid3 Clustered index restored for
master.sysdatabases.
> (here there's alot of 'index restored for msdb.xxxx' and 'Non-clustered
index restored for tempdb.xxx' )...
> 2004-05-06 16:05:17.32 spid3 index restored for msdb.sysjobsteps.
> 2004-05-06 16:05:18.68 spid3 Default collation successfully changed.
> 2004-05-06 16:05:18.69 spid3 Recovery complete.
> 2004-05-06 16:05:18.69 spid3 SQL global counter collection task is
created.
> 2004-05-06 16:05:18.75 spid3 Warning: override, autoexec procedures
skipped.
> 2004-05-06 16:05:24.16 spid3 SQL Server is terminating due to 'stop'
request from Service Control Manager.
>
> Then i've look at the event System log and found an entry similar to the
last line of the server log...
> Event Type: Information
> Event Source: Service Control Manager
> Event Category: None
> Event ID: 7035
> Date: 2004-05-06
> Time: 16:05:23
> User: xxxxxxxxxxxxxxx
> Computer: xxxxxxxx
> Description:
> The MSSQLSERVER service was successfully sent a stop control.
>
> I've made some searches on google and nothing come up, i've read the posts
here and didnt find any answers...
> I can't figure this out. Any help would be appreciated ;)
> P.S. There's a folder called 'C:\Program Files\Microsoft SQL
Server\80\Tools\Binn\cnfgsvr' on my Computer, MSDE seems to be installed but
is not working.
please have a look at
http://support.microsoft.com/default...99&Product=sql
hth
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.7.0 - DbaMgr ver 0.53.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Tanks for your reply,
I didnt have any previous instance installed but i tried it anyz... But unfortunatly it didnt worked.
I dont known if this can help someone or may affect the setup, but i will post it anyz because i've seen in your link a related page stating that having sql7 tools installed may affect the setup. I know its not the same symptoms as mine, but here it is:
My laptop is setup'ed' for programming and tech.. i mean i've alot of tools to support win2000 domain and troubleshooting services such as ActiveDirectory, Sql Server, ... i also have Visual Studio .NET 2003 and debugging tools installed
My laptop is also up to date with Windows Update, and i have alot of tools installed to manage my system (Norton Anti-Virus, DiskKeeper and such (i've try disabling those services before installing, same error))
Hope someone will find something, cause i'm about to give up... Need that MSDE to be able to code while i'm travelling
Thanks for your help all !!

Jonathan

Wednesday, March 21, 2012

Error in SQL startup

Hi guys,

I have an SQL Server 2000 installed on a Windows server 2003. Yesterday, i restart my server and before login to the server the following message poped-up:

"Your SQL Server installation is either corrupt or has been tampered with (unable to load SQLBOOT.DLL). Please uninstall, then re-run setup to correct this problem"

Any ideas what this error is or why occurred?
Any help will be appreciated.

have u checked the sqllog and application log.. post the error from Log. its looks like the REGISTRY/system drive got corrupted/ or master file corrupted... what all are the backup u have. Do u have system dbs backups ?...

Madhu

|||

There are no errors in the event viewer regarding the error i tild you above. There is only the 19012 error which has to do something with the TCP port.

Any other ideas what this error should be?

|||Please post the sql log here. It would help us help you pinpoint the problem. The sqlboot error simply means the service doesn't get all the resources it needs to start up. A re-install typically will fix this.|||

generally this might be the log file path. C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG . Open the ERRORLOG file and paste the contents here

Madhu

Error in sql server 2005 developer edition.

Previously I have posted for the step of installation

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=312644&SiteID=1

I have just installed sql server 2005 developer edition.

After installation is completed when I open sql server management studio I am gwetting Following error.What can I do.

The error is

See the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.

************** Exception Text **************
System.InvalidCastException: Unable to cast object of type 'Microsoft.SqlServer.Management.UI.ConnectionDlg.Personalization' to type 'Microsoft.SqlServer.Management.UI.ConnectionDlg.Personalization'.
at Microsoft.SqlServer.Management.UI.ConnectionDlg.Personalization.LoadFromDisk()
at Microsoft.SqlServer.Management.UI.ConnectionDlg.Personalization.get_Instance()
at Microsoft.SqlServer.Management.UI.ConnectionDlg.Personalization.GetCountByCategory(String category)
at Microsoft.SqlServer.Management.UI.ConnectionDlg.LoginControl.InitFromLastUsedServerType()
at Microsoft.SqlServer.Management.UI.ConnectionDlg.ConnectionDialog.DoOneTimeInitialization()
at Microsoft.SqlServer.Management.UI.ConnectionDlg.ConnectionDialog.OnVisibleChanged(EventArgs e)
at Microsoft.SqlServer.Management.UI.VSIntegration.ShellConnectionDialog.OnVisibleChanged(EventArgs e)
at System.Windows.Forms.Control.WmShowWindow(Message& m)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.ScrollableControl.WndProc(Message& m)
at System.Windows.Forms.ContainerControl.WndProc(Message& m)
at System.Windows.Forms.Form.WmShowWindow(Message& m)
at System.Windows.Forms.Form.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)

************** Loaded Assemblies **************
mscorlib
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll
-
AppIDPackage
Assembly Version: 9.0.242.0
Win32 Version: 9.00.1399.00
CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/AppIDPackage.DLL
-
System
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll
-
Microsoft.SqlServer.SqlTools.VSIntegration
Assembly Version: 9.0.242.0
Win32 Version: 9.00.1399.00
CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/Microsoft.SqlServer.SqlTools.VSIntegration.DLL
-
Microsoft.VisualStudio.Shell.Interop
Assembly Version: 7.1.40304.0
Win32 Version: 7.0.4054
CodeBase: file:///C:/WINDOWS/assembly/GAC/Microsoft.VisualStudio.Shell.Interop/7.1.40304.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.Shell.Interop.dll
-
Microsoft.VisualStudio.OLE.Interop
Assembly Version: 7.1.40304.0
Win32 Version: 7.0.4054
CodeBase: file:///C:/WINDOWS/assembly/GAC/Microsoft.VisualStudio.OLE.Interop/7.1.40304.0__b03f5f7f11d50a3a/Microsoft.VisualStudio.OLE.Interop.dll
-
System.Windows.Forms
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll
-
System.Drawing
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll
-
Microsoft.SqlServer.SqlTDiagM
Assembly Version: 9.0.242.0
Win32 Version: 9.00.1399.00
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.SqlTDiagM/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.SqlTDiagM.dll
-
Microsoft.DataWarehouse.SQM
Assembly Version: 9.0.242.0
Win32 Version: 9.00.1399.00
CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/Microsoft.DataWarehouse.SQM.DLL
-
Microsoft.SqlServer.Instapi
Assembly Version: 9.0.242.0
Win32 Version: 9.00.1399.00
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.Instapi/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.Instapi.dll
-
ObjectExplorer
Assembly Version: 9.0.242.0
Win32 Version: 9.00.1399.00
CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/ObjectExplorer.DLL
-
ConnectionDlg
Assembly Version: 9.0.242.0
Win32 Version: 9.00.1399.00
CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/ConnectionDlg.DLL
-
SqlWorkbench.Interfaces
Assembly Version: 9.0.242.0
Win32 Version: 9.00.1399.00
CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/SqlWorkbench.Interfaces.DLL
-
Microsoft.SqlServer.CustomControls
Assembly Version: 9.0.242.0
Win32 Version: 9.00.1399.00
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.CustomControls/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.CustomControls.dll
-
Accessibility
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Accessibility/2.0.0.0__b03f5f7f11d50a3a/Accessibility.dll
-
SqlMgmt
Assembly Version: 9.0.242.0
Win32 Version: 9.00.1399.00
CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/SqlMgmt.DLL
-
Microsoft.SqlServer.Express.ConnectionDlg
Assembly Version: 9.0.242.0
Win32 Version: 9.00.1399.00
CodeBase: file:///C:/Program%20Files/Microsoft%20SQL%20Server/90/Tools/Binn/VSShell/Common7/IDE/Microsoft.SqlServer.Express.ConnectionDlg.DLL
-
Microsoft.SqlServer.RegSvrEnum
Assembly Version: 9.0.242.0
Win32 Version: 9.00.1399.00
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.RegSvrEnum/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.RegSvrEnum.dll
-
EnvDTE
Assembly Version: 8.0.0.0
Win32 Version: 8.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC/EnvDTE/8.0.0.0__b03f5f7f11d50a3a/EnvDTE.dll
-
Microsoft.NetEnterpriseServers.ExceptionMessageBox
Assembly Version: 9.0.242.0
Win32 Version: 9.00.1399.00
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.NetEnterpriseServers.ExceptionMessageBox/9.0.242.0__89845dcd8080cc91/Microsoft.NetEnterpriseServers.ExceptionMessageBox.dll
-
System.Data
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.42 (RTM.050727-4200)
CodeBase: file:///C:/WINDOWS/assembly/GAC_32/System.Data/2.0.0.0__b77a5c561934e089/System.Data.dll
-
Microsoft.SqlServer.ConnectionInfo
Assembly Version: 9.0.242.0
Win32 Version: 9.00.1399.00
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Microsoft.SqlServer.ConnectionInfo/9.0.242.0__89845dcd8080cc91/Microsoft.SqlServer.ConnectionInfo.dll
-

************** JIT Debugging **************
To enable just-in-time (JIT) debugging, the .config file for this
application or computer (machine.config) must have the
jitDebugging value set in the system.windows.forms section.
The application must also be compiled with debugging
enabled.

For example:

When JIT debugging is enabled, any unhandled exception
will be sent to the JIT debugger registered on the computer
rather than be handled by this dialog box.

What Can I do

Hey Kamran,

I'm moving this thread to the Tools General forum so that the experts there can help you.

Thanks,

-Jeffrey

|||

I've seen this when Management Studio loads preferences from the express version and vice-versa. Do you have Management Studio Express installed on the same machine by any chance?

|||

I had the same problem until I removed Management Studio Express... thanks!

|||Yes That Were The Also the Problem.

Error in SQL server 2000

I just installed SQL Server 2000 EVAL ver, in my Win XP Pro machine and the installtion was succesful though I get the following error once I run the code.

What does this mean ? What should I do here ?

----------------------
[SqlException: Login failed for user 'sa'. Reason: Not associated with a trusted SQL Server connection.]
System.Data.SqlClient.ConnectionPool.GetConnection(Boolean& isInTransaction) +472
System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString options, Boolean& isInTransaction) +311
System.Data.SqlClient.SqlConnection.Open() +383
ASP.DropDownList_aspx.Page_Load() +61
System.Web.Util.ArglessEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) +10
System.Web.UI.Control.OnLoad(EventArgs e) +55
System.Web.UI.Control.LoadRecursive() +27
System.Web.UI.Page.ProcessRequestMain() +731you need to add a user to the users list. if you xpand the your database in sql serve xplorer under users you need to add the machinename\ASPNET user account to grant access to the tables.

hth|||Hi Ndinakar,

Thanks for your help though I have the same, it gives the errors again.

I do run SQL 2000 Evaluation Version in Win XP Professional which is in home use.
(NOT connected into a Server or a Domain)

TIA
dan|||you prbly have an incorrect connection string. check this site for some sample connection strings :http://www.connectionstrings.com

hth|||naw, you didn't put a strong sa password, and it's looking for nt security.|||Hi

Thanks for both of you for the great help.
This is my code and the error message is pasted down. Further my ID and password is mentioned as in the SQL Server.

Further I am very new to ASP.net and just try to study the examples of ASP.net UNLEASHED published by SAMS.

<%@. Page Language="VB" %>
<%@. import Namespace="System.Data" %>
<%@. import Namespace="System.Data.SqlClient" %>
<script runat="server"
"Data Source=Aron1;Initial Catalog=pubs;User Id=sa;Password=tkpkkalu"

Dim conPubs As SqlConnection

Sub Page_Load
Dim dtrAuthors As SqlDataReader

dtrAuthors = GetAuthors()
While dtrAuthors.Read
lblAuthors.Text &= "<li>"
lblAuthors.Text &= dtrAuthors( "au_lname" )
End While
dtrAuthors.Close()
lblAuthors.Text &= "

Connection is:" & conPubs.State.ToString()
End Sub

Function GetAuthors() As SqlDataReader
Dim cmdAuthors As SqlCommand

conPubs = New SqlConnection( "Server=localhost;UID=sa;PWD=secret;database=pubs" )
cmdAuthors = New SqlCommand( "select * from Authors", conPubs )
conPubs.Open()
Return cmdAuthors.ExecuteReader( CommandBehavior.CloseConnection )
End Function

</script>
<html>
<head>
<title>SqlCloseConnection.aspx</title>
</head>
<body>
<asp:Label id="lblAuthors" runat="Server"></asp:Label>
</body>
</html
Compilation Error
Description: An error occurred during the compilation of a resource required to service this request. Please review the following specific error details and modify your source code appropriately.

Compiler Error Message: BC30035: Syntax error.

Source Error:

Line 5:
Line 6:
Line 7: "Data Source=Aron1;Initial Catalog=pubs;User Id=sa;Password=tkpkkalu"
Line 8:
Line 9:

Source File: C:\Inetpub\wwwroot\SqlCloseConnection.aspx Line: 7|||are we missing something between these lines ?


<script runat="server"
"Data Source=Aron1;Initial Catalog=pubs;User Id=sa;Password=tkpkkalu"Dim conPubs As SqlConnection

change the above lines to


<script runat="server">
Dim conPubs As SqlConnection
conPubs.connectionstring="Data Source=Aron1;Initial Catalog=pubs;User Id=sa;Password=tkpkkalu"

also you are missing parameters for the page_load sub.

sub page_load (Sender as Object, e as EventArgs)

hth

Error in sql management express installation

Hi,

I had earlier installation of microsoft sql server 2005 in my machine. Recently I installed the visual studio 2005 beta which comes with sql express and after going through many hoops(as it kept complaining about the previous installation of beta components) i was able to install it correctly. I was also able to also use visaul studio 2005 server explorer to connect to the SQLEXPRESS and create table etc... Now I wanted to install sql server management express so I downloaded SQLEXPR_ADV from te microsoft's website. During the installation it complained about the older version of SQL server management sutdio installed and hence could not install the sql server management express. By looking at different forums I found following steps to deinstall earlier version but still runs into this issue. I will really appreciate somebody's help....

STPES I FOLLOWED TO REMOVE EARLIER VERSION OF SQL SERVER 2005 MANAGEMENT STUDIO

Click Start, and then click Control Panel.
Double-click Add or Remove Programs.
In the list of installed programs, click Microsoft SQL Server 2005, and then click Change.
On the Component Selection page, select Workstation components, and then click Next.
Click Next.
On the Change or Remove Instance page, click Change Installed Components.
Expand Client Components, click Management Tools, and then select Entire Feature will be Unavailable. Or just select the entire client components
Click Next.
Click Install.

2) I also tried to use the complete uninstall of visual studio ( By using the tolls

vs_unists_betas.exe) and after that also window uninstall clean up (msiccu2)

and then reinstalling visual studio 2005 beta which would install sql express...But

nothing seems to be able to uninstall the previous version of SQL SERVER 2005

Management studio from my computer and hence I am not able to uninstall the

sql server management express.

hi,

try having a look at http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=907736&SiteID=1 as well

regards

sql

Monday, March 19, 2012

error in reports

Hi group
Finally I got it installed... ;0)
when I try to access the http://server/reports/ I get the following error
Cannot use 'partitionResolver' unless the mode is StateServer' or SQLServer
I tryid to give it a seperate appPool...
I have a sharepoint on theres as well
anyone that can assist ?On Sep 11, 4:24 am, "Wiper" <taenke...@.gmail.com> wrote:
> Hi group
> Finally I got it installed... ;0)
> when I try to access thehttp://server/reports/I get the following error
> Cannot use 'partitionResolver' unless the mode is StateServer' or SQLServer
> I tryid to give it a seperate appPool...
> I have a sharepoint on theres as well
> anyone that can assist ?
You may want to check the web.config file for Reporting Services
(normally located at: C:\Program Files\Microsoft SQL Server\MSSQL.
2\Reporting Services\ReportManager -or- C:\Program Files\Microsoft SQL
Server\MSSQL.2\Reporting Services\ReportServer; however, MSSQL.2 could
be MSSQL.3) and add:
partitionResolverType="" in the sessionState key.
Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant

Error in report server

I have just installed sql server 2005 developer edition with ssrs

I am getting following error

When Browsing

http://localhost/ReportServer$Yukon/
Reporting Services Error
--

The permissions granted to user 'KAMRANSHAHID\IUSR_KAMRANSHAHID' are insufficient for performing this operation. (rsAccessDenied) Get Online Help

--
SQL Server Reporting Services

**********************************************************************************************************

When editing Surface Area Configuration

TITLE: Surface Area Configuration

System.Web.Services.Protocols.SoapException: The permissions granted to user 'KAMRANSHAHID\IUSR_KAMRANSHAHID' are insufficient for performing this operation. > Microsoft.ReportingServices.Diagnostics.Utilities.AccessDeniedException: The permissions granted to user 'KAMRANSHAHID\IUSR_KAMRANSHAHID' are insufficient for performing this operation.
at Microsoft.ReportingServices.Library.RSService.SetSystemProperties(Property[] properties)
at Microsoft.ReportingServices.WebServer.ReportingService.SetSystemProperties(Property[] Properties)
End of inner exception stack trace
at Microsoft.ReportingServices.WebServer.ReportingService.SetSystemProperties(Property[] Properties) (System.Web.Services)

BUTTONS:

**********************************************************************************************************

Also When I connect from management studio for the reporting services instance I get the same error of insufficient privilge

TITLE: Microsoft SQL Server Management Studio

Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476

ADDITIONAL INFORMATION:

The permissions granted to user 'KAMRANSHAHID\IUSR_KAMRANSHAHID' are insufficient for performing this operation. (rsAccessDenied) (Report Services SOAP Proxy Source)

For help, click: http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings&EvtID=rsAccessDenied&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=9.00.1399.00

The permissions granted to user 'KAMRANSHAHID\IUSR_KAMRANSHAHID' are insufficient for performing this operation. (rsAccessDenied) (ReportingServicesLibrary)

BUTTONS:

**********************************************************************************************************

What Am I missing ?

But While browsing report {not server } works fine

http://localhost/Reports$Yukon/Pages/Folder.aspx

SQL Server Reporting Services

Home

Home | My Subscriptions | Help

I have done by giving ntfs permission to user kamran shahid
and change ownership from administrator to kamranshahid
Now Only problem i am having is that when ever I browse for the reportmanager or reportserver the authentication window come up
in which i have to give my user name and password of the windows
How Can i get rid of this authentication window

Error in report server

I have just installed sql server 2005 developer edition with ssrs

I am getting following error

When Browsing

--
SQL Server Reporting Services

**********************************************************************************************************

When editing Surface Area Configuration

TITLE: Surface Area Configuration

BUTTONS:

**********************************************************************************************************

Also When I connect from management studio for the reporting services instance I get the same error of insufficient privilge

TITLE: Microsoft SQL Server Management Studio

Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&LinkId=20476

ADDITIONAL INFORMATION:

The permissions granted to user 'KAMRANSHAHID\IUSR_KAMRANSHAHID' are insufficient for performing this operation. (rsAccessDenied) (Report Services SOAP Proxy Source)

The permissions granted to user 'KAMRANSHAHID\IUSR_KAMRANSHAHID' are insufficient for performing this operation. (rsAccessDenied) (ReportingServicesLibrary)

BUTTONS:

**********************************************************************************************************

What Am I missing ?

But While browsing report {not server } works fine

http://localhost/Reports$Yukon/Pages/Folder.aspx

SQL Server Reporting Services

Home

Home | My Subscriptions | Help

Sunday, March 11, 2012

error in my event viewer "application log"

Hi all, I'm using winxp pro and just installed MSDE2000 /w
sp3, now I see a error message in my event
viewer "application log":
19012 :
SuperSocket Info: Bind failed on TCP port 1433.
For more information, see Help and Support Center at
http://go.microsoft.com/fwlink/events.asp.
Can anyone give me a hand?
GMow
hi GMov,
"gmow@.shaw.ca" <anonymous@.discussions.microsoft.com> ha scritto nel
messaggio news:5a3101c42d5a$25dd6770$a501280a@.phx.gbl...
> Hi all, I'm using winxp pro and just installed MSDE2000 /w
> sp3, now I see a error message in my event
> viewer "application log":
> 19012 :
> SuperSocket Info: Bind failed on TCP port 1433.
>
your TCP 1433 port is probably in use by other applications..
please refer to
http://support.microsoft.com/default...b;EN-US;293107 for further
info and hints to solve the problem..
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.7.0 - DbaMgr ver 0.53.0
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
|||Hi Andrea,thx for the info, let me try and see!
>--Original Message--
>hi GMov,
>"gmow@.shaw.ca" <anonymous@.discussions.microsoft.com> ha
scritto nel[vbcol=seagreen]
>messaggio news:5a3101c42d5a$25dd6770$a501280a@.phx.gbl...
MSDE2000 /w
>your TCP 1433 port is probably in use by other
applications..
>please refer to
>http://support.microsoft.com/default.aspx?scid=kb;EN-
US;293107 for further
>info and hints to solve the problem..
>--
>Andrea Montanari (Microsoft MVP - SQL Server)
>http://www.asql.biz/DbaMgr.shtm
http://italy.mvps.org
>DbaMgr2k ver 0.7.0 - DbaMgr ver 0.53.0
>(my vb6+sql-dmo little try to provide MS MSDE 1.0 and
MSDE 2000 a visual
>interface)
>-- remove DMO to reply
>.
>

error in ms sql server 2000 enterprise

dear sir, i have got an error in ms SQL server 2000 enterprise...which is installed on a win2003 enterprise system...
SuperSocket info: (SpnRegister) : Error 1355.
can you please tell me what it means??
regards,http://support.microsoft.com/kb/303411

Google is your friend.

Regards,

hmscott

Thursday, March 29, 2012

Error loading resource string in SP2

Error loading http://localhost/ReportServer

Reporting Services Error

An internal error occurred on the report server. See the error log for more details. (rsInternalError)

Error loading http://localhost/ReportServer

Reporting Services Error

An internal error occurred on the report server. See the error log for more details. (rsInternalError)

Error installing SQL2005 SP2

Error installing SQL Server Management Studio Express

Tuesday, March 27, 2012

Error installing SQL Server Management Studio Express

Error installing SQL Server 2005 Express Manager

Error installing SQL Server 2000

Error installing SQL 2008 July CTP

Error installing SQL 2008 July CTP

Monday, March 26, 2012

Error installing MSDE (Yes, another ;) )

Wednesday, March 21, 2012

Error in SQL startup

Error in sql server 2005 developer edition.

Error in SQL server 2000

Error in sql management express installation

Monday, March 19, 2012

error in reports

Error in report server

Error in report server

Sunday, March 11, 2012

error in my event viewer "application log"

error in ms sql server 2000 enterprise

error handling flow

Blog Archive

About Me