using sql 2012 locally - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2012 Forums

SQL Server Administration (2012)

using sql 2012 locally

Author

Topic

esthera
Master Smack Fu Yak Hacker

1410 Posts

Posted - 2014-05-25 : 08:58:53

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

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 Kizer
SQL Server MVP since 2007
http://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.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
[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

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

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 Kizer
SQL Server MVP since 2007
http://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 services

what 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

Posted - 2014-05-27 : 13:48:19

What is localdb?

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/

esthera
Master Smack Fu Yak Hacker

1410 Posts

Posted - 2014-05-28 : 01:44:22

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

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]

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources