Need to Connect to SQL Server via TCP - Resources?

I need to create my own SQL Client and am looking for resources on the
protocol used to communicate to the Server via port 1433.
Any info would be helpful...
Thank you,
Scott<-Hi
SQL Server uses TDS (Tabular Data Stream). The on-the-wire protocol details
are available to 3rd party vendors, but there is no public documentation of
it.
Regards
Michel Epprecht
This posting is provided "AS IS" with no warranties, and confers no rights.
"Scott Townsend" <scott-i@..-N0-SPAMplease.enm.com> wrote in message
news:O1Ha12ROHHA.3668@.TK2MSFTNGP02.phx.gbl...
>I need to create my own SQL Client and am looking for resources on the
>protocol used to communicate to the Server via port 1433.
> Any info would be helpful...
> Thank you,
> Scott<-
>

Need to connect to SQL Server on other side of firewall, listening to a different port

Hi,
I want to communicate to SQL Server through my client. Server is listening
via port 16433 instead of defualt 1433.
And this particular server is on the other side of the firewall and it is in
a workgroup. Client Server is in a domain.
I have tried specifying ServerName,PortNo. but it does not work.
Any one know some other way to communicate to this server. Please help.
Thanks
PushkarCan you show us a connection string?
"Pushkar" <tiwaripushkar@.yahoo.co.in> wrote in message
news:OS%23hNh2hFHA.3288@.TK2MSFTNGP09.phx.gbl...
> Hi,
> I want to communicate to SQL Server through my client. Server is listening
> via port 16433 instead of defualt 1433.
> And this particular server is on the other side of the firewall and it is
in
> a workgroup. Client Server is in a domain.
> I have tried specifying ServerName,PortNo. but it does not work.
> Any one know some other way to communicate to this server. Please help.
> Thanks
> Pushkar
>|||Hi,
I am trying to connect through enterprise browser. And while registering for
the server I am giving server name as
"MyServer,16433"
where 16433 is port on which SQL Server is listening.
Thanks
Pushkar
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:%233IYy92hFHA.2484@.TK2MSFTNGP15.phx.gbl...
> Can you show us a connection string?
> "Pushkar" <tiwaripushkar@.yahoo.co.in> wrote in message
> news:OS%23hNh2hFHA.3288@.TK2MSFTNGP09.phx.gbl...
> in
>|||"Pushkar" <tiwaripushkar@.yahoo.co.in> wrote in message
news:u2to5K3hFHA.1412@.TK2MSFTNGP09.phx.gbl...
> Hi,
> I am trying to connect through enterprise browser. And while registering
> for the server I am giving server name as
> "MyServer,16433"
> where 16433 is port on which SQL Server is listening.
Does the name MyServer resolve on your system? Names must be resolved to IP
addresses (or MAC addresses) using some mechanism, NetBIOS broadcasts, DNS,
WINS -- something. Try pinging it. If you have no reason to believe the
name will resolve, you have no expectation of connectivity with SQL Server.
If you have no mechanism for resolving the name, use the IP address of the
SQL box in place of the name.
Also, are you on the inside of the firewall, or the outside? If you are on
the outside, that port must have been opened by the admin of the firewall.
If you are on the inside, the firewall is *most*likely* not a significant
factor (though that is not exclusively true, a capable firewall can be
configured to block traffic in either direction, it just isn't usually done
that way.)
-Mark

> Thanks
> Pushkar
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:%233IYy92hFHA.2484@.TK2MSFTNGP15.phx.gbl...
>|||Pushkar
Go to the Client Network Utility and create an alias to SQL Server that is
listening 16433 port
Make sure that TCPIP is at begining of the list.
"Pushkar" <tiwaripushkar@.yahoo.co.in> wrote in message
news:u2to5K3hFHA.1412@.TK2MSFTNGP09.phx.gbl...
> Hi,
> I am trying to connect through enterprise browser. And while registering
for
> the server I am giving server name as
> "MyServer,16433"
> where 16433 is port on which SQL Server is listening.
> Thanks
> Pushkar
> "Uri Dimant" <urid@.iscar.co.il> wrote in message
> news:%233IYy92hFHA.2484@.TK2MSFTNGP15.phx.gbl...
is[vbcol=seagreen]
>|||Hi,
Thanks it works by creating alias.
Thanks
Pushkar
"Uri Dimant" <urid@.iscar.co.il> wrote in message
news:OfLT1d3hFHA.1148@.TK2MSFTNGP12.phx.gbl...
> Pushkar
> Go to the Client Network Utility and create an alias to SQL Server that is
> listening 16433 port
> Make sure that TCPIP is at begining of the list.
>
> "Pushkar" <tiwaripushkar@.yahoo.co.in> wrote in message
> news:u2to5K3hFHA.1412@.TK2MSFTNGP09.phx.gbl...
> for
> is
>

Need to access SQL Server 2000 tables

Hello,

I am trying to write a java program that will connect to a SQL Server DB, run some queries, pull some data and try to find some trends in the data.

The problem is that I have a copy of the Database, but I don't have SQL Server. I have been given a backup copy of the database though (SQL Server 2000). I know that in addition to the JDBC driver for SQL Server 2000 I will need something else to be able to access the DB. They have stopped selling SQL Server 2000, also the software tends to be a little expensive.

Is there anything else that I can use that will allow me the functionality of being able to run queries and pull data from the DB using JDBC? Will installing MSDE allow me to do that? Or is there someother software that will allow me to do that? Or do I have no other option except installing SQL Server 2000?

Any help is greatly appreciated.

ThanksHi there,

Will you only be accessing the database for the purposes of reporting (i.e. you won't be changing data and then merging these changes into a master database from which the backup was taken)?

What I would recommend is that you don't use MSDE but you use SQL Server 2005 Express Edition. You can download it here:

Download SQL Server 2005 Express

NB. The download could be quite hefty as you might need to download the .NET Framework 2.0, SQL Server 2005 Express Edition database engine and the Management Studio.

You are able to restore SQL Server 2000 database backups to SQL Server 2005 so what you would do is:

1) Install SQL Server 2005 Express & Management Studio Express (see previous link)

2) Use Management Studio Express to restore the SQL Server 2000 backup (you can do this by creating a new database and then restoring your backup over the top)

3) Download and install the JDBC driver for SQL Server 2005 here:
Download JDBC Driver

4) Write your Java program as required

Well, OK, you don't have to use the JDBC driver as you could also use the JDBC-ODBC bridge which already comes with Java but I'd recommend you use the JDBC driver.

Hope that helps a bit, but sorry if it doesn't

|||Thanks a lot NateV,

