is my sql server 2005 installed correctly?

I installed sql server 2005 enterprise from my MSDN subscription onto
a Vista business system. problem is I am getting a "no server
connection" message in MS sql server mgmt studio and config manager.
do I have to start the server? How do I do that?
I selected the options to install the northwind database. Where do I
find it?
greatness would be if I could get a TSQL command line prompt. also, I
want to connect to this sql server from my development PC.
thanks,
-SteveHi Steve
"Steve Richter" wrote:
> I installed sql server 2005 enterprise from my MSDN subscription onto
> a Vista business system. problem is I am getting a "no server
> connection" message in MS sql server mgmt studio and config manager.
> do I have to start the server? How do I do that?
> I selected the options to install the northwind database. Where do I
> find it?
> greatness would be if I could get a TSQL command line prompt. also, I
> want to connect to this sql server from my development PC.
> thanks,
> -Steve
>
You require SP2 for SQL Server to work on windows vista. Check the readme
file for additional information required for setting up vista.
You can check the combination of SQL Server and OS at
http://msdn2.microsoft.com/en-us/library/ms143506.aspx
The SQL Server configuration manager tool will show which services are
installed and allow you to stop/start the services.
You may also want to check the setup log files see
http://msdn2.microsoft.com/en-us/library/ms144287.aspx
John|||On Mar 15, 5:28 am, John Bell <jbellnewspo...@.hotmail.com> wrote:
> Hi Steve
>
>
> "Steve Richter" wrote:
> > I installed sql server 2005 enterprise from my MSDN subscription onto
> > a Vista business system. problem is I am getting a "no server
> > connection" message in MS sql server mgmt studio and config manager.
> > do I have to start the server? How do I do that?
> > I selected the options to install the northwind database. Where do I
> > find it?
> > greatness would be if I could get a TSQL command line prompt. also, I
> > want to connect to this sql server from my development PC.
> > thanks,
> > -Steve
> You require SP2 for SQL Server to work on windows vista. Check the readme
> file for additional information required for setting up vista.
> You can check the combination of SQL Server and OS athttp://msdn2.microsoft.com/en-us/library/ms143506.aspx
> The SQL Server configuration manager tool will show which services are
> installed and allow you to stop/start the services.
> You may also want to check the setup log files seehttp://msdn2.microsoft.com/en-us/library/ms144287.aspx
> John- Hide quoted text -
> - Show quoted text -
thanks. I checked the summary.txt file. It says my PC does not meet
the hardware requirements of sql server. ( it has 512 meg of
memory ).
Is there any way to run sql server w/less than 1 gig of memory?
Microsoft SQL Server 2005 9.00.1399.06
==============================OS Version : Professional (Build 6000)
Time : Sun Mar 11 15:04:51 2007
VISTA2_PC : The current system does not meet the minimum hardware
requirements for this SQL Server release. For system requirements, see
Hardware and Software Requirements, in the readme file or in SQL
Server Books Online.
VISTA2_PC : The current system does not meet minimum hardware
requirements for this SQL Server release. For detailed hardware
requirements, see the readme file or SQL Server Books Online.
VISTA2_PC : Microsoft Internet Information Services (IIS) is either
not installed or is disabled. IIS is required by some SQL Server
features. Without IIS, some SQL Server features will not be available
for installation. To install all SQL Server features, install IIS from
Add or Remove Programs in Control Panel or enable the IIS service
through the Control Panel if it is already installed, and then run SQL
Server Setup again. For a list of features that depend on IIS, see
Features Supported by Editions of SQL Server in Books Online.
Machine : VISTA2_PC
Product : Microsoft SQL Server Setup Support Files (English)
Product Version : 9.00.1399.06
Install : Successful
Log File : C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Files\SQLSetup0001_VISTA2_PC_SQLSupport_1.log
----
Machine : VISTA2_PC
Product : Microsoft SQL Server Native Client
Product Version : 9.00.1399.06
Install : Successful
Log File : C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Files\SQLSetup0001_VISTA2_PC_SQLNCLI_1.log
----
Machine : VISTA2_PC
Product : Microsoft Visual Studio 2005 Premier Partner Edition
- ENU
Product Version : 8.0.50727.42
Install : Successful
Log File : C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Files\SQLSetup0001_VISTA2_PC_PPESku_1.log
----
Machine : VISTA2_PC
Product : Microsoft Office 2003 Web Components
Product Version : 11.0.6558.0
Install : Successful
Log File : C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Files\SQLSetup0001_VISTA2_PC_OWC11_1.log
----
Machine : VISTA2_PC
Product : Microsoft SQL Server 2005 Books Online (English)
Product Version : 9.00.1399.06
Install : Successful
Log File : C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Files\SQLSetup0001_VISTA2_PC_BOL_1.log
----
Machine : VISTA2_PC
Product : Microsoft SQL Server 2005 Backward compatibility
Product Version : 8.05.1054
Install : Successful
Log File : C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Files\SQLSetup0001_VISTA2_PC_BackwardsCompat_1.log
----
Machine : VISTA2_PC
Product : SQLXML4
Product Version : 9.00.1399.06
Install : Successful
Log File : C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Files\SQLSetup0001_VISTA2_PC_SQLXML4_1.log
----
Machine : VISTA2_PC
Product : Microsoft SQL Server 2005 Tools
Product Version : 9.00.1399.06
Install : Successful
Log File : C:\Program Files\Microsoft SQL Server\90\Setup
Bootstrap\LOG\Files\SQLSetup0001_VISTA2_PC_Tools.log
----
Setup succeeded with the installation, inspect the log file
completely for status on all the components.
Time : Sun Mar 11 23:10:41 2007|||Hi Steve
"Steve Richter" wrote:
> thanks. I checked the summary.txt file. It says my PC does not meet
> the hardware requirements of sql server. ( it has 512 meg of
> memory ).
> Is there any way to run sql server w/less than 1 gig of memory?
>
According to http://msdn2.microsoft.com/en-us/library/ms143506.aspx 512Mb is
the minimum hardware requirement, I assume that not all of it is available
e.g onboard graphics? This requirement will not stop setup, therefore it may
be something else such as processor (which does stop the install) as there
are two failures for the H/W requirements.
John|||On Mar 15, 11:42 am, John Bell <jbellnewspo...@.hotmail.com> wrote:
> Hi Steve
> "Steve Richter" wrote:
> > thanks. I checked the summary.txt file. It says my PC does not meet
> > the hardware requirements of sql server. ( it has 512 meg of
> > memory ).
> > Is there any way to run sql server w/less than 1 gig of memory?
> According tohttp://msdn2.microsoft.com/en-us/library/ms143506.aspx512Mb is
> the minimum hardware requirement, I assume that not all of it is available
> e.g onboard graphics? This requirement will not stop setup, therefore it may
> be something else such as processor (which does stop the install) as there
> are two failures for the H/W requirements.
> John
my pc reports 511MB of memory. ;)
I called MSFT support and they say sql server 2005 enterprise does not
run on Vista.
just trying to mimic a production envirornment. at this point I am
concluding I have to install more memory and install windows server
2003.
-Steve|||Hi Steve
"Steve Richter" wrote:
> On Mar 15, 11:42 am, John Bell <jbellnewspo...@.hotmail.com> wrote:
> > Hi Steve
> >
> > "Steve Richter" wrote:
> > > thanks. I checked the summary.txt file. It says my PC does not meet
> > > the hardware requirements of sql server. ( it has 512 meg of
> > > memory ).
> >
> > > Is there any way to run sql server w/less than 1 gig of memory?
> >
> > According tohttp://msdn2.microsoft.com/en-us/library/ms143506.aspx512Mb is
> > the minimum hardware requirement, I assume that not all of it is available
> > e.g onboard graphics? This requirement will not stop setup, therefore it may
> > be something else such as processor (which does stop the install) as there
> > are two failures for the H/W requirements.
> >
> > John
> my pc reports 511MB of memory. ;)
> I called MSFT support and they say sql server 2005 enterprise does not
> run on Vista.
http://msdn2.microsoft.com/en-us/library/ms143506.aspx says 32 bit on 32 bit
for ultimate and above is a valid combination, one must be wrong!
> just trying to mimic a production envirornment. at this point I am
> concluding I have to install more memory and install windows server
> 2003.
If you wish to mimic the environment then having the same OS is important!
Otherwise you could have used developer edition!
> -Steve
John