| 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 KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
 |
|
|
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 |
|
|
|
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>GOSelect * from myTableJack Vamvas--------------------http://www.sqlserver-dba.com |
|
|
|
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 |
|
|
|
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 KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
|
|
|
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. |
|
|
|
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 KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
|
|
|
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 |
|
|
|
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) |
|
|
|
mksdf
Starting Member
26 Posts |
Posted - 2014-09-16 : 17:09:36
|
| im going to try installing 2012 |
|
|
|
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 KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
|
|
|
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 |
|
|
|
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? |
|
|
|
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 KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
|
|
|
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 |
|
|
|
|
SQL server installation issues