I will be using the DB for reporting purposes. I won't be chaning any data on the backend ( no inserts or updates, just selects). I am going to try using SQL Server Express 05 and let you know if it worked.

Thanks Again

Need some help about DTS

I have create a DTS package, This job is fist connect to database, and
then excute a SQL query, then use the VB ActiveX to create a procedure
to store the sql result to a text file. I ran the package there is no
porblem with query.But the second step for output the result to text
file have problem. The test fiel become 200mb big and cannot open. I
would like to know if there something wrong with my programming.
'**********************************************************************
' Visual Basic ActiveX Script
'************************************************************************
Function Main()
On Error Resume Next
Dim strRecord
Dim strEmailBody
Dim objFSO
Dim objStream
Dim objResults
Const OUTPUT_FILE = "c:\CompanyList.txt"
Const fsoForWriting = 2
Set objFSO = CreateObject("Scripting.FileSystemObject")
Set objResults = DTSGlobalVariables("gResults").Value
Set objStream = objFSO.OpenTextFile(OUTPUT_FILE, fsoForWriting, True)
'Loop through the records and output each one
'to a file.
While Not objResults.EOF
strRecord = "Relatiecode #" & objResults.Fields(0).Value & _
"JA/NEE" & objResults.Fields(1).Value
objStream.WriteLine (strRecord)
objStream.WriteBlankLines (1)
objResults.MoveNext
Wend
If Err.Count = 0 Then
Main = DTSTaskExecResult_Success
Else
Main = DTSTaskExecResult_Failure
End If
End FunctionHi
"superbaby@.gmail.com" wrote:
> I have create a DTS package, This job is fist connect to database, and
> then excute a SQL query, then use the VB ActiveX to create a procedure
> to store the sql result to a text file. I ran the package there is no
> porblem with query.But the second step for output the result to text
> file have problem. The test fiel become 200mb big and cannot open. I
> would like to know if there something wrong with my programming.
> '**********************************************************************
> ' Visual Basic ActiveX Script
> '************************************************************************
> Function Main()
> On Error Resume Next
> Dim strRecord
> Dim strEmailBody
> Dim objFSO
> Dim objStream
> Dim objResults
> Const OUTPUT_FILE = "c:\CompanyList.txt"
> Const fsoForWriting = 2
> Set objFSO = CreateObject("Scripting.FileSystemObject")
> Set objResults = DTSGlobalVariables("gResults").Value
> Set objStream = objFSO.OpenTextFile(OUTPUT_FILE, fsoForWriting, True)
> 'Loop through the records and output each one
> 'to a file.
> While Not objResults.EOF
> strRecord = "Relatiecode #" & objResults.Fields(0).Value & _
> "JA/NEE" & objResults.Fields(1).Value
> objStream.WriteLine (strRecord)
> objStream.WriteBlankLines (1)
> objResults.MoveNext
> Wend
>
> If Err.Count = 0 Then
> Main = DTSTaskExecResult_Success
> Else
> Main = DTSTaskExecResult_Failure
> End If
> End Function
>
You don't seem to be closing the file and setting your cleaning up the
objects by setting them to nothing for examples see
http://www.sqldts.com/303.aspx
I am not sure if it will not solve the problem though!!
John

Need some help about DTS

I have create a DTS package, This job is fist connect to database, and
then excute a SQL query, then use the VB ActiveX to create a procedure
to store the sql result to a text file. I ran the package there is no
porblem with query.But the second step for output the result to text
file have problem. The test fiel become 200mb big and cannot open. I
would like to know if there something wrong with my programming.
'***************************************
*******************************
' Visual Basic ActiveX Script
'***************************************
*********************************
Function Main()
On Error Resume Next
Dim strRecord
Dim strEmailBody
Dim objFSO
Dim objStream
Dim objResults
Const OUTPUT_FILE = "c:\CompanyList.txt"
Const fsoForWriting = 2
Set objFSO = CreateObject("Scripting.FileSystemObject")
Set objResults = DTSGlobalVariables("gResults").Value
Set objStream = objFSO.OpenTextFile(OUTPUT_FILE, fsoForWriting, True)
'Loop through the records and output each one
'to a file.
While Not objResults.EOF
strRecord = "Relatiecode #" & objResults.Fields(0).Value & _
"JA/NEE" & objResults.Fields(1).Value
objStream.WriteLine (strRecord)
objStream.WriteBlankLines (1)
objResults.MoveNext
Wend
If Err.Count = 0 Then
Main = DTSTaskExecResult_Success
Else
Main = DTSTaskExecResult_Failure
End If
End FunctionHi
"superbaby@.gmail.com" wrote:

> I have create a DTS package, This job is fist connect to database, and
> then excute a SQL query, then use the VB ActiveX to create a procedure
> to store the sql result to a text file. I ran the package there is no
> porblem with query.But the second step for output the result to text
> file have problem. The test fiel become 200mb big and cannot open. I
> would like to know if there something wrong with my programming.
> '***************************************
*******************************
> ' Visual Basic ActiveX Script
> '***************************************
*********************************
> Function Main()
> On Error Resume Next
> Dim strRecord
> Dim strEmailBody
> Dim objFSO
> Dim objStream
> Dim objResults
> Const OUTPUT_FILE = "c:\CompanyList.txt"
> Const fsoForWriting = 2
> Set objFSO = CreateObject("Scripting.FileSystemObject")
> Set objResults = DTSGlobalVariables("gResults").Value
> Set objStream = objFSO.OpenTextFile(OUTPUT_FILE, fsoForWriting, True)
> 'Loop through the records and output each one
> 'to a file.
> While Not objResults.EOF
> strRecord = "Relatiecode #" & objResults.Fields(0).Value & _
> "JA/NEE" & objResults.Fields(1).Value
> objStream.WriteLine (strRecord)
> objStream.WriteBlankLines (1)
> objResults.MoveNext
> Wend
>
> If Err.Count = 0 Then
> Main = DTSTaskExecResult_Success
> Else
> Main = DTSTaskExecResult_Failure
> End If
> End Function
>
You don't seem to be closing the file and setting your cleaning up the
objects by setting them to nothing for examples see
http://www.sqldts.com/303.aspx
I am not sure if it will not solve the problem though!!
John

Need simple connect/SQL Select in aspx.vb

I have searched for what I think is a simple solution.

In my aspx.vb code page, I need to make a connection to SQL Server (my connection strings are in the web.config file) and then make a simple SQL Select to return one or 2 values.

For example, the user will select a customer on the ASP form, then I need to read a couple of default values from that user's record and display them back onto the form.

