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
 General SQL Server Forums
 New to SQL Server Programming
 SQL server installation issues

Author  Topic 

mksdf
Starting Member

26 Posts

Posted - 2014-09-15 : 17:46:32
At the risk of sounding a bit stupid I am used to using SQL server at work and I am getting reasonable but I want to practice some more advanced stuff in my spare time as my job demands it. I have installed SQL server on my home laptop. I then realised I dont have a server. Is there a way to get round this? Could someone give me some advice on what I should do? Kind regards

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2014-09-15 : 18:17:35
Your laptop can be your server. When you installed SQL Server on the laptop, did you install just the client tools or also the database engine? If you installed the database engine, then you are all set. To verify, check for services that start with SQL Server.

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

mksdf
Starting Member

26 Posts

Posted - 2014-09-16 : 01:04:45
That's great. I was hoping this might be the solution. I believe I installed the database engine too as it is shown in the 'connect to server' pop up when I open SQL server. I have a sample database file but I don't know how to select it.What do I do now?

Thanks
Go to Top of Page

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2014-09-16 : 01:47:56
Firstly , connect to the server. Second, open up a "New Query" window in SQL Server management Studio, and then start writing queries.
For example, to confirm you can connect to the db , do something like:
USE <db_Name>
GO
Select * from myTable


Jack Vamvas
--------------------
http://www.sqlserver-dba.com
Go to Top of Page

mksdf
Starting Member

26 Posts

Posted - 2014-09-16 : 02:27:36
Jack,
That hasn't answered my question at all. I know how to use SQL server. The problem is I've never set it up so on my work computers I have a server to connect to. At home I do not have a server so I need to have a local instance. I believe the problem is that there are no instances of SQL server installed (looking at the configuration manager. I'm having a google to try to find the solution but I'm not having a lot of luck yet.
thanks anyway
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2014-09-16 : 12:38:50
So did you try connecting to the local server in Management Studio? And did you check services for any that start with SQL Server?

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

mksdf
Starting Member

26 Posts

Posted - 2014-09-16 : 14:52:34
This is what I have done...1) open SQL management studio. The Connect to Server box comes up. I cannot see anywhere where I would try connecting to a local server. Is this the right place? If not could you direct me please?
2) Open SQL server configuration manager. Select SQL server services, Nothing comes up.It just says 'There are no items to show in this view'. I presume this means there are no instances installed? IS that the correct way to refer to it? Sorry. I'm a bit new to this side of things. I really appreciate your help.
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2014-09-16 : 15:35:11
You need to launch setup again for SQL Server and install the database engine. Your installation package might only be for the client tools. So you'll need to verify what you have for the installation media.

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

mksdf
Starting Member

26 Posts

Posted - 2014-09-16 : 15:43:36
thanks tara. i'll get on it and let you know how i get on
Go to Top of Page

mksdf
Starting Member

26 Posts

Posted - 2014-09-16 : 16:48:50
I completely uninstalled and reinstalled it and I still have no instances. I didnt see anywhere along the way mentioning Database engine. To give you all the information I am using my msdn subscription to download the exe file: en_sql_server_2014_management_studio_x64_exe_3941421 by clicking on the link for SQL Server 2014 Management Studio (x64) - (English)

Go to Top of Page

mksdf
Starting Member

26 Posts

Posted - 2014-09-16 : 17:09:36
im going to try installing 2012
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2014-09-16 : 17:12:30
The exe that you have contains only the client tools. It does not include the database engine. You'll likely want Developer Edition or Express Edition for home use.

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

mksdf
Starting Member

26 Posts

Posted - 2014-09-16 : 17:15:50
ah ha! thank you tara. that's very helpful to know. i'll get on it. thank you
Go to Top of Page

mksdf
Starting Member

26 Posts

Posted - 2014-09-17 : 04:08:23
Right...It works!! Thank you so much Tara. Do I need to mark this as solved or something now?
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2014-09-17 : 12:27:09
The Snitz software doesn't have that functionality. You can change the subject to include [RESOLVED] though.

And no problem! Glad to help.

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

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2014-09-18 : 01:48:18
@mksdf - you're question was "I have a sample database file but I don't know how to select it.What do I do now?" , i then responded with some clear , logical steps you could take to verify how to select the database.
You replied - by saying , "That hasn't answered my question at all".
Could you clarify how this hasn't your question at all?

Jack Vamvas
--------------------
http://www.sqlserver-dba.com
Go to Top of Page
   

- Advertisement -