error when i try the link http://localhost/reportserver

Dear All,

i face a problem when i try the link http://localhost/reportserver

an error message appear as the following

The report server has encountered a configuration error. See the report server log files for more information. (rsServerConfigurationError)

Access to the path 'C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer\RSReportServer.config' is denied

and i check the server log file and it is as the following ( i hope anyone help to solve that problem)

<Header>
<Product>Microsoft SQL Server Reporting Services Version 9.00.1399.00</Product>
<Locale>en-US</Locale>
<TimeZone>Egypt Daylight Time</TimeZone>
<Path>C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\LogFiles\ReportServerService__07_30_2007_16_46_58.log</Path>
<SystemName>KKHALIFA-XP-588</SystemName>
<OSName>Microsoft Windows NT 5.1.2600 Service Pack 2</OSName>
<OSVersion>5.1.2600.131072</OSVersion>
</Header>
ReportingServicesService!library!4!7/30/2007-16:46:59:: i INFO: Initializing ConnectionType to '0' as specified in Configuration file.
ReportingServicesService!library!4!7/30/2007-16:46:59:: i INFO: Initializing IsSchedulingService to 'True' as specified in Configuration file.
ReportingServicesService!library!4!7/30/2007-16:46:59:: i INFO: Initializing IsNotificationService to 'True' as specified in Configuration file.
ReportingServicesService!library!4!7/30/2007-16:46:59:: i INFO: Initializing IsEventService to 'True' as specified in Configuration file.
ReportingServicesService!library!4!7/30/2007-16:46:59:: i INFO: Initializing PollingInterval to '10' second(s) as specified in Configuration file.
ReportingServicesService!library!4!7/30/2007-16:46:59:: i INFO: Initializing WindowsServiceUseFileShareStorage to 'False' as specified in Configuration file.
ReportingServicesService!library!4!7/30/2007-16:46:59:: i INFO: Initializing MemoryLimit to '60' percent as specified in Configuration file.
ReportingServicesService!library!4!7/30/2007-16:46:59:: i INFO: Initializing RecycleTime to '720' minute(s) as specified in Configuration file.
ReportingServicesService!library!4!7/30/2007-16:46:59:: i INFO: Initializing MaximumMemoryLimit to '80' percent as specified in Configuration file.
ReportingServicesService!library!4!7/30/2007-16:46:59:: i INFO: Initializing MaxAppDomainUnloadTime to '30' minute(s) as specified in Configuration file.
ReportingServicesService!library!4!7/30/2007-16:46:59:: i INFO: Initializing MaxQueueThreads to '0' thread(s) as specified in Configuration file.
ReportingServicesService!library!4!7/30/2007-16:46:59:: i INFO: Initializing IsWebServiceEnabled to 'True' as specified in Configuration file.
ReportingServicesService!configmanager!4!7/30/2007-16:46:59:: w WARN: WebServiceAccount is not specified in the config file. Using default: KKHALIFA-XP-588\ASPNET
ReportingServicesService!library!4!7/30/2007-16:46:59:: i INFO: Initializing MaxActiveReqForOneUser to '20' requests(s) as specified in Configuration file.
ReportingServicesService!library!4!7/30/2007-16:46:59:: i INFO: Initializing MaxScheduleWait to '5' second(s) as specified in Configuration file.
ReportingServicesService!library!4!7/30/2007-16:46:59:: i INFO: Initializing DatabaseQueryTimeout to '120' second(s) as specified in Configuration file.
ReportingServicesService!library!4!7/30/2007-16:46:59:: i INFO: Initializing ProcessRecycleOptions to '0' as specified in Configuration file.
ReportingServicesService!library!4!7/30/2007-16:46:59:: i INFO: Initializing RunningRequestsScavengerCycle to '60' second(s) as specified in Configuration file.
ReportingServicesService!library!4!7/30/2007-16:46:59:: i INFO: Initializing RunningRequestsDbCycle to '60' second(s) as specified in Configuration file.
ReportingServicesService!library!4!7/30/2007-16:46:59:: i INFO: Initializing RunningRequestsAge to '30' second(s) as specified in Configuration file.
ReportingServicesService!library!4!7/30/2007-16:46:59:: i INFO: Initializing CleanupCycleMinutes to '10' minute(s) as specified in Configuration file.
ReportingServicesService!library!4!7/30/2007-16:46:59:: i INFO: Initializing DailyCleanupMinuteOfDay to default value of '120' minutes since midnight because it was not specified in Configuration file.
ReportingServicesService!library!4!7/30/2007-16:46:59:: i INFO: Initializing WatsonFlags to '1064' as specified in Configuration file.
ReportingServicesService!library!4!7/30/2007-16:46:59:: i INFO: Initializing WatsonDumpOnExceptions to 'Microsoft.ReportingServices.Diagnostics.Utilities.InternalCatalogException,Microsoft.ReportingServices.Modeling.InternalModelingException' as specified in Configuration file.
ReportingServicesService!library!4!7/30/2007-16:46:59:: i INFO: Initializing WatsonDumpExcludeIfContainsExceptions to 'System.Data.SqlClient.SqlException,System.Threading.ThreadAbortException' as specified in Configuration file.
ReportingServicesService!library!4!7/30/2007-16:46:59:: i INFO: Initializing SecureConnectionLevel to '0' as specified in Configuration file.
ReportingServicesService!library!4!7/30/2007-16:46:59:: i INFO: Initializing DisplayErrorLink to 'True' as specified in Configuration file.
ReportingServicesService!library!4!7/30/2007-16:46:59:: i INFO: Initializing WebServiceUseFileShareStorage to 'False' as specified in Configuration file.
ReportingServicesService!resourceutilities!4!7/30/2007-16:46:59:: i INFO: Reporting Services starting SKU: Developer
ReportingServicesService!resourceutilities!4!7/30/2007-16:46:59:: i INFO: Evaluation copy: 0 days left
ReportingServicesService!runningjobs!4!7/30/2007-16:46:59:: i INFO: Database Cleanup (NT Service) timer enabled: Next Event: 600 seconds. Cycle: 600 seconds
ReportingServicesService!runningjobs!4!7/30/2007-16:46:59:: i INFO: Running Requests Scavenger timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
ReportingServicesService!runningjobs!4!7/30/2007-16:46:59:: i INFO: Running Requests DB timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
ReportingServicesService!runningjobs!4!7/30/2007-16:46:59:: i INFO: Execution Log Entry Expiration timer enabled: Next Event: 33180 seconds. Cycle: 86400 seconds
ReportingServicesService!runningjobs!4!7/30/2007-16:46:59:: i INFO: Memory stats update timer enabled: Next Event: 60 seconds. Cycle: 60 seconds
ReportingServicesService!runningjobs!4!7/30/2007-16:46:59:: i INFO: SQM timer timer enabled: Next Event: 36780 seconds. Cycle: 86400 seconds
ReportingServicesService!library!8!7/30/2007-16:47:00:: i INFO: Catalog SQL Server Edition = Developer
ReportingServicesService!library!8!7/30/2007-16:47:00:: e ERROR: Sql errorystem.Data.SqlClient.SqlException: Could not find stored procedure 'GetDBVersion'.
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.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
at System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Microsoft.ReportingServices.Library.InstrumentedSqlCommand.ExecuteNonQuery()
at Microsoft.ReportingServices.Library.ConnectionManager.EnsureCorrectDBVersion()
ReportingServicesService!library!8!7/30/2007-16:47:00:: e ERROR: Throwing Microsoft.ReportingServices.Diagnostics.Utilities.InvalidReportServerDatabaseException: The version of the report server database is either in a format that is not valid, or it cannot be read. The found version is 'Unknown'. The expected version is 'C.0.8.40'. To continue, update the version of the report server database and verify access rights., ;
Info: Microsoft.ReportingServices.Diagnostics.Utilities.InvalidReportServerDatabaseException: The version of the report server database is either in a format that is not valid, or it cannot be read. The found version is 'Unknown'. The expected version is 'C.0.8.40'. To continue, update the version of the report server database and verify access rights.
ReportingServicesService!library!8!7/30/2007-16:47:00:: Exception caught while starting service. Error: Microsoft.ReportingServices.Diagnostics.Utilities.InvalidReportServerDatabaseException: The version of the report server database is either in a format that is not valid, or it cannot be read. The found version is 'Unknown'. The expected version is 'C.0.8.40'. To continue, update the version of the report server database and verify access rights.
at Microsoft.ReportingServices.Library.ConnectionManager.EnsureCorrectDBVersion()
at Microsoft.ReportingServices.Library.ConnectionManager.ConnectStorage()
at Microsoft.ReportingServices.Library.ServiceController.ServiceStartThread()
ReportingServicesService!library!8!7/30/2007-16:47:00:: Attempting to start service again...