Can someone provide the sample code or direct me to this? I'm thinking that this is rather simple, but I can't seem to make it work. If I see a sample of exactly what I need to do, such as reading a value using the Northwind sample DB, then I can modify it to fit my table structure, etc.

Thank you.

Hi,

Here is a sample code that you can run on a web form which reads an Id value from a textbox and then returns the firstname and lastname of the customer.

PrivateSub Button5_Click(ByVal senderAs System.Object,ByVal eAs System.EventArgs)Handles Button5.ClickDim sqlConnectionStringAsString = System.Configuration.ConfigurationSettings.AppSettings.Get("ConnectionString")Dim sqlConnectionAs SqlClient.SqlConnection =New SqlClient.SqlConnection(sqlConnectionString)Dim sqlCommandAs SqlClient.SqlCommand =New SqlClient.SqlCommand("SELECT FirstName, LastName FROM Customers Where CustomerId = @.CustomerId")Dim sqlParamAs SqlClient.SqlParameter =New SqlClient.SqlParameter("@.CustomerId",CInt(txtCustomerId.Text))

sqlCommand.Parameters.Add(sqlParam)

sqlCommand.Connection = sqlConnection

sqlConnection.Open()

Dim drAs SqlClient.SqlDataReader

dr = sqlCommand.ExecuteReader(CommandBehavior.CloseConnection)

While dr.Read

txtFirstName.Text =

CType(dr.GetValue(dr.GetOrdinal("FirstName")),String)

txtLastName.Text =

CType(dr.GetValue(dr.GetOrdinal("LastName")),String)EndWhile

dr.Close()

EndSub

You can use the below line of code to get the connection string from the web.config file

System.Configuration.ConfigurationSettings.AppSettings.Get("ConnectionString")

You should have placed the below configuration declaration within the configuration tags (<configuration></configuration>)

<appSettings><addkey="ConnectionString"value="..."/></appSettings>

Eralper

http://www.kodyaz.com

|||

How come my intellisense does not automatically pop-up the wording 'SqlClient...' in my dim statements. Nothing seems to be wrong with my set up as I have been working fine for months, but now that I am trying to ad-hoc querries I don't have access to these facilities..

Dim sqlConnectionAsSqlClient.SqlConnection =New SqlClient.SqlConnection(sqlConnectionString)Dim sqlCommandAsSqlClient.SqlCommand =New SqlClient.SqlCommand("SELECT FirstName, LastName FROM Customers Where CustomerId = @.CustomerId")Dim sqlParamAsSqlClient.SqlParameter =New SqlClient.SqlParameter("@.CustomerId",CInt(txtCustomerId.Text))

|||

Never mind, I just had to add

Imports System.Data

Imports System.Data.SqlClient

Need Setup Help: "The ReportServerVirtualDirectory element is missing"

I am getting setup problems with Reporting Services 2005.

When I try to connect through SQL Server Management Studio, the browser in the connect dialog can see the Reporting Services 2005 instance, but when I try to connect, I get an error dialog with the message, "The Report Services instance could not be found (Microsoft.SqlServer.Management.UI.RSClient)"

I manually setup ReportServer and ReportManageer virtual directories in IIS to point to the corresponding directories within the Reporting Services installation. Was I supposed to do this manually? Was the installer supposed to set this up?

Anyway, when I browse to http://localhost/ReportServer/ I get:

* The report server has encountered a configuration error. See the report server log files for more information. (rsServerConfigurationError)
o Access to the path 'C:\Program Files\Microsoft SQL Server\MSSQL.4\Reporting Services\ReportServer\RSReportServer.config' is denied.

When I browse to http://localhost/ReportManager/ I get:

An error occurred while parsing the configuration file. The ReportServerVirtualDirectory element is missing.

Anyone know what I'm doing wrong and what I can do to fix?

RS 2005 comes with a Configuration Tool that creates the virtual directories, connects to the repository, updates the config files etc...

Find it at Start -> All Programs -> Microsoft SQL Server 2005 -> Configuration Tools -> Reporting Services Configuration

|||Bingo. That did it. Thanks Adam!
|||

Hi, can you help me with this?

I still having this error and when I go to "Reporting Services Configuration" everything is OK with a green check, but the "Report Manager Virtua Directory" still appears with a Red X indicating that is "Not Configured", I push the New Button, and I get no errors in the "Task Status", it says the virtual directory was created and asigned, but the Red X is still there.

I later delete the vortual directory in the IIS Console and created, but is the same, I already tried changing the name os the virtual directory wne I press the new button, but nothing seems to work.

I've searched for this, but this is the only sites that appears.

Can you help me?

If you need something like a screen shot, just mail me!

Thanks!

|||

hi Abasilis.

Look at "Report Server Virtual Directory" above the "Report Manager Virtual Directory". That's probably not configured which is why you have that red x. Set that up and the red 'x' will go away.

|||Yes, you are right. I have the same problem and it is fixed now. Thanks.|||

Well, this is not the problem. but I resolved, because I formatted the Laptop because I had another problems with my sound card and my wireless network card. Problem solved, but I have to reinstalled 3 times, because each time appears a diferent error. That happens when you use a free product, because I installed SQL Server 2005 and in the first installation of the report services everythig works fine.

Thanks anyway..

|||

Try looking in the file "C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\Reports\RSWebApplication.config"

for this line:

<ReportServerVirtualDirectory>?</ReportServerVirtualDirectory>

Is there no text where the ?'s are? If there is text, is it the correct name for the ReportServer virtual directory?

In my case, for some reason it was empty, there was no text where the ?'s are. When I filled in the text "ReportServer" (without the quotes) in that spot, then refreshed the browser-window that had the error "An error occurred while parsing the configuration file. The ReportServerVirtualDirectory element is missing.", the error went away and instead the normal Report Manager home web page showed up. In my case, no amount of playing with the configuration tool solved this, but this manual intervention did.

Good luck.

|||

DanaLive,

I had the same problem and added the text as you suggested to fix the problem.

I also noticed right above the virtual directory tag is a URL tag. Does anyone know if this should be set as well?

Code Snippet

<Configuration>
<UI>
<ReportServerUrl></ReportServerUrl>
<ReportServerVirtualDirectory>ReportServer</ReportServerVirtualDirectory>
<ReportBuilderTrustLevel>FullTrust</ReportBuilderTrustLevel>
</UI>

Thanks,

Johnny

|||Brilliant, thank you!|||This is just a pointer for the report manager to know where to look for the server, so if they're on different machines or of you are usiong HTTPS to secure the server you need to populate it, otherwise you shouldn't need to.|||

