SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Setting up SQL sever?
 New Topic  Reply to Topic
 Printer Friendly
Previous Page
Author Previous Topic Topic Next Topic
Page: of 2

JohnCash1
Starting Member

39 Posts

Posted - 10/17/2012 :  18:17:18  Show Profile  Reply with Quote
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
Go to Top of Page

robvolk
Most Valuable Yak

USA
15675 Posts

Posted - 10/17/2012 :  18:25:22  Show Profile  Visit robvolk's Homepage  Reply with 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?
Go to Top of Page

JohnCash1
Starting Member

39 Posts

Posted - 10/17/2012 :  19:05:15  Show Profile  Reply with Quote
Is on the same machine. I installed sql management studio(one in the link)
and ran configuration
Manager on same machine.
Go to Top of Page

robvolk
Most Valuable Yak

USA
15675 Posts

Posted - 10/17/2012 :  19:18:30  Show Profile  Visit robvolk's Homepage  Reply with Quote
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.
Go to Top of Page

JohnCash1
Starting Member

39 Posts

Posted - 10/17/2012 :  21:35:53  Show Profile  Reply with Quote
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.
Go to Top of Page

jackv
Flowing Fount of Yak Knowledge

United Kingdom
2063 Posts

Posted - 10/18/2012 :  01:50:08  Show Profile  Visit jackv's Homepage  Reply with Quote
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
Go to Top of Page

JohnCash1
Starting Member

39 Posts

Posted - 10/18/2012 :  03:07:54  Show Profile  Reply with Quote
yes I did. I installed

One of these from this link

SQLManagementStudio_x64_ENU.exe 161.0 MB
SQLManagementStudio_x86_ENU.exe 158.3 MB

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

but it didn't work. Seems there is no database engine and no instance.
Go to Top of Page

JohnCash1
Starting Member

39 Posts

Posted - 10/18/2012 :  03:09:46  Show Profile  Reply with Quote
quote:
Follow this link - which has a downloadable version of SQL Server Express 2008 R2 - and is compatible with Windows Vista
http://www.microsoft.com/en-gb/download/details.aspx?id=30438



I installed this one too and it didn't work.
Go to Top of Page

jackv
Flowing Fount of Yak Knowledge

United Kingdom
2063 Posts

Posted - 10/18/2012 :  10:47:32  Show Profile  Visit jackv's Homepage  Reply with Quote
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
Go to Top of Page

JohnCash1
Starting Member

39 Posts

Posted - 10/18/2012 :  13:03:42  Show Profile  Reply with Quote
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.
Go to Top of Page

robvolk
Most Valuable Yak

USA
15675 Posts

Posted - 10/18/2012 :  13:32:46  Show Profile  Visit robvolk's Homepage  Reply with Quote
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.
Go to Top of Page

JohnCash1
Starting Member

39 Posts

Posted - 10/18/2012 :  15:13:23  Show Profile  Reply with Quote
cool. I did just that and I see something in the config manager.
http://postimage.org/image/b1aux4o85/

But I wonder what is the difference between this,

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

and this

http://www.codefrenzy.net/2011/06/03/how-to-install-sql-server-2008-management-studio/

?

I mean for the second one, to access instance and database engine we need a web hosting company like DotNetPanel (the link below) that we pay to, to create and use database?

http://blog.arvixe.com/how-to-use-microsoft-sql-server-2008-to-connect-to-your-database/

What is the difference between the two, the advantage, disadvantage, and limitation etc?
Go to Top of Page

robvolk
Most Valuable Yak

USA
15675 Posts

Posted - 10/18/2012 :  17:41:56  Show Profile  Visit robvolk's Homepage  Reply with Quote
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.
Go to Top of Page

JohnCash1
Starting Member

39 Posts

Posted - 10/18/2012 :  19:18:04  Show Profile  Reply with Quote
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.
Go to Top of Page
Page: of 2 Previous Topic Topic Next Topic  
Previous Page
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.38 seconds. Powered By: Snitz Forums 2000