Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I am looking for a SQL Server file I am supposed to delete, only the instructions I found for this are for Windows XP and my OS is Windows Vista.

And as ridiculous as this is, I cannot find this file path in Vista:

C:\Documents and Settings\YOUR_USERNAME\Local Settings\Application Data\Microsoft\Microsoft SQL Server Data\SQLEXPRESS

can someone help me out?

EDIT:

ok guys, well what I am actually trying to do is resolve an Web developer 2008 express edition connection to sql server 2005 express issue that I am having.

So I found this page, and I am trying to accomplish set 2 but cannot find the file in my own computer anywhere!

http://www.aspdotnetfaq.com/Faq/fix-error-Failed-to-generate-a-user-instance-of-SQL-Server-due-to-a-failure-in-starting-the-process-for-the-user-instance.aspx

share|improve this question

migrated from serverfault.com Jan 20 '10 at 7:17

This question came from our site for professional system and network administrators.

    
This question would be better suited at serverfault.com. –  Anonymous Jan 20 '10 at 3:01
    
Actually, superuser would be better. This is just a general xp=>vista question. It's only incidental that he's looking for a sql server db file. –  Joel Coehoorn Jan 20 '10 at 3:08
    
oops...sorry i will ask there then –  Fretwizard Jan 20 '10 at 3:18
    
Hello, welcome to SuperUser. Your question has been migrated here, where it is more adapted. To regain ownership over your question, you should create an account here, and associate it with your ServerFault account in user options. –  Gnoupi Jan 20 '10 at 9:00

3 Answers 3

up vote 2 down vote accepted

I think in Vista this would be:

C:\Users\YOUR_USERNAME\AppData\Local\Microsoft.....

AppData is a hidden folder, in case you can't find it in Windows Explorer.

share|improve this answer
    
yeah i tried to search through everything that is under me, and I can find nothing that points to 'local settings' or any folder taht is similiar. so that is why i just asked cause i thought perhaps i was way off. thanks! –  Fretwizard Jan 20 '10 at 2:58
    
UH YEAH..."me" being my username. :D –  Fretwizard Jan 20 '10 at 2:59

I thought it might have to do with 64 bit stuff... Googled; found this:
http://kometbomb.net/2009/05/07/migrating-from-32-bit-xp-to-64-bit-windows-7/

The Application Data and the Local Settings\Application Data folders that previously were right under the user directory are now in C:\Users\kometbomb\AppData\ and C:\Users\kometbomb\AppData\Local\, respectively. I just dropped the Firefox and Thunderbird profile folders in there and here I am again with the same setup.

share|improve this answer
    
That's just Vista & 7 vs. XP. Not related to 32-bit vs. 64-bit. –  Andrew Medico Jan 20 '10 at 3:06

%LOCALAPPDATA%\Microsoft\Microsoft SQL Server Data\SQLEXPRESS

Environment variables are the way to go, easier to remember and easier to navigate around with. There are additional ones here if you are interested.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.