| Author |
 Topic  |
|
JohnCash1
Starting Member
39 Posts |
 Posted - 10/17/2012 : 18:17:18
|
How do I have sql sever installed?
I ran configuration manager on the same machine I install sql server studio given by the link you mentioned.
All I did is run SQL management studio as you said and then look to configuration manager to see the TCP and IP and name pipes to see if they are enable and they are.
I don't know why else is not working. If you know of anything please let me know. Thx |
 |
|
|
robvolk
Most Valuable Yak
USA
15559 Posts |
Posted - 10/17/2012 : 18:25:22
|
| Did you also install the SQL Server Database Engine components on that server? Are you trying to connect to a locally installed SQL Server, or to a remote server hosted by someone else? |
|
|
|
JohnCash1
Starting Member
39 Posts |
Posted - 10/17/2012 : 19:05:15
|
Is on the same machine. I installed sql management studio(one in the link)
and ran configuration
Manager on same machine. |
|
|
|
robvolk
Most Valuable Yak
USA
15559 Posts |
Posted - 10/17/2012 : 19:18:30
|
| The management software is not the same thing as the database engine, if those components were not installed, there is no "SQL Server" to connect to. If you installed the Express Edition you would normally see an entry in the Services area with "EXPRESS" in the name. |
|
|
|
JohnCash1
Starting Member
39 Posts |
Posted - 10/17/2012 : 21:35:53
|
hey sorry, its funny. I didn't know there was a second page. I didn't see my response to you until now. hehe.
quote:
Did you also install the SQL Server Database Engine components on that server? Are you trying to connect to a locally installed SQL Server, or to a remote server hosted by someone else?
I don't think I install SQL server Database engine component on server, how do I do this?
I am trying to connect to a locally installed SQL server.
how do I install the database engine.
I tried installing express but I can't open the software and also I have a hard time finding one that is compatible to window vista. |
|
|
|
jackv
Flowing Fount of Yak Knowledge
United Kingdom
1769 Posts |
Posted - 10/18/2012 : 01:50:08
|
JohnCash - did you read my earlier post - about the link to the SQL Server Express - supported on Windows Vista? Have you attempted to download and install?
Jack Vamvas
--------------------
http://www.sqlserver-dba.com |
|
|
|
JohnCash1
Starting Member
39 Posts |
|
|
JohnCash1
Starting Member
39 Posts |
|
|
jackv
Flowing Fount of Yak Knowledge
United Kingdom
1769 Posts |
Posted - 10/18/2012 : 10:47:32
|
what error messages? Normally , when there is a failure . a log file is created , if sql server 2008 - in : "C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log"
Jack Vamvas
--------------------
http://www.sqlserver-dba.com |
|
|
|
JohnCash1
Starting Member
39 Posts |
Posted - 10/18/2012 : 13:03:42
|
from this website
http://www.microsoft.com/en-gb/download/details.aspx?id=30438
i downloaded
SQLManagementStudio_x86_ENU.exe 158.3 MB
and I tried to connect but there is an error, I can't connect to local
and the database engineer is not there. I went to registered servers
and in local server group i left click and then go to task and go to register local server and I get this message.
http://postimage.org/image/g92gvszgx/
I don't know what is wrong, how come I can't connect to database engine and have no instance? I seems to be doing what is necessary to have it work but it doesn't.
|
|
|
|
robvolk
Most Valuable Yak
USA
15559 Posts |
Posted - 10/18/2012 : 13:32:46
|
| Try downloading and installing the SQLEXPRWT_x64_ENU.exe (or SQLEXPRWT_x86_ENU.exe if you're on 32-bit Vista) package. Install every component that's listed. Run configuration manager again, you should see the SQLEXPRESS instance under the Services tab. |
|
|
|
JohnCash1
Starting Member
39 Posts |
|
|
robvolk
Most Valuable Yak
USA
15559 Posts |
Posted - 10/18/2012 : 17:41:56
|
Dont' confuse Management Studio with SQL Server, they're different components.
SQL Server has several services, including the database engine (which is what people usually mean when they say SQL Server). There's also Integration Services, Reporting Services, and Analysis Services as separate products, but they all fall under the SQL Server umbrella. The database engine also has SQL Agent and Full-text indexing as additional components. None of these are included with SQL Express Edition, which only has the Database Engine.
Management Studio is just a user interface that can work with SQL Server products (DB, Integration/Reporting/Analysis Services). You don't need it to install or use SQL Server, and it's pretty useless without any of the products installed.
Edit: you don't need a web hosting company to host or install SQL Server. If you do use a hosting company, they provide the web panel to work with the SQL Server databases you have with them. It's just a convenience so people don't have to install Management Studio to access it. The web panel won't work with a locally installed instance like you have. |
|
|
|
JohnCash1
Starting Member
39 Posts |
Posted - 10/18/2012 : 19:18:04
|
I see, I am new to SQL server so I am just try to make sense and get an understanding of the software/system/database etc. MS SQL Sever being that it is pretty popular, I've seen businesses use (the second link i posted) management studio 2008 to configure to websites and manipulate the datas in the database and do store procedures to create users friendly reports on the websites. From my guess base on my little exposure so far to MS SQL sever is that businesses doesn't use the local express version that I just installed.
So what I just want to know is how can someone make MS management studio SQL sever work, like what does it take to make it work and functioning? Since there is no database as I think someone mentioned for the MS management studio SQL sever, where do they get their database and is there a limitation on database storage in the database on the sever?
And for the one I installed, SQL sever express, how is it different from the management studio SQL sever 2008, is there a limit on how much data can the express store, can I create store procedure and reports etc.
Is the one I installed on a sever, where is the data store when I start to create database and upload large amount of datas for analysis?
Thanks and I appreciate your expertise and time in answering some of the Questions I have for this.
|
|
|
|
Topic |
|
Setting up SQL sever?
