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
This Question has been solved and asker verified All Experts Exchange premium technology solutions are available to subscription members.
Experts Exchange has been collecting answers to technology questions since 1996…3 million and counting! If you have a question, chances are we already have your answer.
If you can't find the exact answer you're looking for, ask our exclusive community of 50,000 experts. You’ll get a personalized answer from a trusted professional.
Thousands of free tech tips, tricks, how-to’s and tutorials are available in our peer reviewed articles section. See for yourself how smart our experts are, no login required.
Save solutions to your questions, answers you’ve discovered through searching plus helpful articles in your personal knowledgebase for easy future access.
Access the answers to your technology questions today.
30-day free trial. Register in 60 seconds.
Members of the expert community talk about why the experience at Experts Exchange is different than what you will find anywhere else.
Try it out and discover for yourself.
30-day free trial. Register in 60 seconds.
Join the community of experts here and help other tech pros by answering question in your area of expertise. You can earn FREE access to all Experts Exchange's premium features and resources.
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.
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\
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 ?
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?
Business Accounts
Answer for Membership
by: kaylanreilorPosted on 2008-02-01 at 03:27:08ID: 20795732
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) ?