assign configuration package

There is a configuration file which is used to hold a connectionstring for the ssis packages.
Once the configuration file is created then is it necessary to go to each package and then package configuration to point the package to the configuration file?
It seems the packages do not automatically refer to the config file. Instead each time the config file is changed then all the packages have to be pointed to the config file one by one. i.e. going from Dev to live.
Am I right?
Thanks

Once a package points to a config file, you don't have to do anything when migrating to different environments, provided the package can find that file in the new environment.

aspnetdb connection could not establish but database correctly created.

I installed netframework 2.0 Visual Web developer and MSSQL 2005 express edition with SQL Server management express.

I have got this configuration: 2*256 mb ram Intel Pentium 3.2Ghz Windows XP HUN SP2 latest version.

server name: localhost\SQLEXPRESS
Authentication: Windows Authentication

I run aspnet_regsql.exe and the setup wizard created aspnetdb see here, Microsoft sql server management studio can see the database:

But! When I run to the asp.net web application administration tool in Provider Configuration and choose
AspNetSqlProvider only 1
then I clickSelect a single provider for all site management data link -> then test

The Tool write this:
Could not establish a connection to the database.
If you have not yet created the SQL Server database, exit the Web SiteAdministration tool, use the aspnet_regsql command-line utility tocreate and configure the database, and then return to this tool to setthe provider.

Hi,

You application does not "know" where your database is. It is trying to find it in App_Data folder of your application. If it is not there you can specify its locaton by using connection string in web.config like this:

<connectionStrings>
<clear/>
<add name="LocalSqlServer" connectionString="data source=.\SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|aspnetdb.mdf;User Instance=true" providerName="System.Data.SqlClient"/>
</connectionStrings>

|||

<!--
 Note: As an alternative to hand editing this file you can use the
 web admin tool to configure settings for your application. Use
 the Website->Asp.Net Configuration option in Visual Studio.
 A full list of settings and comments can be found in
 machine.config.comments usually located in
 \Windows\Microsoft.Net\Framework\v2.x\Config
-->
<configuration xmlns="http://schemas.microsoft.com/.NetConfiguration/v2.0">
<appSettings/>
 <connectionStrings>
 <clear/>
 <add name="LocalSqlServer" connectionString="data source=.\SQLEXPRESS;Integrated Security=SSPI;AttachDBFilename=|DataDirectory|aspnetdb.mdf;User Instance=true" providerName="System.Data.SqlClient"/>
 </connectionStrings>
 <system.web>
<!--
 Set compilation debug="true" to insert debugging
 symbols into the compiled page. Because this
 affects performance, set this value to true only
 during development.
 Visual Basic options:
 Set strict="true" to disallow all data type conversions
 where data loss can occur.
 Set explicit="true" to force declaration of all variables.
 -->
<compilation debug="true" strict="false" explicit="true"/>
<pages>
<namespaces>
<clear/>
<add namespace="System"/>
<add namespace="System.Collections"/>
<add namespace="System.Collections.Specialized"/>
<add namespace="System.Configuration"/>
<add namespace="System.Text"/>
<add namespace="System.Text.RegularExpressions"/>
<add namespace="System.Web"/>
<add namespace="System.Web.Caching"/>
<add namespace="System.Web.SessionState"/>
<add namespace="System.Web.Security"/>
<add namespace="System.Web.Profile"/>
<add namespace="System.Web.UI"/>
<add namespace="System.Web.UI.WebControls"/>
<add namespace="System.Web.UI.WebControls.WebParts"/>
<add namespace="System.Web.UI.HtmlControls"/>
</namespaces>
</pages>
<!--
 The <authentication> section enables configuration
 of the security authentication mode used by
 ASP.NET to identify an incoming user.
 -->
<authentication mode="Windows"/>
<!--
 The <customErrors> section enables configuration
 of what to do if/when an unhandled error occurs
 during the execution of a request. Specifically,
 it enables developers to configure html error pages
 to be displayed in place of a error stack trace.
 <customErrors mode="RemoteOnly" defaultRedirect="GenericErrorPage.htm">
 <error statusCode="403" redirect="NoAccess.htm" />
 <error statusCode="404" redirect="FileNotFound.htm" />
 </customErrors>
 -->
</system.web>
</configuration>

I paste But doesn't work. modify the text or not? When I run the page createuserwizard

Kiszolgálóhiba t?rtént az alkalmazásban: ?/Website".Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. The connection will be closed.Leírás: Nem kezelt kivétel k?vetkezett be az aktuális webes kérelem végrehajtása során. A hibára és az azt okozó kódrészletre vonatkozó adatok az alábbi veremkivonatban találhatók.Hiba t?rtént az SQLExpress adatbázisfájl automatikus létrehozásakor:A kapcsolódási karakterlánc az alkalmazás App_Data k?nyvtárában található adatbázishelyet használó helyi SQL Server Express példányt ad meg. A szolgáltató megkísérelte automatikusan létrehozni az alkalmazás szolgáltatási adatbázisát, mert a szolgáltató megállapította, hogy az adatbázis nem létezik. A k?vetkez? konfigurálási k?vetelmények megléte szükséges ahhoz, hogy az alkalmazás szolgáltatási adatbázisának létezése sikeresen ellen?rizhet? legyen, és hogy az alkalmazás szolgáltatási adatbázisa automatikusan létrehozható legyen: 1. Ha még nem létezik az alkalmazás App_Data k?nyvtára, a webkiszolgálói fióknak olvasási és írási hozzáféréssel kell rendelkeznie az alkalmazás k?nyvtárához. Ez azért szükséges, mert a webkiszolgálói fiók automatikusan létre fogja hozni az App_Data k?nyvtárat, ha az még nem létezik. 2. Ha már létezik az alkalmazás App_Data k?nyvtára, a webkiszolgálói fióknak csak az alkalmazás App_Data k?nyvtárához van szüksége olvasási és írási hozzáférésre. Ez azért szükséges, mert a webkiszolgálói fiók megkísérli ellen?rizni, hogy az alkalmazás App_Data k?nyvtárában már létezik-e az SQL Server Express adatbázis. Ha visszavonja a webkiszolgálói fióktól az olvasási engedélyt az App_Data k?nyvtárhoz, a szolgáltató nem fogja tudni helyesen megállapítani, hogy már létezik-e az SQL Server Express adatbázis. Ez hibát okoz, amikor a szolgáltató megpróbálja még egyszer létrehozni a már létez? adatbázis másodpéldányát. Az írási hozzáférés azért szükséges, mert az új adatbázis létrehozásához a webkiszolgálói fiók hitelesít? adatait kell használni. 3. A számítógépen telepítve kell lennie az SQL Server Express programnak. 4. A webkiszolgálói fiók folyamatidentitásának helyi felhasználói profillal kell rendelkeznie. A mind a számítógéphez, mind a tartományi fiókokhoz készített helyi felhasználói profil létrehozásáról az információs fájl tartalmaz további tudnivalókat.Forráshiba:Az aktuális webes kérelem végrehajtása nem kezelt kivételt okozott. A kivétel okára és helyére vonatkozó adatok az alábbi veremkivonatban találhatók.Veremkivonat:[SqlException (0x80131904): Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. The connection will be closed.] System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +735027 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +188 System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +1838 System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK) +33 System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +628 System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +170 System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +130 System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup) +27 System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +47 System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +105 System.Data.SqlClient.SqlConnection.Open() +111 System.Web.Management.SqlServices.GetSqlConnection(String server, String user, String password, Boolean trusted, String connectionString) +67[HttpException (0x80004005): Nem lehet csatlakozni az SQL Server adatbázishoz.] System.Web.Management.SqlServices.GetSqlConnection(String server, String user, String password, Boolean trusted, String connectionString) +122 System.Web.Management.SqlServices.SetupApplicationServices(String server, String user, String password, Boolean trusted, String connectionString, String database, String dbFileName, SqlFeatures features, Boolean install) +89 System.Web.Management.SqlServices.Install(String database, String dbFileName, String connectionString) +26 System.Web.DataAccess.SqlConnectionHelper.CreateMdfFile(String fullFileName, String dataDir, String connectionString) +388Verzióinformáció: Microsoft .NET-keretrendszer verziója:2.0.50727.42; ASP.NET verziója:2.0.50727.42

|||

I don't understand I try to make an other database in app_data new_item anotherdatabase.mdf and I have got this message:
Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. The connection will be closed.
I reinstall everything maybe next time work normal.

|||

Where is located aspnetdb.mdf?

|||

C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\here

But I try to put them into the App_Data and doesn't work.
I install Windows Longhorn Beta (server 2008) and sites runingI try the same in my notebook windows XP HUN and workso I don't know what is the problem ,but NOW run everything and I don't care.

asp:login / ASP.NET Configuration menu / & login DB

All,

I may have bitten off a bit much here, but here goes. I'm trying to learn ASP.NET while at the same time learning SQL 2005. I have two machines. One is running Visual Studio 2005 and SQL 2005 Express. The other is my "production" box which is running VWD 2005 and SQL 2005 Standard. I picked up some WROX books and began learning. So far so good until about half way through the book on ASP (keep in mind I haven't learned SQL yet). I learned that I can use the ASP.NET configuration menu to automagically create a database, populate it with users, add them to profiles (groups), and grant them rights to pages. This was kind of neat and it worked fine on my dev box. So I looked up in my SQL book how to detach a DB, copy it over to the other machine and re-attach it. So I copied the whole web site (DB and all, under APP DATA) to the other machine and reattached it. This seemed to go well, however when I tried to log in I recieved an error.

***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)

After doing some hunting around I discovered that I'm supposed to have a connection string. I checked my web.config file and the only thing I find there is

<

appSettings/>

<

connectionStrings/>

<

system.web>

As you can see this doesn't point to a database which the docs I found say is how you connect to them. Apparently one error someone can run into is between expree and SQL where you have to change the connection string. Well, it's not in the web.config. So I checked the default and login page (and code behind files), but found nothing. So, I'm at a loss. I have no idea where the problem is or where to go from here. Any assistance will be appreciated. While I'm enjoying the journey of learning this, the road seems to be kind of bumpy.

Thanks in advance - Stephen

Hi Stephen,

to change default connection string in web.config you can remove and add new one it's name LocalSqlServer like..

<connectionStrings>
<removename="LocalSqlServer"/>
<addname="LocalSqlServer"connectionString="your connection string..."/>
</connectionStrings>

and give look at this article aboutMembership you will find also how to config Membership

I hope this help

ASP.Net service account gray out

I am installing RS2005 on Windows server 2000 with IIS 5.0. Everything is fine in configuration tool except service account. It is empty. I have added ASPNET account in reportservice user group and tried to add <machinename>\ASPNET to <WebServiceAccount>. It is still empty. Any idea?

Thanks.

Hello,

I believe this is pulled from the Identity of your application pool. Go to IIS and set the identity there and it should be reflected in the RS Configuration Manager.

Hope this helps.

Jarret

|||

Hi,

It seems that application pool is only for IIS6.0. I am using IIS5.0. How can I set the identity in this case

thanks

Ken

|||Therer's no direct way (from RS tools at least) to set IIS5 app pool identities. In fact, there's no way in IIS to set IIS5 app pool identities. I've heard that you can modify a .config file and change the IIS5 app pool identity, but I've not tried this myself.|||Yes, I have changed <WebServiceAccount> tag in RSReportServer.config but it doesn't work. I think Jarret is right. The identity is from somewhere in IIS setting.

I also installed report service in XP pro. I don't need to set anything to let it work. I am not sure if there is something special in Windows 2000 Server.
|||

Has anyone installed Report service 2005 on Windows 2000 server successfully? Please give comment. I appreciate it.

Ken

|||Did anybody solve this issue?

ASP.NET Configuration with VWD 2005 Express Ed.

I am deploying a new website (hosted at Godaddy.com) and want to take advantage of some of the power VWD 5005 offers. Specificaly the 'ASP.NET Configuration' under the 'Website' menu item. How do I go about using the ASP.NET Configuration on a site that is hosted? Is it possible? I want to be able to add new rolls, create some users manually and set permissions on directories. If I cant use ASP.NET Configuration how do i go about this task in a hosted environment. My host is GoDaddy.com

Thank you,

Unfortunately the ASP .NET Web Site Administration Tool?can?only?be?used?to?manage?local?applications.?

Fortunate some tools are available to manage corresponding records in membership database,?you?can take a look at this?tool:

http://peterkellner.net/2006/01/09/microsoft-aspnet-20-memberrole-management-with-iis/

asp.net configuration tool

I deployed a web site, and converted SQL Server Express to a single SQL Server 2005 database. I created all of the tables required for memberships and roles with aspnet_regsql.exe.

Real simple question - how can I populate the membership and role tables out on the server? When I attach VWD to it, the ASP.NET Configuration tool is gone. How do you maintain memberships and roles without the tool?

Thanks for any help you will share :)

It's been a long journey but I am finally here!

Hi CK,

I'm going to punt on this one.

The ASP.net forums is a better place to ask questions about ASP.net and Visual Web Developer. You can find all the forums at http://forums.asp.net/ and the forum that is specifically about SQL Express in VWD at http://forums.asp.net/54/ShowForum.aspx.

I can't redirect outside of MSDN, so you'll need to repost the question in the new forum.

Mike

|||

Hi mike,

You helped me SO MUCH already on other questions -- xoxo

I'll buy you a beer if you are in redmond and when I get this one figured out.

Are you in?

ck

|||

It's beer time Mike.

VWD asp.net configuration tool successfully allowed me to update roles and memberships.

My web site is up and running.

For future reference, this article was of help: 4guysfromrolla.com article 040506-1

thanks again for helping me - let's go!