http://prologika.com/CS/blogs/blog/archive/2007/07/12/ssrs-setup-woes.aspx

|||

About the Question i had asked ,

i found its solution and know what was the problem,

so i like to share it with You all ,

all i have done is setting the Reporting Services Configuration that was need to be configure

you can find it in the following path:

from the start menu ==> All program ==>Microsoft SQL Server 2005 ==>Configuration Tools ==>Reporting Services Configuration

in my case most of the configration Was invalid and not configure right so i Reconfigure it and then everything is great after that.

Regards,

Maylo

Error when attempt to link to exchange

hello,
I try to add exchange server as linked server in mssql on SBS2003.
I use sp_addlinkedserver :
EXEC sp_addlinkedserver 'exchange',
'Exchange OLE DB provider',
'exoledb.DataSource.1',
'file:\\.\backofficestorage\localhost\public folders
Now when trying to run a query or listing tables in EM I always get the
following error:
Error 7304: A new session on OLE DB-Provider
'exoledb.DataSource.1' could not be created.
OLE DB-Errortrace [OLE/DB Provider 'exoledb.DataSource.1'
IDBCreateSession::CreateSession returned 0x80150804].
Is there anybody out there who could help me;-)
regards
reinhold
1. Have you tried using a UDL connection to connect to the SQL server?
2. Please refer to 287534 PRB: ExOLEDB Provider Cannot Access or Create
Items Remotely http://support.microsoft.com/?id=287534 which explains some
more information.
thanks,
Vikram
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.
|||Thanks Vikram,
I've resolved the problem in the meanwhile.
It was related to casesensitivity. When indicating path to webstorage via
"file://.." path must be casesensitive as it seems.
thanks
reinhold
"Vikram Jayaram [MS]" <vikramj@.online.microsoft.com> wrote in message
news:aAS$ZhobEHA.2880@.cpmsftngxa06.phx.gbl...
> 1. Have you tried using a UDL connection to connect to the SQL server?
> 2. Please refer to 287534 PRB: ExOLEDB Provider Cannot Access or Create
> Items Remotely http://support.microsoft.com/?id=287534 which explains some
> more information.
> thanks,
> Vikram
> Vikram Jayaram
> Microsoft, SQL Server
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.
>

