.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Choosing Operating System to host SQL Server

Posted By:      Posted Date: October 08, 2010    Points: 0   Category :Sql Server

As part of a solution at multipel customer sites, we are considering using Windows 7 as the OS for SQL Server 2008 installations.  These are non-mission critical installs, used for a environmental monitoring system for continous data logging, and alarm and event logging.  Reporting Services will be used to view reports occasionally, so mostly it is a a data collection system with little user interaction.  The rationale is that Windows 7 provides a lower cost yet robust platform for SQL Server 2008, than using a server OS.  Are there any reasons Windows 7 would not not be a good (or even prefered) choice for this application, and if not why not?  What practical benefits would Windows 2003 Server or Windows 2008 Server really have?


View Complete Post

More Related Resource Links

Unable to open physical file - Operating system error 5: 5(error not found) Microsoft SQL Server: Er

I am trying to attach a database to SQL 2005. This database has not previously been attached. I have only just installed SQL.   I get the following message: Unable to open physical file "C:\ArrowSQL\Arr@Data\Arrow_data.mdf" Operating system error 5: "5(error not found)" (Microsoft SQL Server: Error 5120)".   I have loaded SQL and the database fiel and directory with the same user acccount which is a local adminstrator ont hsi machine. I have checked that I have read/write access to the file.   The machine runs Windows Vista Business. SQL has SP 2 loaded.   What causes this?

unable to create new table in sql server 2000 enterprise manager on windows7(Operating system)

i have successfuly installed sql server 2000 on windows7 and i am able to browse all the tables and edit aswell(on enterprise manager) but i have a problem while creating new tables it says ' MMC has detected an error in a snap-in' and provides options to either continue with the error or send a report to microsoft ,   Please help regarding this compatibility issue   Thanks in advance !

SQL Server 2008 Installation on SBS 2003 - Rule "Operating system supported for edition" failed


I'm trying to install SQL Server 2008 for Small Business, on a Windows Server 2003 SBS, which is a Domain Controller on a less than 50 users ' domain. I'm logged in with the Administrator account, wich belongs to the 'Doman admins' group also. Setup failed with this error:

2010-09-25 11:55:34 Slp: EditionRequirementCheck Rule Check : The edition is not allowed on this OS.
2010-09-25 11:55:34 Slp: Evaluating rule        : EditionRequirementCheck
2010-09-25 11:55:34 Slp: Rule running on machine: DELL1
2010-09-25 11:55:34 Slp: Rule evaluation done   : Failed
2010-09-25 11:55:34 Slp: Rule evaluation message: This SQL Server edition is not supported on this operating system. See SQL Server Books Online for information about supported operating systems for SQL Small Business Server edition.

According to this link, this version is supported on Windows Server 2003 SBS: http://msdn.microsoft.com/en-us/library/ms143506%28SQL.100%29.aspx#SE32

I've tried to diagnose the error, after reading this link: http://blogs.technet.com/b/sbs/archive/2010/07/21/how-to-diagnose-quot-operating-system-supported-for-edition-quot-pre-requisite-errors-while-installing-sql-2008-standard-edition-for-small-business.aspx

After a new