Thanks everyone for the information. However I still had a problem with getting Reporting Services to work. Here is what fixed it for me:

Under Web Service Identity, Select the Drop Down for Report Server and Report Manager and change the Default AppPool to RS.Net.0AppPool.

This corrected the errors I was having, hope this helps.

|||Changing the app pool has fixed the issue because it probably runs under a different identity to the original one i.e. an account that matches the rs service.|||

I'm also installing new and this fix also worked for me. Man I'm glad I found MSDN. I tried support.microsoft.com for this error and no luck.

I suspect this problem originally occurred because I did the Report Server Configuration and IIS was not running.

Need Setup Help: "The ReportServerVirtualDirectory element is missing"

I am getting setup problems with Reporting Services 2005.

When I try to connect through SQL Server Management Studio, the browser in the connect dialog can see the Reporting Services 2005 instance, but when I try to connect, I get an error dialog with the message, "The Report Services instance could not be found (Microsoft.SqlServer.Management.UI.RSClient)"

I manually setup ReportServer and ReportManageer virtual directories in IIS to point to the corresponding directories within the Reporting Services installation. Was I supposed to do this manually? Was the installer supposed to set this up?

Anyway, when I browse to http://localhost/ReportServer/ I get:

* The report server has encountered a configuration error. See the report server log files for more information. (rsServerConfigurationError)
o Access to the path 'C:\Program Files\Microsoft SQL Server\MSSQL.4\Reporting Services\ReportServer\RSReportServer.config' is denied.

When I browse to http://localhost/ReportManager/ I get:

An error occurred while parsing the configuration file. The ReportServerVirtualDirectory element is missing.

Anyone know what I'm doing wrong and what I can do to fix?

RS 2005 comes with a Configuration Tool that creates the virtual directories, connects to the repository, updates the config files etc...

Find it at Start -> All Programs -> Microsoft SQL Server 2005 -> Configuration Tools -> Reporting Services Configuration

|||Bingo. That did it. Thanks Adam!|||

Hi, can you help me with this?

I still having this error and when I go to "Reporting Services Configuration" everything is OK with a green check, but the "Report Manager Virtua Directory" still appears with a Red X indicating that is "Not Configured", I push the New Button, and I get no errors in the "Task Status", it says the virtual directory was created and asigned, but the Red X is still there.

I later delete the vortual directory in the IIS Console and created, but is the same, I already tried changing the name os the virtual directory wne I press the new button, but nothing seems to work.

I've searched for this, but this is the only sites that appears.

Can you help me?

If you need something like a screen shot, just mail me!

Thanks!

|||

hi Abasilis.

Look at "Report Server Virtual Directory" above the "Report Manager Virtual Directory". That's probably not configured which is why you have that red x. Set that up and the red 'x' will go away.

|||Yes, you are right. I have the same problem and it is fixed now. Thanks.|||

Well, this is not the problem. but I resolved, because I formatted the Laptop because I had another problems with my sound card and my wireless network card. Problem solved, but I have to reinstalled 3 times, because each time appears a diferent error. That happens when you use a free product, because I installed SQL Server 2005 and in the first installation of the report services everythig works fine.

Thanks anyway..

|||

Try looking in the file "C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\Reports\RSWebApplication.config"

for this line:

<ReportServerVirtualDirectory>?</ReportServerVirtualDirectory>

Is there no text where the ?'s are? If there is text, is it the correct name for the ReportServer virtual directory?

In my case, for some reason it was empty, there was no text where the ?'s are. When I filled in the text "ReportServer" (without the quotes) in that spot, then refreshed the browser-window that had the error "An error occurred while parsing the configuration file. The ReportServerVirtualDirectory element is missing.", the error went away and instead the normal Report Manager home web page showed up. In my case, no amount of playing with the configuration tool solved this, but this manual intervention did.

Good luck.

|||

DanaLive,

I had the same problem and added the text as you suggested to fix the problem.

I also noticed right above the virtual directory tag is a URL tag. Does anyone know if this should be set as well?

Code Snippet

<Configuration>
<UI>
<ReportServerUrl></ReportServerUrl>
<ReportServerVirtualDirectory>ReportServer</ReportServerVirtualDirectory>
<ReportBuilderTrustLevel>FullTrust</ReportBuilderTrustLevel>
</UI>

Thanks,

Johnny

|||Brilliant, thank you!|||This is just a pointer for the report manager to know where to look for the server, so if they're on different machines or of you are usiong HTTPS to secure the server you need to populate it, otherwise you shouldn't need to.|||

Thanks everyone for the information. However I still had a problem with getting Reporting Services to work. Here is what fixed it for me:

Under Web Service Identity, Select the Drop Down for Report Server and Report Manager and change the Default AppPool to RS.Net.0AppPool.

This corrected the errors I was having, hope this helps.

|||Changing the app pool has fixed the issue because it probably runs under a different identity to the original one i.e. an account that matches the rs service.|||

I'm also installing new and this fix also worked for me. Man I'm glad I found MSDN. I tried support.microsoft.com for this error and no luck.

I suspect this problem originally occurred because I did the Report Server Configuration and IIS was not running.

Need Setup Help: "The ReportServerVirtualDirectory element is missing"

I am getting setup problems with Reporting Services 2005.

When I try to connect through SQL Server Management Studio, the browser in the connect dialog can see the Reporting Services 2005 instance, but when I try to connect, I get an error dialog with the message, "The Report Services instance could not be found (Microsoft.SqlServer.Management.UI.RSClient)"

I manually setup ReportServer and ReportManageer virtual directories in IIS to point to the corresponding directories within the Reporting Services installation. Was I supposed to do this manually? Was the installer supposed to set this up?

Anyway, when I browse to http://localhost/ReportServer/ I get:

* The report server has encountered a configuration error. See the report server log files for more information. (rsServerConfigurationError)
o Access to the path 'C:\Program Files\Microsoft SQL Server\MSSQL.4\Reporting Services\ReportServer\RSReportServer.config' is denied.

When I browse to http://localhost/ReportManager/ I get:

An error occurred while parsing the configuration file. The ReportServerVirtualDirectory element is missing.

Anyone know what I'm doing wrong and what I can do to fix?

RS 2005 comes with a Configuration Tool that creates the virtual directories, connects to the repository, updates the config files etc...

Find it at Start -> All Programs -> Microsoft SQL Server 2005 -> Configuration Tools -> Reporting Services Configuration

|||Bingo. That did it. Thanks Adam!
|||

Hi, can you help me with this?

I still having this error and when I go to "Reporting Services Configuration" everything is OK with a green check, but the "Report Manager Virtua Directory" still appears with a Red X indicating that is "Not Configured", I push the New Button, and I get no errors in the "Task Status", it says the virtual directory was created and asigned, but the Red X is still there.

