problem while configuring RS using rsconfih utility.

i installed reporting services on the same machine where i insatalled SQl
server. i did some sample reports in visual studio.net 2003. initally when i
try to deploy it,iam getting 'cannot connect to http://localhost/report
server.' one more insteresting thing is when i browse to
http://localhost/reports or reportserver is an stating that ' connot find to
directory /not having permissions.' then i gave some permission set to both
these virtual directory.
and later i try to browse i got a different error --'The report server
cannot open a connection to the report server database. A connection to the
database is required for all requests and processing.
(rsReportServerDatabaseUnavailable) Get Online Help Login failed for user
'MDPMS117591\ASPNET'.--'. then i tried to config using rsconfig utility
providing sql auth ,uid,pwd,dbname,sername.but when i execute rsconfig
command its giving an error that 'No Reporting Services instance found on
localhost.'. What to do Next i don't have any choice,can any one susject me
some thing.
----
--
pammiDid your installation succeed? This seems to look like you didn't actually
have a successful installation.
In your SQL Server, do you have a database named reportserver and another
called reportservertempdb?
In your filesystem, do you have files under c:\program files\sql
server\mssql\reporting services?
-Lukasz
This posting is provided "AS IS" with no warranties, and confers no rights.
"pavan kumar" <pavan.madireddy@.wipro.com> wrote in message
news:643E4551-2C89-4EA0-B2EA-3135FBC11217@.microsoft.com...
>i installed reporting services on the same machine where i insatalled SQl
> server. i did some sample reports in visual studio.net 2003. initally when
> i
> try to deploy it,iam getting 'cannot connect to http://localhost/report
> server.' one more insteresting thing is when i browse to
> http://localhost/reports or reportserver is an stating that ' connot find
> to
> directory /not having permissions.' then i gave some permission set to
> both
> these virtual directory.
> and later i try to browse i got a different error --'The report server
> cannot open a connection to the report server database. A connection to
> the
> database is required for all requests and processing.
> (rsReportServerDatabaseUnavailable) Get Online Help Login failed for user
> 'MDPMS117591\ASPNET'.--'. then i tried to config using rsconfig utility
> providing sql auth ,uid,pwd,dbname,sername.but when i execute rsconfig
> command its giving an error that 'No Reporting Services instance found on
> localhost.'. What to do Next i don't have any choice,can any one susject
> me
> some thing.
> ----
> --
> pammi|||Lukasz, while installation i don't have problems but when i check it now i
don't have those two databases(reportserver and reportservertempdb) and i
have files under c:\program files\sql
> server\mssql\reporting services. Now what to do i have to reinstall it again. And one more thing i forgot to say is my reporting services is an Evaluation Edition which i down loaded from microsoft site.
"Lukasz Pawlowski [MSFT]" wrote:
> Did your installation succeed? This seems to look like you didn't actually
> have a successful installation.
> In your SQL Server, do you have a database named reportserver and another
> called reportservertempdb?
> In your filesystem, do you have files under c:\program files\sql
> server\mssql\reporting services?
> -Lukasz
>
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "pavan kumar" <pavan.madireddy@.wipro.com> wrote in message
> news:643E4551-2C89-4EA0-B2EA-3135FBC11217@.microsoft.com...
> >i installed reporting services on the same machine where i insatalled SQl
> > server. i did some sample reports in visual studio.net 2003. initally when
> > i
> > try to deploy it,iam getting 'cannot connect to http://localhost/report
> > server.' one more insteresting thing is when i browse to
> > http://localhost/reports or reportserver is an stating that ' connot find
> > to
> > directory /not having permissions.' then i gave some permission set to
> > both
> > these virtual directory.
> > and later i try to browse i got a different error --'The report server
> > cannot open a connection to the report server database. A connection to
> > the
> > database is required for all requests and processing.
> > (rsReportServerDatabaseUnavailable) Get Online Help Login failed for user
> > 'MDPMS117591\ASPNET'.--'. then i tried to config using rsconfig utility
> > providing sql auth ,uid,pwd,dbname,sername.but when i execute rsconfig
> > command its giving an error that 'No Reporting Services instance found on
> > localhost.'. What to do Next i don't have any choice,can any one susject
> > me
> > some thing.
> >
> > ----
> >
> > --
> > pammi
>
>|||If you do not have the databases, then the report server will not work.
You will need to reinstall reporting services. Ensure that after setup, the
reportserver service is running in the service control manager. Also ensure
you can access the report server on the virtual directory you specified
during setup,e.g. http://localhost/reportserver (default).
-Lukasz
This posting is provided "AS IS" with no warranties, and confers no rights.
"pavan kumar" <pavan.madireddy@.wipro.com> wrote in message
news:5F564F75-5CF5-4EC7-8DEF-2CA873450D3C@.microsoft.com...
> Lukasz, while installation i don't have problems but when i check it now i
> don't have those two databases(reportserver and reportservertempdb) and i
> have files under c:\program files\sql
>> server\mssql\reporting services. Now what to do i have to reinstall it
>> again. And one more thing i forgot to say is my reporting services is an
>> Evaluation Edition which i down loaded from microsoft site.
>
> "Lukasz Pawlowski [MSFT]" wrote:
>> Did your installation succeed? This seems to look like you didn't
>> actually
>> have a successful installation.
>> In your SQL Server, do you have a database named reportserver and another
>> called reportservertempdb?
>> In your filesystem, do you have files under c:\program files\sql
>> server\mssql\reporting services?
>> -Lukasz
>>
>> --
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "pavan kumar" <pavan.madireddy@.wipro.com> wrote in message
>> news:643E4551-2C89-4EA0-B2EA-3135FBC11217@.microsoft.com...
>> >i installed reporting services on the same machine where i insatalled
>> >SQl
>> > server. i did some sample reports in visual studio.net 2003. initally
>> > when
>> > i
>> > try to deploy it,iam getting 'cannot connect to http://localhost/report
>> > server.' one more insteresting thing is when i browse to
>> > http://localhost/reports or reportserver is an stating that ' connot
>> > find
>> > to
>> > directory /not having permissions.' then i gave some permission set to
>> > both
>> > these virtual directory.
>> > and later i try to browse i got a different error --'The report server
>> > cannot open a connection to the report server database. A connection to
>> > the
>> > database is required for all requests and processing.
>> > (rsReportServerDatabaseUnavailable) Get Online Help Login failed for
>> > user
>> > 'MDPMS117591\ASPNET'.--'. then i tried to config using rsconfig utility
>> > providing sql auth ,uid,pwd,dbname,sername.but when i execute rsconfig
>> > command its giving an error that 'No Reporting Services instance found
>> > on
>> > localhost.'. What to do Next i don't have any choice,can any one
>> > susject
>> > me
>> > some thing.
>> >
>> > ----
>> >
>> > --
>> > pammi
>>|||Thanks Lukasz,
i reistalled it and now its working...
pavan
"Lukasz Pawlowski [MSFT]" wrote:
> If you do not have the databases, then the report server will not work.
> You will need to reinstall reporting services. Ensure that after setup, the
> reportserver service is running in the service control manager. Also ensure
> you can access the report server on the virtual directory you specified
> during setup,e.g. http://localhost/reportserver (default).
> -Lukasz
>
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "pavan kumar" <pavan.madireddy@.wipro.com> wrote in message
> news:5F564F75-5CF5-4EC7-8DEF-2CA873450D3C@.microsoft.com...
> > Lukasz, while installation i don't have problems but when i check it now i
> > don't have those two databases(reportserver and reportservertempdb) and i
> > have files under c:\program files\sql
> >> server\mssql\reporting services. Now what to do i have to reinstall it
> >> again. And one more thing i forgot to say is my reporting services is an
> >> Evaluation Edition which i down loaded from microsoft site.
> >
> >
> > "Lukasz Pawlowski [MSFT]" wrote:
> >
> >> Did your installation succeed? This seems to look like you didn't
> >> actually
> >> have a successful installation.
> >>
> >> In your SQL Server, do you have a database named reportserver and another
> >> called reportservertempdb?
> >>
> >> In your filesystem, do you have files under c:\program files\sql
> >> server\mssql\reporting services?
> >>
> >> -Lukasz
> >>
> >>
> >> --
> >> This posting is provided "AS IS" with no warranties, and confers no
> >> rights.
> >>
> >>
> >>
> >> "pavan kumar" <pavan.madireddy@.wipro.com> wrote in message
> >> news:643E4551-2C89-4EA0-B2EA-3135FBC11217@.microsoft.com...
> >> >i installed reporting services on the same machine where i insatalled
> >> >SQl
> >> > server. i did some sample reports in visual studio.net 2003. initally
> >> > when
> >> > i
> >> > try to deploy it,iam getting 'cannot connect to http://localhost/report
> >> > server.' one more insteresting thing is when i browse to
> >> > http://localhost/reports or reportserver is an stating that ' connot
> >> > find
> >> > to
> >> > directory /not having permissions.' then i gave some permission set to
> >> > both
> >> > these virtual directory.
> >> > and later i try to browse i got a different error --'The report server
> >> > cannot open a connection to the report server database. A connection to
> >> > the
> >> > database is required for all requests and processing.
> >> > (rsReportServerDatabaseUnavailable) Get Online Help Login failed for
> >> > user
> >> > 'MDPMS117591\ASPNET'.--'. then i tried to config using rsconfig utility
> >> > providing sql auth ,uid,pwd,dbname,sername.but when i execute rsconfig
> >> > command its giving an error that 'No Reporting Services instance found
> >> > on
> >> > localhost.'. What to do Next i don't have any choice,can any one
> >> > susject
> >> > me
> >> > some thing.
> >> >
> >> > ----
> >> >
> >> > --
> >> > pammi
> >>
> >>
> >>
>
>

