Error exporting report

Hello

I've developed an ASP.NET WebApplication (VS.NET 2002) with some Crystal Reports in it to report the data.

This reports are automatically exported into a pdf-File (using the Report.Export function)

To give the user the ability to change the language of the WebApp, all the texts are stored in a MS SQL 2000 Database.

I set the Text-Property of the TextObject in the Report with the following code:

Dim TextObjekt As CrystalDecisions.CrystalReports.Engine.TextObject
TextObjekt = Report.ReportDefinition.ReportObjects.Item("Text14")
TextObjekt.Text = Data.Tables(0).Rows(0).Item("TransText") & ":"

I thought this works fine, till I changed the Text in the database.

Examples:

1.) Text in the database = "Mobil 1"
--> The report works fine, the PDF is successfully created and the TextObject shows "Mobil 1:"

2.) Text in the database = "Hello Echo"
--> The Report works and the PDF is created, but the TextObject shows "Hello Ec"

3.) Text in the database = "PSA"
--> Report.Export crashes with the following error:
"Error #5 - Error in file C:\DOKUME~1\STEFAN\ASPNET\LOKALE~1\Temp\temp_c67a4fca-9bd3-4aa6-935b-0ad7a389f034.rpt:
Error found in Export-DLL : \n0\nCrystalDecisions.CrystalReports.Engine"

Has anyone an idea how I can solve this absolutly strange problem?

Thanks and best regards
GulliwahnDoes that PSA have any special charaters?
Do very Database on the Report and try againsql

Error executing SQL Script from VB:NET

Hi.

I have a complete script from a Database.

But when I try to execute this script (script.txt) from VB.NET shows me many errors. Basically, the special caracters (vbreturn, vbtab, etc.)

How execute this script or format the text to generate the database without problems?

Thanks 4all

IF it is a SQL script, you need a SQL interpreter to run the script.

You would use either OSQL.exe or SQLCmd.exe. (Refer to Books Online for complete syntax details.)

OSQL -S servername -U username -P password -i Scriptfile

Similar command line parameters for SQLCmd.exe

|||You could also tell us what the errors are, what VB object you are trying to use, etc. There are lots of different reasons why this won't work, but I am sure that it could be made to work. Using sqlcmd, osql, or isql would be the easiest way to go, (it changes from one version of SQL Server to the next for the past few versions but SQLCMD is just a .NET program running your batches, so we can make it happen if you will describe more about your issues.

Error encountered while executing a UDF

Hi,

I get the following error while trying to execute a UDF.

Msg 6522, Level 16, State 1, Line 1

A .NET Framework error occurred during execution of user defined routine or aggregate 'test':

System.NullReferenceException: Object reference not set to an instance of an object.

System.NullReferenceException:

at SalesCentral_Database.UserDefinedFunctions.udfTest()

My function is defined as follows:

Imports System

Imports System.Data

Imports System.Data.SqlClient

Imports System.Data.SqlTypes

Imports Microsoft.SqlServer.Server

Partial Public Class UserDefinedFunctions

<Microsoft.SqlServer.Server.SqlFunction(DataAccess:=DataAccessKind.Read)> _

Public Shared Function udfTest() As SqlString

SqlContext.Pipe.Send(System.DateTime.Now().ToString())

Dim conn As New SqlConnection("context connection=true")

conn.Open()

Dim cmd As New SqlCommand("SELECT MAX(ACCTPERIOD) FROM TBL_OPPORTUNITY_HIS", conn)

Return New SqlString(cmd.ExecuteScalar().ToString())

End Function

End Class

SQL Server

CREATE ASSEMBLY SalesCentral_Database from '\\isew5l6c\tranf\SFS_Sales\SalesCentral_Database.dll' WITH PERMISSION_SET = SAFE

CREATE FUNCTION test() RETURNS NVARCHAR(10) AS EXTERNAL NAME [SalesCentral_Database].[SalesCentral_Database.UserDefinedFunctions].[udfTest]

SELECT dbo.test()

- Here I get the error mentioned above. Can anyone please tell me what am I missing.

Thanks.

Hi,

This is the same error as in this thread. You should remove the "SqlContext.Pipe.Send..." line from your code. I'm curious what you intent is with that linethe pipe is really to return results from within a stored procedure.

Cheers,
-Isaac

|||Thanks for bringing that to my notice. Sorry it has slipped out of my mind :)

Error during installation

I was installing SQL Server 2005 Standard Edition on Windows 2000 server. During the prerequisites installation .NET 2.0 installed sucessfully but unable to install Microsoft SQL Native Client and produce an error.

Error occurred during installation:

Error 1619 installing Microsoft SQL Native Client. See log file for more detailed information. This installation package could not be opened. Varify that the package exists and that you can access it, or contact the application vendor to valify that this is a valid Windows Installer package.

Log File Errors:

=== Verbose logging started: 7/24/200616:04:11Build type: SHIP UNICODE 3.01.4000.2435Calling process: C:\WINNT\system32\msiexec.exe ===

MSI (c) (04:98) [16:04:11:359]: Resetting cached policy values

MSI (c) (04:98) [16:04:11:359]: Machine policy value 'Debug' is 0

MSI (c) (04:98) [16:04:11:359]: ******* RunEngine:

******* Product: F:\MS SQL Server 2005\Disk 1\setup\sqlncli.msi

******* Action:

******* CommandLine: **********

MSI (c) (04:98) [16:04:11:359]: Client-side and UI is none or basic: Running entire install on the server.

MSI (c) (04:98) [16:04:11:359]: Grabbed execution mutex.

MSI (c) (04:98) [16:04:11:437]: Cloaking enabled.

MSI (c) (04:98) [16:04:11:437]: Attempting to enable all disabled priveleges before calling Install on Server

MSI (c) (04:98) [16:04:11:468]: Incrementing counter to disable shutdown. Counter after increment: 0

MSI (s) (D0:C0) [16:04:11:515]: Grabbed execution mutex.

MSI (s) (D0:C8) [16:04:11:515]: Resetting cached policy values

MSI (s) (D0:C8) [16:04:11:515]: Machine policy value 'Debug' is 0

MSI (s) (D0:C8) [16:04:11:515]: ******* RunEngine:

******* Product: F:\MS SQL Server 2005\Disk 1\setup\sqlncli.msi

******* Action:

******* CommandLine: **********

MSI (s) (D0:C8) [16:04:11:531]: Note: 1: 2203 2: F:\MS SQL Server 2005\Disk 1\setup\sqlncli.msi 3: -2147287037

MSI (s) (D0:C8) [16:04:11:531]: MainEngineThread is returning 3

MSI (c) (04:98) [16:04:11:531]: Decrementing counter to disable shutdown. If counter >= 0, shutdown will be denied.Counter after decrement: -1

MSI (c) (04:98) [16:04:11:531]: MainEngineThread is returning 3

=== Verbose logging stopped: 7/24/200616:04:11 ===

Any ideas. Please help....

Thanks.

Zafar.

Zafar, if you're attempting to install SQL Server 2005 onto Windows Server 2000 via a network share it will not work. You either have to put the CD/DVD directly into the server's reader drive or copy the files from the network share to the local hard drive of the server to perform the installation.sql

error during .NET Remoting

Hi

When I run the reports in my .NET application, I get an error message when I attempt to use .NET remoting while processing a report :

"The type CrystalDecisions.CrystalReports.Engine.FormatEngine in Assembly CrystalDecisions.CrystalReports.Engine, Version=11.2.3300.0, Culture=neutral, PublicKeyToken=692fbea5521e1304 is not marked as serializable."

I checked the net for solution, and the work around for this error message, use Report Web Services, or the Crystal Enterprise Report Application Server (CE RAS) or Crystal Enterprise (CE) .NET SDK in your application.

But this will be a major change in the application.

Has anybody else got the same error and found a simpler solution ?

Thanking in advanceSee if you find answer here
http://support.businessobjects.com/

Error creating control