I later delete the vortual directory in the IIS Console and created, but is the same, I already tried changing the name os the virtual directory wne I press the new button, but nothing seems to work.

I've searched for this, but this is the only sites that appears.

Can you help me?

If you need something like a screen shot, just mail me!

Thanks!

|||

hi Abasilis.

Look at "Report Server Virtual Directory" above the "Report Manager Virtual Directory". That's probably not configured which is why you have that red x. Set that up and the red 'x' will go away.

|||Yes, you are right. I have the same problem and it is fixed now. Thanks.|||

Well, this is not the problem. but I resolved, because I formatted the Laptop because I had another problems with my sound card and my wireless network card. Problem solved, but I have to reinstalled 3 times, because each time appears a diferent error. That happens when you use a free product, because I installed SQL Server 2005 and in the first installation of the report services everythig works fine.

Thanks anyway..

|||

Try looking in the file "C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\Reports\RSWebApplication.config"

for this line:

<ReportServerVirtualDirectory>?</ReportServerVirtualDirectory>

Is there no text where the ?'s are? If there is text, is it the correct name for the ReportServer virtual directory?

In my case, for some reason it was empty, there was no text where the ?'s are. When I filled in the text "ReportServer" (without the quotes) in that spot, then refreshed the browser-window that had the error "An error occurred while parsing the configuration file. The ReportServerVirtualDirectory element is missing.", the error went away and instead the normal Report Manager home web page showed up. In my case, no amount of playing with the configuration tool solved this, but this manual intervention did.

Good luck.

|||

DanaLive,

I had the same problem and added the text as you suggested to fix the problem.

I also noticed right above the virtual directory tag is a URL tag. Does anyone know if this should be set as well?

Code Snippet

<Configuration>
<UI>
<ReportServerUrl></ReportServerUrl>
<ReportServerVirtualDirectory>ReportServer</ReportServerVirtualDirectory>
<ReportBuilderTrustLevel>FullTrust</ReportBuilderTrustLevel>
</UI>

Thanks,

Johnny

|||Brilliant, thank you!|||This is just a pointer for the report manager to know where to look for the server, so if they're on different machines or of you are usiong HTTPS to secure the server you need to populate it, otherwise you shouldn't need to.|||

Thanks everyone for the information. However I still had a problem with getting Reporting Services to work. Here is what fixed it for me:

Under Web Service Identity, Select the Drop Down for Report Server and Report Manager and change the Default AppPool to RS.Net.0AppPool.

This corrected the errors I was having, hope this helps.

|||Changing the app pool has fixed the issue because it probably runs under a different identity to the original one i.e. an account that matches the rs service.|||

I'm also installing new and this fix also worked for me. Man I'm glad I found MSDN. I tried support.microsoft.com for this error and no luck.

I suspect this problem originally occurred because I did the Report Server Configuration and IIS was not running.

Need Setup Help: "The ReportServerVirtualDirectory element is missing"

I am getting setup problems with Reporting Services 2005.

When I try to connect through SQL Server Management Studio, the browser in the connect dialog can see the Reporting Services 2005 instance, but when I try to connect, I get an error dialog with the message, "The Report Services instance could not be found (Microsoft.SqlServer.Management.UI.RSClient)"

I manually setup ReportServer and ReportManageer virtual directories in IIS to point to the corresponding directories within the Reporting Services installation. Was I supposed to do this manually? Was the installer supposed to set this up?

Anyway, when I browse to http://localhost/ReportServer/ I get:

* The report server has encountered a configuration error. See the report server log files for more information. (rsServerConfigurationError)
o Access to the path 'C:\Program Files\Microsoft SQL Server\MSSQL.4\Reporting Services\ReportServer\RSReportServer.config' is denied.

When I browse to http://localhost/ReportManager/ I get:

An error occurred while parsing the configuration file. The ReportServerVirtualDirectory element is missing.

Anyone know what I'm doing wrong and what I can do to fix?

RS 2005 comes with a Configuration Tool that creates the virtual directories, connects to the repository, updates the config files etc...

Find it at Start -> All Programs -> Microsoft SQL Server 2005 -> Configuration Tools -> Reporting Services Configuration

|||Bingo. That did it. Thanks Adam!
|||

Hi, can you help me with this?

I still having this error and when I go to "Reporting Services Configuration" everything is OK with a green check, but the "Report Manager Virtua Directory" still appears with a Red X indicating that is "Not Configured", I push the New Button, and I get no errors in the "Task Status", it says the virtual directory was created and asigned, but the Red X is still there.

I later delete the vortual directory in the IIS Console and created, but is the same, I already tried changing the name os the virtual directory wne I press the new button, but nothing seems to work.

I've searched for this, but this is the only sites that appears.

Can you help me?

If you need something like a screen shot, just mail me!

Thanks!

|||

hi Abasilis.

Look at "Report Server Virtual Directory" above the "Report Manager Virtual Directory". That's probably not configured which is why you have that red x. Set that up and the red 'x' will go away.

|||Yes, you are right. I have the same problem and it is fixed now. Thanks.|||

Well, this is not the problem. but I resolved, because I formatted the Laptop because I had another problems with my sound card and my wireless network card. Problem solved, but I have to reinstalled 3 times, because each time appears a diferent error. That happens when you use a free product, because I installed SQL Server 2005 and in the first installation of the report services everythig works fine.

Thanks anyway..

|||

Try looking in the file "C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\Reports\RSWebApplication.config"

for this line:

<ReportServerVirtualDirectory>?</ReportServerVirtualDirectory>

Is there no text where the ?'s are? If there is text, is it the correct name for the ReportServer virtual directory?

In my case, for some reason it was empty, there was no text where the ?'s are. When I filled in the text "ReportServer" (without the quotes) in that spot, then refreshed the browser-window that had the error "An error occurred while parsing the configuration file. The ReportServerVirtualDirectory element is missing.", the error went away and instead the normal Report Manager home web page showed up. In my case, no amount of playing with the configuration tool solved this, but this manual intervention did.

Good luck.

|||

DanaLive,

I had the same problem and added the text as you suggested to fix the problem.

I also noticed right above the virtual directory tag is a URL tag. Does anyone know if this should be set as well?

Code Snippet

<Configuration>
<UI>
<ReportServerUrl></ReportServerUrl>
<ReportServerVirtualDirectory>ReportServer</ReportServerVirtualDirectory>
<ReportBuilderTrustLevel>FullTrust</ReportBuilderTrustLevel>
</UI>

