Showing posts with label matrix. Show all posts
Showing posts with label matrix. Show all posts

Sunday, March 11, 2012

"SQL Server does not exist or access denied" error message

Hello!

When I start my .aspx with ASP.NET Web Matrix Server, it work, but when i try to start it with IIS I get error message.

TIA,

Misha

What is your connection string to the database like? Are you using a trusted connection? Is IIS running under a different account than Web Matrix? SQL Server needs to know about which accounts are acceptable.

|||string ConnectionString = "server=SERVER;database=pubs;trusted_connection=true";
SQL is on server PC, Web Matrix on Workstation.

Sunday, February 19, 2012

"Index was out of range" error on a very simple report with one ma

Hello,
I have a very simple report with one matrix setup on a landscape page
orientation. Margins are properly setup. I cannot get this to preview in
Report Designer. What is the solution for this?
Thanks,
SamA couple of questions:
* Do you have Reporting Services SP1 installed?
* Can you post to the newsgroup or send me an RDL that reproduces the
problem?
Ideally the report should work against a sample database (Northwind,
Pubs, or AdventureWorks).
* If you have SP1 installed could you delete the rdl.Data file for this
report and then preview the report?
The rdl.Data files are created in the report project directory.
--
Bruce Johnson [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Sam" <Sam@.discussions.microsoft.com> wrote in message
news:A4F98E05-A7FB-4BAC-81C4-E76685047B10@.microsoft.com...
> Hello,
> I have a very simple report with one matrix setup on a landscape page
> orientation. Margins are properly setup. I cannot get this to preview in
> Report Designer. What is the solution for this?
> Thanks,
> Sam|||* Yes.
* I have recreated the report. It works fine now.
Thanks,
Sam
"Bruce Johnson [MSFT]" wrote:
> A couple of questions:
> * Do you have Reporting Services SP1 installed?
> * Can you post to the newsgroup or send me an RDL that reproduces the
> problem?
> Ideally the report should work against a sample database (Northwind,
> Pubs, or AdventureWorks).
> * If you have SP1 installed could you delete the rdl.Data file for this
> report and then preview the report?
> The rdl.Data files are created in the report project directory.
> --
> Bruce Johnson [MSFT]
> Microsoft SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Sam" <Sam@.discussions.microsoft.com> wrote in message
> news:A4F98E05-A7FB-4BAC-81C4-E76685047B10@.microsoft.com...
> > Hello,
> >
> > I have a very simple report with one matrix setup on a landscape page
> > orientation. Margins are properly setup. I cannot get this to preview in
> > Report Designer. What is the solution for this?
> >
> > Thanks,
> > Sam
>
>