Showing posts with label asp. Show all posts
Showing posts with label asp. Show all posts

Wednesday, March 21, 2012

Deployment issue : COM object with CLSID {10020200-EB1C-11CF-AE6E-00AA004A34D5} is either not va

Hello,

I have a asp.net application that calls a DTS package. This application is running fine on my machine (where SQL Server and Web Server are running). When I moved the application to a Web Server, I am getting the following error due to the DTS package.

COM object with CLSID {10020200-EB1C-11CF-AE6E-00AA004A34D5} is either not valid or not registered.

In my Bin folder, I do have the reference to the Interop.DTS.dll. The web server admin tells me that the dtsffile.dll, dtspkg.dll, dtspump.dll and axscphst.dll are registered onto the web server.

I am struggling to find the reasons for this. I have tried to replicate this error onto my machine to help me finding out the cause of this problem but in vain!

Can you help please?

Thank you.

Hello,

Just an update on this issue.
Basically, I have never been able to manage to sort this one out, despite viewing many articles on the net.

However, I just want to share one option to overcome this problem.

You can invoke your DTS package through a JOB using SP_START_JOB stored proc. This SP Instructs SQL Server Agent to execute a job immediately. This would do the job of executing the package!!! Of course, you will need the right to run the job.

Hope this helps.

Deployment issue : COM object with CLSID {10020200-EB1C-11CF-AE6E-00AA004A34D5} is either no

Hello,

I have a asp.net application that calls a DTS package. This application is running fine on my machine (where SQL Server and Web Server are running). When I moved the application to a Web Server, I am getting the following error due to the DTS package.

COM object with CLSID {10020200-EB1C-11CF-AE6E-00AA004A34D5} is either not valid or not registered.

In my Bin folder, I do have the reference to the Interop.DTS.dll. The web server admin tells me that the dtsffile.dll, dtspkg.dll, dtspump.dll and axscphst.dll are registered onto the web server.

I am struggling to find the reasons for this. I have tried to replicate this error onto my machine to help me finding out the cause of this problem but in vain!

Can you help please?

Thank you.

Hello,

Just an update on this issue.
Basically, I have never been able to manage to sort this one out, despite viewing many articles on the net.

However, I just want to share one option to overcome this problem.

You can invoke your DTS package through a JOB using SP_START_JOB stored proc. This SP Instructs SQL Server Agent to execute a job immediately. This would do the job of executing the package!!! Of course, you will need the right to run the job.

Hope this helps.

Deployment Help

I'm trying to test my ASP.NET application. Everything is working to the point of getting to my login page to open. When I try to login I receive and error that the database does not exist or access is denied. I used the developer version of SQL Server to create the database and installed the MSDE on my test PC. Then I copied the mdf and ldf files to the new PC. Is there something else I should be doing? Or any suggestions?

Thank you,::Then I copied the mdf and ldf files to the new PC

did you "attach" the database ??

hth|||The test PC only has the MSDE installed. I don't know of a way to run the attach sp without query analyzer, is there a way?

Thank you,|||I tested, and I can connect the SQL Server database to a Access adp. Would this mean that I should be able to connect to my ASP.NET web pages? Could there be a problem with my connection string when I moved the app to the new PC? What is the simplest connect string to a SQL Server database, so I can test it?

Thanks you any suggestions,|||Can you install SQL Server tools (only)?
That would be easier to attach a db via Enterprise Manager (right-click DB / all tasks).|||I was trying to do this as if those tools were not available. I read that it was possible, but I cannot find the listing again.

Thank you,sql

Monday, March 19, 2012

Deploying the Personal Web Site

Rank newbie to ASP.NET here, so I'm totally "at sea" as to finding a "cookbook" for "how to deploy" a slightly customized version of the "Personal Web Site" project.

My hosting service has an ASP.NET database installed. I can verify from their "SQL Server Web Admin" package that there are 11 "aspnet_" table names present. I have run the "personal-add.sql" script which has defined two (empty) tables -- "Albums" and "Photos".

CONFUSION 1: The hosting service includes a Help fille for "Connecting to a SQL Server Database Using ASP.NET 2.0" which details the way to add 'connectionStrings' for "Personal" and "LocalSqlServer". I have made a "remote" copy of the "web.config" file and supplied the ostensively correct info for my Server, Database, User ID and Password. QUESTION: Why are there TWO names -- "Personal" and "LocalSqlServer"? Since all of the tables are contained now within the ASP.NET database are the details for both of these to be the same?

CONFUSION 2: Error handling. I'm getting "An application error occurred on the server. The current custom error settings for this application prevent the details of the application error from being viewed remotely (for security reasons). It could, however, be viewed by browsers running on the local server machine." Huh!? That page then goes on to mention "<customErrors mode="RemoteOnly" defaultRedirect="mycustompage.htm"/>". I've not a clue as to what "mycustompage.htm" should contain in order to field the error[s] erupting.

POINTERS, anyone? Have I missed some basic part of the manual[s] someplace? I was sort of hoping that there would be a simple "cookbook" around someplace for how to "deploy" a relatively tested group of pages (application) in a relatively idiot-proof manner. I'm not finding it, so ANY pointers, hints, URLs will be greatly appreciated.

Color me "confused in Kauai" ... :) KevInKauai

Hi,

1.For your first question,the difference between "Personal" and "LocalSqlServer" is like the following:

Personal connectionStrings:"Data Source=localhost;Initial Catalog=CatelogName;uid=sa;password=XXX" (For other editions than the Express edition)

LocalSqlServer connectionString:"data source=.\SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|aspnetdb.mdf;User Instance=true" . (For SqlServer Express Edition)

2.For your second question,you can change the customErrors settings into the following mode if your hoster provide the authority.

<customErrors mode="off"/>

Thanks.

|||

Thanks, Jin !

My "VB guru days" were back with VB6 and I've taken a long hiatus, so I guess I'm suffering from object (or abject!) confusion. I've been trying to find the uttimate object reference but have only come up with this: http://quickstarts.asp.net/QuickStartv20/util/classbrowser.aspx


I've gone through all but the last 2 of the LearningVisualStudio (Express) videos and there really was never an application deployed in all of that.

Color me -- STILL WAY CONFUSED!

:) mahalos ... KevInKauai

Deploying SQL Express with ASP.Net Application

I have a small ASP.Net application developed in VS 2005 that I would like to deploy with SQL Express.

I have included the MDF file in the Application and added SQL Express as a pre-requisite for the Setup and Deployment project.

It installs SQL Express but when it tries to connect I receive:
"This is not a valid login Cannot open user default database. Login failed. Login failed for user 'NT AUTHORITY\SYSTEM'."

I don't seem to have any options using the "prerequisite options in VS 2005 in terms of command line deployment parameters.

Likewise I would prefer to attach the database to the instance (because I need to write a connection string from a PDA using RDA and I have zero clue how to do RDA directly back to the file).

Thanks for any help!
If you do not impersinate the user within your Asp application, the service account which the ASP Service is running with is used to connect to the SQL Server. If this account is not priviledged to access the server, you will get the mentioned error message. I don′t know how your application design is, but if you want to leave it as it is, you will have to grant access for the SYSTEM account to the server.

Jens K. Suessmeyer.

http://www.sqlserver2005.de

Friday, February 24, 2012

deploy SQL Server Express

Problem: (asp.net 2.0)

I x-copy from my development server a database named C:\site_test\site.mdf to C:\site. When I attach the database with Server Management Studio Express, it list the name as: "C:\site_test\site.mdf" eventhough on the live server the database is in the C:\site directory and my connection string in my web.config is "C:\site\site.mdf".


But everything works until a week later when I need to make a field change to a table on the live site: I'm forced to re-attach the database, but this time it list the database as:C:\site\site.mdf". When I re-attach I get a NT AUTHORITY\SERVICE does not have permission. So I give NT AUTHORITY\SERVICE permission on the directory and files and ownership with Server Management Stuidio Express, but I still get the error.

What am I'm doing wrong? Thanks for the help

--Dietrich

Hi Dietrich,

If you have attached the .mdf file to database manually, please check if you have set the connection string accordingly.

It has to be "Data Source=ServerName\Instancename; Initial Catelog=DatabaseName"

Deploy Report Model without VS

Is it possible to deploy report models without Visual Studio?
I ask this for when it comes to deploy an ASP.NET project to a
customer that includes reports and they would like to use the Report
Builder.
I've heard use of the RS Web Service but I have not seen any code.
This would normally be a one time event at time of deployment to
production but could involve future updates. These future update
deployments would not be possible with VS (except for the actual
editing of the update).I've used rs.exe to create folders, datasources, and reports, but what
I'm conerned about is the Models folder, the datasource view and
anything else that the "Report Builder" needs before it can be run for
the first time by the end users.

Deploy on the hoster

Dears,

I have devoloped an application ASP.NET 2.0.

Before I have builded the aspnetdb throught the command then I built some tables and stored procedures on this db. (My db is sql express 2005 and my hoster db is sql 2005 workgroup)

My hoster doesn't allow connection Management studio express, doesn't allow attach or restore functionalities.

Than I have built my script db (contains Tables, Views and Stored Procedures), I have substituted the dbo with my user account in the script because my hoster doesn't allow the dbo access.

I have also transfered my site files (.aspx, img, etc.) on the server.

When I try to access the db I receive this error (for example when I push on the button create user):

The SSE Provider did not find the database file specified in the connection string. At the configured trust level (below High trust level), the SSE provider can not automatically create the database file.

Please could you help me?

Thank you.

I Forgot one thing!!

For allow the access throught an user different from dbo I have modified the "ASP.NET Provider Toolkit SQL Samples".

Thank you