Showing posts with label folder. Show all posts
Showing posts with label folder. Show all posts

Monday, March 19, 2012

Is this a bug?

RS 2005 (SQL 2005 SP1).

When you edit the ASP.Net tab (in IIS) for the ReportServer folder and change the Authentication Mode from Windows to None the Report Server will bomb out. Trying to open th ereportserver returns "Report Server is not responding, verify the report server is running and can be accessed from this computer".

Changing it back to "Windows" makes no difference, even re-starting the Reporting Service and IIS makes no difference, the report server will not respond.

Can some one test this?

I ended up having to re-install RS 2005....!!

What does the venet log / the logs in the log directory tell you ?

HTH, Jens Suessmeyer.

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

In the SQLDUMPER_ERRORLog.log file there wass this..

07/13/06 12:53:35, ERROR , SQLDUMPER_UNKNOWN_APP.EXE, AdjustTokenPrivileges () failed (00000514)
07/13/06 12:53:35, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Input parameters: 4 supplied
07/13/06 12:53:35, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ProcessID = 328
07/13/06 12:53:35, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ThreadId = 0
07/13/06 12:53:35, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Flags = 0x0
07/13/06 12:53:35, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, MiniDumpFlags = 0x0
07/13/06 12:53:35, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, SqlInfoPtr = 0x47405860
07/13/06 12:53:35, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, DumpDir = <NULL>
07/13/06 12:53:35, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ExceptionRecordPtr = 0x00000000
07/13/06 12:53:35, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ContextPtr = 0x00000000
07/13/06 12:53:35, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ExtraFile = <NULL>
07/13/06 12:53:35, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, InstanceName = <NULL>
07/13/06 12:53:35, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, ServiceName = <NULL>
07/13/06 12:53:36, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 11 not used
07/13/06 12:53:37, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, Callback type 7 not used
07/13/06 12:53:37, ACTION, SQLDUMPER_UNKNOWN_APP.EXE, MiniDump completed: C:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting Services\LogFiles\SQLDmpr0001.mdmp
07/13/06 12:53:37, ACTION, w3wp.exe, Watson Invoke: No

|||Is the report service running after that bug ? What does the reportserver log tell you ? Are there any event log entries ? It would be helpful to have all event log (at leat the last entries) to identify the bug.

HTH, jens Suessmeyer.

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

Yes the report service was running after this.

Did you try to replicate the problem (on a test machine of course)....

|||

Hey, niallhannon,

I have read some of your posting and found out that you had most of the problems with the report service I have now, I wonder if you have set up the sample reports from Microsoft.

I am setting up the sample report on the testing server and I have problems with deploying to the http://myserver/reportserver and it gave the the following error, see if you can provide some tips to me:

TITLE: Microsoft Report Designer

A connection could not be made to the report server http://10.128.64.223/reportserver.


ADDITIONAL INFORMATION:

