How to create a local server with Microsoft SQL Server Management Studio? (SQL Server 2008 R2)

Question

Hi!

I tried it thousand times to create a local server with the Management Studio, but when I clicked Test, it returned an error that it cannot connect to the server. (course not, its not running, but I cannot make it run)

Could you please tell me in detailed simple steps how to register and start a local server?

Answer 1

Hi

 you can install Microsoft Virtual Pc, or Vm VirualBox into loacal pc after complete.

setup windows server 2003,2008 in Virtual Machine  and setup sql data server.

Answer 2

Hi Andulkahim, 

does it mean that I cannot do that the way I tried?

Answer 3

Hello,

Do you have a local installed SQL Server? Is the SQL Server service running; you can check it with services.msc? Is it a named instance and which name is used (maybe SQLEXPRESS)?

In the combobox "Server name" in login dialog you can choose "<Browse for server>", have you tried this option, if you can see a SQL Server there?

---

Olaf Helper

Blog Xing

Answer 4

Hi,

Thank you for your help. Apparently it is not running, the only service running with similar name is SQL SERVER VSS ...

I guess I have installed SQL server, yes, it is in the installed programs list: Microsoft SQL Server 2008 R2.

Please help me how to get that service running and set up the server. 

Thank you 

Answer 5

SQL Server VSS = Volume Shadow Server, it belongs to SQL Server, but isn't the database engine.

There should be a service "SQL Server (SQLEXPRESS)" and it should be in a running state, if it's installed.

If not, download the free Express Edition of SQL Server and install it.

---

Olaf Helper

Blog Xing

Answer 6

"it is in the installed programs list: Microsoft SQL Server 2008 R2." It is installed, isn't it possible that some configurations are wrong???

Answer 7

Use the SQL Server Configuration Manager program to start the SQL Server Database Engine.

---

Rick Byham, Microsoft, SQL Server Books Online, Implies no warranty

Answer 8

I can't, in the SQL Server Configurator Manager "There are no items to show in this view". There are no items at all. 

Answer 9

You get that message, because the SQL Server isn't installed.

Download the free Express Edition and install it.

---

Olaf Helper

Blog Xing

Answer 10

I trusts of course, but still cannot understand why is the Microsoft SQL Server 2008 and Microsoft SQL Server 2008 R2 as well in the installed programs and all programs(start menu) lists...

Could you please give me a download link. (I have already downloaded one version (2008 R2), but apparently I failed with it) 

I just wondered that it might coincide with the versions installed before?????? Do I need to delete these, before installing the one you recommend to me.

Answer 11

Hello ,

I would suggest you to have a look at this link :

http://www.microsoft.com/en-us/download/details.aspx?id=30438

I suppose that you have a Windows 2008 Server 64-bit

You have to download SQLEXPRADV_x64_ENU.exe , advantage : you have the full edition including the database engine , SQL Server Management Studio ( shortcut : SSMS ) and the Reporting Services

If you want the 32-bit version of SQL Server 2008 R2 , choose : SQLEXPRADV_x86_ENU.exe

I prefer to download the full pack as if you download only SQL Server 2008 R2 Express with Tools  ( SQLEXPRWT_x64_ENU.exe ), if you want to install the Reporting Services , you will have to download the  SQLEXPRADV_x64_ENU.exe ( a loss of time and space )

Don't forget to save the download on your computer before the install ( with this behavior , you could use this download to install a second SQL Server instance , so you avoid not only a 2nd download , but the setup program will use the same files extracted during the 1st install ==> less time for the install and less space lost on your drives )

If you have installed only SSMS , you have downloaded only SQLManagementStudio_x64_ENU.exe or SQLManagementStudio_x86_ENU.exe ( a classical pitfall for SQL Server Express 2005 or 2008 ).

Have a nice day

---

Mark Post as helpful if it provides any help.Otherwise,leave it as it is.

Answer 12

Hi, 

Meanwhile, I have uninstalled all the SQL Server stuff and just installed SQL Server 2012. Now, I have the SQL Server services running in the services.msc, but I have not got the SQL Server Management Studio installed. (???) 
I don't know how to install it, should I use the SQL Server Installation Manager? It asks for some 'Installation Media", that I can't find. 

Please help me figure out how to get the Management Studio installed.

Thank you very much

Answer 13

Sorry you are having trouble. Try starting with this http://www.microsoft.com/en-us/download/details.aspx?id=29062 The instructions say "Once you click on the “Download” button, you will be prompted to select the files you need." Then select ENU\x64\SQLManagementStudio_x64_ENU.exe which should get you just the latest Management Studio.

---

Rick Byham, Microsoft, SQL Server Books Online, Implies no warranty