Thanks,

Johnny

|||Brilliant, thank you!|||This is just a pointer for the report manager to know where to look for the server, so if they're on different machines or of you are usiong HTTPS to secure the server you need to populate it, otherwise you shouldn't need to.|||

Thanks everyone for the information. However I still had a problem with getting Reporting Services to work. Here is what fixed it for me:

Under Web Service Identity, Select the Drop Down for Report Server and Report Manager and change the Default AppPool to RS.Net.0AppPool.

This corrected the errors I was having, hope this helps.

|||Changing the app pool has fixed the issue because it probably runs under a different identity to the original one i.e. an account that matches the rs service.|||

I'm also installing new and this fix also worked for me. Man I'm glad I found MSDN. I tried support.microsoft.com for this error and no luck.

I suspect this problem originally occurred because I did the Report Server Configuration and IIS was not running.

Need Setup Help: "The ReportServerVirtualDirectory element is missing"

I am getting setup problems with Reporting Services 2005.

When I try to connect through SQL Server Management Studio, the browser in the connect dialog can see the Reporting Services 2005 instance, but when I try to connect, I get an error dialog with the message, "The Report Services instance could not be found (Microsoft.SqlServer.Management.UI.RSClient)"

I manually setup ReportServer and ReportManageer virtual directories in IIS to point to the corresponding directories within the Reporting Services installation. Was I supposed to do this manually? Was the installer supposed to set this up?

Anyway, when I browse to http://localhost/ReportServer/ I get:

* The report server has encountered a configuration error. See the report server log files for more information. (rsServerConfigurationError)
o Access to the path 'C:\Program Files\Microsoft SQL Server\MSSQL.4\Reporting Services\ReportServer\RSReportServer.config' is denied.

When I browse to http://localhost/ReportManager/ I get:

An error occurred while parsing the configuration file. The ReportServerVirtualDirectory element is missing.

Anyone know what I'm doing wrong and what I can do to fix?

RS 2005 comes with a Configuration Tool that creates the virtual directories, connects to the repository, updates the config files etc...

Find it at Start -> All Programs -> Microsoft SQL Server 2005 -> Configuration Tools -> Reporting Services Configuration

|||Bingo. That did it. Thanks Adam!
|||

Hi, can you help me with this?

I still having this error and when I go to "Reporting Services Configuration" everything is OK with a green check, but the "Report Manager Virtua Directory" still appears with a Red X indicating that is "Not Configured", I push the New Button, and I get no errors in the "Task Status", it says the virtual directory was created and asigned, but the Red X is still there.

I later delete the vortual directory in the IIS Console and created, but is the same, I already tried changing the name os the virtual directory wne I press the new button, but nothing seems to work.

I've searched for this, but this is the only sites that appears.

Can you help me?

If you need something like a screen shot, just mail me!

Thanks!

|||

hi Abasilis.

Look at "Report Server Virtual Directory" above the "Report Manager Virtual Directory". That's probably not configured which is why you have that red x. Set that up and the red 'x' will go away.

|||Yes, you are right. I have the same problem and it is fixed now. Thanks.|||

Well, this is not the problem. but I resolved, because I formatted the Laptop because I had another problems with my sound card and my wireless network card. Problem solved, but I have to reinstalled 3 times, because each time appears a diferent error. That happens when you use a free product, because I installed SQL Server 2005 and in the first installation of the report services everythig works fine.

Thanks anyway..

|||

Try looking in the file "C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\Reports\RSWebApplication.config"

for this line:

<ReportServerVirtualDirectory>?</ReportServerVirtualDirectory>

Is there no text where the ?'s are? If there is text, is it the correct name for the ReportServer virtual directory?

In my case, for some reason it was empty, there was no text where the ?'s are. When I filled in the text "ReportServer" (without the quotes) in that spot, then refreshed the browser-window that had the error "An error occurred while parsing the configuration file. The ReportServerVirtualDirectory element is missing.", the error went away and instead the normal Report Manager home web page showed up. In my case, no amount of playing with the configuration tool solved this, but this manual intervention did.

Good luck.

|||

DanaLive,

I had the same problem and added the text as you suggested to fix the problem.

I also noticed right above the virtual directory tag is a URL tag. Does anyone know if this should be set as well?

Code Snippet

<Configuration>
<UI>
<ReportServerUrl></ReportServerUrl>
<ReportServerVirtualDirectory>ReportServer</ReportServerVirtualDirectory>
<ReportBuilderTrustLevel>FullTrust</ReportBuilderTrustLevel>
</UI>

Thanks,

Johnny

|||Brilliant, thank you!|||This is just a pointer for the report manager to know where to look for the server, so if they're on different machines or of you are usiong HTTPS to secure the server you need to populate it, otherwise you shouldn't need to.|||

Thanks everyone for the information. However I still had a problem with getting Reporting Services to work. Here is what fixed it for me:

Under Web Service Identity, Select the Drop Down for Report Server and Report Manager and change the Default AppPool to RS.Net.0AppPool.

This corrected the errors I was having, hope this helps.

|||Changing the app pool has fixed the issue because it probably runs under a different identity to the original one i.e. an account that matches the rs service.|||

I'm also installing new and this fix also worked for me. Man I'm glad I found MSDN. I tried support.microsoft.com for this error and no luck.

I suspect this problem originally occurred because I did the Report Server Configuration and IIS was not running.

Need Setup Help: "The ReportServerVirtualDirectory element is missing"

I am getting setup problems with Reporting Services 2005.

When I try to connect through SQL Server Management Studio, the browser in the connect dialog can see the Reporting Services 2005 instance, but when I try to connect, I get an error dialog with the message, "The Report Services instance could not be found (Microsoft.SqlServer.Management.UI.RSClient)"

I manually setup ReportServer and ReportManageer virtual directories in IIS to point to the corresponding directories within the Reporting Services installation. Was I supposed to do this manually? Was the installer supposed to set this up?

Anyway, when I browse to http://localhost/ReportServer/ I get:

* The report server has encountered a configuration error. See the report server log files for more information. (rsServerConfigurationError)
o Access to the path 'C:\Program Files\Microsoft SQL Server\MSSQL.4\Reporting Services\ReportServer\RSReportServer.config' is denied.

When I browse to http://localhost/ReportManager/ I get:

An error occurred while parsing the configuration file. The ReportServerVirtualDirectory element is missing.

Anyone know what I'm doing wrong and what I can do to fix?

RS 2005 comes with a Configuration Tool that creates the virtual directories, connects to the repository, updates the config files etc...

Find it at Start -> All Programs -> Microsoft SQL Server 2005 -> Configuration Tools -> Reporting Services Configuration

