hi! i have a BIG Problem...i update the Commerce Starkit and edit the Commerce.mdf database,its ok in my pc but once i transer the files to another computer it does'nt work.
here is what i do to transfer the files from my pc to another pc, i copy the modified Commerce Starkit and paste it to
c:\Intepub\wwwroot (from another pc), then i copy the Commerce.mdf and Commerce.ldf from the MS SQL folder, then paste it to another pc with MSDE also installed.
Once i run the modified Commerce Starterkit in another pc it generates this kind of ERROR:
Cannot open database requested in login 'Commerce'. Login fails. Login failed for user 'LOCALSERVER\ASPNET'.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Data.SqlClient.SqlException: Cannot open database requested in login 'Commerce'. Login fails. Login
failed for user 'LOCALSERVER\ASPNET'.
Source Error:
Line 30: Dim productCatalogue As ASPNET.StarterKit.Commerce.ProductsDB = New ASPNET.StarterKit.Commerce.ProductsDB()
Line 31:
Line 32: MyList.DataSource = productCatalogue.GetProducts(categoryId)
Line 33: MyList.DataBind()
Line 34:
Source File: c:\inetpub\wwwroot\STIeCommerce\productslist.aspx Line: 32
Stack Trace:
[SqlException: Cannot open database requested in login 'Commerce'. Login fails.
Login failed for user 'LOCALSERVER\ASPNET'.]
System.Data.SqlClient.ConnectionPool.GetConnection(Boolean& isInTransaction) +474
System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString options, Boolean& isInTransaction)
+372
System.Data.SqlClient.SqlConnection.Open() +384
ASPNET.StarterKit.Commerce.ProductsDB.GetProducts(Int32 categoryID)
ASP.ProductsList_aspx.Page_Load(Object sender, EventArgs e) in c:\inetpub\wwwroot\STIeCommerce\productslist.aspx:32
System.Web.UI.Control.OnLoad(EventArgs e) +67
System.Web.UI.Control.LoadRecursive() +35
System.Web.UI.Page.ProcessRequestMain() +731
i can't solve this problem, what is the proper way to transfer the Commerce.mdf to another pc, it ask for user and password account, but if i try to install the ASP.NET Commerce(VBSDK) Installer 1.0 its ok, however i have to delete the previous
Commerce.mdf and Commerce.ldf files to able to install the ASP.NET Commerce(VBSDK) Installer 1.0 . if i try to replace the Commerce.mdf and paste the modified Commerce.mdf it generates the same error. What i have to do?? I eagerly need this to
solve..pls help me with this problem, i've been stuck here for almost 5 days.