| Author |
Topic |
|
esthera
Master Smack Fu Yak Hacker
1410 Posts |
 Posted - 2014-05-25 : 08:58:53
|
| I want to set up sql 2012 locallyI have sql management studio 2012 set up that I connect to other serversHow 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
38200 Posts |
Posted - 2014-05-25 : 19:14:16
|
| You need to install the database engine and then would connect like this: hostname or hostname\instancename.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
 |
|
|
esthera
Master Smack Fu Yak Hacker
1410 Posts |
Posted - 2014-05-26 : 00:27:35
|
| how can i tell if it's installed?and what is hostname and instancename? |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2014-05-26 : 01:00:59
|
quote:
Originally posted by esthera
how can i tell if it's installed?
http://msdn.microsoft.com/en-us/library/ms366339.aspxquote:
Originally posted by estheraand what is hostname and instancename?
Hostname = server name / computer nameinstance name = name given to multiple instance of SQL Server installed on same machine
KH[spoiler]Time is always against us[/spoiler] |
|
|
|
esthera
Master Smack Fu Yak Hacker
1410 Posts |
Posted - 2014-05-26 : 02:10:24
|
| I installed local db but I still don't see it under services in sql configuration manager |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2014-05-26 : 11:02:34
|
What edition of SQL Server did you installed ?
KH[spoiler]Time is always against us[/spoiler] |
|
|
|
esthera
Master Smack Fu Yak Hacker
1410 Posts |
Posted - 2014-05-26 : 12:00:43
|
| 2012Microsoft SQL Server Management Studio 11.0.2100.60Microsoft Data Access Components (MDAC) 6.1.7601.17514Microsoft MSXML 3.0 6.0 Microsoft Internet Explorer 9.10.9200.16798Microsoft .NET Framework 4.0.30319.18408Operating System 6.1.7601 |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2014-05-26 : 20:03:24
|
| Check services in Control Panel and see what you have for SQL Server*.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2014-05-26 : 22:51:09
|
Is it Standard Edition ? Enterprise or Developer Edition ?
KH[spoiler]Time is always against us[/spoiler] |
|
|
|
esthera
Master Smack Fu Yak Hacker
1410 Posts |
Posted - 2014-05-27 : 01:10:24
|
| I don't even see sql server in serviceswhat should I download to get this working?(I did run localdb and it said installed successfully but I don't see it) |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2014-05-27 : 01:29:35
|
install Express or Developer edition
KH[spoiler]Time is always against us[/spoiler] |
|
|
|
esthera
Master Smack Fu Yak Hacker
1410 Posts |
Posted - 2014-05-27 : 13:38:15
|
| 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 |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
esthera
Master Smack Fu Yak Hacker
1410 Posts |
Posted - 2014-05-28 : 01:44:22
|
| I thought localdb is what I need to installHow do I run a sql database locally in 2012I am trying to set up a database on my local computer for testing purposes |
|
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2014-05-28 : 03:56:59
|
install Express (free) or Developer Edition (not free)
KH[spoiler]Time is always against us[/spoiler] |
|
|
|
|
using sql 2012 locally