|||Bingo. That did it. Thanks Adam!
|||

Hi, can you help me with this?

I still having this error and when I go to "Reporting Services Configuration" everything is OK with a green check, but the "Report Manager Virtua Directory" still appears with a Red X indicating that is "Not Configured", I push the New Button, and I get no errors in the "Task Status", it says the virtual directory was created and asigned, but the Red X is still there.

I later delete the vortual directory in the IIS Console and created, but is the same, I already tried changing the name os the virtual directory wne I press the new button, but nothing seems to work.

I've searched for this, but this is the only sites that appears.

Can you help me?

If you need something like a screen shot, just mail me!

Thanks!

|||

hi Abasilis.

Look at "Report Server Virtual Directory" above the "Report Manager Virtual Directory". That's probably not configured which is why you have that red x. Set that up and the red 'x' will go away.

|||Yes, you are right. I have the same problem and it is fixed now. Thanks.|||

Well, this is not the problem. but I resolved, because I formatted the Laptop because I had another problems with my sound card and my wireless network card. Problem solved, but I have to reinstalled 3 times, because each time appears a diferent error. That happens when you use a free product, because I installed SQL Server 2005 and in the first installation of the report services everythig works fine.

Thanks anyway..

|||

Try looking in the file "C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\Reports\RSWebApplication.config"

for this line:

<ReportServerVirtualDirectory>?</ReportServerVirtualDirectory>

Is there no text where the ?'s are? If there is text, is it the correct name for the ReportServer virtual directory?

In my case, for some reason it was empty, there was no text where the ?'s are. When I filled in the text "ReportServer" (without the quotes) in that spot, then refreshed the browser-window that had the error "An error occurred while parsing the configuration file. The ReportServerVirtualDirectory element is missing.", the error went away and instead the normal Report Manager home web page showed up. In my case, no amount of playing with the configuration tool solved this, but this manual intervention did.

Good luck.

|||

DanaLive,

I had the same problem and added the text as you suggested to fix the problem.

I also noticed right above the virtual directory tag is a URL tag. Does anyone know if this should be set as well?

Code Snippet

<Configuration>
<UI>
<ReportServerUrl></ReportServerUrl>
<ReportServerVirtualDirectory>ReportServer</ReportServerVirtualDirectory>
<ReportBuilderTrustLevel>FullTrust</ReportBuilderTrustLevel>
</UI>

Thanks,

Johnny

|||Brilliant, thank you!|||This is just a pointer for the report manager to know where to look for the server, so if they're on different machines or of you are usiong HTTPS to secure the server you need to populate it, otherwise you shouldn't need to.|||

Thanks everyone for the information. However I still had a problem with getting Reporting Services to work. Here is what fixed it for me:

Under Web Service Identity, Select the Drop Down for Report Server and Report Manager and change the Default AppPool to RS.Net.0AppPool.

This corrected the errors I was having, hope this helps.

|||Changing the app pool has fixed the issue because it probably runs under a different identity to the original one i.e. an account that matches the rs service.|||

I'm also installing new and this fix also worked for me. Man I'm glad I found MSDN. I tried support.microsoft.com for this error and no luck.

I suspect this problem originally occurred because I did the Report Server Configuration and IIS was not running.

Need Setup Help: "The ReportServerVirtualDirectory element is missing"

I am getting setup problems with Reporting Services 2005.

When I try to connect through SQL Server Management Studio, the browser in the connect dialog can see the Reporting Services 2005 instance, but when I try to connect, I get an error dialog with the message, "The Report Services instance could not be found (Microsoft.SqlServer.Management.UI.RSClient)"

I manually setup ReportServer and ReportManageer virtual directories in IIS to point to the corresponding directories within the Reporting Services installation. Was I supposed to do this manually? Was the installer supposed to set this up?

Anyway, when I browse to http://localhost/ReportServer/ I get:

* The report server has encountered a configuration error. See the report server log files for more information. (rsServerConfigurationError)
o Access to the path 'C:\Program Files\Microsoft SQL Server\MSSQL.4\Reporting Services\ReportServer\RSReportServer.config' is denied.

When I browse to http://localhost/ReportManager/ I get:

An error occurred while parsing the configuration file. The ReportServerVirtualDirectory element is missing.

Anyone know what I'm doing wrong and what I can do to fix?

RS 2005 comes with a Configuration Tool that creates the virtual directories, connects to the repository, updates the config files etc...

Find it at Start -> All Programs -> Microsoft SQL Server 2005 -> Configuration Tools -> Reporting Services Configuration

|||Bingo. That did it. Thanks Adam!|||

Hi, can you help me with this?

I still having this error and when I go to "Reporting Services Configuration" everything is OK with a green check, but the "Report Manager Virtua Directory" still appears with a Red X indicating that is "Not Configured", I push the New Button, and I get no errors in the "Task Status", it says the virtual directory was created and asigned, but the Red X is still there.

I later delete the vortual directory in the IIS Console and created, but is the same, I already tried changing the name os the virtual directory wne I press the new button, but nothing seems to work.

I've searched for this, but this is the only sites that appears.

Can you help me?

If you need something like a screen shot, just mail me!

Thanks!

|||

hi Abasilis.

Look at "Report Server Virtual Directory" above the "Report Manager Virtual Directory". That's probably not configured which is why you have that red x. Set that up and the red 'x' will go away.

|||Yes, you are right. I have the same problem and it is fixed now. Thanks.|||

Well, this is not the problem. but I resolved, because I formatted the Laptop because I had another problems with my sound card and my wireless network card. Problem solved, but I have to reinstalled 3 times, because each time appears a diferent error. That happens when you use a free product, because I installed SQL Server 2005 and in the first installation of the report services everythig works fine.

Thanks anyway..

|||

Try looking in the file "C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\Reports\RSWebApplication.config"

for this line:

<ReportServerVirtualDirectory>?</ReportServerVirtualDirectory>

Is there no text where the ?'s are? If there is text, is it the correct name for the ReportServer virtual directory?

In my case, for some reason it was empty, there was no text where the ?'s are. When I filled in the text "ReportServer" (without the quotes) in that spot, then refreshed the browser-window that had the error "An error occurred while parsing the configuration file. The ReportServerVirtualDirectory element is missing.", the error went away and instead the normal Report Manager home web page showed up. In my case, no amount of playing with the configuration tool solved this, but this manual intervention did.

Good luck.

|||

DanaLive,

I had the same problem and added the text as you suggested to fix the problem.

I also noticed right above the virtual directory tag is a URL tag. Does anyone know if this should be set as well?

