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.
Who is Participating?
kaylanreilorConnect With a Mentor Commented:
Well, I'm not sure to understand your needs but,
- if you go there : Control Panel => Administrative Tools => Services then you should find your SQL Server (let say MSSQLSERVER) then when clicking on property you will have some info.
- if you go there in the registry : HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\MSSQLSERVER
you will get some other info
- or you can add or modify a connection to a DB through the Server Explorer of VS and then play with the "Advanced properties" dlg of the "Modify Connection" dlg.

But how did you manage this connection when you've developped your web site ?
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) ?
mpdillonAuthor Commented:
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.
mpdillonAuthor Commented:
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?
I suppose that if you check where the connection string is set in your init files that the name of the machine is specified.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.