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.
| Author |
Topic |
|
VillaLion
Starting Member
2 Posts |
 Posted - 2010-12-08 : 17:11:56
|
| Ok, SQL Server Management Studio has made me feel really thick.I want to do some data mining of a very large csv file. I understand this software will allow me to do this. I have installed the free version of the 2008 software, though I seem unable to connect/create a database, let alone start any data mining.I understand that I need to start an SQL Server Service instance... ummm, how?I have gone into SQL Server Configuration, clicked on SQL Server Status and nothing appears. If there is nothing there, how can I start one?Please help a man in distress.Thanks. |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2010-12-08 : 23:32:28
|
| Did you just install management studio, or SQL Server Express? If you just installed the client tools, there is no SQL Server to start, you need to install SQL Server.-Chad |
 |
|
|
VillaLion
Starting Member
2 Posts |
Posted - 2010-12-11 : 17:40:15
|
| Thanks Chad - that would have been the simple reason why!Ok, I have now made some progress... I have my database created, got the data into it and I'm able to connect to it. I have Visual Studio 2008 installed, I'm able to connect to my database through this program also. However, when it comes trying to connect to the Server Analysis Services it will not connect. It is unable to connect to the server... I have the relevant service running (SQL Server Browser I believe?) but it just won't connect.Am I missing something blindingly obvious again? I'm trying to connect to this service through Excel if that makes any difference...Thanks in advance. |
|
|
|
|
|
|
|
|
SQL Server Configuration Manager