Error when attempt to link to exchange

hello,
I try to add exchange server as linked server in mssql on SBS2003.
I use sp_addlinkedserver :
EXEC sp_addlinkedserver 'exchange',
'Exchange OLE DB provider',
'exoledb.DataSource.1',
'file:\\.\backofficestorage\localhost\public folders
Now when trying to run a query or listing tables in EM I always get the
following error:
Error 7304: A new session on OLE DB-Provider
'exoledb.DataSource.1' could not be created.
OLE DB-Errortrace [OLE/DB Provider 'exoledb.DataSource.1'
IDBCreateSession::CreateSession returned 0x80150804].
Is there anybody out there who could help me;-)
regards
reinhold1. Have you tried using a UDL connection to connect to the SQL server?
2. Please refer to 287534 PRB: ExOLEDB Provider Cannot Access or Create
Items Remotely http://support.microsoft.com/?id=287534 which explains some
more information.
thanks,
Vikram
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.|||Thanks Vikram,
I've resolved the problem in the meanwhile.
It was related to casesensitivity. When indicating path to webstorage via
"file://.." path must be casesensitive as it seems.
thanks
reinhold
"Vikram Jayaram [MS]" <vikramj@.online.microsoft.com> wrote in message
news:aAS$ZhobEHA.2880@.cpmsftngxa06.phx.gbl...
> 1. Have you tried using a UDL connection to connect to the SQL server?
> 2. Please refer to 287534 PRB: ExOLEDB Provider Cannot Access or Create
> Items Remotely http://support.microsoft.com/?id=287534 which explains some
> more information.
> thanks,
> Vikram
> Vikram Jayaram
> Microsoft, SQL Server
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.
>