Client found response content type of 'text/html; charset=utf-8', but expected 'text/xml'.
The request failed with the error message:
--
<html>
<head>
<title>
SQL Server Reporting Services
</title><meta name="Generator" content="Microsoft SQL Server Reporting Services 9.00.1399.00" />
<meta name="HTTP Status" content="500" />
<meta name="ProductLocaleID" content="9" />
<meta name="CountryLocaleID" content="1033" />
<meta name="StackTrace" content />
<style>
BODY {FONT-FAMILY:Verdana; FONT-WEIGHT:normal; FONT-SIZE: 8pt; COLOR:black}
H1 {FONT-FAMILY:Verdana; FONT-WEIGHT:700; FONT-SIZE:15pt}
LI {FONT-FAMILY:Verdana; FONT-WEIGHT:normal; FONT-SIZE:8pt; DISPLAY:inline}
.ProductInfo {FONT-FAMILY:Verdana; FONT-WEIGHT:bold; FONT-SIZE: 8pt; COLOR:gray}
A:link {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#3366CC; TEXT-DECORATION:none}
A:hover {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#FF3300; TEXT-DECORATION:underline}
A:visited {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; COLOR:#3366CC; TEXT-DECORATION:none}
A:visited:hover {FONT-SIZE: 8pt; FONT-FAMILY:Verdana; color:#FF3300; TEXT-DECORATION:underline}

</style>
</head><body bgcolor="white">
<h1>
Reporting Services Error<hr width="100%" size="1" color="silver" />
</h1><ul>
<li>An internal error occurred on the report server. See the error log for more details. (rsInternalError) <a href="http://go.microsoft.com/fwlink/?LinkId=20476&EvtSrc=Microsoft.ReportingServices.Diagnostics.Utilities.ErrorStrings&EvtID=rsInternalError&ProdName=Microsoft%20SQL%20Server%20Reporting%20Services&ProdVer=9.00.1399.00" target="_blank">Get Online Help</a></li><ul>
<li>Object reference not set to an instance of an object.</li>
</ul>
</ul><hr width="100%" size="1" color="silver" /><span class="ProductInfo">SQL Server Reporting Services</span>
</body>
</html>
--. (Microsoft.ReportingServices.Designer)


BUTTONS:

OK


Monday, February 20, 2012

Is there any API to browse for folder on SQL Server's machine?

Hi!
I know there is xp_dirtree, xp_subdirs, xp_fixeddrives procedures which
allows me to implement a folder select dialog.
But SQL Server's Enterprise Manager already has such dialog. For example
if you open "Attach Database"
dialog and then press browse [...] button Enterprise Manager will show you
"Browse For Existing File" dialog. And
as you can see all the path information in that dialog is local to SQL
Server's machine. This is what
SHBrowseForFolder cannot do for you because SHBrowseForFolder always shows
paths relative to local machine.
My question is: Is there any way to reuse that Enterprise Manager's
"Browse For Existing File" dialog? Or I am
obliged to reinvent it?Hi,
You need to re-invent it using the xp's you mentioned
Greg O
"Igor Solodovnikov" <IgorSolodovnikov@.discussions.microsoft.com> wrote in
message news:op.suy1vyq7n8ihmu@.iw2k.helpmicro.local...
> Hi!
> I know there is xp_dirtree, xp_subdirs, xp_fixeddrives procedures which
> allows me to implement a folder select dialog.
> But SQL Server's Enterprise Manager already has such dialog. For example
> if you open "Attach Database"
> dialog and then press browse [...] button Enterprise Manager will show you
> "Browse For Existing File" dialog. And
> as you can see all the path information in that dialog is local to SQL
> Server's machine. This is what
> SHBrowseForFolder cannot do for you because SHBrowseForFolder always shows
> paths relative to local machine.
> My question is: Is there any way to reuse that Enterprise Manager's
> "Browse For Existing File" dialog? Or I am
> obliged to reinvent it?|||Hi
If you use SQL profiler to check out what EM is doing you will see the same
procedures being called!
John
"Igor Solodovnikov" wrote:

> Hi!
> I know there is xp_dirtree, xp_subdirs, xp_fixeddrives procedures which
> allows me to implement a folder select dialog.
> But SQL Server's Enterprise Manager already has such dialog. For example
> if you open "Attach Database"
> dialog and then press browse [...] button Enterprise Manager will show you
> "Browse For Existing File" dialog. And
> as you can see all the path information in that dialog is local to SQL
> Server's machine. This is what
> SHBrowseForFolder cannot do for you because SHBrowseForFolder always shows
> paths relative to local machine.
> My question is: Is there any way to reuse that Enterprise Manager's
> "Browse For Existing File" dialog? Or I am
> obliged to reinvent it?
>|||You could look into the SQL-NS API (where NS stands for Name Space). The API
exposes most of EM
dialogs as COM objects, I'm not sure about the file browsing dialogs, though
. It is not
re-distributable, though. This means that the client machine need the SQL Se
rver tools (EM)
installed to run your app. And it will not be carried forward to SQL Server
2005.
Two other alternatives:
Use the undocumented xp's you mention. Downside is that they are undocumente
d, unsupported etc.
Use xp_cmdshell and DIR etc. Harder to interpret the result (a table with on
e column, so some string
parsing is needed).
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Igor Solodovnikov" <IgorSolodovnikov@.discussions.microsoft.com> wrote in me
ssage
news:op.suy1vyq7n8ihmu@.iw2k.helpmicro.local...
> Hi!
> I know there is xp_dirtree, xp_subdirs, xp_fixeddrives procedures which a
llows me to implement a
> folder select dialog.
> But SQL Server's Enterprise Manager already has such dialog. For example
if you open "Attach
> Database"
> dialog and then press browse [...] button Enterprise Manager will show you "Br
owse For Existing
> File" dialog. And
> as you can see all the path information in that dialog is local to SQL Se
rver's machine. This is
> what
> SHBrowseForFolder cannot do for you because SHBrowseForFolder always shows
paths relative to
> local machine.
> My question is: Is there any way to reuse that Enterprise Manager's "Brow
se For Existing File"
> dialog? Or I am
> obliged to reinvent it?|||> You could look into the SQL-NS API (where NS stands for Name Space). The
> API exposes most of EM dialogs as COM objects, I'm not sure about the
> file browsing dialogs, though. It is not re-distributable, though. This
> means that the client machine need the SQL Server tools (EM) installed
> to run your app. And it will not be carried forward to SQL Server 2005.
Thank you for this information. I will loo into SQL-NS

> Two other alternatives:
> Use the undocumented xp's you mention. Downside is that they are
> undocumented, unsupported etc.
And another downside: i need to spend significant time to implement and
debug that dialog. :(