Problem when opening the sql server express in visual web developmer express edition

hi

i download free starter kit timetraker application( i downloaded both Visual web devaloper and sql server express from the Internet)

when i tried to run it it is showing the following error

An error has occurred while establishing a connection tothe server. When connecting to SQL Server 2005, this failure may becaused by the fact that under the default settings SQL Server does notallow remote connections. (provider: Shared Memory Provider, error: 40- Could not open a connection to SQL Server)

plz give me the solution above error

thanks in advance

vittal

The simplest thing have u checked the Sql Server Service is started or not... This is the simplest error which occur... 50% time

Satya

|||

Type inetmgr on run.
select the verual directory -> right click and select property -> go to ASP.NET tab -> click Edit Configuration

and then Edit the connection string accordingly.

Problem when installing MS SQL Reporting Service

Hi,
I need help.
I am trying to install the Reporting Service.
When the screen was in "System Prerequisites Check", it tell me that
visual Studio.NET 2003 is not installed.
After clicking next in "System Prerequisites Check"
It jump to a page called "Welcome to ...SQL Reporting Service SETUP"
and then it automatically jump to a page called "Installing Reporting
Services"
But I haven't selected anything.
Then wait a few minutes, a general error message appears and and tell
me "... was failed to install Reporting Service" with the "Send Report"
and "Don't send" button.
Could anyone get the solution? Thank you very much.I am facing similar problem while installing Reporting Services.
At the "System Prerequisites Check" all checks are OK but at the
"Welcome to Ms SQL Server 2000 Reporting Services Setup" screen I
waited for 10-15 minutes for the NEXT button that never appeared.
Finally, a general error message appears and telling
me "... was failed to install Reporting Service" with the "Send Report"
and "Don't send" button.
Can someone help?|||I have resolved the problem by doing a windows update, shut down all
the active applications. Then proceed with the installation.
Your installer may be corrupted if this doesn't help.

