SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2012 Forums
 SQL Server Administration (2012)
 using sql 2012 locally
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

esthera
Flowing Fount of Yak Knowledge

1392 Posts

Posted - 05/25/2014 :  08:58:53  Show Profile  Reply with Quote
I want to set up sql 2012 locally

I have sql management studio 2012 set up that I connect to other servers

How do I set up sql management studio locally?
(I want to set up a local db for testing)

and then how do I connect to the local instance from the same computer?

tkizer
Almighty SQL Goddess

USA
36985 Posts

Posted - 05/25/2014 :  19:14:16  Show Profile  Visit tkizer's Homepage  Reply with Quote
You need to install the database engine and then would connect like this: hostname or hostname\instancename.

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

esthera
Flowing Fount of Yak Knowledge

1392 Posts

Posted - 05/26/2014 :  00:27:35  Show Profile  Reply with Quote
how can i tell if it's installed?


and what is hostname and instancename?

Go to Top of Page

khtan
In (Som, Ni, Yak)

Singapore
17638 Posts

Posted - 05/26/2014 :  01:00:59  Show Profile  Reply with Quote
quote:
Originally posted by esthera

how can i tell if it's installed?



http://msdn.microsoft.com/en-us/library/ms366339.aspx

quote:
Originally posted by esthera
and what is hostname and instancename?



Hostname = server name / computer name

instance name = name given to multiple instance of SQL Server installed on same machine


KH
Time is always against us

Go to Top of Page

esthera
Flowing Fount of Yak Knowledge

1392 Posts

Posted - 05/26/2014 :  02:10:24  Show Profile  Reply with Quote
I installed local db but I still don't see it under services in sql configuration manager
Go to Top of Page

khtan
In (Som, Ni, Yak)

Singapore
17638 Posts

Posted - 05/26/2014 :  11:02:34  Show Profile  Reply with Quote
What edition of SQL Server did you installed ?


KH
Time is always against us

Go to Top of Page

esthera
Flowing Fount of Yak Knowledge

1392 Posts

Posted - 05/26/2014 :  12:00:43  Show Profile  Reply with Quote
2012


Microsoft SQL Server Management Studio 11.0.2100.60
Microsoft Data Access Components (MDAC) 6.1.7601.17514
Microsoft MSXML 3.0 6.0
Microsoft Internet Explorer 9.10.9200.16798
Microsoft .NET Framework 4.0.30319.18408
Operating System 6.1.7601
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
36985 Posts

Posted - 05/26/2014 :  20:03:24  Show Profile  Visit tkizer's Homepage  Reply with Quote
Check services in Control Panel and see what you have for SQL Server*.

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

khtan
In (Som, Ni, Yak)

Singapore
17638 Posts

Posted - 05/26/2014 :  22:51:09  Show Profile  Reply with Quote
Is it Standard Edition ? Enterprise or Developer Edition ?


KH
Time is always against us

Go to Top of Page

esthera
Flowing Fount of Yak Knowledge

1392 Posts

Posted - 05/27/2014 :  01:10:24  Show Profile  Reply with Quote
I don't even see sql server in services

what should I download to get this working?

(I did run localdb and it said installed successfully but I don't see it)
Go to Top of Page

khtan
In (Som, Ni, Yak)

Singapore
17638 Posts

Posted - 05/27/2014 :  01:29:35  Show Profile  Reply with Quote
install Express or Developer edition


KH
Time is always against us

Go to Top of Page

esthera
Flowing Fount of Yak Knowledge

1392 Posts

Posted - 05/27/2014 :  13:38:15  Show Profile  Reply with Quote
I am getting an error Installation of SQL server 2012 express localdb failed because a higher version already exists on the machine.


but I don't know where to get the right version
(I thought I installed it but I don't see it in services so I assume that means it's not installed
Go to Top of Page

tkizer
Almighty SQL Goddess

USA
36985 Posts

Posted - 05/27/2014 :  13:48:19  Show Profile  Visit tkizer's Homepage  Reply with Quote
What is localdb?

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

esthera
Flowing Fount of Yak Knowledge

1392 Posts

Posted - 05/28/2014 :  01:44:22  Show Profile  Reply with Quote
I thought localdb is what I need to install

How do I run a sql database locally in 2012

I am trying to set up a database on my local computer for testing purposes
Go to Top of Page

khtan
In (Som, Ni, Yak)

Singapore
17638 Posts

Posted - 05/28/2014 :  03:56:59  Show Profile  Reply with Quote
install Express (free) or Developer Edition (not free)


KH
Time is always against us

Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.11 seconds. Powered By: Snitz Forums 2000