Error when attempt to link to exchange

hello,
I try to add exchange server as linked server in mssql on SBS2003.
I use sp_addlinkedserver :
EXEC sp_addlinkedserver 'exchange',
'Exchange OLE DB provider',
'exoledb.DataSource.1',
'file:\\.\backofficestorage\localhost\public folders
Now when trying to run a query or listing tables in EM I always get the
following error:
Error 7304: A new session on OLE DB-Provider
'exoledb.DataSource.1' could not be created.
OLE DB-Errortrace [OLE/DB Provider 'exoledb.DataSource.1'
IDBCreateSession::CreateSession returned 0x80150804].
Is there anybody out there who could help me;-)
regards
reinhold1. Have you tried using a UDL connection to connect to the SQL server?
2. Please refer to 287534 PRB: ExOLEDB Provider Cannot Access or Create
Items Remotely http://support.microsoft.com/?id=287534 which explains some
more information.
thanks,
Vikram
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.|||Thanks Vikram,
I've resolved the problem in the meanwhile.
It was related to casesensitivity. When indicating path to webstorage via
"file://.." path must be casesensitive as it seems.
thanks
reinhold
"Vikram Jayaram [MS]" <vikramj@.online.microsoft.com> wrote in message
news:aAS$ZhobEHA.2880@.cpmsftngxa06.phx.gbl...
> 1. Have you tried using a UDL connection to connect to the SQL server?
> 2. Please refer to 287534 PRB: ExOLEDB Provider Cannot Access or Create
> Items Remotely http://support.microsoft.com/?id=287534 which explains some
> more information.
> thanks,
> Vikram
> Vikram Jayaram
> Microsoft, SQL Server
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.
>

Error when "SELECT" statement has conditions

Hi everyone,

I just started in developing applications for PocketPC. I found an example from this webpage link and I tried it out. I have a listbox to display the results.

Dim mySelectQuery As String = "SELECT ID, Name FROM StaffData WHERE Name = 'John'"

Dim myConnection As New SqlServerCe.SqlCeConnection("Data Source = \My Documents\test.sdf")

Dim myCommand As New SqlServerCe.SqlCeCommand(mySelectQuery, myConnection)
myConnection.Open()

Dim myReader As SqlServerCe.SqlCeDataReader
myReader = myCommand.ExecuteReader()

' Always call Read before accessing data.
While myReader.Read()
ListBox1.Items.Add(myReader.GetInt32(0) & " " & myReader.GetString(1))
End While

' always call Close when done reading.
myReader.Close()
' Close the connection when done with it.
myConnection.Close()

The above code gave me an error on the line in red.
But, if I have the query statement without condition:

Dim mySelectQuery As String = "SELECT ID, Name FROM StaffData"

Everything runs fine and my listbox has the data.

Am I doing something wrong?

Regards.

What error are you getting? Since you are new to SQL CE/SQL Mobile development, wrap everything starting with "myConnection.Open()" through the While loop in a Try Catch block. Catch Exception or SqlCeException and use the following code to enumerate the exception:

Public Sub DisplaySQLCEErrors(ByVal ex As SqlCeException)

Dim errorCollection As SqlCeErrorCollection = ex.Errors
Dim bld As New StringBuilder()
Dim inner As Exception = ex.InnerException
Dim err As SqlCeError

For Each err In errorCollection

bld.Append(ControlChars.Lf + " Error Code: " + err.HResult.ToString())
bld.Append(ControlChars.Lf + " Message : " + err.Message)
bld.Append(ControlChars.Lf + " Minor Err.: " + err.NativeError.ToString())
bld.Append(ControlChars.Lf + " Source : " + err.Source)

Dim numPar As Integer
For Each numPar In err.NumericErrorParameters
If (numPar <> 0) Then
bld.Append(ControlChars.Lf + " Num. Par. : " + numPar.ToString())
End If
Next numPar
Dim errPar As String
For Each errPar In err.ErrorParameters
If (errPar <> String.Empty) Then
bld.Append(ControlChars.Lf + " Err. Par. : " + errPar)
End If
Next errPar

MessageBox.Show(bld.ToString(), "SQL Mobile Error")

Next err

End Sub

-Darren Shaffer
.NET Compact Framework MVP

|||Thanks Darren!

Your error display code is awesome!
I've an error saying "The ntext and image data types cannot be used in WHERE, HAVING, GROUP BY, ON, or IN clauses, except when these data types are used with the LIKE or IS NULL predicates."

I guess what I need to do is to change the data type.

But one thing I don't understand is why do I always have to declare like this:

Dim err As SqlServerCe.SqlCeError

instead of:

Dim err As SqlCeError

which I have no clue.

Thanks!|||Apparently your Name column is of type ntext - you should probably change it to nchar or nvarchar.

-Darren Shaffer

Error running script: sp1_serv_uni.sql(1), while installing SP3(sql2ksp3)

Thanks for the reply.
The link which you have given me, I went to that page but
the solution they gave is to install the latest service
pack or a work around solution, I was trying to install
the latest service pack itself not the service pack 1,the
solution they gave is for servive pack 1 not for service
pack 3, so do you have any idea what I should do.
Please mail me a response.
Regards,
Jyotshna.
--Original Message--
this error may occur if the master database files have
been moved from the
orignal installation location.
check the following link:
http://support.microsoft.com/default.aspx?scid=kb;en-
us;Q308753
regards,
Harsh.
"Jyotshna Vonguru" <jyotshna.vonguru@.icn.siemens.com>
wrote in message
news:568701c3e51c$aefe4410$a401280a@.phx.gbl...
Hello,
I am getting an error called:
Error running script: sp1_serv_uni.sql(1), while
installing service pack 3(sql2ksp3).
Could anybody tell me, how to correct this.
Is there anyway.
Please give me a quick solution.
Thank you,
Jyotshna.Please find the corresponding *.out file to see a detailed error mesage.
Thanks,
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.|||I too am getting the same problem.
The *.out file says (1 row affected)
Thats it.
This is driving me made, as I have 3 x 2003 Servers I am building with SQL 2000 on them, and am getting exactly the same error on all 3.|||I'm having the exact same problem.
No one has been able to help me.
Would I be correct in guessing that this is on a Windows 2003 Server, and
its a fresh install of SQL 2000.
Dave.|||What does the sqlstp.log say?
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.

Error running script: sp1_serv_uni.sql(1), while installing SP3(sql2ksp3)

Thanks for the reply.
The link which you have given me, I went to that page but
the solution they gave is to install the latest service
pack or a work around solution, I was trying to install
the latest service pack itself not the service pack 1,the
solution they gave is for servive pack 1 not for service
pack 3, so do you have any idea what I should do.
Please mail me a response.
Regards,
Jyotshna.
--Original Message--
this error may occur if the master database files have
been moved from the
orignal installation location.
check the following link:
http://support.microsoft.com/default.aspx?scid=kb;en-
us;Q308753
regards,
Harsh.
"Jyotshna Vonguru" <jyotshna.vonguru@.icn.siemens.com>
wrote in message
news:568701c3e51c$aefe4410$a401280a@.phx.gbl...
Hello,
I am getting an error called:
Error running script: sp1_serv_uni.sql(1), while
installing service pack 3(sql2ksp3).
Could anybody tell me, how to correct this.
Is there anyway.
Please give me a quick solution.
Thank you,
Jyotshna.Please find the corresponding *.out file to see a detailed error mesage.
Thanks,
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.|||I'm having the exact same problem.
No one has been able to help me.
Would I be correct in guessing that this is on a Windows 2003 Server, and
its a fresh install of SQL 2000.
Dave.|||I too am getting the same problem.
The *.out file says (1 row affected)
Thats it.
This is driving me made, as I have 3 x 2003 Servers I am building with SQL 2
000 on them, and am getting exactly the same error on all 3.|||What does the sqlstp.log say?
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.