Problem when deploying Reports

Hello, I am working on SQL Server 2005 Reporting Services embedded in the Visual Studio 2005. I ve build reports perefctly, but the problem raised when I tried to deploy this report:

I am deploying these report with a debug configuration , and I have tried with the 2 TargetServerURL:

http://localhost/reportserver$sql2005

http://localhost/reportserver

The Error message is the following:

TITLE: Microsoft Report Designer

A connection could not be made to the report server http://localhost/reportserver$sql2005.

ADDITIONAL INFORMATION:

Client found response content type of 'text/html; charset=utf-8', but expected 'text/xml'.
The request failed with the error message:
--
<html>
<head>
<title>Configuration Error</title>
<style>
body {font-family:"Verdana";font-weight:normal;font-size: .7em;color:black;}
p {font-family:"Verdana";font-weight:normal;color:black;margin-top: -5px}
b {font-family:"Verdana";font-weight:bold;color:black;margin-top: -5px}
H1 { font-family:"Verdana";font-weight:normal;font-size:18pt;color:red }
H2 { font-family:"Verdana";font-weight:normal;font-size:14pt;color:maroon }
pre {font-family:"Lucida Console";font-size: .9em}
.marker {font-weight: bold; color: black;text-decoration: none;}
.version {color: gray;}
.error {margin-bottom: 10px;}
.expandable { text-decoration:underline; font-weight:bold; color:navy; cursor:hand; }
</style>
</head>

