Failed to open a rowset (Crystal Reports)

I am using Visual Studio .NET 2003 and the version of Crystal that comes with it. I have a problem that when a report is displayed and it doesn't have any data I receive the following error message "Failed to open a rowset" and only a blank screen is shown. I need at least the Header labels to show. How can I make it show at least the header labels.Ok, I figured it out. The stored procedure that runs the report gathers data into a temp table. If the there isn't any data it made the report error out. I rewrote the SP to not use a temp table and all is working well.|||hey,
i am having the same problem with Crystal reports.
i have a few Crystal Reports that were being used as stand-alone reports.
Now i would like to develop an application (WITHOUT including the reports into the application) that shows all the reports that are in a specific directory (done!), list all the report names in a listview (done), and when the user clicks on a reportname.... i want the application to open the report.

Currently i have the following code:
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnOK.Click
'Dim report As ReportDocument = New ReportDocument
Dim ReportName As String
ReportName = Me.ListView1.SelectedItems(0).Text
report.Load(ConfigurationSettings.AppSettings("DirPath") & ReportName & ".rpt")
report.SetDatabaseLogon("testLogin", "testPassword")

Dim frm As New frmViewer
frm.Show()
End Sub

I rewrote the SP to not use a temp table and all is working well
how exactly was this done?

Thanks..... i hope you solve my problem!

failed to connect to new instance in MSSQL2005

I tried to connect to a new created instance (specifying server\instance)in
MSSQL2005 server with mangement studio in another mssql2005 server. It show
an error
'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 connections.
(provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instanc
e
Specified) (.Net SqlClient Data Provider)'
I have enabled the TCPIP in configuration manager and with allow remote
access enabled.
Any idea on it? Thanks in advance!Hello,
could be the following:
http://support.microsoft.com/defaul...kb;en-us;307197
regards,
Henk
"stephanie" <stephanie@.discussions.microsoft.com> wrote in message
news:2BD93101-CA8A-47A4-A766-DDC090C9AD5D@.microsoft.com...
>I tried to connect to a new created instance (specifying server\instance)in
> MSSQL2005 server with mangement studio in another mssql2005 server. It
> show
> an error
> '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 connections.
> (provider: SQL Network Interfaces, error: 26 - Error Locating
> Server/Instance
> Specified) (.Net SqlClient Data Provider)'
> I have enabled the TCPIP in configuration manager and with allow remote
> access enabled.
> Any idea on it? Thanks in advance!
>|||Could be blocked by the firewall, particularly if the SQL Server is running
on Windows XP Professional SP1.
Could be unable to get the port number of the named instance because the SQL
Server Browser Service (on the server computer) is not running, or is
blocked by the firewall.
http://msdn2.microsoft.com/en-us/library/ms345318(en-US,SQL.90).aspx has a
step by step review of some common connectivity issues.
--
Rick Byham
MCDBA, MCSE, MCSA
Documentation Manager,
Microsoft, SQL Server Books Online
This posting is provided "as is" with
no warranties, and confers no rights.
"Henk Steunenberg (Ms)" <stjesp@.hotmail.com> wrote in message
news:OFRCwrWLGHA.1180@.TK2MSFTNGP09.phx.gbl...
> Hello,
> could be the following:
> http://support.microsoft.com/defaul...kb;en-us;307197
> regards,
> Henk
> "stephanie" <stephanie@.discussions.microsoft.com> wrote in message
> news:2BD93101-CA8A-47A4-A766-DDC090C9AD5D@.microsoft.com...
>|||Thanks for all's reply.
I have studied through the suggestion material and configured in SQL2005 but
the same error is still occur.
While I telnet to servernname with named instance port #, it success.
Any other advise. Thanks in advance!
"Rick Byham [MS]" wrote:

> Could be blocked by the firewall, particularly if the SQL Server is runnin
g
> on Windows XP Professional SP1.
> Could be unable to get the port number of the named instance because the S
QL
> Server Browser Service (on the server computer) is not running, or is
> blocked by the firewall.
> http://msdn2.microsoft.com/en-us/library/ms345318(en-US,SQL.90).aspx has a
> step by step review of some common connectivity issues.
> --
> Rick Byham
> MCDBA, MCSE, MCSA
> Documentation Manager,
> Microsoft, SQL Server Books Online
> This posting is provided "as is" with
> no warranties, and confers no rights.
> "Henk Steunenberg (Ms)" <stjesp@.hotmail.com> wrote in message
> news:OFRCwrWLGHA.1180@.TK2MSFTNGP09.phx.gbl...
>
>|||I have enabled the service 'SQL Server Browers' and now it works
"stephanie" wrote:
[vbcol=seagreen]
> Thanks for all's reply.
> I have studied through the suggestion material and configured in SQL2005 b
ut
> the same error is still occur.
> While I telnet to servernname with named instance port #, it success.
> Any other advise. Thanks in advance!
> "Rick Byham [MS]" wrote:
>|||Right. The SQL Server Browser Service receives requests for named instances
and responds with the port number that the instance is listening on. Then
the SQL Server Native Client talks directly to the port.
--
Rick Byham
MCDBA, MCSE, MCSA
Documentation Manager,
Microsoft, SQL Server Books Online
This posting is provided "as is" with
no warranties, and confers no rights.
"stephanie" <stephanie@.discussions.microsoft.com> wrote in message
news:146E8DB0-DB1E-4C8B-8DF0-C30737B4692E@.microsoft.com...[vbcol=seagreen]
>I have enabled the service 'SQL Server Browers' and now it works
> "stephanie" wrote:
>|||I have exactly the same problem (see below)
I've enabled TCP/IP, enabled browser service, made sure there is no error in
binding to TCP/IP via the SQL logs. Still I keep getting the same error.
Any clue'
I have the following setup:
1. ASP.NET 2.0 web app hosted on a web server (inetpub directory
hosting physical files of the web site on a different drive name, E:
than the SQL Server Instance, which is on C
2. SQL Server on the same server, with security settings enabling
ASPNET group and groups containing users allowed to interact with the
website added to SQL Server Instance security settings.
3. Impersonation = true, i.e. ASPNET worker process will impersonate
the user who has been authenticated by IIS
I am continiously getting this error:
========================
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
connections. (provider: SQL Network Interfaces, error: 26 - Error
Locating Server/Instance Specified)
The stack trace and event log is at the end of this post.
I tried the following:
1. enabled TCPIP and Pipes for remote connection via the SQL Server
Configuration Manager
2. enabled remote and local connections via the SQL Surface area
Configuration (TCPIP and named pipes)
3. totally disabled the firewall (even if it is enabled, both the
sqlbrowser, and sqlserver are added as exceptions)
4. enabled the SQL Server Browser Service (to start automatically)
I've tried doing everything i came across on the net.
Nobody seems to have a solution but a lot of people have encountered
this problem.
If anybody out there does have a solution, PLEASE reply to this post.
Thanking you in advance
Part of the stack trace:
--
[SqlException (0x80131904): 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 connections. (provider: SQL Network
Interfaces, error: 26 - Error Locating Server/Instance Specified)]
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException
exception, Boolean breakConnection) +734995
System.Data.SqlClient.TdsParser. ThrowExceptionAndWarning(TdsParserStateO
bje
_ct
stateObj) +188
System.Data.SqlClient.TdsParser.Connect(Boolean& useFailoverPartner,
Boolean& failoverDemandDone, String host, String failoverPartner,
String protocol, SqlInternalConnectionTds connHandler, Int64
timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean
integratedSecurity, SqlConnection owningObject, Boolean aliasLookup)
+820
System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnectio
_n
owningObject, SqlConnectionString connectionOptions, String
newPassword, Boolean redirectedUserInstance) +628
System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdenti
_ty
identity, SqlConnectionString connectionOptions, Object providerInfo,
String newPassword, SqlConnection owningObject, Boolean
redirectedUserInstance) +170
System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOpt
_ions
options, Object poolGroupProviderInfo, DbConnectionPool pool,
DbConnection owningConnection) +130
System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConne
_ction
owningConnection, DbConnectionPool pool, DbConnectionOptions options)
+28
System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection
owningObject) +424
System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection
owningObject) +66
System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection
owningObject) +496
Part of the Event Log (Application)
---
Process information:
Process ID: 5600
Process name: w3wp.exe
Account name: EUSRCMW309\IWAM_EUSRCMW309
Exception information:
Exception type: SqlException
Exception message: 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 connections. (provider: SQL Network
Interfaces, error: 26 - Error Locating Server/Instance Specified)
Request information:
Request URL: http://138.85.90.253/psdb/main.aspx
Request path: /psdb/main.aspx
User host address: 138.85.90.253
User: EAMCS\EUSJESadm
Is authenticated: True
Authentication Type: Negotiate
Thread account name: EUSRCMW309\IWAM_EUSRCMW309
"Rick Byham [MS]" wrote:

> Right. The SQL Server Browser Service receives requests for named instance
s
> and responds with the port number that the instance is listening on. Then
> the SQL Server Native Client talks directly to the port.
> --
> Rick Byham
> MCDBA, MCSE, MCSA
> Documentation Manager,
> Microsoft, SQL Server Books Online
> This posting is provided "as is" with
> no warranties, and confers no rights.
> "stephanie" <stephanie@.discussions.microsoft.com> wrote in message
> news:146E8DB0-DB1E-4C8B-8DF0-C30737B4692E@.microsoft.com...
>
>

failed to connect to new instance in MSSQL2005

I tried to connect to a new created instance (specifying server\instance)in
MSSQL2005 server with mangement studio in another mssql2005 server. It show
an error
'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 connections.
(provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance
Specified) (.Net SqlClient Data Provider)'
I have enabled the TCPIP in configuration manager and with allow remote
access enabled.
Any idea on it? Thanks in advance!
Hello,
could be the following:
http://support.microsoft.com/default...b;en-us;307197
regards,
Henk
"stephanie" <stephanie@.discussions.microsoft.com> wrote in message
news:2BD93101-CA8A-47A4-A766-DDC090C9AD5D@.microsoft.com...
>I tried to connect to a new created instance (specifying server\instance)in
> MSSQL2005 server with mangement studio in another mssql2005 server. It
> show
> an error
> '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 connections.
> (provider: SQL Network Interfaces, error: 26 - Error Locating
> Server/Instance
> Specified) (.Net SqlClient Data Provider)'
> I have enabled the TCPIP in configuration manager and with allow remote
> access enabled.
> Any idea on it? Thanks in advance!
>
|||Could be blocked by the firewall, particularly if the SQL Server is running
on Windows XP Professional SP1.
Could be unable to get the port number of the named instance because the SQL
Server Browser Service (on the server computer) is not running, or is
blocked by the firewall.
http://msdn2.microsoft.com/en-us/library/ms345318(en-US,SQL.90).aspx has a
step by step review of some common connectivity issues.
Rick Byham
MCDBA, MCSE, MCSA
Documentation Manager,
Microsoft, SQL Server Books Online
This posting is provided "as is" with
no warranties, and confers no rights.
"Henk Steunenberg (Ms)" <stjesp@.hotmail.com> wrote in message
news:OFRCwrWLGHA.1180@.TK2MSFTNGP09.phx.gbl...
> Hello,
> could be the following:
> http://support.microsoft.com/default...b;en-us;307197
> regards,
> Henk
> "stephanie" <stephanie@.discussions.microsoft.com> wrote in message
> news:2BD93101-CA8A-47A4-A766-DDC090C9AD5D@.microsoft.com...
>
|||Thanks for all's reply.
I have studied through the suggestion material and configured in SQL2005 but
the same error is still occur.
While I telnet to servernname with named instance port #, it success.
Any other advise. Thanks in advance!
"Rick Byham [MS]" wrote:

> Could be blocked by the firewall, particularly if the SQL Server is running
> on Windows XP Professional SP1.
> Could be unable to get the port number of the named instance because the SQL
> Server Browser Service (on the server computer) is not running, or is
> blocked by the firewall.
> http://msdn2.microsoft.com/en-us/library/ms345318(en-US,SQL.90).aspx has a
> step by step review of some common connectivity issues.
> --
> Rick Byham
> MCDBA, MCSE, MCSA
> Documentation Manager,
> Microsoft, SQL Server Books Online
> This posting is provided "as is" with
> no warranties, and confers no rights.
> "Henk Steunenberg (Ms)" <stjesp@.hotmail.com> wrote in message
> news:OFRCwrWLGHA.1180@.TK2MSFTNGP09.phx.gbl...
>
>
|||I have enabled the service 'SQL Server Browers' and now it works
"stephanie" wrote:
[vbcol=seagreen]
> Thanks for all's reply.
> I have studied through the suggestion material and configured in SQL2005 but
> the same error is still occur.
> While I telnet to servernname with named instance port #, it success.
> Any other advise. Thanks in advance!
> "Rick Byham [MS]" wrote:
|||Right. The SQL Server Browser Service receives requests for named instances
and responds with the port number that the instance is listening on. Then
the SQL Server Native Client talks directly to the port.
Rick Byham
MCDBA, MCSE, MCSA
Documentation Manager,
Microsoft, SQL Server Books Online
This posting is provided "as is" with
no warranties, and confers no rights.
"stephanie" <stephanie@.discussions.microsoft.com> wrote in message
news:146E8DB0-DB1E-4C8B-8DF0-C30737B4692E@.microsoft.com...[vbcol=seagreen]
>I have enabled the service 'SQL Server Browers' and now it works
> "stephanie" wrote:

Failed to access IIS metabase?

Please help!

All of sudden, I cannot connect to the reporting services through MS SQL Server management studio. error message is "Failed to access IIS metabase".

As I checked the system:

1. reporting services is working properly (status is "started")

2. cannot access http://localhost/ReportServer$SQL2005 , the same error

3. Run:"C:\>cscript metaacl.vbs IIS://localhost/w3svc", it shows:
Microsoft (R) Windows Script Host Version 5.6
Copyright (C) Microsoft Corporation 1996-2001. All rights reserved.

XP\ASPNET
Access: R E
BUILTIN\Administrators
Access: RWSUED
Everyone
Access: E
XP\VS Developers
Access: RWSUE
XP\ASPNET
Access: R
XP\ASPNET
Access: R

I reinstall IIS and it doesn't work. Please help, thank you so much!

Are you able to access http://localhost/reportserver from IE? Are you able to access any web pages from IE?|||

Thank you for your reply.

The first answer is no, I cannot access http://localhost/reportserver from IE(The instance of SQL server 2005 is "SQL2005".)

The second answer is yes, I can access IIS' default web page and the other web pages.

|||Anybody can help, please?|||

I think you need to figure out what are the required ACLs. Maybe you can start by giving everybody full access. If that works start reducing the permissions.

BTW, I thought the error message would give you more details about what ACLs are missing, but I could be wrong.

|||One more thing, if you uninstalled IIS, you may run into some problem when you try to uninstall RS later on: http://lab.msdn.microsoft.com/productfeedback/viewfeedback.aspx?feedbackid=735b5260-f6bf-4ea5-94b2-6c41ae387a9a

Failed login MyMachine\ASPNET

I just wanted to write a simple WebService to return a dataset.
But when I am trying to debug it under Visual Studio, I get an exception
when calling conn.Open( ). The error message is "Failed to login user
myMachine\ASPNET". What is ASPNET? Why does Visual Studio invent that
account, if it fails to connect to my local MSDE? What can I do about it?
Please, I am not an administrator, so I need every detail.Make sure that you have a right Login as well as check if you have Windows
Authentication only. Change it to Mixed Authentication
"N Thorell" <NThorell@.discussions.microsoft.com> wrote in message
news:06CD83E4-9F83-4BE2-A695-652A7C4A7DF9@.microsoft.com...
> I just wanted to write a simple WebService to return a dataset.
> But when I am trying to debug it under Visual Studio, I get an exception
> when calling conn.Open( ). The error message is "Failed to login user
> myMachine\ASPNET". What is ASPNET? Why does Visual Studio invent
that
> account, if it fails to connect to my local MSDE? What can I do about
it?
> Please, I am not an administrator, so I need every detail.|||The local ASPNET Windows account is created automatically when you install
ASP.NET. This account is used by default as the security context for
ASP.NET applications.
You can either grant ASPNET access to SQL Server or reconfigure ASP.NET to
use a different account. See
http://support.microsoft.com/defaul...kb;en-us;316989 for details
on how to do this.
Hope this helps.
Dan Guzman
SQL Server MVP
"N Thorell" <NThorell@.discussions.microsoft.com> wrote in message
news:06CD83E4-9F83-4BE2-A695-652A7C4A7DF9@.microsoft.com...
>I just wanted to write a simple WebService to return a dataset.
> But when I am trying to debug it under Visual Studio, I get an exception
> when calling conn.Open( ). The error message is "Failed to login user
> myMachine\ASPNET". What is ASPNET? Why does Visual Studio invent
> that
> account, if it fails to connect to my local MSDE? What can I do about
> it?
> Please, I am not an administrator, so I need every detail.