Event 18210 error - Operating system error 1130 (not enough server storage is available to process t


I tried for the last three days to do a restore over the network or copy the files from one server to another. I kept getting NOT Enough space but there is 500GB free for 49GB file.

OS: Windows Server 2008 64bits

SQL Server 2008 R2 Enterprise 64bits

Restoring using T-sql got the following error:

Msg 3203, Level 16, State 1, Line 1

Read on "\\servername\backup\xxxxx\xxxxx_backup.bak" failed: 1130(Not enough server storage is available to process this command.)

Msg 3013, Level 16, State 1, Line 1

RESTORE DATABASE is terminating abnormally.

Event log as the following:

BackupIoRequest::ReportIoError: read failure on backup device '\\servername\backup\xxxxx\xxxxx_backup.bak'. Operating system error 1130(Not enough server storage is available to process this command.).

I did some research and I found stuff for SQL 7 or windows XP or NT old s

how to install 32 bit sql server 2005 express in 64 bit windows 7 operating system?

how to install 32 bit sql server 2005 express in 64 bit windows 7 operating system?

how i can install sql server in my system


which edition of sql server  are best for me  Developer edition or express editon for development purpose.

i try to install last time sql server in my system but not successful so what i do for get the sql server in my system.

Team System: Team Foundation Server Event Service


Use the Team Foundation Server EventService to create and manage event subscriptions or create a Web service to receive and process events.

Brian A. Randell

MSDN Magazine May 2008

Team System: Team Foundation Server Version Control


In this new column, Brian Randell begins his long look at how to extend and enhance Visual Studio Team System.

Brian A. Randell

MSDN Magazine January 2007

Types in Yukon: Managed UDTs Let You Extend the SQL Server Type System


The next version of SQL Server, code-named "Yukon," will offer enhanced support for user-defined types (UDTs). Because UDTs can be managed by the CLR, you can represent a wide variety of data structures to create types not possible with previous versions of SQL Server. With UDTs you can more precisely control the kind of data your type accepts, resulting in better data management. This article explores UDTs in "Yukon" and covers their design and implementation.

Peter W. DeBetta

MSDN Magazine February 2004

Windows Server 2003: Discover Improved System Info, New Kernel, Debugging, Security, and UI APIs


There's a lot to say about Windows Server 2003. First of all, it's the first operating system with built-in .NET Framework support, and it's the first 64-bit OS from Microsoft. But wait, there's more! There are lots of new features and APIs in this version as well. For instance, Windows Server 2003 features Hot Add Memory and a number of other arcane new tidbits. There are new APIs for handling threads, directories, and files, and new features like the low fragmentation heap for managing memory and system information. There's vectored exception handling and new UI APIs as well.OS internals expert Matt Pietrek takes a look at the additions he finds most interesting and useful so you'll have a good place to start when you dive into Windows Server 2003.

Matt Pietrek

MSDN Magazine June 2003

HOWTO add a C#.NET library to SQL Server as an assembly that uses such references as system.web.

HOWTO add a C#.NET library to SQL Server as an assembly that uses such references as system.web. I have a C# library (dll) I want to add to SQL Server via "CREATE ASSEMBLY", but the DLL uses these references: Microsoft.VisualBasic System System.Core System.Data System.Data.DataSetExtensions System.Drawing System.Management System.Web System.Web.Extensions System.Web.Mobile System.Web.Services System.Xml System.Xml.Linq And just to be clear, the DLL is a .NET 3.5 app, with the SQL Server being SQL Server 2008. Right off the bat, the "CREATE ASSEMBLY" call fails due to System.Web, which strangely, is The CREATE ASSEMBLE says this error: Msg 10301, Level 16, State 1, Line 1 Assembly 'MyLibrary' references assembly 'system.web, version=, culture=neutral, publickeytoken=b03f5f7f11d50a3a.', which is not present in the current database. SQL Server attempted to locate and automatically load the referenced assembly from the same location where referring assembly came from, but that operation has failed (reason: 2(The system cannot find the file specified.)). Please load the referenced assembly into the current database and retry your request. I have tried to use VS 2010, to create a SQL Server DB project, and it point blank does not let one add references to things like System.Web. When trying to use "Add Ref", VS 2010 literally lo

'System.OutOfMemoryException' SQL Server 2005

Looking for a solution to SQL Server 2005 'System.OutOfMemoryException' error, or at least the root cause of this error.   Following please find:1) Description of problem2) Exact error message3) Query that fails (against large 'SourceTable', but works against smaller subsets of 'SourceTable' )4) Query that works (above, split apart) on any size table5) Machine and SQL configuration and versions DESCRIPTION OF PROBLEM-------------------------------------------------------I am getting a 'System.OutOfMemoryException' error running a simple query on a large table in SQL SERVER 2005. If I run with a fresh boot, only me on the server, and only SQL Server Management Studio open with 1 query window, I'll get this error when I run it against my full-sized SourceTable.  Task Manager indicates there is still more than 7 Gig of physical memory available! (see system configuration at end of this note).   The query runs to competion if I run it against a smaller 'SourceTable'.    If I break out the matchup to the derived table from the query into a separate step, the query will run until completion against any size table I throw at it.   I've searched the web, and found that people are getting this error with SQL Server 2005, but not with SQL Server 2000.  It looks like people are encountering it in various queries that should work, and in other circumstances such as when runn

