Geekzone: technology news, blogs, forums
Guest
Welcome Guest.
You haven't logged in yet. If you don't have an account you can register now.


Forums › IT Pro and developers › ASP.Net website, changing the admin mdf database to live on an sql server


411 posts

Ultimate Geek


# 38604 1-Aug-2009 21:43
Send private message

So, im workiing on this project at th emoment and I have the ASPNETDB database (The one which does all the login stuff, is a tool that you drag on and the database gets automatically created.

I migrated that .MDF database file to live on a proper SQL Server Database, but the problem I now have is that the program now cant find that database.

I cant figure out how to change the link to point at the SQL database rather than the .MDF file
Does anyone know how to do this?

Im using Visual Studio 2008 and SQL Server 2005 Developer on Server 2003

Thanks in advanced!




-- Divett Enterprises -- The Power Of Tomorrow --

Create new topic
Phil Gale
1108 posts

Uber Geek
+1 received by user: 45

Trusted
Red Jungle
Subscriber

  # 241328 1-Aug-2009 22:03
Send private message

If I'm understanding that correctly, then it should be just a matter of updating your SQL connection string in the Web.config

Rather than pointing to the .mdf, you'll want something like this:

Data Source=myServerAddress;Initial Catalog=myDataBase;User Id=myUsername;Password=myPassword;




Red Jungle: we make fantastic software

RSS  Twitter  Facebook  Skype

96 posts

Master Geek


  # 241684 3-Aug-2009 09:02
Send private message

Here is the connection string from my web.config file on a server connecting to a MSSQL database
name="name" connectionString="Data Source=DBSERVERIP;Initial Catalog=DBNAME;User ID=DBUSERD;password=DBPASSWORD;Trusted_Connection=no;

 
 
 
 


8033 posts

Uber Geek
+1 received by user: 390

Trusted
Subscriber

  # 241828 3-Aug-2009 15:35
Send private message

Don't forget http://www.connectionstrings.com/ :)



411 posts

Ultimate Geek


  # 242307 4-Aug-2009 12:19
Send private message

Does anyone have an example connection string for the ASPNETDB database (The default one when creating the login form)




-- Divett Enterprises -- The Power Of Tomorrow --

Create new topic



Twitter »

Follow us to receive Twitter updates when new discussions are posted in our forums:



Follow us to receive Twitter updates when news items and blogs are posted in our frontpage:



Follow us to receive Twitter updates when tech item prices are listed in our price comparison site:





News »

HPE to acquire supercomputing leader Cray
Posted 20-May-2019 11:07

Techweek starting around NZ today
Posted 20-May-2019 09:52

Porirua City Council first to adopt new council software solution Datascape
Posted 15-May-2019 12:00

New survey provides insight into schools' technology challenges and plans
Posted 15-May-2019 09:30

Apple Music now available on Alexa devices in Australia and New Zealand
Posted 15-May-2019 09:11

Make a stand against cyberbullying this Pink Shirt Day
Posted 14-May-2019 20:23

Samsung first TV manufacturer to launch the Apple TV App and Airplay 2
Posted 14-May-2019 20:11

Vodafone New Zealand sold
Posted 14-May-2019 07:25

Kordia boosts cloud performance with locally-hosted Microsoft Azure ExpressRoute
Posted 8-May-2019 10:25

Microsoft Azure ExpressRoute in New Zealand opens up faster, more secure internet for Kiwi businesses
Posted 8-May-2019 09:39

Vocus Communications to deliver Microsoft Azure Cloud Solutions through Azure ExpressRoute
Posted 8-May-2019 09:25

Independent NZ feature film #statusPending to premiere during WLG-X
Posted 6-May-2019 22:13

The ultimate dog photoshoot with Nokia 9 PureView #ForgottenDogsofInstagram
Posted 6-May-2019 09:41

Nokia 9 PureView available in New Zealand
Posted 6-May-2019 09:06

Motorola Solutions joins local partners to deliver advanced communications network in New Zealand
Posted 30-Apr-2019 21:50


Geekzone Live »

Try automatic live updates from Geekzone directly in your browser, without refreshing the page, with Geekzone Live now.


Support Geekzone »

Our community of supporters help make Geekzone possible. Click the button below to join them.

Support Geezone on PressPatron


Updates »

Are you subscribed to our RSS feed? You can download the latest headlines and summaries from our stories directly to your computer or smartphone by using a feed reader.

Alternatively, you can receive a daily email with Geekzone updates.