Thursday, March 29, 2012
can't connect 2005 reporting server...need help
window2003 with sp1 and IIS 6.0 is running on it as well. I am in local
admin and got error when i try to connect report server:
Cannot execute a program. The command being executed was
"C:\WINNT\Microsoft.NET\Framework\v2.0.50727\csc.exe" /noconfig /fullpaths
@."C:\WINNT\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET
Files\reports$sql2005\47980326\bf0ad169\lzwjfwcj.cmdline".
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.Runtime.InteropServices.ExternalException: Cannot
execute a program. The command being executed was
"C:\WINNT\Microsoft.NET\Framework\v2.0.50727\csc.exe" /noconfig /fullpaths
@."C:\WINNT\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET
Files\reports$sql2005\47980326\bf0ad169\lzwjfwcj.cmdline".
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.
anyone knows about this and thanks alot for a help
Karen,On Apr 27, 1:50 pm, Karen Chen <KarenC...@.discussions.microsoft.com>
wrote:
> We installed sql 2005 server and reporting services (standard edition) on
> window2003 with sp1 and IIS 6.0 is running on it as well. I am in local
> admin and got error when i try to connect report server:
> Cannot execute a program. The command being executed was
> "C:\WINNT\Microsoft.NET\Framework\v2.0.50727\csc.exe" /noconfig /fullpaths
> @."C:\WINNT\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET
> Files\reports$sql2005\47980326\bf0ad169\lzwjfwcj.cmdline".
> 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.Runtime.InteropServices.ExternalException: Cannot
> execute a program. The command being executed was
> "C:\WINNT\Microsoft.NET\Framework\v2.0.50727\csc.exe" /noconfig /fullpaths
> @."C:\WINNT\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET
> Files\reports$sql2005\47980326\bf0ad169\lzwjfwcj.cmdline".
> 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.
> anyone knows about this and thanks alot for a help
> Karen,
I received your email and noticed that you posted here as well. If you
do not have the .NET 2.0 framework installed, this might be the
problem.
Regards,
Enrique Martinez
Sr. Software Consultant
Can't connect 2005 reporting server
window2003 with sp1 and IIS 6.0 is running on it as well. I am in local
admin and got error when i try to connect report server:
Cannot execute a program. The command being executed was
"C:\WINNT\Microsoft.NET\Framework\v2.0.50727\csc.exe" /noconfig /fullpaths
@."C:\WINNT\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET
Files\reports$sql2005\47980326\bf0ad169\lzwjfwcj.cmdline".
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.Runtime.InteropServices.ExternalException: Cannot
execute a program. The command being executed was
"C:\WINNT\Microsoft.NET\Framework\v2.0.50727\csc.exe" /noconfig /fullpaths
@."C:\WINNT\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET
Files\reports$sql2005\47980326\bf0ad169\lzwjfwcj.cmdline".
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.
anyone knows about this and thanks alot for a help
Karen,On Apr 27, 2:24 pm, Karen Chen <KarenC...@.discussions.microsoft.com>
wrote:
> We installed sql 2005 server and reporting services (standard edition) on
> window2003 with sp1 and IIS 6.0 is running on it as well. I am in local
> admin and got error when i try to connect report server:
> Cannot execute a program. The command being executed was
> "C:\WINNT\Microsoft.NET\Framework\v2.0.50727\csc.exe" /noconfig /fullpaths
> @."C:\WINNT\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET
> Files\reports$sql2005\47980326\bf0ad169\lzwjfwcj.cmdline".
> 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.Runtime.InteropServices.ExternalException: Cannot
> execute a program. The command being executed was
> "C:\WINNT\Microsoft.NET\Framework\v2.0.50727\csc.exe" /noconfig /fullpaths
> @."C:\WINNT\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET
> Files\reports$sql2005\47980326\bf0ad169\lzwjfwcj.cmdline".
> 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.
> anyone knows about this and thanks alot for a help
> Karen,
Please refer to my previous post at:
http://groups.google.com/group/microsoft.public.sqlserver.reportingsvcs/browse_thread/thread/9efeaacdc0875e6d/7ce06f2ec8a78f36#7ce06f2ec8a78f36
Regards,
Enrique Martinez
Sr. Software Consultant|||Hi Enrique,
Thanks your replay and i do have .NET 2.0 installed. I feel like its
security issue.
What is security context of .NETservice account (NT
Authority\NetworkService)? and how do you confiure this account for web
service identity?
"EMartinez" wrote:
> On Apr 27, 2:24 pm, Karen Chen <KarenC...@.discussions.microsoft.com>
> wrote:
> > We installed sql 2005 server and reporting services (standard edition) on
> > window2003 with sp1 and IIS 6.0 is running on it as well. I am in local
> > admin and got error when i try to connect report server:
> > Cannot execute a program. The command being executed was
> > "C:\WINNT\Microsoft.NET\Framework\v2.0.50727\csc.exe" /noconfig /fullpaths
> > @."C:\WINNT\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET
> > Files\reports$sql2005\47980326\bf0ad169\lzwjfwcj.cmdline".
> > 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.Runtime.InteropServices.ExternalException: Cannot
> > execute a program. The command being executed was
> > "C:\WINNT\Microsoft.NET\Framework\v2.0.50727\csc.exe" /noconfig /fullpaths
> > @."C:\WINNT\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET
> > Files\reports$sql2005\47980326\bf0ad169\lzwjfwcj.cmdline".
> >
> > 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.
> >
> > anyone knows about this and thanks alot for a help
> >
> > Karen,
>
> Please refer to my previous post at:
> http://groups.google.com/group/microsoft.public.sqlserver.reportingsvcs/browse_thread/thread/9efeaacdc0875e6d/7ce06f2ec8a78f36#7ce06f2ec8a78f36
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>|||Hi Enrique,
Thanks your replay and we do have .Net 2.0 installed. I feel like that this
problem related to security issue.
How do you configure your web service account (NT Authoriry/NetworkServices)
?
Karen,
"EMartinez" wrote:
> On Apr 27, 2:24 pm, Karen Chen <KarenC...@.discussions.microsoft.com>
> wrote:
> > We installed sql 2005 server and reporting services (standard edition) on
> > window2003 with sp1 and IIS 6.0 is running on it as well. I am in local
> > admin and got error when i try to connect report server:
> > Cannot execute a program. The command being executed was
> > "C:\WINNT\Microsoft.NET\Framework\v2.0.50727\csc.exe" /noconfig /fullpaths
> > @."C:\WINNT\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET
> > Files\reports$sql2005\47980326\bf0ad169\lzwjfwcj.cmdline".
> > 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.Runtime.InteropServices.ExternalException: Cannot
> > execute a program. The command being executed was
> > "C:\WINNT\Microsoft.NET\Framework\v2.0.50727\csc.exe" /noconfig /fullpaths
> > @."C:\WINNT\Microsoft.NET\Framework\v2.0.50727\Temporary ASP.NET
> > Files\reports$sql2005\47980326\bf0ad169\lzwjfwcj.cmdline".
> >
> > 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.
> >
> > anyone knows about this and thanks alot for a help
> >
> > Karen,
>
> Please refer to my previous post at:
> http://groups.google.com/group/microsoft.public.sqlserver.reportingsvcs/browse_thread/thread/9efeaacdc0875e6d/7ce06f2ec8a78f36#7ce06f2ec8a78f36
> Regards,
> Enrique Martinez
> Sr. Software Consultant
>
Tuesday, March 20, 2012
Can't Access http://MyServer/Reports -- 401 Error
I'll try both!
Although I've never seen it, I've been told that our Reporting Service
used to work until I changed the permissions on a TOTALLY unrelated
virtual directory and file folder. Using IE, when I try to go to the
site I get that nasty message, "The request failed with HTTP status
401: Unauthorized." I've researched here, looked at several MSDN
knowledge base articles (the ones about negotiating Kerebos logins),
and tried everything else I could think of. Interestingly, when I use
FireFox, I at least get a dialog box asking me for my user name and
password although it doesn't accept login.
Any suggestions would be most appreciated.
Thanks.
RandyIt sounds like it was broken before you made changes but no one knew
about it, and since you were the last one making server changes that
anyone knew about... you got stuck with having to fix something you did
not break.
By default, IIS does not return any 401 message that looks like "The
request failed with HTTP status 401: Unauthorized". IE does not
translate any errors into that, either.
So, I believe you are getting 401 from some non-IIS-related custom
authentication component, in which case you need to identify that
component and obtain configuration support for it. It is important for
you to obtain support from the component having problems and not just
generic assistance because there are unknown details that can be
important.
I did a search on those words, and it appears to come from a .NET
Client. Probably used by the Reporting Service application itself. So
you want to start your questions from them.
FYI: IE skipped to the 401 message because it already automatically
tried several logons over different allowed protocols on your behalf
and decided to stop trying. FireFox assumes you can retry yourself so
it pops up the login. But they both fail to login, of course.
//David
http://w3-4u.blogspot.com
//
EoRaptor013 wrote:
> Not sure if this is the place to post this or over at the IIS group so
> I'll try both!
> Although I've never seen it, I've been told that our Reporting Service
> used to work until I changed the permissions on a TOTALLY unrelated
> virtual directory and file folder. Using IE, when I try to go to the
> site I get that nasty message, "The request failed with HTTP status
> 401: Unauthorized." I've researched here, looked at several MSDN
> knowledge base articles (the ones about negotiating Kerebos logins),
> and tried everything else I could think of. Interestingly, when I use
> FireFox, I at least get a dialog box asking me for my user name and
> password although it doesn't accept login.
> Any suggestions would be most appreciated.
> Thanks.
> Randy
Monday, March 19, 2012
Cannot view reports, SSRS on Vista
I have installed/configured SSRS on a Vista-laptop but I cannot view reports
in IE.
Finally, I got the reportserver running under IIS 7.0.The report works fine
in VS2005 and deployment (finally!!) works fine from the editor.
But the infamous 'rsReportNotReady'-error shows once I try to view a report.
Other strange stuff: When I click on the link "ReportViewer.aspx" IE only
shows the reportServer root-directory. And the same thing happens if I
create a dumb .aspx-file and put into the reportServer/Pages directory.
The installation has been hellish so far, and I have read SO many blogs and
tips but nothing works...
* Yes, I have tried to turn off database snapshot isolation level for the
SSRS-databases
* Yes, I have installed Service Pack 2 (twice)
Im hoping for your help, as I see no path to a solution for this mystery!
Cheers DavidTwo things to try (I have never done this, this is from the newsgroup).
1) Control Panel / User Accounts / Turn User Account Control - off
2) run "%windir%\Microsoft.NET\Framework\version\aspnet_regiis.exe" -i
My advice is to try #1 first. I have seen this multiple times. As far as #2,
that I have only seen once in the newsgroup.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"David" <david_sundstrom_sandegard.nospam@.hotmail.com> wrote in message
news:OW%23s1iLbIHA.4476@.TK2MSFTNGP06.phx.gbl...
> Hello!
> I have installed/configured SSRS on a Vista-laptop but I cannot view
> reports in IE.
> Finally, I got the reportserver running under IIS 7.0.The report works
> fine in VS2005 and deployment (finally!!) works fine from the editor.
> But the infamous 'rsReportNotReady'-error shows once I try to view a
> report.
> Other strange stuff: When I click on the link "ReportViewer.aspx" IE only
> shows the reportServer root-directory. And the same thing happens if I
> create a dumb .aspx-file and put into the reportServer/Pages directory.
> The installation has been hellish so far, and I have read SO many blogs
> and tips but nothing works...
> * Yes, I have tried to turn off database snapshot isolation level for the
> SSRS-databases
> * Yes, I have installed Service Pack 2 (twice)
> Im hoping for your help, as I see no path to a solution for this mystery!
> Cheers David|||I managed to get thÃngs running by un-installing the whole SQL-server package.
(I believe that I might have had a mix-up of editions installed)
Took me anothier full two hours, but now the thing works!
Thx for helping out!
David
"Bruce L-C [MVP]" wrote:
> Two things to try (I have never done this, this is from the newsgroup).
> 1) Control Panel / User Accounts / Turn User Account Control - off
> 2) run "%windir%\Microsoft.NET\Framework\version\aspnet_regiis.exe" -i
> My advice is to try #1 first. I have seen this multiple times. As far as #2,
> that I have only seen once in the newsgroup.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
>
> "David" <david_sundstrom_sandegard.nospam@.hotmail.com> wrote in message
> news:OW%23s1iLbIHA.4476@.TK2MSFTNGP06.phx.gbl...
> > Hello!
> >
> > I have installed/configured SSRS on a Vista-laptop but I cannot view
> > reports in IE.
> >
> > Finally, I got the reportserver running under IIS 7.0.The report works
> > fine in VS2005 and deployment (finally!!) works fine from the editor.
> >
> > But the infamous 'rsReportNotReady'-error shows once I try to view a
> > report.
> >
> > Other strange stuff: When I click on the link "ReportViewer.aspx" IE only
> > shows the reportServer root-directory. And the same thing happens if I
> > create a dumb .aspx-file and put into the reportServer/Pages directory.
> >
> > The installation has been hellish so far, and I have read SO many blogs
> > and tips but nothing works...
> >
> > * Yes, I have tried to turn off database snapshot isolation level for the
> > SSRS-databases
> > * Yes, I have installed Service Pack 2 (twice)
> >
> > Im hoping for your help, as I see no path to a solution for this mystery!
> >
> > Cheers David
>
>
Sunday, March 11, 2012
Cannot use TCP of SQL Server Client.
machine and separate by a firewall.
Recently, I need to disable name-pipe protocol in our SQL
client of webserver. But the TCP/IP not work, even I
opened the port 1433 of this.
I've a test that I release all port for that and set the
client network setting to use TCP IP only. It still not
work.
Please help.
(P.S: if I added Name-pipe in network config. of client,
it request port 445 & 139 on the firewall. Is it correct
response? I afraid we are under attack)Things to test.
1. Can you make a tcp socket connection to the server inside the firewall?
Test with ISQL.
ISQL -Stcp:ServerNameHere -Uuser -Ppassword -Q"select @.@.version"
If it fails, search on the OS error returned.
Example:
10060 is connection timeout
10061 is the server is not listening on the socket.
11001 host not found
If it works inside the firewall, try the same on the machine outside the
firewall.
Check the firewall logs.
Or make simultaneous network traces on both the client and server when
running the ISQL command above.
Hope this helps.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.
Sunday, February 12, 2012
Cannot retrieve data in utf-8 from php
I have a IIS server with php3 installed. I have SQL server database
and data stored in unicode format (nvarchar fields). In header of my
php I have the meta: <meta HTTP-EQUIV="content-type"
CONTENT="text/html; charset=UTF-8">.
I have the following problem:
- I trie to do a query using ODBC (version 3.525.1022.0) and SQL
Server odbc driver (version 200.85.1022.00). The query doesn't
retrieve information in utf format and accents and extra characters
aren't showed correctly.
- I trie to di the query usin native OLE DB. I use mssql funtions and
the problem is the same.
If I install php4 and I use "new
COM("ADODB.Connection",NULL,CP_UTF8);", then it works correctly.
Anybody knows if its posible to retrieve data from sql-server in utf-8
format using php3?
I see in other postings that odbc driver only accept utf-8 in version
3.7 or higher? Is it true? If is true, where I can download odbc
driver 3.7?
Thank's in advance.
Miki.Miki (miquelpl2@.hotmail.com) writes:
> I see in other postings that odbc driver only accept utf-8 in version
> 3.7 or higher? Is it true? If is true, where I can download odbc
> driver 3.7?
First, as far as I know, the ODBC driver for SQL Server does not handle
UTF-8 at all, since SQL Server does not support UTF-8, but stores
all Unicode data as UCS-2. See http://support.microsoft.com/?id=232580.
ODBC is part of the MDAC, and with any recently new Windows machine,
you have an MDAC version which includes ODBC 3.7 or later. If you have
some old NT4 platform, you may have to look for something news.
Go to http://www.microsoft.com/downloads/...?displaylang=en,
and pick MDAC. You will have to check the versions that they support
your OS.
--
Erland Sommarskog, SQL Server MVP, sommar@.algonet.se
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp