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
mpdillonAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

kaylanreilorCommented:
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) ?
0
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.
0
kaylanreilorCommented:
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 ?
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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?
0
kaylanreilorCommented:
I suppose that if you check where the connection string is set in your init files that the name of the machine is specified.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
.NET Programming

From novice to tech pro — start learning today.