Post reply

question about configuring SQL 2005 Reporting Services

  • October 11, 2007 at 1:28 pm

    #118479

    Hi, i'm trying to configure reporting services (on a seperate server from the db server)

    I'm getting this error when trying to make the database connection, and this is even using the sa account for SQL credentials. thanks

    System.Data.SqlClient.SqlException: Could not locate entry in sysdatabases for database 'EdgeSightTempDB'. No entry found with that name. Make sure that the name is entered correctly.

    at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)

    at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)

    at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)

    at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)

    at System.Data.SqlClient.SqlCommand.RunExecuteNonQueryTds(String methodName, Boolean async)

    at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)

    at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()

    at ReportServicesConfigUI.SqlClientTools.SqlTools.ApplyScript(String connectionString, String script)

  • October 12, 2007 at 6:45 am

    #741521

    I didn't know you could actually do this, perhaps you can't! I'm sure a former colleague tried this and decided you couldn't - I'd be interested to know the correct answer - sorry this doesn't help your post.

    [font="Comic Sans MS"]The GrumpyOldDBA[/font]
    www.grumpyolddba.co.uk
    http://sqlblogcasts.com/blogs/grumpyolddba/

  • October 12, 2007 at 6:53 am

    #741526

    Please find a very good article on Reporting Services Installation and configuration at http://www.informit.com/articles/article.aspx?p=357694&seqNum=6

    Prasad Bhogadi
    www.inforaise.com

  • October 12, 2007 at 9:00 am

    #741608

    This might help -

    Troubleshooting Server and Database Connection Problems

    http://technet.microsoft.com/en-us/library/ms156468.aspx

    Tommy

    Follow @sqlscribe

  • October 12, 2007 at 9:33 am

    #741645

    Well while configuring you can also script the portion. Try scripting it out and then run it.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply