asked on

Profile connection string

Sorry about the cryptic title. I want to use Profile properties in a new web applicaiton. I have it up and running without any significant trouble. However, I have two instances of SQL Server Express running on my desktop(I won't take the time to relate the story of how that happened). I want to remove one of these instances but I do not want to remover the copy that VS2008 is using to store my Profile Properties. VS2008 must store the connection to SQL server information somewhere. I would like to view that connection information so I can determine which instance of SQL that VS2008 is using.
Thanks,
pat

kaylanreilor

Can't just temporary stop one of the two servers, then run VS to see if it complains or not (and if it is not complaining check that the server has not been re-started) ?

mpdillon

ASKER

Yes, I could do that but I was hoping to gain a better understanding of the underlying process. As I move the web site from test to production, it is very possible the SQL server will be on a different server. At that point I will have to know how where the information is stored so that I can redirect the program to look at the remote server.

ASKER CERTIFIED SOLUTION

kaylanreilor

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

mpdillon

ASKER

Thanks. I see which instance of SQL server the aspnet.mdf is attached. I can delete the other.
I am still curious, when I move my project off the development machine and into production, how do I point the project to use an instance of SQL server on a remote machine. That is, the web project will be on Server A but SQL server will be on Sever B. How does the web project know to store its profile information on server B?

kaylanreilor

I suppose that if you check where the connection string is set in your init files that the name of the machine is specified.