Hello everybody,
I my asp.net application, when I select a CrystalReportViewer control and put it on my form, it says "Error creating control" and hence I am unable to use it.
Any ideas ??
Thankslooks like ur .NET is corrupted. Try with another language (VB.NET). If it the same u gotta reinstall .NET.

error creating a new pull subscription

Hi

Using RMO, VB.net 2005 and SQL 2005

Trying to create a new pull subscription programatically - merge HTTPS ovfr the internet

Works fine when within out internal network - but when externally there is a problem....

I'm using the code from BOL - using their values - but pretty much cut and pasted.

' Define the Publisher, publication, and databases.
Dim publicationName As String = "AdvWorksSalesOrdersMerge"
Dim publisherName As String = instanceName
Dim subscriberName As String = instanceName
Dim subscriptionDbName As String = "AdventureWorksReplica"
Dim publicationDbName As String = "AdventureWorks"
Dim hostname As String = "adventure-works\garrett1"

'Create connections to the Publisher and Subscriber.
Dim subscriberConn As ServerConnection = New ServerConnection(subscriberName)
Dim publisherConn As ServerConnection = New ServerConnection(publisherName)

' Create the objects that we need.
Dim publication As MergePublication
Dim subscription As MergePullSubscription

Try
' Connect to the Subscriber.
subscriberConn.Connect()

' Ensure that the publication exists and that
' it supports pull subscriptions.
publication = New MergePublication()
publication.Name = publicationName
publication.DatabaseName = publicationDbName
publication.ConnectionContext = publisherConn

This last line gives me an error:

