Is there 1 default instance per OS Server or per SQL Server?

On a Server 2k3 x64, I've installed SQL Server 2000 x32 SP4 and SQL Server 2005 x64. When installing both SQL Server 2000 and 2005 on the same server, does each SQL Server have it's own "default instance" or there can only be one "default instance" per server? TIA, Gary.

There can only be one default instance per OS.

Be carefull when installing SQL 2005 on a SQL 2000 machine. It's very easy to upgrade the existing instance without releasing it.

|||Well that explains what happened. I noticed SQL Server 2005 was showing SQL Server 2000 databases. The good thing is it only the test server, not production. But since SQL Server 2000 instance has been updated, I'm assuming I'll have to uninstall both SQL Server 2000 and 2005 in order to set both up correctly? Is there a shortcut to fix this?|||

Correct, there is no way to revert to DB's back to SQL 2000. The default instance naming is the same in both products to make upgrade easier. You can always supply a different instance name with the second install to run both editions side by side.

Thanks,
Sam Lester (MSFT)

sql

Is SQL Server/MSDE a memory hog?

I installed MSDE, and now when my pc starts up, I get a little icon in the toolbar for the sql server administration. Note I did not purchase sql server, I just dowloaded and installed msde.

The problem is that I do not do database programming every day, and so I probably do not need sql server running every time my pc runs. And I have noticed that since I installed MSDE/sql server that their appears to be a lot of disk thrashing going on, and my system seems a lot slower than it use to be.

Has anyone had a similar problem? What do I need to do to shut it down if not in use? Is stopping the sqlsever.exe in task manager the proper way to shut it down?

I have 256 meg of Ram.

Thanks in advance, Amy DanoughWhat operating system are you using? For XP/2000/2003/NT, you can go into Control Panel/Administrative Tools/Services and chane the startup mode for the MSDE service (possibly still called SQL Server) to manual, and then it will start only when you manually start it.

Failing that, you can right click on the icon and then stop the MSDE when you do not need it (and right click to start it up again if need be).|||XP Professional,

Thanks for the help.
Amy|||Go to administrative tools->services and set the service's startup mode to manual. that way it won't start up with the OS. the downside is you'll have to start it manually when you need it. it'll probably be under "mssqlserver". you can start it the same way or at the command line with

net start mssqlserver

personally I've never found it to be an excessive memory hog (well, full SQL Server at least). I've run it on systems as low-grade as P233+/64Mb before now

j

Is SQL Server required?

Hi

If the source tables for Analysis Services 2000 and 2005 are all coming from Oracle, is there any reason why we need to have SQL Server installed as well?

Thanks

Steve

Nope!

-Jamie

is sql server 2005 a standalone install? Or do you have to install windows server

I have never installed sql server before and I didnt know if I just take the sql server 2005 standard edition media and boot off it and do a fresh install that way or do I have to install Windows server

SQL Server is "just" a database*. You need an underlying operating system in place before you attempt to install it. For SQL Server 2005, supported operating systems are Windows 2000, Windows XP, and Windows Server 2003. Not all versions of SQL Server 2005 are supported on all these operating systems, but I believe the standard edition of SQL is.

Paul

*Well, a database and tools and report server and... But it's not an operating system.

|||thanks, that exacty what i needed to hear.

Is SQL Express required...

Does SQL Express 2005 have to be installed for SQL Developer 2005 to work correctly in VB 2005 Pro?

Thank you,

David

Nope, SQL Express and SQL Developer are just two different editions of SQL Server 2005. You can have either one for your VB install to connect to.

Thanks,

Sam Lester (MSFT)

Is SP 4 for Analysis Services needed ?

Hi !

We′ve just installed SP 4 for SQL 2000 and Microsoft Reporting Services on the Test environment. The Analysis Services still has the SP3.

At the same environment we have Business Objects Enterprise XIR2. The OLAP Intelligence application doesn′t work properly anymore since we′ve installed SP4 for SQL and the Microsoft Reporting Services.