I am getting System.Web.Services.Protocols.SoapHeaderException: Server unavailable error?..

 Hi,    I am using WSE 3.0 for my applicaton. when run from the client end I am getting following error.System.Web.Services.Protocols.SoapHeaderException: Server unavailable, please try later ---> System.ApplicationException: WSE841: An error occured processing an outgoing fault response. ---> System.Web.Services.Protocols.SoapHeaderException: Microsoft.Web.Services3.Security.SecurityFault: Header http://schemas.xmlsoap.org/ws/2004/08/addressing:Action for ultimate recipient is required but not present in the message.  at Microsoft.Web.Services3.Design.RequireSoapHeaderAssertion.RequireSoapHeaderFilter.ProcessMessage(SoapEnvelope envelope)  at Microsoft.Web.Services3.Pipeline.ProcessInputMessage(SoapEnvelope envelope)  at Microsoft.Web.Services3.WseProtocol.FilterRequest(SoapEnvelope requestEnvelope)  at Microsoft.Web.Services3.WseProtocol.RouteRequest(SoapServerMessage message)  at System.Web.Services.Protocols.SoapServerProtocol.Initialize()  at System.Web.Services.Protocols.ServerProtocolFactory.Create(Type type, HttpContext context, HttpRequest request, HttpResponse response, Boolean& abortProcessing)  --- End of inner exception stack trace ---  --- End of inner exception stack trace ---         Help needed on this. re

Problem to install MS SQL 2005 on Window 7 Operating System

Hi, I recently have problem to install MS SQL 2005 on Window 7 Operating System. Setup showing an error for compitability issues. When click on to button to check for solution online, after a while it pop up that No solutions found for Microsoft SQL Server 2005. Any one know solution for this? Is is possible to install Microsoft SQL Server 2008 on Window 7 and migrate data from Microsoft SQL Server 2005 to 2008? Please advice. Appreciate your help. Thanks.

System DSN created on x64 08 server but not visible - SQL08 x64 to be used by x32 app

Hi all, I am trying to create a SystemDSN on a 64bit Windows 2008 server. The application that will use it is a 32bit app so i go into C:\Windows\SysWOW64 and run as admin odbcad32.exe I then go ahead to create a systemDSN to a SQL2008 database using the SQL native client. All off the steps of the systemdsn creation wizard go thrugh and i get a success at the end. But then i get no new systemDSN listen in the box. The user that is doing the creation is a domain administrator and also in the admin group on the particular server. This is really strange to me. Has anyone seen this behaviour? SQL server 08 is x64 on a x64 machine. The reason i am using the 32bit ODBC is beacause the app is x32 app. Any advice? Cheers Dan

Where is System.Web.Extensions.dll now? Fails on remote hosted server.

I've read all the notes about how from RC2 to ajax.net the name space has changed. "The core ASP.NET AJAX assembly has been changed from Microsoft.Web.Extensions.dll to System.Web.Extensions.dll. In addition, the namespace has changed from Microsoft.Web.* to System.Web.*. For some reason, my app runs on my local machine but when I copy it to a remote server (that does not have the ajax updated installed) it fails.  How can I get an IIS installation to work?  Am I missing a dll that I can push up to the remote server?  I can't run the install on the remote machine becasue it's a hosted server. Thanks

System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> Object canno

hello,i am using a web servicewrtitten in .net and i access the webservice from my wepApplication i get this error System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> Object cannot be cast from DBNull to other types.my code is access webservice: protected void btnSave_Click(object sender, EventArgs e)        {            int intStatusCode;            dtProjectStatus = (DataTable)ViewState["dtProjectStatus"];            try            {                objService.Credentials = System.Net.CredentialCache.DefaultCredentials;                if(dtProjectStatus.Rows.Count>0)                {                  intStatusCode = objService.InsertTest(dtProjectStatus);                }   
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend