Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


Login to reporting services fails

Posted on 2007-10-01
Medium Priority
Last Modified: 2012-06-27
I am trying to deploy a report created using VB Studio 2005.  I get a 'Reporting Serivces Login' screen wanting me to log into the server but no usernames/passwords seem to work.  (I have never used 2005 on this machine)

However, I also have VB Studio 2003 installed and can succesfully deploy reports without this login prompt even showing up.  What am I missing???

Thanks in advance,

Question by:UniqueData
  • 3
  • 2
LVL 14

Expert Comment

ID: 20005402
Suspect that a DSN or connection string is set up in your VB Studio 2003 project, that has thye username and password in it.

It's not there for 2005, so when you try to connect, you're prompted for login.

So, check what connection strings \ DSN both are using.



Author Comment

ID: 20037533
Where do I find the connection strings \ DSN?
LVL 14

Expert Comment

ID: 20076741
DSN in admin tools -> Data Sources

Connection strings are in application code \ configuration files
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.


Author Comment

ID: 20079915
I think I'm missing something.  I don't see 'admin tools'.  As far as connections, the report is connecting to the database (it pulls up in preview mode), I just am asked for a password when deploying and none of the login/passwords I have work.
LVL 14

Expert Comment

ID: 20083980
"However, I also have VB Studio 2003 installed and can succesfully deploy reports without this login prompt even showing up.  What am I missing???"

I'm thinking that VB Studio 2003 has a DSN \ connection string set up that either uses a trusted connection, or has a working username \ password in it, and that VB Studio 2005 doesn't have this set.
LVL 18

Accepted Solution

PFrog earned 2000 total points
ID: 20158943
You cannot use Visual Studio 2005 to publish reports to SQL 2000.
You can use Visual Studio 2003 to publish to SQL 2005; SQL 2005 converts the rdl file format in real time during the publish process.

More info here

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.
Suggested Courses

580 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question