Do you know, is Microsoft Reporting Services working good together with Business Objects?

I suppose we have to install also the SP4 for Analysis Services also; are there others HotFixes we should install?

greetings,

Laura

Hi,

The SP4 works perfectly fine. It is basically language oriented and gives the symbol of currency when we install in different language. There are few problems in

viewing the 'restricted dimension' column in 'manage roles' for a cube in analysis manager.

Please let me know if there are any problem.

And BusinessObjects OLAPI works fine for the same also. Moreover recommended for OLAPI is SP3a which is OK.

Please let me know if i am wrong.

Thanks,

|||

Hotfix rollup package for SQL Server 2000 Analysis Services Service Pack - Build 2174 : http://support.microsoft.com/?kbid=907323&SD=tech

This article lists the hotfixes that were originally released for Microsoft SQL Server 2000 Analysis Services Service Pack 3 (SP3), but that were not included in Service Pack 4 (SP4). These hotfixes are now available in a downloadable post-SP4 hotfix rollup package for SQL Server 2000 Analysis Services.

Here are some important notes regarding this hotfix rollup package:

? To apply this hotfix rollup package, you must have SQL Server 2000 Analysis Services SP4 installed. For more information, click the following article number to view the article in the Microsoft Knowledge Base:

290211 (http://support.microsoft.com/kb/290211/) How to obtain the latest SQL Server 2000 service pack

?

This hotfix rollup package is Microsoft SQL Server 2000 Analysis Services Build 8.0.2174

IS service won't start after installing SP1

I have just installed SP1 and now the IS service will not start at all. I have tried using the LocalSystem account and an account with domain admin rights that I use to run all the other SQL Server services.

Before the SP was applied the service was running fine.

I have tried starting it from the command prompt, services and configuration manager but none of them work, I get the following error message:

"The service did not respond to the start or control request in a timely fashion"

This message is also in in the System Event Viewer, but there are no messages in the Application Event Viewer for the IS Service so I am now officially stumped (not to mention frustrated)

Please help!

This issue is all voer the web: http://www.google.com/search?hl=en&lr=&q=ssis+%22The+service+did+not+respond+to+the+start+or+control+request+in+a+timely+fashion%22

Here for example: http://blogs.conchango.com/jamiethomson/archive/2006/04/26/3877.aspx

-Jamie

|||

Thanks for the help Jamie, I have found the kb article (918644).

Now I have to install 5 separate fixes, that fix problems caused by a big bunch of fixes!! Wow

|||

bobbins wrote:

Thanks for the help Jamie, I have found the kb article (918644).

Now I have to install 5 separate fixes, that fix problems caused by a big bunch of fixes!! Wow

Err yeah, that's basically it!

|||

will keep me busy I suppose

I am tempted to take a trip to the feedback centre and it won't be pretty

Cheers again

Is server downgrade possible?

Hello,
my question is simple, i guess, if anyone can help me solve this problem:
I just installed Windows 2003 SBS Premium R2 but i have a software using SQL Server 2000 and not the one included in this version, 2005 wich is not compatible with. How can i downgrade, where cand i get the older server if the downgrade is possible and what else can i do before i shoot myself? Is there any license issue that will not allow me the downgrade?
Thank You!!!
SBS Premium R2 comes with 2005, but prior releases came with 2000. So, I would try to uninstall 2005 and reinstall 2000 with your install disks for the prior release.

Alternatively, you can install an MSDE instance on the same server and have it host your SQL 2000 database.

As I understand, however, if the install process for R2 upgraded the database itself, then you can't downgrade the database. Rather, you'd have to restore the most recent backup of the 2000 database.
|||Well, i don't have an older SQL 2000 database backup (also don't have a prior SBS 2003 server release) because we never used SQL before, version 2005 is uninstalled already but i don't know where from to download/get the SQL 2000 server as long as "Microsoft's ways" are a big mistery to me... if someone can drop a link for the SQL 2000 server would be great, just any version of the SQL 2000 that will work/install fine on our version of Windows, our software can't use the SQL 2005 included in SBS Premium 2003 R2, that's why i'm in trouble, nobody told me that before buying this license...
Many Thanks
|||

Don't you love it when they omit the details!

Here's a link to MSDE 2000 download...

http://www.microsoft.com/downloads/details.aspx?FamilyID=413744D1-A0BC-479F-BAFA-E4B278EB9147&displaylang=en

MSDE is the equivalent of SQL Server 2000 Engine, but other features are limited or not supported in the free version. For instance, performance is "throttled" after a certain number of users (about 16?) connect. If you don't know if those features are required by your database / application, I guess it's worth a try anyway. You can manage a SQL 2000 instance with SSMS that comes with SQL 2005.

Good luck...

Del

Is server downgrade possible?

Hello,
my question is simple, i guess, if anyone can help me solve this problem:
I just installed Windows 2003 SBS Premium R2 but i have a software using SQL Server 2000 and not the one included in this version, 2005 wich is not compatible with. How can i downgrade, where cand i get the older server if the downgrade is possible and what else can i do before i shoot myself? Is there any license issue that will not allow me the downgrade?
Thank You!!!SBS Premium R2 comes with 2005, but prior releases came with 2000. So, I would try to uninstall 2005 and reinstall 2000 with your install disks for the prior release.

Alternatively, you can install an MSDE instance on the same server and have it host your SQL 2000 database.

As I understand, however, if the install process for R2 upgraded the database itself, then you can't downgrade the database. Rather, you'd have to restore the most recent backup of the 2000 database.|||Well, i don't have an older SQL 2000 database backup (also don't have a prior SBS 2003 server release) because we never used SQL before, version 2005 is uninstalled already but i don't know where from to download/get the SQL 2000 server as long as "Microsoft's ways" are a big mistery to me... if someone can drop a link for the SQL 2000 server would be great, just any version of the SQL 2000 that will work/install fine on our version of Windows, our software can't use the SQL 2005 included in SBS Premium 2003 R2, that's why i'm in trouble, nobody told me that before buying this license...
Many Thanks|||

Don't you love it when they omit the details!

Here's a link to MSDE 2000 download...

http://www.microsoft.com/downloads/details.aspx?FamilyID=413744D1-A0BC-479F-BAFA-E4B278EB9147&displaylang=en

MSDE is the equivalent of SQL Server 2000 Engine, but other features are limited or not supported in the free version. For instance, performance is "throttled" after a certain number of users (about 16?) connect. If you don't know if those features are required by your database / application, I guess it's worth a try anyway. You can manage a SQL 2000 instance with SSMS that comes with SQL 2005.

Good luck...

Del

Is Rreporting services and add on module?

I installed SQL 05 and all it's options including RS, however I don't see any
programs to launch any RS programs other than the configurator.
What am I missing here?
MikeOn Apr 16, 5:12 pm, Mike <M...@.discussions.microsoft.com> wrote:
> I installed SQL 05 and all it's options including RS, however I don't see any
> programs to launch any RS programs other than the configurator.
> What am I missing here?
> Mike
The Reporting Services development environment is called SQL Server
Business Intelligence Development Environment and is normally located
in Programs -> Microsoft SQL Server 2005. Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||the default RS access is full web based, so there is no program anywhere.
(its the standard access for the end users)
after this, from the admin point of view you can manage it using the SQL
management studio or through the /reports web site (where the admin can
manage the security and few parameters).
and finally from a developer point of view, you can create and publish
reports using Visual Studio.
"Mike" <Mike@.discussions.microsoft.com> wrote in message
news:B74233E5-2BB9-4C31-9B0E-39308EEE0BBC@.microsoft.com...
>I installed SQL 05 and all it's options including RS, however I don't see
>any
> programs to launch any RS programs other than the configurator.
> What am I missing here?
> Mike

is problems with hidden parameters solved in sp1?