Face problem into Report "ReportViewControl"

We have created report into Sql server 2005 and viewing this from
â'Reportviewcontrolâ' of Visual studio 2005. Now problem is some time report
first page displays only Report header and all data on Second page. Some time
its display report header and report details on same page.
Any one know how to solve this problem
Please help me out from this problem
I have made lots of R&D for it and finally come on conclusion that it is a
bug of control because of following reason
If report page has capacity of 25 records to display then first it tries to
display on single page. Now if we add one record then its display into
another page
In first case when record is too less then its display all record and report
header on same page
In second case if we have more record which can not display together with
Report header on same page then it will display report header only on first
page and report detail row on second page(as its try to fit all record on
single page)
In third case when we have more records which can not fit on single page
then it start to display record from first page (this time it is not possible
to it to fit all record on same page)Sounds alot like you've got the KeepTogether option checked?
Richard
"ecnindia@.newsgroups.nospam"
<ecnindianewsgroupsnospam@.discussions.microsoft.com> wrote in message
news:ED96230E-D761-41DD-9B46-C27C1C2BC883@.microsoft.com...
> We have created report into Sql server 2005 and viewing this from
> "Reportviewcontrol" of Visual studio 2005. Now problem is some time report
> first page displays only Report header and all data on Second page. Some
> time
> its display report header and report details on same page.
> Any one know how to solve this problem
> Please help me out from this problem
> I have made lots of R&D for it and finally come on conclusion that it is a
> bug of control because of following reason
> If report page has capacity of 25 records to display then first it tries
> to
> display on single page. Now if we add one record then its display into
> another page
> In first case when record is too less then its display all record and
> report
> header on same page
> In second case if we have more record which can not display together with
> Report header on same page then it will display report header only on
> first
> page and report detail row on second page(as its try to fit all record on
> single page)
> In third case when we have more records which can not fit on single page
> then it start to display record from first page (this time it is not
> possible
> to it to fit all record on same page)
>|||Thanks Richard
But i have not checked any option like "KeepTogether" or "fit in
one page".
"Richard Coltrane" wrote:
> Sounds alot like you've got the KeepTogether option checked?
> Richard
> "ecnindia@.newsgroups.nospam"
> <ecnindianewsgroupsnospam@.discussions.microsoft.com> wrote in message
> news:ED96230E-D761-41DD-9B46-C27C1C2BC883@.microsoft.com...
> > We have created report into Sql server 2005 and viewing this from
> > "Reportviewcontrol" of Visual studio 2005. Now problem is some time report
> > first page displays only Report header and all data on Second page. Some
> > time
> > its display report header and report details on same page.
> >
> > Any one know how to solve this problem
> > Please help me out from this problem
> >
> > I have made lots of R&D for it and finally come on conclusion that it is a
> > bug of control because of following reason
> >
> > If report page has capacity of 25 records to display then first it tries
> > to
> > display on single page. Now if we add one record then its display into
> > another page
> >
> > In first case when record is too less then its display all record and
> > report
> > header on same page
> >
> > In second case if we have more record which can not display together with
> > Report header on same page then it will display report header only on
> > first
> > page and report detail row on second page(as its try to fit all record on
> > single page)
> >
> > In third case when we have more records which can not fit on single page
> > then it start to display record from first page (this time it is not
> > possible
> > to it to fit all record on same page)
> >
>
>