<body bgcolor="white">

<span><H1>Server Error in '/' Application.<hr width=100% size=1 color=silver></H1>

<h2> <i>Configuration Error</i> </h2></span>

<font face="Arial, Helvetica, Geneva, SunSans-Regular, sans-serif ">

<b> Description: </b>An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.
<br><br>

<b> Parser Error Message: </b>Could not load type 'Microsoft.Web.Services.ScriptModule'. (c:\inetpub\wwwroot\web.config line 123)<br><br>

<b>Source Error:</b> <br><br>

<table width=100% bgcolor="#ffffcc">
<tr>
<td>
<code><pre>

Line 121: </httpHandlers>
Line 122: <httpModules>
<font color=red>Line 123: <add name="ScriptModule" type="Microsoft.Web.Services.ScriptModule"/>
</font>Line 124: <add name="BridgeModule" type="Microsoft.Web.Services.BridgeModule"/>
Line 125: <add name="WebResourceCompression" type="Microsoft.Web.Services.WebResourceCompressionModule"/></pre></code>

</td>
</tr>
</table>

<br>

<b> Source File: </b> c:\inetpub\wwwroot\web.config<b> Line: </b> 123
<br><br>

<hr width=100% size=1 color=silver>

<b>Version Information:</b> Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.42

</font>

</body>
</html>
<!--
[ConfigurationErrorsException]: Could not load type 'Microsoft.Web.Services.ScriptModule'. (c:\inetpub\wwwroot\web.config line 123) (c:\inetpub\wwwroot\web.config line 123)
at System.Web.Configuration.HttpModuleAction.get_Entry()
at System.Web.Configuration.HttpModulesSection.CreateModules()
at System.Web.HttpApplication.InitModules()
at System.Web.HttpApplication.InitInternal(HttpContext context, HttpApplicationState state, MethodInfo[] handlers)
at System.Web.HttpApplicationFactory.GetNormalApplicationInstance(HttpContext context)
at System.Web.HttpApplicationFactory.GetApplicationInstance(HttpContext context)
at System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr)
-->
--. (Microsoft.ReportingServices.Designer)

BUTTONS:

OK

How Should I proceed to remedy this?

Thanks in advance

make sure report server is running.

please let me know what u r getting when access " http://localhost/reportserver"

|||

Well, when runing the reportServer URL, this error message was displayed

Configuration Error

Description: An error occurred during the processing of a configuration file required to service this request. Please review the specific error details below and modify your configuration file appropriately.

Parser Error Message: Could not load type 'Microsoft.Web.Services.ScriptModule'. (c:\inetpub\wwwroot\web.config line 123)

Source Error:

Line 121:</httpHandlers>

Line 122:<httpModules>

Line 123:<add name="ScriptModule" type="Microsoft.Web.Services.ScriptModule"/>

Line 124:<add name="BridgeModule" type="Microsoft.Web.Services.BridgeModule"/>

Line 125:<add name="WebResourceCompression" type="Microsoft.Web.Services.WebResourceCompressionModule"/>

What Can I do to load this module? Thanks

Problem when adding ssis packages from microsoft visual source safe 6.0

I have created a integration services project on machine A and have added to visual source safe 6.0

When i try to take the project from source safe and store that on a different machine B i have a problem with it....

I check in everything on Machine A

When i try to add on machine B it tries to add it with "Name of package(1)" which means that its adding a copy.But it dosent do for all only for few

Could anyone let me know what the problem is?

Any time you see an unexpected "Name of package(1)" package added to you project, means the folder where the packages are stored already have a file with that name. Depending in how you do it, a file that is not part of the project may still exists in the folder. Use a windows explore to check what I am saying.

Problem when adding ssis packages from microsoft visual source safe 6.0

I have created a integration services project on machine A and have added to visual source safe 6.0

When i try to take the project from source safe and store that on a different machine B i have a problem with it....

I check in everything on Machine A

When i try to add on machine B it tries to add it with "Name of package(1)" which means that its adding a copy.But it dosent do for all only for few

Could anyone let me know what the problem is?

Any time you see an unexpected "Name of package(1)" package added to you project, means the folder where the packages are stored already have a file with that name. Depending in how you do it, a file that is not part of the project may still exists in the folder. Use a windows explore to check what I am saying.

Problem Viewing Reports on Server

