Cannot preview/deploy error

When I try to preview a report developed an on XP Pro box with Reporting
Services evaluation installed (Visual Studio 2003), I get a blank screen with
no preview. My SQL statement appears to be fine, because I get no errors
when I execute it on the Data tab, and see the data that should be reported
on.
When I try to deploy the report from within Visual Studio, I get an error
message telling me that "The type initializer for
'Microsoft.ReportingServices.Diagnostics.CatalogItemUrlBuilder' threw an
exception", and nothing gets deployed. Is there any way to get details on
this exception thrown, or a known way to prevent this?
If I upload the .rdl file into the http://localhost/Reports report manager
site manually, the report generates and displays without any kind of errors.Several people have reported this error, but we have never identified the
source. Can you try debugging the Report Designer process? (Attach another
instance of Visual Studio as a debugger, enable catching exceptions and view
the call stack.) Send me a dump of the call stack.
Thanks,
--
Albert Yen
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"B Shaffer" <B Shaffer@.discussions.microsoft.com> wrote in message
news:E6ED9D3F-10A7-49B5-AFD9-D2411E702815@.microsoft.com...
> When I try to preview a report developed an on XP Pro box with Reporting
> Services evaluation installed (Visual Studio 2003), I get a blank screen
> with
> no preview. My SQL statement appears to be fine, because I get no errors
> when I execute it on the Data tab, and see the data that should be
> reported
> on.
> When I try to deploy the report from within Visual Studio, I get an error
> message telling me that "The type initializer for
> 'Microsoft.ReportingServices.Diagnostics.CatalogItemUrlBuilder' threw an
> exception", and nothing gets deployed. Is there any way to get details on
> this exception thrown, or a known way to prevent this?
> If I upload the .rdl file into the http://localhost/Reports report manager
> site manually, the report generates and displays without any kind of
> errors.|||This problem was bizarre - after restarting my PC the following day, the
problems with deploying the reports and previewing reports went away. I've
been able to deploy and preview without any difficulty since.
"Albert Yen [MSFT]" wrote:
> Several people have reported this error, but we have never identified the
> source. Can you try debugging the Report Designer process? (Attach another
> instance of Visual Studio as a debugger, enable catching exceptions and view
> the call stack.) Send me a dump of the call stack.
> Thanks,
> --
> Albert Yen
> SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "B Shaffer" <B Shaffer@.discussions.microsoft.com> wrote in message
> news:E6ED9D3F-10A7-49B5-AFD9-D2411E702815@.microsoft.com...
> > When I try to preview a report developed an on XP Pro box with Reporting
> > Services evaluation installed (Visual Studio 2003), I get a blank screen
> > with
> > no preview. My SQL statement appears to be fine, because I get no errors
> > when I execute it on the Data tab, and see the data that should be
> > reported
> > on.
> >
> > When I try to deploy the report from within Visual Studio, I get an error
> > message telling me that "The type initializer for
> > 'Microsoft.ReportingServices.Diagnostics.CatalogItemUrlBuilder' threw an
> > exception", and nothing gets deployed. Is there any way to get details on
> > this exception thrown, or a known way to prevent this?
> >
> > If I upload the .rdl file into the http://localhost/Reports report manager
> > site manually, the report generates and displays without any kind of
> > errors.
>
>

Cannot Open Database after Publishing

Hi All,

I have developed a database application using c# and SQL Express 2005.

I have coded a connection string that works fine on the development machine but upon publishing to another machine I am getting the following error message:

Cannot open database "name of database" requested by the login. The login failed. Login Failed for user "machine name\user name".

The remote machine has SQL server express installed.

Now on the development machine the machine name and user names are different to that on the remote machine. I am using Windows Auth. The application successfully runs on the remote machine. It even updates the same database (as mentioned in the issue above) on a different form which all connection strings etc were created automatically by c#. I'm pretty new to all this and don't know where to go from here.
Any help would be greatly appritiated.

Thanks
Jon.

Hi,

The error message says that you have Windows Authentication , change it to SQL/Mix Authentication and your application will run.

Refer below links

http://support.microsoft.com/kb/555332

http://hemantgirisgoswami.blogspot.com/2006/11/change-authentication-mode-with.html

And also refer How to enable Remote Connection

blogs.msdn.com/sqlexpress/archive/2005/05/05/415084.aspx

http://support.microsoft.com/kb/914277/en-us

Hemantgiri S. Goswami

|||Thanks. I will give that a try.|||Hi Hemantgiri,

Thanks for the reply. Do I need to change this in SQL Man Studio Express or in my application?

Sorry, I'm new to this

Thanks

Jon|||

Hi,

You need to change this in your SQL Server Properties using SQL Server Management Studio.

1. Open Your SQL Server Management Studio

2. Connect / Login to Server

3. Right Click on the Server Name

4. Click on Properties

5. Select Security

6. Select the option "SQL Server and Windows Authentication Mode" under Server Authentication

7. Click Ok

Hemantgiri S. Goswami

|||Thanks

Cannot get access to my Access 2003 database tables

I developed a database with Access 2003 and everything was working good until my tech came in and reformated my hard drive and install a new Ghost image that met our company standards.

Now I cannot go in and make any changes to any of the tables, queries and forms. All of this started when a new Ghost image was installed on my pc.

The message I get when I try to open my database is "You do not have permission to run "tblSwitchboard." I get the same error message when I try to do anything at all on the database.

I am at a loss as to what to do. Please help.

Hi,

if you are using an access database, you probably should address your question to an access forum. use the MS public access forum to find adqueate answers.

HTH, Jens K. Suessmeyer.

http://www.sqlserver2005.de

Cannot find stored procedure

I developed a ASP.net web application with a MSDE database backend on my laptop(vs.net 2003 XP Pro), then I transferred the website onto a server(Windows Server 2003) and generated a SQL Server 2000 database from the scripts I exported from MSDE(web administrator). The problem I am having is that it can't find any stored procedures. I keep getting errors when logging on, 'Could not find stored procedure "_myProc" '.
Any one with any clues what might be the problem?
Yes I have changed the connection strings.
Thanks in advance
PPerhaps the owner of the SP is not what you expect? I have not used web_administrator, but perhaps it does not prefix SPs scripted with dbo., and so the SPs are owned by a different user.|||My Error, SP is case sensitive and somehow during the transfer of the site and DB one letter in SP name was changed to upper case. Buggered if I know how.
Have a great weekend Doug
Thanks for the help
Pete