Attaching SQL Express Database
Re-invent ASP.NET Hosting Community
Home       Members    Calendar    Who's On
Welcome Guest ( Login | Register )
        



Attaching SQL Express Database Expand / Collapse
Author
Message
Posted 12/3/2006 5:27:00 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: Forum Members
Last Login: 7/19/2008 8:13:35 PM
Posts: 9, Visits: 6

Greetings Folks,

I've uploaded my site which includes Login Controls and a SQL Express database.

All of the database files are in the App_Data folder.

How do I get the database attached so Ican use the Login and datbase functions?

Thanks

Post #444
Posted 12/4/2006 1:27:00 PM
Supreme Being

Supreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme Being

Group: Administrators
Last Login: 2 days ago @ 7:12:08 PM
Posts: 105, Visits: 264

Hello!

Yes we do this at no charge, just email support or submit a ticket to our support dept and they will be happy to get that attached for you quickly.

Thanks for choosing Re-invent!



Plato
Re-invent Technologies LLC
Re-invent Support Team
http://www.re-invent.com

Specializing in ASP.NET Hosting

Post #445
Posted 12/4/2006 1:41:00 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: Forum Members
Last Login: 7/19/2008 8:13:35 PM
Posts: 9, Visits: 6
Thanks Plato,
The database has been attached. How should I modify my connection string to get the Login controls and database working?
Post #446
Posted 12/4/2006 1:54:00 PM
Supreme Being

Supreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme BeingSupreme Being

Group: Administrators
Last Login: 2 days ago @ 7:12:08 PM
Posts: 105, Visits: 264

Hello,

You may be the same person I'm working with via Support Email.  I'm not sure as I have someone with the same question.  Here is the info:

You would need to update your connectionstrings to use the SQL 2005 database rather than the Express and make sure there is no mention of the Express Database strings:

Here is an example, you'll need to substitute your own information:

<connectionStrings>

<add name="MyConnectionDB" connectionString="Data Source=MYSQLSERVER;Integrated Security=false;Initial Catalog=MYDATABASE;User ID=MYUSER;Password=MYPASSWORD" providerName="System.Data.SqlClient"/>

<remove name="LocalSqlServer"/>

<add name="LocalSqlServer" connectionString="Data Source=MYSQLSERVER;Integrated Security=false;Initial Catalog=MYDATABASE;User ID=MYUSER;Password=MYPASSWORD" providerName="System.Data.SqlClient" />

</connectionStrings>



Plato
Re-invent Technologies LLC
Re-invent Support Team
http://www.re-invent.com

Specializing in ASP.NET Hosting

Post #447
Posted 12/4/2006 3:07:00 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: Forum Members
Last Login: 7/19/2008 8:13:35 PM
Posts: 9, Visits: 6
Thanks Plato, I'll give it a shot when I get home today
Post #448
« Prev Topic | Next Topic »


Reading This Topic Expand / Collapse
Active Users: 0 (0 guests, 0 members, 0 anonymous members)
No members currently viewing this topic.
Forum Moderators: Administrator, Re-invent (Paul), Re-invent (Nick)

Permissions Expand / Collapse

All times are GMT -5:00, Time now is 7:08am

Powered By InstantForum.NET v4.1.4 © 2008
Execution: 0.031. 9 queries. Compression Disabled.


Copyright 2007 Re-invent Technologies LLC All Rights Reserved.