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 Administration
 Absolute newbie: How to "run" SQL server?

Author  Topic 

h800
Starting Member

2 Posts

Posted - 2011-05-18 : 14:54:39
I believe I have SQL server 2008 R2 installed on my Windows 7 PC. (I went to Control Panel and looked at installed software and it was listed.) I actually don't know how it was installed. Perhaps it was installed together with Visual Studio 2010.

What do I have to do to run the SQL server?

My goal is to convert an Access database to an SQL database. After this is done, I want to be able to query the SQL database directly.
Thanks.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-05-18 : 15:21:14
SQL Express gets installed with VS 2010. As far as how to run it, just start the service in control panel.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2011-05-19 : 01:19:32
If you want to manage the databases use the SQL Server Management Studio and connect to the sql server service. Various methods are available to move structure and data

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

- Advertisement -