Hello, we're having a bit of an issue getting Report Server to display reports. We've published via the web-interface and Visual Studio. After we publish, it gives an error and it looks as if it's trying to find the data source that we used to create the report. We've changed the datasource names to match that of the local machine too. Here's the error...

An error has occurred during report processing.

Cannot create a connection to data source 'LocalDataSourceName'.

Keyword not supported: 'driver'.

Any help would be greatly appreciated. Thank you!

What is the connection string and which data provider are you using? It looks like the data provider can't handle the connection string.|||Problem solved....we were using an invalid connection string. For some reason it was working on one server but not the other. Just tried a different string on both of them and it works great now.

Problem using Visual Studio 2008 Winforms ReportViewer

I have an application built using VS 2008 (3.5 fx). I build a series of
reports (using VS 2005 (sigh)) and am now tryiing to render them using a
Windows form and the ReportViewer control in the VS 2008 app. However I
always get the error message "The source of the report definition has not
been specified" when I execute the line
m_reportViewer.RefreshReport();
When I try to view the very same report in a VS 2005 app it renders without
error. I can also view the report using Report Manager and preview it in the
VS 2005 app I use to build it. Any suggestions?
Thx
Helen
--
Helen Warn, PhD
Agile Software Inc.
www.agile-soft.comNever mind. I added and removed the ReportViewer control a few times,
switching between Versino 8 & Version 9, and finally it worked :)
--
Helen Warn, PhD
Agile Software Inc.
www.agile-soft.com

problem using sql statement in Visual Studio 2005

thanks for read my question.
i have problem when i using sql statement in Visual Studio 2005:
for example:
sp_configure 'show advanced options',1;
GO
RECONFIGURE;
GO
sp_configure 'Ad Hoc Distributed Queries',1;
GO
RECONFIGURE;
GO
with these statement i have put on separate line to exec, but if i but these statement on separate in VS2005 it is failed, what can i do?
how can i run file .sql from VS2005
HOW?
thanks a lot.

use the following statement to execute the .sql file from your sql server..

USE master
GO
EXEC sp_configure 'show advanced options', 1
GO
RECONFIGURE WITH OVERRIDE
GO
EXEC sp_configure 'xp_cmdshell', 1
GO
RECONFIGURE WITH OVERRIDE
GO
EXEC sp_configure 'show advanced options', 0
GO

Exec XP_CmdShell 'sqlcmd -SWXP-J72MM1S\MSSQL2005 -USA -Psqladmin -i"PATH OF THE .SQL FILE"'

|||it return error:

Msg 15281, Level 16, State 1, Procedure xp_cmdshell, Line 1
SQL Server blocked access to procedure 'sys.xp_cmdshell' of component 'xp_cmdshell' because this component is turned off as part of the security configuration for this server. A system administrator can enable the use of 'xp_cmdshell' by using sp_configure. For more information about enabling 'xp_cmdshell', see "Surface Area Configuration" in SQL Server Books Online.

What can i do? how can i solve?
thanks
|||

Before executing the xp_cmdshell you have to change the server config.

USE master
GO
EXEC sp_configure 'show advanced options', 1
GO
RECONFIGURE WITH OVERRIDE
GO
EXEC sp_configure 'xp_cmdshell', 1
GO
RECONFIGURE WITH OVERRIDE
GO
EXEC sp_configure 'show advanced options', 0
GO

To execute the above batch you shoule be a System Admin.

|||thanks for your answer but i can't get my result
it return 6 rows with output

HResult 0xFFFFFFFF, Level 16, State 1
SQL Network Interfaces: Error Locating Server/Instance Specified [xFFFFFFFF].
Sqlcmd: Error: Microsoft SQL Native Client : An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote c
onnections..
Sqlcmd: Error: Microsoft SQL Native Client : Login timeout expired.
NULL

what must i do?|||

The cause may be,

#1. The server is not enabled the Remote Connection (if you are not executing your query from remote server leave this cause and goto #2). To enable the remote login goto Programs -> Microsoft SQL Server 2005 -> Configuration Tools and open the "SQL Server Surface Area Configuration" click the Service & Connections link.

Select the Remote Connections node under the data base engine and check the Local and Remote Connection radio button.

#2. The login you entered is incorrect. don't put more space between your password and -i

sqlcmd -SSERVERNAME -UUSERNAME -PPASSWORD -i"PATH OF THE FILE"