Karen Schaefer
asked on
Sql Server 2012 - local copy can find server
ASKER
it returned no results
Open up regedit.exe ... look in HKEY_LOCAL_MACHINE\SOFTWAR E\Wow6432N ode\Micros oft\Micros oft 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.
See if you can find what you'd expect there. If you can't, then it was deleted on that computer.
ASKER
how do i create a new connection - I am new to this.
That registry entry (above in my last post) was for the 32-bit. Look in:
HKEY_LOCAL_MACHINE\SOFTWAR E\Microsof t\Microsof t SQL Server\Instance Names\SQL
HKEY_LOCAL_MACHINE\SOFTWAR
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.
To create a new instance, just open the installer and follow its instructions.
ASKER
Try using "KARENSPLACE" as the server name when logging in. That's the default instance
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?
Sure you're not trying to access an instance on some remote computer, or is this strictly from home?
ASKER
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
k
ASKER
strictly home pc for training purposes..
K
K
Did you try just using server name without instance name??
ASKER
YZlat,
Tried that and it could find KarensPlace.
K
Tried that and it could find KarensPlace.
K
ASKER
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
k
It should be under C:\Program Files\Microsoft SQL Server and further beneath.
Look for files ending in .mdf
Look for files ending in .mdf
Sounds like KARENSPLACE (without the \extra) is what you're looking for.
ASKER
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.
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.
Can you connect to SQL Server using the SA login id? When you installed it would have asked you for a password.
ASKER
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).
Can you make sure the MSSQL service is started? Look at your Services (under Control Panel, Administrative).
ASKER
I am using Windows 8 and I do not see the folder in question.
In the search, type Services. Open it up that way.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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?
how do I create a new instance?
ASKER
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.
ASKER
thanks for the great assist.
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.
All the best.
ASKER
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.
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.
Start up the other service that says SQL Server (MSSQLSERVER). See if you can connect to either KARENSPLACE\KAREN or KARENSPLACE afterward.
ASKER
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
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
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. :)
Don't forget to note and save your SA password. :)
In a command point, type: SQLCMD -L
Is your instance anywhere in that list?