Code Snippet

<Configuration>
<UI>
<ReportServerUrl></ReportServerUrl>
<ReportServerVirtualDirectory>ReportServer</ReportServerVirtualDirectory>
<ReportBuilderTrustLevel>FullTrust</ReportBuilderTrustLevel>
</UI>

Thanks,

Johnny

|||Brilliant, thank you!|||This is just a pointer for the report manager to know where to look for the server, so if they're on different machines or of you are usiong HTTPS to secure the server you need to populate it, otherwise you shouldn't need to.|||

Thanks everyone for the information. However I still had a problem with getting Reporting Services to work. Here is what fixed it for me:

Under Web Service Identity, Select the Drop Down for Report Server and Report Manager and change the Default AppPool to RS.Net.0AppPool.

This corrected the errors I was having, hope this helps.

|||Changing the app pool has fixed the issue because it probably runs under a different identity to the original one i.e. an account that matches the rs service.|||

I'm also installing new and this fix also worked for me. Man I'm glad I found MSDN. I tried support.microsoft.com for this error and no luck.

I suspect this problem originally occurred because I did the Report Server Configuration and IIS was not running.

Need Setup Help: "The ReportServerVirtualDirectory element is missing"

I am getting setup problems with Reporting Services 2005.

When I try to connect through SQL Server Management Studio, the browser in the connect dialog can see the Reporting Services 2005 instance, but when I try to connect, I get an error dialog with the message, "The Report Services instance could not be found (Microsoft.SqlServer.Management.UI.RSClient)"

I manually setup ReportServer and ReportManageer virtual directories in IIS to point to the corresponding directories within the Reporting Services installation. Was I supposed to do this manually? Was the installer supposed to set this up?

Anyway, when I browse to http://localhost/ReportServer/ I get:

* The report server has encountered a configuration error. See the report server log files for more information. (rsServerConfigurationError)
o Access to the path 'C:\Program Files\Microsoft SQL Server\MSSQL.4\Reporting Services\ReportServer\RSReportServer.config' is denied.

When I browse to http://localhost/ReportManager/ I get:

An error occurred while parsing the configuration file. The ReportServerVirtualDirectory element is missing.

Anyone know what I'm doing wrong and what I can do to fix?

RS 2005 comes with a Configuration Tool that creates the virtual directories, connects to the repository, updates the config files etc...

Find it at Start -> All Programs -> Microsoft SQL Server 2005 -> Configuration Tools -> Reporting Services Configuration

|||Bingo. That did it. Thanks Adam!
|||

Hi, can you help me with this?

I still having this error and when I go to "Reporting Services Configuration" everything is OK with a green check, but the "Report Manager Virtua Directory" still appears with a Red X indicating that is "Not Configured", I push the New Button, and I get no errors in the "Task Status", it says the virtual directory was created and asigned, but the Red X is still there.

I later delete the vortual directory in the IIS Console and created, but is the same, I already tried changing the name os the virtual directory wne I press the new button, but nothing seems to work.

I've searched for this, but this is the only sites that appears.

Can you help me?

If you need something like a screen shot, just mail me!

Thanks!

|||

hi Abasilis.

Look at "Report Server Virtual Directory" above the "Report Manager Virtual Directory". That's probably not configured which is why you have that red x. Set that up and the red 'x' will go away.

|||Yes, you are right. I have the same problem and it is fixed now. Thanks.|||

Well, this is not the problem. but I resolved, because I formatted the Laptop because I had another problems with my sound card and my wireless network card. Problem solved, but I have to reinstalled 3 times, because each time appears a diferent error. That happens when you use a free product, because I installed SQL Server 2005 and in the first installation of the report services everythig works fine.

Thanks anyway..

|||

Try looking in the file "C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\Reports\RSWebApplication.config"

for this line:

<ReportServerVirtualDirectory>?</ReportServerVirtualDirectory>

Is there no text where the ?'s are? If there is text, is it the correct name for the ReportServer virtual directory?

In my case, for some reason it was empty, there was no text where the ?'s are. When I filled in the text "ReportServer" (without the quotes) in that spot, then refreshed the browser-window that had the error "An error occurred while parsing the configuration file. The ReportServerVirtualDirectory element is missing.", the error went away and instead the normal Report Manager home web page showed up. In my case, no amount of playing with the configuration tool solved this, but this manual intervention did.

Good luck.

|||

DanaLive,

I had the same problem and added the text as you suggested to fix the problem.

I also noticed right above the virtual directory tag is a URL tag. Does anyone know if this should be set as well?

Code Snippet

<Configuration>
<UI>
<ReportServerUrl></ReportServerUrl>
<ReportServerVirtualDirectory>ReportServer</ReportServerVirtualDirectory>
<ReportBuilderTrustLevel>FullTrust</ReportBuilderTrustLevel>
</UI>

Thanks,

Johnny

|||Brilliant, thank you!|||This is just a pointer for the report manager to know where to look for the server, so if they're on different machines or of you are usiong HTTPS to secure the server you need to populate it, otherwise you shouldn't need to.|||

Thanks everyone for the information. However I still had a problem with getting Reporting Services to work. Here is what fixed it for me:

Under Web Service Identity, Select the Drop Down for Report Server and Report Manager and change the Default AppPool to RS.Net.0AppPool.

This corrected the errors I was having, hope this helps.

|||Changing the app pool has fixed the issue because it probably runs under a different identity to the original one i.e. an account that matches the rs service.|||

I'm also installing new and this fix also worked for me. Man I'm glad I found MSDN. I tried support.microsoft.com for this error and no luck.

I suspect this problem originally occurred because I did the Report Server Configuration and IIS was not running.

need sample code in c# to connect to sql database

hi,
i learn by practice and i would like an asp code using c# that connects to sql database can retrives information from a table.
can you please copy paste me some code or give me exact link a?

thank youHere is a tutorial.

NEED HELP! - Unable to connect to MSDE Database through Web Matrix Project

I'm new to asp.net and databases and I'm currently working my way through SAMs Teach Yourself ASP.
I am up to working with databases and have successfully installed MSDE using the sql2kdesksp3.exe file. However, when I try to create a new database through the web matrix project I get an 'unable to connect' error. I have tried removing and re-installing the database and I've also re-installed it using the latest file from the MS web site but I still get the same error. I've checked the obvious...that the msde service is running, password is correct, and that checks out ok.
Has anyone had a similar problem and resolved it?
Thanks.

Try this link and download the eval edition of SQL Server. Hope this helps.
http://www.microsoft.com/sql/evaluation/trial/default.mspx

|||Works a treat.
Many thanks!