+ InnerException {"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.Exception
The server/instance is obviously the name of the internal server / sql instance

What next - yikes - I've got to deliver this tomorrow

thanks as always.
BruceDoes the publisher allow remote connections as per the error message?

If that is the case, use SAC (Surface Area COnfiguration) to enable the remote connections, recycle the SQL server and try connecting again.

To access it Click on Start-->All Programs-->Microsoft SQL Server-->Configuration Tools-->SQL Server Surface Area Configuration-->Surface Area Configuration for Services and Connections-->DataBase Engine-->Remote Connections-->Local and Remote conenctions-->Using both TCP/IP and named pipes.
Then recycle the server|||

Hi

It was already marked as allowing remote connections, but named pipes was not enabled. I enabled named pipes and restarted but not difference. Looking at the code, I can't really see how it could work !

The sample code seems to assume that the server/instance is reachable from the client (unless I'm missing something) - in order to validate the publication.

Given that we are trying to synch via HTTPS and at this point no mention has been made of the URL, isn't the sample code a little bit wrong - again I'm not having the cleverest of weeks so I may be talking rubbish..

Look forward to your feedback

Bruce

|||When you are trying to create a subscription, it does not go through HTTPS. You need a connection to the publisher to first create the subscription. Only the sync uses HTTPS and the IIS machine. Alternatively you could create subscription by any other means and use HTTPS just for synching.

You could try something else, like creating a publication on the publisher using similar code and see if your connections to the publisher are going through from the machine you are using.|||Hi

So are you saying that if the machine is not on the network / a trusted connection, in order create a subscription then port 1433/1434 will have to be open ?

I hope not.

thanks
Bruce|||

try to set the subscription as anonymous, otherwise, when the sub.create() was called, it will try to connect to the publisher and setup the subscription entry there, hence the error.

sub.SubscriptionType = SubscriptionOption.Anonymous

Hope this helps.

Thanks
Yunwen

|||I can see BOL has been updated recently with this sort of scenario (web synch where the subscriber does not have a trusted connection) - that's great and responsive...

So can I take it when I create the subscription I can set the subscription.syncType to indicate whether I have the initial data ?

Also, one thing I noticed is that after I create the subscription this way (subscriberType being anonymous), that the subscription no longer shows up in the enumeration of the subscriberSubscriptions - is this a bug or is there another way of finding out whether the subscription has been created.....

Dim serverConnection As New ServerConnection(m_subscriberName)serverConnection.Connect()

Dim replicationServer As New ReplicationServer(serverConnection)availableSubscriptions = replicationServer.EnumSubscriberSubscriptions("", Convert.ToInt32(2))

For Each subscriber In availableSubscriptions
... nothing gets returned in the enumeration.....
Next

Thanks again.
Bruce|||

the syncType is actually used to determine if the initial data needed to be downloaded to the subscriber ( please refer to sp_addmergepullsubscription for details ).

regarding with the EnumSubscriberSubscriptions() method, it is equivalent to the sp_MSenumallsubscriptions ( you can give it a try ). if your call this method with the publisher, in this case, you will not get the anonymous subscriptions. you can call this method on a subscriber server to get the info you need. Please let us know if the RMO method returns anything different from what you get from the SP call.

Hope this helps.

Thanks
Yunwen

|||Hi

I ransp_MSenumallsubscriptions on the subscriber and it returned no entries. As did EnumSubscriberSubscriptions()

However, when I was creating the subscription on the internal network and was able to connect to the publisher prior to creating the subscription, then EnumSubscriberSubscriptions() did return the subscription details.....

I am executing this method against the subscriber (as per the code in my previous post)

thanks
Bruce|||

Thanks Bruce for reminding me to take a careful look at your code. This actually turn out to be a bug in replication( at least it is a document bug). For now, you can try to pass in 3 for the subscriptionType in EnumSubscriberSubscriptions() to get the subscription info returned. Similarly, you need to specify @.subscription_type='both' for the SP call.

Sorry for the inconvenience. Please let us know if there is any other issues you encountered in your application.

Thanks again for helping us to make it better.

Yunwen

error creating a new pull subscription

Hi

Using RMO, VB.net 2005 and SQL 2005

Trying to create a new pull subscription programatically - merge HTTPS ovfr the internet

Works fine when within out internal network - but when externally there is a problem....

I'm using the code from BOL - using their values - but pretty much cut and pasted.

' Define the Publisher, publication, and databases.
Dim publicationName As String = "AdvWorksSalesOrdersMerge"
Dim publisherName As String = instanceName
Dim subscriberName As String = instanceName
Dim subscriptionDbName As String = "AdventureWorksReplica"
Dim publicationDbName As String = "AdventureWorks"
Dim hostname As String = "adventure-works\garrett1"

'Create connections to the Publisher and Subscriber.
Dim subscriberConn As ServerConnection = New ServerConnection(subscriberName)
Dim publisherConn As ServerConnection = New ServerConnection(publisherName)

' Create the objects that we need.
Dim publication As MergePublication
Dim subscription As MergePullSubscription

Try
' Connect to the Subscriber.
subscriberConn.Connect()

' Ensure that the publication exists and that
' it supports pull subscriptions.
publication = New MergePublication()
publication.Name = publicationName
publication.DatabaseName = publicationDbName
publication.ConnectionContext = publisherConn

This last line gives me an error:

+ InnerException {"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.Exception
The server/instance is obviously the name of the internal server / sql instance

What next - yikes - I've got to deliver this tomorrow

thanks as always.
BruceDoes the publisher allow remote connections as per the error message?

If that is the case, use SAC (Surface Area COnfiguration) to enable the remote connections, recycle the SQL server and try connecting again.

To access it Click on Start-->All Programs-->Microsoft SQL Server-->Configuration Tools-->SQL Server Surface Area Configuration-->Surface Area Configuration for Services and Connections-->DataBase Engine-->Remote Connections-->Local and Remote conenctions-->Using both TCP/IP and named pipes.
Then recycle the server|||

Hi

It was already marked as allowing remote connections, but named pipes was not enabled. I enabled named pipes and restarted but not difference. Looking at the code, I can't really see how it could work !

The sample code seems to assume that the server/instance is reachable from the client (unless I'm missing something) - in order to validate the publication.

Given that we are trying to synch via HTTPS and at this point no mention has been made of the URL, isn't the sample code a little bit wrong - again I'm not having the cleverest of weeks so I may be talking rubbish..

Look forward to your feedback

Bruce

|||When you are trying to create a subscription, it does not go through HTTPS. You need a connection to the publisher to first create the subscription. Only the sync uses HTTPS and the IIS machine. Alternatively you could create subscription by any other means and use HTTPS just for synching.

You could try something else, like creating a publication on the publisher using similar code and see if your connections to the publisher are going through from the machine you are using.|||Hi

So are you saying that if the machine is not on the network / a trusted connection, in order create a subscription then port 1433/1434 will have to be open ?

I hope not.

thanks
Bruce|||

try to set the subscription as anonymous, otherwise, when the sub.create() was called, it will try to connect to the publisher and setup the subscription entry there, hence the error.

sub.SubscriptionType = SubscriptionOption.Anonymous

Hope this helps.

Thanks
Yunwen

|||I can see BOL has been updated recently with this sort of scenario (web synch where the subscriber does not have a trusted connection) - that's great and responsive...

So can I take it when I create the subscription I can set the subscription.syncType to indicate whether I have the initial data ?

Also, one thing I noticed is that after I create the subscription this way (subscriberType being anonymous), that the subscription no longer shows up in the enumeration of the subscriberSubscriptions - is this a bug or is there another way of finding out whether the subscription has been created.....

Dim serverConnection As New ServerConnection(m_subscriberName)serverConnection.Connect()

Dim replicationServer As New ReplicationServer(serverConnection)availableSubscriptions = replicationServer.EnumSubscriberSubscriptions("", Convert.ToInt32(2))

For Each subscriber In availableSubscriptions
... nothing gets returned in the enumeration.....
Next

Thanks again.
Bruce|||

the syncType is actually used to determine if the initial data needed to be downloaded to the subscriber ( please refer to sp_addmergepullsubscription for details ).

regarding with the EnumSubscriberSubscriptions() method, it is equivalent to the sp_MSenumallsubscriptions ( you can give it a try ). if your call this method with the publisher, in this case, you will not get the anonymous subscriptions. you can call this method on a subscriber server to get the info you need. Please let us know if the RMO method returns anything different from what you get from the SP call.

Hope this helps.

Thanks
Yunwen

|||Hi

I ran sp_MSenumallsubscriptions on the subscriber and it returned no entries. As did EnumSubscriberSubscriptions()

However, when I was creating the subscription on the internal network and was able to connect to the publisher prior to creating the subscription, then EnumSubscriberSubscriptions() did return the subscription details.....

I am executing this method against the subscriber (as per the code in my previous post)

thanks
Bruce|||

Thanks Bruce for reminding me to take a careful look at your code. This actually turn out to be a bug in replication( at least it is a document bug). For now, you can try to pass in 3 for the subscriptionType in EnumSubscriberSubscriptions() to get the subscription info returned. Similarly, you need to specify @.subscription_type='both' for the SP call.

Sorry for the inconvenience. Please let us know if there is any other issues you encountered in your application.

Thanks again for helping us to make it better.

Yunwen

error converting varchar to numeric

i have a huge stored procedure abt 500 lines..and i am calling this sp from an asp.net page...thn i got this error - error converting varchar to numeric - and am trying to debug...is there any way we can find out where the error is coming from...like aproxly which line number..etcor do i have to go through each line manually and see where i am doing the conversion...

thanksNever tried it myself but it should let you step through a sproc like you would your C#/VB.Net code behind.

Walkthrough: Debugging Hello World, a SQL Stored Procedure|||hi MMS

I was able to isolate the line tht was causing the problem..however i will go through the article to see if it will help with some info for future use.

thanks.

Error connecting to SQLExpress 2005 locally

Hello,
I'm a newbie here and was wondering anyone could help me with this.
I have a simple ASP.NET 2 web application running perfectly fine with
IIS and SQLServerExpress installed locally on my WinXP as a testing
server (I created the app in Visual Studio.NET 2005).
When deploying this app on the production server (running Win2000
Server, IIS and SQLServerExpress 2005), I'm getting the following
message when calling an aspx data-bound page from a browser:
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)
On the production server, I have the SQLServerExpress installed locally
on C: drive and the database is located on D: drive (on the same
directory as the app).
Connection string used in the webconfig file:
connectionString=" Server=SERVERNAME\SQLEXPRESS;AttachDbFil
ename=D:\Inetpub\A
pp_Data\registration. mdf;Database=registration;Trusted_Connec
tion=yes;"
providerName="System.Data.SqlClient"
Does anyone know how to solve this issue? Any help would be greatly
appreciated.
Thanks,
HarryHi
Have you checked if you are allowing remote connections on your SQL Express
installation, by default these will be switched off.
Check the Remote Connections setting the the SQL Server 2005 Surface Aread
Configuration tool.
John
"hko" wrote:

> Hello,
> I'm a newbie here and was wondering anyone could help me with this.
> I have a simple ASP.NET 2 web application running perfectly fine with
> IIS and SQLServerExpress installed locally on my WinXP as a testing
> server (I created the app in Visual Studio.NET 2005).
> When deploying this app on the production server (running Win2000
> Server, IIS and SQLServerExpress 2005), I'm getting the following
> message when calling an aspx data-bound page from a browser:
> 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)
> On the production server, I have the SQLServerExpress installed locally
> on C: drive and the database is located on D: drive (on the same
> directory as the app).
> Connection string used in the webconfig file:
> connectionString=" Server=SERVERNAME\SQLEXPRESS;AttachDbFil
ename=D:\Inetpub
\App_Data\registration. mdf;Database=registration;Trusted_Connec
tion=yes;"
> providerName="System.Data.SqlClient"
> Does anyone know how to solve this issue? Any help would be greatly
> appreciated.
> Thanks,
> Harry|||Hi John,
I did allow remote connections eventhough my database is on the same machine
as my web app, but no luck so far.
I used windows authentication for the database, and login to the machine
using admin account.
Another thing that I noticed is that when I go to SQL Server Configuration
Manager, under SQL Server 2005 Network Configuration, it says Protocols for
MSSQLSERVER, whereas on my dev machine it says SQLEXPRESS. When upgrading
from MSDE to SQLExpress i just chose the default instance name, but somehow
it's saying MSSQLSERVER.
I checked the databaseconnection through SQL Management Studio Express and
it works fine. Only when viewing the data-bound page on a browser that I get
the error message.
Do you think I should try to uninstall SQLServer Express and reinstall?
hko
"John Bell" wrote:
> Hi
> Have you checked if you are allowing remote connections on your SQL Expres
s
> installation, by default these will be switched off.
> Check the Remote Connections setting the the SQL Server 2005 Surface Aread
> Configuration tool.
> John
> "hko" wrote:
>|||Hi
If this is the default instance then change your connection string to only
be the servername.
If you want to change the installation from being the default instance you
will need to re-install.
John
"hko" wrote:
> Hi John,
> I did allow remote connections eventhough my database is on the same machi
ne
> as my web app, but no luck so far.
> I used windows authentication for the database, and login to the machine
> using admin account.
> Another thing that I noticed is that when I go to SQL Server Configuration
> Manager, under SQL Server 2005 Network Configuration, it says Protocols fo
r
> MSSQLSERVER, whereas on my dev machine it says SQLEXPRESS. When upgrading
> from MSDE to SQLExpress i just chose the default instance name, but someho
w
> it's saying MSSQLSERVER.
> I checked the databaseconnection through SQL Management Studio Express and
> it works fine. Only when viewing the data-bound page on a browser that I g
et
> the error message.
> Do you think I should try to uninstall SQLServer Express and reinstall?
> hko
> "John Bell" wrote:
>|||I only have one instance and that is the default instance, and this is my
connection string:
connectionString=" Server=HOMER\SQLEXPRESS;AttachDbFilename
=D:\Inetpub\App_Da
ta\registration. mdf;Database=registration;Trusted_Connec
tion=yes;"
providerName="System.Data.SqlClient"
Still something isn't right. Do you think I should probably re-install and
do fresh installation of SQL Express instead of upgrading (like what I did)?
"John Bell" wrote:
> Hi
> If this is the default instance then change your connection string to only
> be the servername.
> If you want to change the installation from being the default instance you
> will need to re-install.
> John
>
> "hko" wrote:
>|||Hi
Try the connection string:
connectionString=" Server=HOMER;AttachDbFilename=D:\Inetpub
\App_Data\registra
tion. mdf;Database=registration;Trusted_Connec
tion=yes;"
providerName="System.Data.SqlClient"
If you want a names instance then you would have to re-install and say that
you want a named instance and not the default instance.
John
"hko" wrote:
> I only have one instance and that is the default instance, and this is my
> connection string:
> connectionString=" Server=HOMER\SQLEXPRESS;AttachDbFilename
=D:\Inetpub\App_
Data\registration. mdf;Database=registration;Trusted_Connec
tion=yes;"
> providerName="System.Data.SqlClient"
> Still something isn't right. Do you think I should probably re-install and
> do fresh installation of SQL Express instead of upgrading (like what I did
)?
> "John Bell" wrote:
>|||Still not working. I tried different combination of connection strings but
kept getting the same error message.
I just want to use the default instance since there's only one database on
the machine.
I suspect there's a glitch during the upgrade process which causes SQL
server to locate the default instance. I was able to connect ok using
Management Studio Express.
This is the most frustrating thing ever to deal with...
"John Bell" wrote:
> Hi
> Try the connection string:
> connectionString=" Server=HOMER;AttachDbFilename=D:\Inetpub
\App_Data\regist
ration. mdf;Database=registration;Trusted_Connec
tion=yes;"
> providerName="System.Data.SqlClient"
> If you want a names instance then you would have to re-install and say tha
t
> you want a named instance and not the default instance.
> John
> "hko" wrote:
>|||Hi
A couple of suggestions:
Try using osql to try and connect, use both the server name and the IP
address and different user combinations.
Check that there is no blocking of the ports being used by a firewall (Try
telneting to the port!)
John
"hko" wrote:
> Still not working. I tried different combination of connection strings but
> kept getting the same error message.
> I just want to use the default instance since there's only one database on
> the machine.
> I suspect there's a glitch during the upgrade process which causes SQL
> server to locate the default instance. I was able to connect ok using
> Management Studio Express.
> This is the most frustrating thing ever to deal with...
> "John Bell" wrote:
>

Error connecting to SQL Server 2005 - ... does not allow remote connections?

I have an ASP.NET 2.0 Website that in the connection string does not connect
to the local SQL Server but tries to connect to another SQL Server 2005
Server in another State. When I run the application from Visual Studio 2005
it connects just fine. When I published the website to the Live Server I
receive the below 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.
Any ideas?
Peace in Christ
Marco Napoli
http://www.ourlovingmother.orgCheck this url for troubleshooting:
http://blogs.msdn.com/sql_protocols.../22/506607.aspx
Jack Vamvas
___________________________________
Receive free SQL tips - www.ciquery.com/sqlserver.htm
___________________________________
"Marco Napoli" <marco@.avantitecnospam.com> wrote in message
news:#14p4JoaGHA.5004@.TK2MSFTNGP02.phx.gbl...
> I have an ASP.NET 2.0 Website that in the connection string does not
connect
> to the local SQL Server but tries to connect to another SQL Server 2005
> Server in another State. When I run the application from Visual Studio
2005
> it connects just fine. When I published the website to the Live Server I
> receive the below 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.
> Any ideas?
> --
> Peace in Christ
> Marco Napoli
> http://www.ourlovingmother.org
>
>|||Thank you.
Marco
"Jack Vamvas" <delete_this_bit_jack@.ciquery.com_delete> wrote in message
news:euqdnWInVNe2O8zZRVnyjg@.bt.com...
> Check this url for troubleshooting:
> http://blogs.msdn.com/sql_protocols.../22/506607.aspx
> --
> Jack Vamvas
> ___________________________________
> Receive free SQL tips - www.ciquery.com/sqlserver.htm
> ___________________________________
>
> "Marco Napoli" <marco@.avantitecnospam.com> wrote in message
> news:#14p4JoaGHA.5004@.TK2MSFTNGP02.phx.gbl...
> connect
> 2005
>

error connecting to sql db

I have an asp.net project on my laptop 'supposed to be' connecting to a SQL DB on the same machine. But I keep getting this error:

System.Data.SqlClient.SqlException: Cannot open database requested in login 'ASPState'. Login fails. Login failed for user 'xyz'.

It's driving me nuts. Any help would be appreciated.

txs
sonnersYou have to go to Sql Server Manager, go to the database, click Add New User and add the user that needs permission, then give that user owner permission|||I did all this. My SQL knowledge isn't so bad. I've been using the main SQL login account as it's my local machine. This account works for other ASP sites but not for .Net ASP site.|||What does your connection string look like? You may need to add <identity impersonate="true"/> to your web.config file.

Terri

Error connecting to Report Manager

System.Net.WebException: Unable to connect to the remote server -->
System.Net.Sockets.SocketException: No connection could be made because the
target machine actively refused it 127.0.0.1:443
Can someone help me with that error?
ThanksThats a bit unusual. Try this post
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=552017&SiteID=1
Cheers
Shai
On Nov 19, 11:46 pm, "Mark Goldin" <mgol...@.ufandd.com> wrote:
> System.Net.WebException: Unable to connect to the remote server -->
> System.Net.Sockets.SocketException: No connection could be made because the
> target machine actively refused it 127.0.0.1:443
> Can someone help me with that error?
> Thanks

Error connecting to DB

Hi everyone,

I am learning how to use .NET and MSDE. I am working out of the book "ASP.NET Unleashed" on the Job Site (Chap 30)

I have used osql to run the .sql script, but now I am having problems connecting to the DB; I get "SQL Server does not exist or access denied"

The web.config file is:

<configuration>
<appSettings>
<add key="constring"
value="Server=localhost;UID=AspNETJobsUser;PWD=secret;Database=AspNetJobs" />
</appSettings>
<system.web>
<authentication mode="Forms" >
<forms name=".ASPNETJOBS"
loginUrl="/aspnetjobs/site/password/login.aspx" />
</authentication>
</system.web>
</configuration
My computer is running in Windows Authentication Mode.

I have tried replacing the UID and PWD to my sa account settings, but I still can not connect.
The books says I need to manually add a login that has access to the AspNETJobsDatabase, but I assume that would be the sa login or do I need to create another all together? If so, can anyone suggest an article to lead me in that direction.

Any suggestions would be helpful and greatly appreciated.

ThanksHere's an article that'll tell you how to add a login to an MSDE instance.

Regards,

Xander|||Data Source=IpAddyorServerName;Initial Catalog=DbName;User ID=UserName;Password=BlankpasswordSucks|||[SqlException: Impossibile eseguire l'accesso per l'utente 'sa'. Motivo: l'utente non è associato a una connessione SQL Server trusted.]

Why?
Bye Bye!|||I changed my code in the Web.config file to:

<configuration>
<appSettings>
<add key="constring"
value="Data Source=SHAYLA1;Initial Catalog=AspNetJobs;User ID=AspNETJobsUser;Password=secret" />
</appSettings>
<system.web>
<authentication mode="Forms" >
<forms name=".ASPNETJOBS"
loginUrl="/aspnetjobs/site/password/login.aspx" />
</authentication>
</system.web>
</configuration
and now I get the error:
Login failed for user 'AspNETJobsUser'. Reason: Not associated with a trusted SQL Server connection.

I followed the article on how to create a login, and I got the message of "user AspNETJobsUser already exists"

When I change the User to sa and password to "my password," I still get the same error

Still missing something?|||just an update for anybody out there that might be facing the same problem. I changed the setting to Mixed Mode from Windows authentication following the direction of the article at

http://support.microsoft.com/?kbid=322336#2

Once I restarted my computer, the app came up fine.

My final web.config files looks like so:

<configuration>
<appSettings>
<add key="constring"
value="Server=(local);Database=AspNetJobs;UID=AspNETJobsUser;PWD=secret" />
</appSettings>
<system.web>
<authentication mode="Forms" >
<forms name=".ASPNETJOBS"
loginUrl="/aspnetjobs/site/password/login.aspx" />
</authentication>
</system.web>
</configuration
Thank you to those who responded to my original post.

Error Connecting to DB

I downloaded an ASP.NET web application from the web to learn the .NET framework. I was successful in running the website on my laptop using ASP.NET Development Server that comes with Visual Studio 2005. My laptop is running Windows XP Professional and SQL Server 2005. I am now trying to do the same on my desktop computer running Windows Vista; however, for some reason i am getting an error when the website tries to connect to the DB. Here are the steps i have followed so far:

1. I tried to configure the website DB connection the same way i configured it on my laptop. Basically I use the following connectionStrings:

<connectionStrings>
<remove name="LocalSqlServer"/>
<add name="LocalSqlServer" connectionString="Data Source=localhost;Initial Catalog=TheBeerHouse;Integrated Security=True" providerName="System.Data.SqlClient"/>
</connectionStrings
2. That same connection string worked fine on my laptop. But I got the following error on my desktop:

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: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)

I am wondering if the error is related to Vista. When i try to connect to that DB using SQL Management Studio via Windows Authetication and do not run it as Administrator then I cannot connect to the DB. In other words, only when i run SQL Management Studio as administrator i am able to use Windows authentication to connect to that DB.

3. Next, I tried creating a SQL login. I made sure I can use that login to access the DB directly using SQL Management Studio. In addition, I changed the database to allow "Local and remote connections" "Using both TCP/IP and named pipes".

4. Changed the connectionStrings in web.config to:

<connectionStrings>
<remove name="LocalSqlServer"/>
<add name="LocalSqlServer" connectionString="Data Source=localhost;Initial Catalog=TheBeerHouse;Integrated Security=False;uid=*****pwd=****" providerName="System.Data.SqlClient"/>
</connectionStrings
Obviously, the actual connectionString has the actual user name i created and the correct password instead of (*) asterisks.

5. And once again, I got same error as above

Any help will be appreciated!

Hi,

Is sqlserver on your desktop running in "Windows Authentication Mode" or "Mixed Mode"

Open up SqlServer Management Studio, right click on the Server, not the database(s), then in the left hand menu shown select Security. The dialog box on the right should have"SQL Server and Window Authentication Mode" checked instead of just"Windows Authentication Mode".

Hope this helps

Regards

ScottyB

|||

I have "SQL Server and Window Authentication Mode"checked. I can login directly to the database via SQL Managament Studio using the same login and password as specified in the connectionString. I also have allowedLocal and remote connections and haveUsingboth TCP/IP and named pipeschecked.

|||

Hi nj07208

I have just noticed in the connection string that you posted here that you do not have a semiclon after the uid and pwd parameters. You can try this. See the listings below

Original Connection String

<connectionStrings> <remove name="LocalSqlServer"/> <add name="LocalSqlServer" connectionString="Data Source=localhost;Initial Catalog=TheBeerHouse;Integrated Security=False;uid=*****pwd=****" providerName="System.Data.SqlClient"/> </connectionStrings>

Modified Connection String

<connectionStrings> <remove name="LocalSqlServer"/> <add name="LocalSqlServer" connectionString="Data Source=localhost;Initial Catalog=TheBeerHouse;Integrated Security=False;uid=*****;pwd=****"; providerName="System.Data.SqlClient"/> </connectionStrings>

Regards

ScottyB

|||

i guess you meant with the semicolon right after the password before the double quotes. I tried that and it didn't work =(

|||

I got a new error now! I turned off my firewalls (both Windows and McAfee ViruScan) and now i get a new error:

Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached.

Any ideas?

|||

If you have access to the iismanager try doing a pool reset or a iisreset.

Do you have any code in your application that goes through a loop and opens connections. This error may suggest you are opening connections faster than the garbage collector can dispose of them.

Regards

ScottyB

|||

I am using ASP.NET Development Server that comes with Visual Studio 2005. I am not using IIS.

|||

I got it!!! It works now!!! On the connectionString i changed Data Source from localhost to localhost\SQLEXPRESS. This is needed because I am using a named instance. So, to recap for anyone who is interested, these are the steps i followed:

1. EnableSQL Server and Windows Authentication mode. This can be done from SQL Management Studio

2. Create SQL Server login. Make sure you can login to the database using SQL Management Studio

3. EnableLocal and remote connections and haveUsingboth TCP/IP and named pipeschecked. This can be done from SQL Server Surface Area Configuration.

4. Connection String on web.config should be the following

<connectionStrings> <remove name="LocalSqlServer"/> <add name="LocalSqlServer" connectionString="Data Source=localhost\SQLEXPRESS;Initial Catalog=TheBeerHouse;Integrated Security=False;uid=username;pwd=password;" providerName="System.Data.SqlClient"/></connectionStrings>

Note that I enabled both Windows and McAvfee AntiVirus firewalls and it still works.

Error connecting to datasource using bulk load

I am trying to use xml bulk load in a .net environment using vb.net.
The first issue I ran into was not being able to do a bulk load in a
multi-threaded environment. So I now have initiated a new thread prior
to trying to execute the bulk load. I am consistenly getting an unable
to connect to data source error. Does anyone have any ideas as to what
I may be doing incorrectly? The connection string is the same one I
use in other places without any issues.
Private Sub BulkLoadXML()
Dim bulkload As New Thread(New ThreadStart(AddressOf
ExecuteBulkCall))
bulkload.ApartmentState = ApartmentState.STA
bulkload.Start()
bulkload.Join()
End Sub
Private Sub ExecuteBulkCall()
Dim _bulkInstance As New SQLXMLBulkLoad3Class
_bulkInstance.ConnectionString = _strConn
_bulkInstance.ErrorLogFile = "c:\temp\xmlerror.log"
_bulkInstance.KeepIdentity = False
_bulkInstance.Execute("c:\SampleSchema.xsd",
"c:\SampleXMLData.xml")
End Sub
franksag
Posted via http://www.codecomments.com
What does the connection string look like? When you say it worked in other
places - what places are those?
Andrew Conrad
Microsoft Corp

Error connecting to datasource using bulk load

I am trying to use xml bulk load in a .net environment using vb.net. The fi
rst issue I ran into was not being able to do a bulk load in a multi-threade
d environment. So I now have initiated a new thread prior to trying to exec
ute the bulk load. I am consistenly getting an unable to connect to data so
urce error. Does anyone have any ideas as to what I may be doing incorrectly
? The connection string is the same one I use in other places without any i
ssues.
Private Sub BulkLoadXML()
Dim bulkload As New Thread(New ThreadStart(AddressOf ExecuteBulkCall
))
bulkload.ApartmentState = ApartmentState.STA
bulkload.Start()
bulkload.Join()
End Sub
Private Sub ExecuteBulkCall()
Dim _bulkInstance As New SQLXMLBulkLoad3Class
_bulkInstance.ConnectionString = _strConn
_bulkInstance.ErrorLogFile = "c:\temp\xmlerror.log"
_bulkInstance.KeepIdentity = False
_bulkInstance.Execute("c:\SampleSchema.xsd", "c:\SampleXMLData.xml")
End SubWhat does the connection string look like? When you say it worked in other
places - what places are those?
Andrew Conrad
Microsoft Corp|||thanks for getting back to me. I am able to connect to the database elsewhe
re in the application to call stored procedures and retrieve the data to dis
play. This is the only place within the application that I am unable to conn
ect. I suspect it has to do with the fact that I am calling within a single
thread. Here is the connect string:
"Data Source=(local);Initial Catalog=IOC;User ID=sg2user;password=sg2user"|||Try setting the Provider=sqloledb value in the connection string. Here's an
example from our docs of Bulkload in .NET:
[STAThread]
static void Main(string[] args)
{
try
{
SQLXMLBULKLOADLib.SQLXMLBulkLoad3Class objBL = new
SQLXMLBULKLOADLib.SQLXMLBulkLoad3Class();
objBL.ConnectionString =
" Provider=sqloledb;server=server;database
=databaseName;integrated
security=SSPI";
objBL.ErrorLogFile = "error.xml";
objBL.KeepIdentity = false;
objBL.Execute ("schema.xml","data.xml");
}
catch(Exception e)
{
Console.WriteLine(e.ToString());
}
}
"franksag" <franksag.1llvtp@.mail.codecomments.com> wrote in message
news:franksag.1llvtp@.mail.codecomments.com...
> thanks for getting back to me. I am able to connect to the database
> elsewhere in the application to call stored procedures and retrieve the
> data to display. This is the only place within the application that I am
> unable to connect. I suspect it has to do with the fact that I am
> calling within a single thread. Here is the connect string:
> "Data Source=(local);Initial Catalog=IOC;User
> ID=sg2user;password=sg2user"
>
> --
> franksag
> ---
> Posted via http://www.codecomments.com
> ---
>

Error automating SQL DTS Pkg from VB6 to VB.Net

I am trying to convert a VB6 SQL 2000 created code into VB.NET. Everything
complies fine but then I get this error message:
An unhandled exception of type 'System.InvalidCastException' occurred in
Project1.exe
Additional information: QueryInterface for interface DTS.CustomTask failed.
This is the portion of the code that it is breaking on:
I found 2 ways to do this but both ways are giving me the same error message
Way #1:
Public Sub Task_Sub1(ByVal goPackage As DTS.Package2)
Dim oTask As DTS.Task
Dim oLookup As DTS.Lookup
Dim oCustomTask1 As DTS.DataPumpTask2
oTask = CType(goPackage, DTS.Package2).Tasks.New("DTSDataPumpTask")
oTask = goPackage.Tasks.New("DTSDataPumpTask")
oCustomTask1 = oTask.CustomTask
Way #2:
Public Sub Task_Sub1(ByVal goPackage As Object)
Dim oTask As DTS.Task
Dim oLookup As DTS.Lookup
Dim oCustomTask1 As DTS.DataPumpTask2
oTask = CType(goPackage, DTS.Package2).Tasks.New("DTSDataPumpTask")
oCustomTask1 = oTask.CustomTask
If anyone has an idea on what I need to change in the code I would greatly
appreciate it.
Thanks in advanceJohn,
Try with this excellent article from Gert Drapers:
http://www.sqldev.net/dts/DotNETCookBook.htm.
Dejan Sarka, SQL Server MVP
Mentor
www.SolidQualityLearning.com
"John" <John@.discussions.microsoft.com> wrote in message
news:B830B251-9289-4510-9ED8-6165AB2A0B92@.microsoft.com...
>I am trying to convert a VB6 SQL 2000 created code into VB.NET. Everything
> complies fine but then I get this error message:
> An unhandled exception of type 'System.InvalidCastException' occurred in
> Project1.exe
> Additional information: QueryInterface for interface DTS.CustomTask
> failed.
> This is the portion of the code that it is breaking on:
> I found 2 ways to do this but both ways are giving me the same error
> message
> Way #1:
> Public Sub Task_Sub1(ByVal goPackage As DTS.Package2)
> Dim oTask As DTS.Task
> Dim oLookup As DTS.Lookup
> Dim oCustomTask1 As DTS.DataPumpTask2
> oTask = CType(goPackage, DTS.Package2).Tasks.New("DTSDataPumpTask")
> oTask = goPackage.Tasks.New("DTSDataPumpTask")
> oCustomTask1 = oTask.CustomTask
> Way #2:
> Public Sub Task_Sub1(ByVal goPackage As Object)
> Dim oTask As DTS.Task
> Dim oLookup As DTS.Lookup
> Dim oCustomTask1 As DTS.DataPumpTask2
> oTask = CType(goPackage, DTS.Package2).Tasks.New("DTSDataPumpTask")
> oCustomTask1 = oTask.CustomTask
> If anyone has an idea on what I need to change in the code I would greatly
> appreciate it.
> Thanks in advance
>

ERROR at LogonUser in UILogon.aspx.cs

HI,
I am actually a java developer .I have suddenly changed to RS.
so i am very new to .net programming and ReportingServices.
I am getting error like "HTTP 401 Error: Access Denied."
I know i have to set credentials.But i don't know where i have to set i.e in
which file i have to set.
According to the MSDN white pages While i debugging the file
"UILogOni.aspx.cs" it is stopping at
"server.LogonUser(TxtUser.Text,TxtPwd.Text, null)" it is taking the value of
username and password which i enterd into logon page.
the logfiles has an error type ReportServerWebApp__02_23_2005_17_27_48
this says
CantCommunicateWithReportServerException: Unable to communicate with report
server. Please verify that the report server is operational. at
Microsoft.ReportingServices.UI.RSWebServiceWrapper.GetSecureMethods() at
Microsoft.SqlServer.ReportingServices.RSConnection.IsSecureMethod(String
methodname) at Microsoft.ReportingServices.UI.Global.SecureAllAPI() at
Microsoft.ReportingServices.UI.ReportingPage.EnsureHttpsLevel(HttpsLevel
level) at
Microsoft.ReportingServices.UI.ReportingPage.ReportingPage_Init(Object
sender, EventArgs args) at System.EventHandler.Invoke(Object sender,
EventArgs e) at System.Web.UI.Control.OnInit(EventArgs e) at
System.Web.UI.Control.InitRecursive(Control namingContainer) at
System.Web.UI.Page.ProcessRequestMain()
aspnet_wp!ui!5b8!2/24/2005-10:02:09:: e ERROR: Exception in ShowErrorPage:
System.Threading.ThreadAbortException: Thread was being aborted.
at System.Threading.Thread.AbortInternal()
at System.Threading.Thread.Abort(Object stateInfo)
at System.Web.HttpResponse.End()
at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String
errMsg) at at System.Threading.Thread.AbortInternal()
at System.Threading.Thread.Abort(Object stateInfo)
at System.Web.HttpResponse.End()
at System.Web.HttpServerUtility.Transfer(String path, Boolean preserveForm)
at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String
errMsg)
aspnet_wp!ui!5b8!2/24/2005-10:02:45:: e ERROR: Unable to communicate with
report server. Please verify that the report server is operational.
aspnet_wp!ui!5b8!2/24/2005-10:02:45:: e ERROR: HTTP status code --> 500
plz could anybody help meAre you using Forms Authentication? If so, have you very carefully followed
the instructions outlined here:
http://msdn.microsoft.com/library/?url=/library/en-us/dnsql2k/html/ufairs.asp?frame=true#ufairs
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"gundui" <gundui@.discussions.microsoft.com> wrote in message
news:2D8E30FA-D971-4D1D-9A48-61126D835AB1@.microsoft.com...
> HI,
> I am actually a java developer .I have suddenly changed to RS.
> so i am very new to .net programming and ReportingServices.
> I am getting error like "HTTP 401 Error: Access Denied."
> I know i have to set credentials.But i don't know where i have to set i.e
> in
> which file i have to set.
> According to the MSDN white pages While i debugging the file
> "UILogOni.aspx.cs" it is stopping at
> "server.LogonUser(TxtUser.Text,TxtPwd.Text, null)" it is taking the value
> of
> username and password which i enterd into logon page.
> the logfiles has an error type ReportServerWebApp__02_23_2005_17_27_48
> this says
>
> CantCommunicateWithReportServerException: Unable to communicate with
> report
> server. Please verify that the report server is operational. at
> Microsoft.ReportingServices.UI.RSWebServiceWrapper.GetSecureMethods() at
> Microsoft.SqlServer.ReportingServices.RSConnection.IsSecureMethod(String
> methodname) at Microsoft.ReportingServices.UI.Global.SecureAllAPI() at
> Microsoft.ReportingServices.UI.ReportingPage.EnsureHttpsLevel(HttpsLevel
> level) at
> Microsoft.ReportingServices.UI.ReportingPage.ReportingPage_Init(Object
> sender, EventArgs args) at System.EventHandler.Invoke(Object sender,
> EventArgs e) at System.Web.UI.Control.OnInit(EventArgs e) at
> System.Web.UI.Control.InitRecursive(Control namingContainer) at
> System.Web.UI.Page.ProcessRequestMain()
> aspnet_wp!ui!5b8!2/24/2005-10:02:09:: e ERROR: Exception in ShowErrorPage:
> System.Threading.ThreadAbortException: Thread was being aborted.
> at System.Threading.Thread.AbortInternal()
> at System.Threading.Thread.Abort(Object stateInfo)
> at System.Web.HttpResponse.End()
> at System.Web.HttpServerUtility.Transfer(String path, Boolean
> preserveForm)
> at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String
> errMsg) at at System.Threading.Thread.AbortInternal()
> at System.Threading.Thread.Abort(Object stateInfo)
> at System.Web.HttpResponse.End()
> at System.Web.HttpServerUtility.Transfer(String path, Boolean
> preserveForm)
> at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String
> errMsg)
> aspnet_wp!ui!5b8!2/24/2005-10:02:45:: e ERROR: Unable to communicate with
> report server. Please verify that the report server is operational.
> aspnet_wp!ui!5b8!2/24/2005-10:02:45:: e ERROR: HTTP status code --> 500
> plz could anybody help me|||Hi jeff
I had fallowed all steps according to that MSDN white pages .
while openning the ReportManager I am getting error like "Http 401 :Access
Denied"
so in which file i have to set Networkcredentials? i could't get it .
i am working with this problem from allmost a month
so can u help me.
"Jeff A. Stucker" wrote:
> Are you using Forms Authentication? If so, have you very carefully followed
> the instructions outlined here:
> http://msdn.microsoft.com/library/?url=/library/en-us/dnsql2k/html/ufairs.asp?frame=true#ufairs
> --
> Cheers,
> '(' Jeff A. Stucker
> \
> Business Intelligence
> www.criadvantage.com
> ---
> "gundui" <gundui@.discussions.microsoft.com> wrote in message
> news:2D8E30FA-D971-4D1D-9A48-61126D835AB1@.microsoft.com...
> > HI,
> > I am actually a java developer .I have suddenly changed to RS.
> > so i am very new to .net programming and ReportingServices.
> >
> > I am getting error like "HTTP 401 Error: Access Denied."
> >
> > I know i have to set credentials.But i don't know where i have to set i.e
> > in
> > which file i have to set.
> >
> > According to the MSDN white pages While i debugging the file
> > "UILogOni.aspx.cs" it is stopping at
> > "server.LogonUser(TxtUser.Text,TxtPwd.Text, null)" it is taking the value
> > of
> > username and password which i enterd into logon page.
> >
> > the logfiles has an error type ReportServerWebApp__02_23_2005_17_27_48
> > this says
> >
> >
> > CantCommunicateWithReportServerException: Unable to communicate with
> > report
> > server. Please verify that the report server is operational. at
> > Microsoft.ReportingServices.UI.RSWebServiceWrapper.GetSecureMethods() at
> > Microsoft.SqlServer.ReportingServices.RSConnection.IsSecureMethod(String
> > methodname) at Microsoft.ReportingServices.UI.Global.SecureAllAPI() at
> > Microsoft.ReportingServices.UI.ReportingPage.EnsureHttpsLevel(HttpsLevel
> > level) at
> > Microsoft.ReportingServices.UI.ReportingPage.ReportingPage_Init(Object
> > sender, EventArgs args) at System.EventHandler.Invoke(Object sender,
> > EventArgs e) at System.Web.UI.Control.OnInit(EventArgs e) at
> > System.Web.UI.Control.InitRecursive(Control namingContainer) at
> > System.Web.UI.Page.ProcessRequestMain()
> > aspnet_wp!ui!5b8!2/24/2005-10:02:09:: e ERROR: Exception in ShowErrorPage:
> > System.Threading.ThreadAbortException: Thread was being aborted.
> > at System.Threading.Thread.AbortInternal()
> > at System.Threading.Thread.Abort(Object stateInfo)
> > at System.Web.HttpResponse.End()
> > at System.Web.HttpServerUtility.Transfer(String path, Boolean
> > preserveForm)
> > at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String
> > errMsg) at at System.Threading.Thread.AbortInternal()
> > at System.Threading.Thread.Abort(Object stateInfo)
> > at System.Web.HttpResponse.End()
> > at System.Web.HttpServerUtility.Transfer(String path, Boolean
> > preserveForm)
> > at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String
> > errMsg)
> > aspnet_wp!ui!5b8!2/24/2005-10:02:45:: e ERROR: Unable to communicate with
> > report server. Please verify that the report server is operational.
> > aspnet_wp!ui!5b8!2/24/2005-10:02:45:: e ERROR: HTTP status code --> 500
> >
> > plz could anybody help me
>
>|||Is this error before or after you enter credentials?
If you've been working on it a month, your best bet is probably a clean
install and re-configuring according the the Forms Authentication sample
from Microsoft. (That's about 4 hours of work.) It's so very easy to screw
it up, and unless you've got a working baseline, you could have tweaked any
number of settings trying to "fix" it, and simply made things worse. Once
you get a working baseline, then you can start modifying the sample to work
with your existing environment, security systems, etc. Or, if you had it
working at some customization after running the sample, go back to that
point again.
Bottom line: get to a known state. You need to have a reference point of a
working system, so you can point to what you were doing when it starts going
wrong.
--
Cheers,
'(' Jeff A. Stucker
\
Business Intelligence
www.criadvantage.com
---
"gundui" <gundui@.discussions.microsoft.com> wrote in message
news:25979987-9508-4CDD-9A2D-E46B71B32B99@.microsoft.com...
> Hi jeff
> I had fallowed all steps according to that MSDN white pages .
> while openning the ReportManager I am getting error like "Http 401 :Access
> Denied"
> so in which file i have to set Networkcredentials? i could't get it .
> i am working with this problem from allmost a month
> so can u help me.
> "Jeff A. Stucker" wrote:
>> Are you using Forms Authentication? If so, have you very carefully
>> followed
>> the instructions outlined here:
>> http://msdn.microsoft.com/library/?url=/library/en-us/dnsql2k/html/ufairs.asp?frame=true#ufairs
>> --
>> Cheers,
>> '(' Jeff A. Stucker
>> \
>> Business Intelligence
>> www.criadvantage.com
>> ---
>> "gundui" <gundui@.discussions.microsoft.com> wrote in message
>> news:2D8E30FA-D971-4D1D-9A48-61126D835AB1@.microsoft.com...
>> > HI,
>> > I am actually a java developer .I have suddenly changed to RS.
>> > so i am very new to .net programming and ReportingServices.
>> >
>> > I am getting error like "HTTP 401 Error: Access Denied."
>> >
>> > I know i have to set credentials.But i don't know where i have to set
>> > i.e
>> > in
>> > which file i have to set.
>> >
>> > According to the MSDN white pages While i debugging the file
>> > "UILogOni.aspx.cs" it is stopping at
>> > "server.LogonUser(TxtUser.Text,TxtPwd.Text, null)" it is taking the
>> > value
>> > of
>> > username and password which i enterd into logon page.
>> >
>> > the logfiles has an error type
>> > ReportServerWebApp__02_23_2005_17_27_48
>> > this says
>> >
>> >
>> > CantCommunicateWithReportServerException: Unable to communicate with
>> > report
>> > server. Please verify that the report server is operational. at
>> > Microsoft.ReportingServices.UI.RSWebServiceWrapper.GetSecureMethods()
>> > at
>> > Microsoft.SqlServer.ReportingServices.RSConnection.IsSecureMethod(String
>> > methodname) at Microsoft.ReportingServices.UI.Global.SecureAllAPI()
>> > at
>> > Microsoft.ReportingServices.UI.ReportingPage.EnsureHttpsLevel(HttpsLevel
>> > level) at
>> > Microsoft.ReportingServices.UI.ReportingPage.ReportingPage_Init(Object
>> > sender, EventArgs args) at System.EventHandler.Invoke(Object sender,
>> > EventArgs e) at System.Web.UI.Control.OnInit(EventArgs e) at
>> > System.Web.UI.Control.InitRecursive(Control namingContainer) at
>> > System.Web.UI.Page.ProcessRequestMain()
>> > aspnet_wp!ui!5b8!2/24/2005-10:02:09:: e ERROR: Exception in
>> > ShowErrorPage:
>> > System.Threading.ThreadAbortException: Thread was being aborted.
>> > at System.Threading.Thread.AbortInternal()
>> > at System.Threading.Thread.Abort(Object stateInfo)
>> > at System.Web.HttpResponse.End()
>> > at System.Web.HttpServerUtility.Transfer(String path, Boolean
>> > preserveForm)
>> > at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String
>> > errMsg) at at System.Threading.Thread.AbortInternal()
>> > at System.Threading.Thread.Abort(Object stateInfo)
>> > at System.Web.HttpResponse.End()
>> > at System.Web.HttpServerUtility.Transfer(String path, Boolean
>> > preserveForm)
>> > at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String
>> > errMsg)
>> > aspnet_wp!ui!5b8!2/24/2005-10:02:45:: e ERROR: Unable to communicate
>> > with
>> > report server. Please verify that the report server is operational.
>> > aspnet_wp!ui!5b8!2/24/2005-10:02:45:: e ERROR: HTTP status code --> 500
>> >
>> > plz could anybody help me
>>|||Hi jeff ,
i did't get errors at the time of registration.
i am getting errors when i am trying to logon to ReportManager .
like "HTTP Error 401 : Access Denied"
everything is fine with reportserver.
"Jeff A. Stucker" wrote:
> Is this error before or after you enter credentials?
> If you've been working on it a month, your best bet is probably a clean
> install and re-configuring according the the Forms Authentication sample
> from Microsoft. (That's about 4 hours of work.) It's so very easy to screw
> it up, and unless you've got a working baseline, you could have tweaked any
> number of settings trying to "fix" it, and simply made things worse. Once
> you get a working baseline, then you can start modifying the sample to work
> with your existing environment, security systems, etc. Or, if you had it
> working at some customization after running the sample, go back to that
> point again.
> Bottom line: get to a known state. You need to have a reference point of a
> working system, so you can point to what you were doing when it starts going
> wrong.
> --
> Cheers,
> '(' Jeff A. Stucker
> \
> Business Intelligence
> www.criadvantage.com
> ---
> "gundui" <gundui@.discussions.microsoft.com> wrote in message
> news:25979987-9508-4CDD-9A2D-E46B71B32B99@.microsoft.com...
> > Hi jeff
> >
> > I had fallowed all steps according to that MSDN white pages .
> > while openning the ReportManager I am getting error like "Http 401 :Access
> > Denied"
> >
> > so in which file i have to set Networkcredentials? i could't get it .
> >
> > i am working with this problem from allmost a month
> > so can u help me.
> >
> > "Jeff A. Stucker" wrote:
> >
> >> Are you using Forms Authentication? If so, have you very carefully
> >> followed
> >> the instructions outlined here:
> >>
> >> http://msdn.microsoft.com/library/?url=/library/en-us/dnsql2k/html/ufairs.asp?frame=true#ufairs
> >>
> >> --
> >> Cheers,
> >>
> >> '(' Jeff A. Stucker
> >> \
> >>
> >> Business Intelligence
> >> www.criadvantage.com
> >> ---
> >> "gundui" <gundui@.discussions.microsoft.com> wrote in message
> >> news:2D8E30FA-D971-4D1D-9A48-61126D835AB1@.microsoft.com...
> >> > HI,
> >> > I am actually a java developer .I have suddenly changed to RS.
> >> > so i am very new to .net programming and ReportingServices.
> >> >
> >> > I am getting error like "HTTP 401 Error: Access Denied."
> >> >
> >> > I know i have to set credentials.But i don't know where i have to set
> >> > i.e
> >> > in
> >> > which file i have to set.
> >> >
> >> > According to the MSDN white pages While i debugging the file
> >> > "UILogOni.aspx.cs" it is stopping at
> >> > "server.LogonUser(TxtUser.Text,TxtPwd.Text, null)" it is taking the
> >> > value
> >> > of
> >> > username and password which i enterd into logon page.
> >> >
> >> > the logfiles has an error type
> >> > ReportServerWebApp__02_23_2005_17_27_48
> >> > this says
> >> >
> >> >
> >> > CantCommunicateWithReportServerException: Unable to communicate with
> >> > report
> >> > server. Please verify that the report server is operational. at
> >> > Microsoft.ReportingServices.UI.RSWebServiceWrapper.GetSecureMethods()
> >> > at
> >> > Microsoft.SqlServer.ReportingServices.RSConnection.IsSecureMethod(String
> >> > methodname) at Microsoft.ReportingServices.UI.Global.SecureAllAPI()
> >> > at
> >> > Microsoft.ReportingServices.UI.ReportingPage.EnsureHttpsLevel(HttpsLevel
> >> > level) at
> >> > Microsoft.ReportingServices.UI.ReportingPage.ReportingPage_Init(Object
> >> > sender, EventArgs args) at System.EventHandler.Invoke(Object sender,
> >> > EventArgs e) at System.Web.UI.Control.OnInit(EventArgs e) at
> >> > System.Web.UI.Control.InitRecursive(Control namingContainer) at
> >> > System.Web.UI.Page.ProcessRequestMain()
> >> > aspnet_wp!ui!5b8!2/24/2005-10:02:09:: e ERROR: Exception in
> >> > ShowErrorPage:
> >> > System.Threading.ThreadAbortException: Thread was being aborted.
> >> > at System.Threading.Thread.AbortInternal()
> >> > at System.Threading.Thread.Abort(Object stateInfo)
> >> > at System.Web.HttpResponse.End()
> >> > at System.Web.HttpServerUtility.Transfer(String path, Boolean
> >> > preserveForm)
> >> > at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String
> >> > errMsg) at at System.Threading.Thread.AbortInternal()
> >> > at System.Threading.Thread.Abort(Object stateInfo)
> >> > at System.Web.HttpResponse.End()
> >> > at System.Web.HttpServerUtility.Transfer(String path, Boolean
> >> > preserveForm)
> >> > at Microsoft.ReportingServices.UI.ReportingPage.ShowErrorPage(String
> >> > errMsg)
> >> > aspnet_wp!ui!5b8!2/24/2005-10:02:45:: e ERROR: Unable to communicate
> >> > with
> >> > report server. Please verify that the report server is operational.
> >> > aspnet_wp!ui!5b8!2/24/2005-10:02:45:: e ERROR: HTTP status code --> 500
> >> >
> >> > plz could anybody help me
> >>
> >>
> >>
>
>

Error after installing Whidbey!

I've installed Whidbey (VS Studio .net 2005 beta 1) (i already had VS .Net
2003 installed as well) and now I can't open my old sql databases! An
mmc.exrror comes up: The instruction at "0x00000000" referenced memory at
"0x00000000". The memory could not be "read". Any idea how this could be
fixed? Cheers in advance.Nab wrote:
> I've installed Whidbey (VS Studio .net 2005 beta 1) (i already had VS
> .Net 2003 installed as well) and now I can't open my old sql
> databases! An mmc.exrror comes up: The instruction at "0x00000000"
> referenced memory at "0x00000000". The memory could not be "read".
> Any idea how this could be fixed? Cheers in advance.
I sure hope you didn't install on a production server. Beta software is
not certified for production use. The two .Net editions should co-exist
without a problem. In fact, that's one of the benefits of .Net. That is,
it supports multiple installed versions (in production form).
What do you mean "can't open your SQL databases"? It's not clear what's
installed on your PC, where your SQL Servers are located (local vs.
server). Are you saying that SQL 2000 runs fine, but SQL EM won't allow
you to browse your server? What application are you running?
David Gugick
Imceda Software
www.imceda.com