database change...

Ok, in VS 2008 I have been using mdf for my database. NowI created a database in my control panel, and successfully attached my database to it. As well as my login data base...



<add name="ConnectionString" connectionString="Data Source=.\SQLEXPRESS;AttachDbFilename=|DataDirectory|\premieredb.mdf;Integrated Security=True;User Instance=True"


How do I change my program to access the sql database on the server instead of what I have above?

 

In the SQL 2005 page of your control panel, there is an example connection string. Copy and paste that for the connectionString value. You will have to change the password to your actual database password in the string.

Aristotle

DiscountASP.NET
www.DiscountASP.NET

 

Okay, I got it to work. I have another mdf file for what I assume is for my "Roles" and stuff. I made logins and it created a database called ASPNETDB.MDF. Do I need to make another database and attatch that one to it? If I do that, where do I added the connection to that database? I can't even find in my login page sourcewhere that database is even accessed.

Post Edited (Klexen) : 11/30/2007 1:27:19 AM GMT