I have installed the sp1
But the problem with hidden parameters is still there. I could not set the
value of hidden parameter from the querysting.
Let me know how to check whether the sp1 is properly installed or not.
Thanks in advanceThis is onlt supported on the server. In Report Manager, leave the 'prompt
user' checkbox checked but clear our the prompt string. This should not
prompt the user but still allow you to specify them via URL.
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"VV" <vineshk@.omegatech.com> wrote in message
news:OkNdQneWEHA.2520@.TK2MSFTNGP12.phx.gbl...
>I have installed the sp1
> But the problem with hidden parameters is still there. I could not set the
> value of hidden parameter from the querysting.
> Let me know how to check whether the sp1 is properly installed or not.
> Thanks in advance
>|||Just a suggestion -
Wouldn't it be better if you provide with a checkbox in Report Manager
that just says "hide parameter" and which in turn will clear the
prompt string an keep the prompt user checked... ' It took me 20 min.
to figure out that. Your readme on sp1 is not clear on this...
Thanks|||Yes, but this required a string change that we didn't want to add in SP1. We
will make it more understandable in the future.
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Harsh" <creative@.mailcity.com> wrote in message
news:fa671a26.0406281005.1cf5f133@.posting.google.com...
> Just a suggestion -
> Wouldn't it be better if you provide with a checkbox in Report Manager
> that just says "hide parameter" and which in turn will clear the
> prompt string an keep the prompt user checked... ' It took me 20 min.
> to figure out that. Your readme on sp1 is not clear on this...
> Thanks

Is only "shared memory" connection with "SQL Server Management Studio Express&quo

I have installed MS SQL Sever Express with it there is a SQL Server Configuration Manager installed. In this configuration manager there it is possible to enable and disable protocols for SQLEXPRESS. The following protocols are supported (and each protocol can be enabled/disabled individually):

Shared memory, Named Pipes, TCP/IP and VIA.

In the "SQL Server Management Studio Express" I connect to the SQL server and this works fine when "shared memory" are enabled. But when I disable "shared memory" in the configuration manager I can not connect to the SQL server via "SQL Server Management Studio Express".

In the "SQL Server Management Studio Express" there also are some "options/connection properties". There is a property for "network protocol" nomally set to "default" but possible to change to any of the enabled protocols. I have tested both to match the enabled protocols and also using the "default" selection without any success as long as "shared memory" is disabled in the configuration manager!

So, is it possible to enable only TCP/IP (or only named pipes) in the configuration manager and connecting to the SQL Server from the "SQL Server Management Studio Express"?

I'm going to move this to the Tools forum.

- Mike

|||

When connecting to a local server management studio uses shared memory. The other connection types are only used when establishing connections to remote servers.

Cheers,
Dan

Is ntwdblib.dll freely distributed by Microsoft?

We have just installed SQL 2005 on a brand new server and have installed our software for our business solution. When I attempt to run the program, it says that it cannot find "ntwdblib.dll" Where is this file? Am I missing a file from the install or what?

The error indicates that your application uses the DB-Library API. SQL Server 2005 does not include the files needed to do programming work on applications that use these APIs.

The recommended alternatives are captured in SQL Server 2005 Books Online in section "Deprecated Database Engine Features in SQL Server 2005", which can also found at MSDN at http://msdn2.microsoft.com/en-us/library/ms143729(en-US,SQL.90).aspx:

Other

DB-Library

Embedded SQL for C

Although the SQL Server 2005 Database Engine still supports connections from existing applications using the DB-Library and Embedded SQL APIs, it does not include the files or documentation needed to do programming work on applications that use these APIs. A future version of the SQL Server Database Engine will drop support for connections from DB-Library or Embedded SQL applications. Do not use DB-Library or Embedded SQL to develop new applications. Remove any dependencies on either DB-Library or Embedded SQL when modifying existing applications. Instead of these APIs, use the SQLClient namespace or an API such as OLE DB or ODBC. SQL Server 2005 does not include the DB-Library DLL required to run these applications. To run DB-Library or Embedded SQL applications you must have available the DB-Library DLL from SQL Server version 6.5, SQL Server 7.0, or SQL Server 2000.

