Sql Server 2012 - local copy can find server

I installed a local copy of SQL 2012 a few months back,  now that I am attempting to connect to the local instance I previously set up I am getting the following error.  Do I need to reinstall the evaluation version? or what am I missing.

screenshot.png
Thanks,

K
Karen SchaeferBI ANALYSTAsked:
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.

dsackerContract ERP Admin/ConsultantCommented:
Is the instance by chance named:  KARENSPLACE\EXPRESS?

In a command point, type: SQLCMD -L

Is your instance anywhere in that list?
0
Karen SchaeferBI ANALYSTAuthor Commented:
it returned no results
0
dsackerContract ERP Admin/ConsultantCommented:
Open up regedit.exe ... look in HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Microsoft SQL Server\Instance Names\SQL

See if you can find what you'd expect there. If you can't, then it was deleted on that computer.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Karen SchaeferBI ANALYSTAuthor Commented:
how do i create a new connection - I am new to this.
0
dsackerContract ERP Admin/ConsultantCommented:
That registry entry (above in my last post) was for the 32-bit. Look in:

HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\Instance Names\SQL
0
dsackerContract ERP Admin/ConsultantCommented:
A new connection for what? Or do you mean a new instance?

To create a new instance, just open the installer and follow its instructions.
0
Karen SchaeferBI ANALYSTAuthor Commented:
there is not an instance folder.  Does this mean it got deleted, and if so how do I recreate it.

screenshot.png
0
YZlatCommented:
Try using "KARENSPLACE" as the server name when logging in. That's the default instance
0
dsackerContract ERP Admin/ConsultantCommented:
Under  MSSQLServer I would expect to see "Instance Names". That means you don't have any instances installed on your computer.

Sure you're not trying to access an instance on some remote computer, or is this strictly from home?
0
Karen SchaeferBI ANALYSTAuthor Commented:
what is an installation folder, where should if be located?  for a local copy.  I installed sql on my local pc.  I currently have two versions 2008 and 2012.

k
0
Karen SchaeferBI ANALYSTAuthor Commented:
strictly home pc for training purposes..

K
0
YZlatCommented:
Did you try just using server name without instance name??
0
Karen SchaeferBI ANALYSTAuthor Commented:
YZlat,

Tried that and it could find KarensPlace.

K
0
Karen SchaeferBI ANALYSTAuthor Commented:
what is an installation folder, where should if be located?  for a local copy.  I installed sql on my local pc.  I currently have two versions 2008 and 2012.

k
0
dsackerContract ERP Admin/ConsultantCommented:
It should be under C:\Program Files\Microsoft SQL Server and further beneath.

Look for files ending in .mdf
0
dsackerContract ERP Admin/ConsultantCommented:
Sounds like KARENSPLACE (without the \extra) is what you're looking for.
0
Karen SchaeferBI ANALYSTAuthor Commented:
here is where i am at in the installation process.

screenshot.png
0
Karen SchaeferBI ANALYSTAuthor Commented:
tried just KarensPlace - see no luck.
screenshot.png
0
Karen SchaeferBI ANALYSTAuthor Commented:
It should be under C:\Program Files\Microsoft SQL Server and further beneath.

Look for files ending in .mdf

Tried just opening the adventureworks file with mdf - and said server not found.
0
dsackerContract ERP Admin/ConsultantCommented:
Well, that looks like KARENSPLACE\KAREN was the instance name.

Can you connect to SQL Server using the SA login id? When you installed it would have asked you for a password.
0
Karen SchaeferBI ANALYSTAuthor Commented:
Can you connect to SQL Server using the SA login id? When you installed it would have asked you for a password.

Don't Remember - I installed the sql several months back.
tried sa login - still errors out.
screenshot.png
0
dsackerContract ERP Admin/ConsultantCommented:
Seeing MSSQL$KAREN verifies that you created an instance called KARENSPLACE\KAREN.

Can you make sure the MSSQL service is started? Look at your Services (under Control Panel, Administrative).
0
Karen SchaeferBI ANALYSTAuthor Commented:
I am using Windows 8 and I do not see the folder in question.
0
dsackerContract ERP Admin/ConsultantCommented:
In the search, type Services. Open it up that way.
0
Karen SchaeferBI ANALYSTAuthor Commented:
found services folder,

here is the results.  which one should I be using.screenshot.png
0
dsackerContract ERP Admin/ConsultantCommented:
Don't know how they got "disabled", but enable and start (KAREN). See if you can connect.
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
Karen SchaeferBI ANALYSTAuthor Commented:
unforunately I don't remember the admin password and when I try the local still won't open from the sql studio.

how do I create a new instance?
0
Karen SchaeferBI ANALYSTAuthor Commented:
nevermind i closed down management studio and open the server again and it seems to have worked.  Thanks for all your time and effort and patience.
0
Karen SchaeferBI ANALYSTAuthor Commented:
thanks for the great assist.
0
dsackerContract ERP Admin/ConsultantCommented:
Very welcome. Glad that worked. One final thing: Set that service to "Automatic", so that it starts up whenever you reboot your computer.

All the best.
1
Karen SchaeferBI ANALYSTAuthor Commented:
Turns out I was wrong don't have it fixed - the database Engine I was connecting to was 2008 version, and when I try to connect to the 2012. I unable to make a connection.  I hate to ask but still need your assistance.

I have two version so sql server installed and it can get confusing.  I reset the services for the 2012 versions and made sure they were all set to Lccal w/o password, including the SQL Agent as a dependent.

screenshot.png
0
dsackerContract ERP Admin/ConsultantCommented:
Start up the other service that says SQL Server (MSSQLSERVER). See if you can connect to either KARENSPLACE\KAREN or KARENSPLACE afterward.
0
Karen SchaeferBI ANALYSTAuthor Commented:
SQL Server (MSSQLSERVER) is the wrong version of Sql Server

MSSQL10_50.MSSQLSERVER.

Should I clear all these out and start fresh by reinstalling the correct version or is there a way to edit the installation process to point at the correct version?

Thanks,

K
0
dsackerContract ERP Admin/ConsultantCommented:
Yes, that probably would be best. I'd uninstall every version of SQL Server you have and start fresh. SQL Server 2012 at the least. If you're adventuresome, you can install 2014. It's free (the express version).

Don't forget to note and save your SA password. :)
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
Microsoft SQL Server

From novice to tech pro — start learning today.

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.