|||

I'm running into a similar problem, and was wondering if the NTWDBLIB.DLL file is a freely distributable file from Microsoft? If it is, then the file could be distributed with our application to ensure that it works with SQL Server 2005 database engine.

I understand that this would be a short-term solution, until the next build of Microsoft's SQL Server engine comes out, which will not support connections from DB-Library APIs.

is notification services installed?

Hi All,
for ss2000, if notification services was installed, it will show up under
add remove programs...correct?
but for ss2005, it does not show up under add/remove... but you would see it
in management studio...correct?
thanks
Hello Jason,
As for SQL Server 2005 database instance, after you install it on your
machine, you can still use the "Control Panel--> Add/Remove programs" to
modify or remove it. The difference from SQL Server 2000 instance is that,
you need to first select the "Microsoft SqlServer 2005" in the add/remove
program's installed program list, and then choose "Change" or "Remove"
according to what you want to do. Then, it will show all installed SQL
Server 2005 instances and all the available installed SQL Server 2005
components(such as notification service, reporting service...), you can
choose add or remove certain component. Here is a knowledge base article
detailedly describe this:
#How to use the Add or Remove Programs item in Control Panel to add or
remove components for stand-alone installations and clustered installations
of SQL Server 2005
http://support.microsoft.com/kb/922670/en-us
Hope this helps.
Sincerely,
Steven Cheng
Microsoft MSDN Online Support Lead
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

is notification services installed?

Hi All,
for ss2000, if notification services was installed, it will show up under
add remove programs...correct?
but for ss2005, it does not show up under add/remove... but you would see it
in management studio...correct?
thanksHello Jason,
As for SQL Server 2005 database instance, after you install it on your
machine, you can still use the "Control Panel--> Add/Remove programs" to
modify or remove it. The difference from SQL Server 2000 instance is that,
you need to first select the "Microsoft SqlServer 2005" in the add/remove
program's installed program list, and then choose "Change" or "Remove"
according to what you want to do. Then, it will show all installed SQL
Server 2005 instances and all the available installed SQL Server 2005
components(such as notification service, reporting service...), you can
choose add or remove certain component. Here is a knowledge base article
detailedly describe this:
#How to use the Add or Remove Programs item in Control Panel to add or
remove components for stand-alone installations and clustered installations
of SQL Server 2005
http://support.microsoft.com/kb/922670/en-us
Hope this helps.
Sincerely,
Steven Cheng
Microsoft MSDN Online Support Lead
========================================
==========
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscript...ault.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscript...t/default.aspx.
========================================
==========
This posting is provided "AS IS" with no warranties, and confers no rights.

is notification services installed?

Hi All,
for ss2000, if notification services was installed, it will show up under
add remove programs...correct?
but for ss2005, it does not show up under add/remove... but you would see it
in management studio...correct?
thanksHello Jason,
As for SQL Server 2005 database instance, after you install it on your
machine, you can still use the "Control Panel--> Add/Remove programs" to
modify or remove it. The difference from SQL Server 2000 instance is that,
you need to first select the "Microsoft SqlServer 2005" in the add/remove
program's installed program list, and then choose "Change" or "Remove"
according to what you want to do. Then, it will show all installed SQL
Server 2005 instances and all the available installed SQL Server 2005
components(such as notification service, reporting service...), you can
choose add or remove certain component. Here is a knowledge base article
detailedly describe this:
#How to use the Add or Remove Programs item in Control Panel to add or
remove components for stand-alone installations and clustered installations
of SQL Server 2005
http://support.microsoft.com/kb/922670/en-us
Hope this helps.
Sincerely,
Steven Cheng
Microsoft MSDN Online Support Lead
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

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

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,
-Steve
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 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:
>
>
>
> 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_SQLSupp ort_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.l og
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_Backwar dsCompat_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.l og
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:
>
> 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:
> 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

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:
>
>
>
>
>
> 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.microsof
t.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.c
om/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:
>
> 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 m
ay
> 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:
> 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