Showing posts with label desktop. Show all posts
Showing posts with label desktop. Show all posts

Tuesday, March 20, 2012

Running SQL Server on a Desktop Machine

Hi,

The company I work at was going to install SQL Server 2005 on a server running Windows Server 2000. However this server is no longer available, and due to cost restraints we are unable to purchase another server.

I still wish to get SQL Server 2005 running, and have a spare desktop computer avaible. This computer is a P4 3.2GHz with 1GB of RAM and 40GB hard disk.
I was thinking of adding RAM and a larger hard disk, and installing Windows Server 2003 on it.

Is it advisable to run SQL Server 2005 (and Server 2003) on a desktop computer? Any comments or experiences of similar situations would be appreciated.

Thanks,
MattThere's lots of issues here;
1 What's it for?
2 Version
You have not mentioned which version of SQL Server 2005
3 Capacity
Your hardware spec. meets the minimum requirements, you can install SQL 2005, but what you will actually be doing with it will determine the hardware.
4 Availability
Again, what do you need to do on this server; server hardware is built to serve mission critical applications, the numbers might not look as good but you generally get a system that allows for RAID, hot swapping HDDs and memory, etc.
5 Maintenance & Support
E.g. If a HDD fails, will your hardware guys fix it, or will they say - what's this mickey-mouse setup?

And so on...|||Thanks for the reply, sorry I should have been more specific.

The version used would be the Standard Edition.

I am responsible for the reporting of our organisation. Currently data is taken from the enterprise system and reported on using Microsoft Access and Excel. So if I upgraded to SQL Server then it would be used to implement a data warehousing solution. Table updates would run in the morning, along with the emailing/printing of several reports. After that most usage would be via Excel queries. There would be around 20-30 users doing this, with no more than 10 accessing the SQL Server concurrently.

Eventually the SQL Server system would be moved to a server, but this cannot happen until 8 months or so. I am ready to start going live with a SQL Server solution, and want to use to desktop machine as a temporary solution. I want to know whether using this desktop will provide a workable solution. I know it is far from perfect, but considering we are currently running Access as a reporting database server, will the solution work temporarily?

Regarding maintennance and support, seeing it is not a mission critical solution, I had planned to backup the data files and any code created in BIDS on a seperate server. In the event of a disaster this would allow me to recreate the data warehouse on another hard drive. Again, it is an imperfect solution but I am hoping it would do the job until a server machine becomes available.

Purchasing a server is not really an option due to the price. The cost of SQL Server has already been approved, and if I go with this desktop machine only another $1200 or so will be needed for Server 2003 and hardware upgrades.

Any help or opinions with this would be great.|||You haven't said anything that makes me think it won't be able to handle the capacity, but I still would worry about a live service on a server-under-the-desk scenario.
Apart from the issues I've alreay mentioned, make sure you aren't breaking any corporate standards, laws or regulatory requirements for the data you are handling.

Tuesday, February 21, 2012

Running Snort with MSDE/Server Express 2005

Hi,
Is it possible to install SNORT with MSDE or SQL Server 2005 Express
Edition?
I'm trying to install this on a standalone desktop PC, running Windows XP
Pro SP2 that has been stripped of any non-essential services. I have
installed MSDE 2000A from
http://www.microsoft.com/downloads/details.aspx?FamilyID=413744d1-a0bc-479f-bafa-e4b278eb9147&DisplayLang=en
and then installed the latest version of snort, and WinPcap3.1. However when
I try and configure snort, I get an error message about ntwdblib.dll not
being found or registered. I have read an FAQ that says:
"This is the Microsoft SQL Server(tm) client DLL. This library is used by
client applications attempting to establish direct connections to an
installation of SQL Server, as opposed to connecting via ODBC or ADO. It is
provided by Microsoft as part of their SQL Server product, and is installed
as part of the SQL Server client package on the SQL Server CD-ROM.".
So I installed SQL Server 2005 Express Edition, in the hope that it would
install & register this file, but again, I'm receiving the same error.
Any help would be greatly appreciated.
BenHi
ntwdblib.dll is for db-library which no longer supported, but your msde
install would have created it. Did you check the DLL exists and is it on your
PATH? It should be in the system32 directory.
John
"benblackmore@.nospam.postalias" wrote:
> Hi,
> Is it possible to install SNORT with MSDE or SQL Server 2005 Express
> Edition?
> I'm trying to install this on a standalone desktop PC, running Windows XP
> Pro SP2 that has been stripped of any non-essential services. I have
> installed MSDE 2000A from
> http://www.microsoft.com/downloads/details.aspx?FamilyID=413744d1-a0bc-479f-bafa-e4b278eb9147&DisplayLang=en
> and then installed the latest version of snort, and WinPcap3.1. However when
> I try and configure snort, I get an error message about ntwdblib.dll not
> being found or registered. I have read an FAQ that says:
> "This is the Microsoft SQL Server(tm) client DLL. This library is used by
> client applications attempting to establish direct connections to an
> installation of SQL Server, as opposed to connecting via ODBC or ADO. It is
> provided by Microsoft as part of their SQL Server product, and is installed
> as part of the SQL Server client package on the SQL Server CD-ROM.".
> So I installed SQL Server 2005 Express Edition, in the hope that it would
> install & register this file, but again, I'm receiving the same error.
> Any help would be greatly appreciated.
> Ben
>
>|||Hi,
Thanks for the reply.
Yes, I even did a search of my entire C: drive for 'ntwdblib.dll', and it
found nothing.
Ben
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:0FE539E5-18EC-4D71-A4B7-13B014A34079@.microsoft.com...
> Hi
> ntwdblib.dll is for db-library which no longer supported, but your msde
> install would have created it. Did you check the DLL exists and is it on
> your
> PATH? It should be in the system32 directory.
> John
> "benblackmore@.nospam.postalias" wrote:
>> Hi,
>> Is it possible to install SNORT with MSDE or SQL Server 2005 Express
>> Edition?
>> I'm trying to install this on a standalone desktop PC, running Windows XP
>> Pro SP2 that has been stripped of any non-essential services. I have
>> installed MSDE 2000A from
>> http://www.microsoft.com/downloads/details.aspx?FamilyID=413744d1-a0bc-479f-bafa-e4b278eb9147&DisplayLang=en
>> and then installed the latest version of snort, and WinPcap3.1. However
>> when
>> I try and configure snort, I get an error message about ntwdblib.dll not
>> being found or registered. I have read an FAQ that says:
>> "This is the Microsoft SQL Server(tm) client DLL. This library is used by
>> client applications attempting to establish direct connections to an
>> installation of SQL Server, as opposed to connecting via ODBC or ADO. It
>> is
>> provided by Microsoft as part of their SQL Server product, and is
>> installed
>> as part of the SQL Server client package on the SQL Server CD-ROM.".
>> So I installed SQL Server 2005 Express Edition, in the hope that it would
>> install & register this file, but again, I'm receiving the same error.
>> Any help would be greatly appreciated.
>> Ben
>>|||Hi Ben
An installation of MSDE with "MDAC with additional client components" will
install DB-Library. You may want to enable logging for your installation by
using the /L*v option see
http://support.microsoft.com/default.aspx?scid=KB;EN-US;Q324998
John
"benblackmore@.nospam.postalias" wrote:
> Hi,
> Thanks for the reply.
> Yes, I even did a search of my entire C: drive for 'ntwdblib.dll', and it
> found nothing.
> Ben
>
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:0FE539E5-18EC-4D71-A4B7-13B014A34079@.microsoft.com...
> > Hi
> >
> > ntwdblib.dll is for db-library which no longer supported, but your msde
> > install would have created it. Did you check the DLL exists and is it on
> > your
> > PATH? It should be in the system32 directory.
> >
> > John
> >
> > "benblackmore@.nospam.postalias" wrote:
> >
> >> Hi,
> >>
> >> Is it possible to install SNORT with MSDE or SQL Server 2005 Express
> >> Edition?
> >>
> >> I'm trying to install this on a standalone desktop PC, running Windows XP
> >> Pro SP2 that has been stripped of any non-essential services. I have
> >> installed MSDE 2000A from
> >> http://www.microsoft.com/downloads/details.aspx?FamilyID=413744d1-a0bc-479f-bafa-e4b278eb9147&DisplayLang=en
> >> and then installed the latest version of snort, and WinPcap3.1. However
> >> when
> >> I try and configure snort, I get an error message about ntwdblib.dll not
> >> being found or registered. I have read an FAQ that says:
> >>
> >> "This is the Microsoft SQL Server(tm) client DLL. This library is used by
> >> client applications attempting to establish direct connections to an
> >> installation of SQL Server, as opposed to connecting via ODBC or ADO. It
> >> is
> >> provided by Microsoft as part of their SQL Server product, and is
> >> installed
> >> as part of the SQL Server client package on the SQL Server CD-ROM.".
> >>
> >> So I installed SQL Server 2005 Express Edition, in the hope that it would
> >> install & register this file, but again, I'm receiving the same error.
> >>
> >> Any help would be greatly appreciated.
> >>
> >> Ben
> >>
> >>
> >>
>
>|||Hi Ben,
None of the SQL Server 2005 client tools have any dependency on
ntwdblib.dll and it is no longer shipped with SQL Server 2005.
Ntwdblib.dll is the DLL for the old DB-Library API. DB-Library is
deprecated with SQL Server 2005; SQL Server 2005 no longer includes the
DB-Library dll, and anyone wanting to run a DB-Library application against
SQL Server 2005 needs to get the dll from a previous version of SQL Server.
From the SQL Server 2005 Books Online:
http://msdn2.microsoft.com/en-us/library/ms143729(en-US,SQL.90).aspx
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 think you have to copy the ntwdblib.dll from another computer which
contains and register it manually.
Best regards,
Vincent Xu
Microsoft Online Partner Support
======================================================Get Secure! - www.microsoft.com/security
======================================================When responding to posts, please "Reply to Group" via your newsreader so
that others
may learn and benefit from this issue.
======================================================This posting is provided "AS IS" with no warranties,and confers no rights.
======================================================>>Reply-To: <benblackmore@.nospam.postalias>
>>From: <benblackmore@.nospam.postalias>
>>Subject: Running Snort with MSDE/Server Express 2005
>>Date: Mon, 26 Jun 2006 11:58:47 +0100
>>Lines: 27
>>X-Priority: 3
>>X-MSMail-Priority: Normal
>>X-Newsreader: Microsoft Outlook Express 6.00.2900.2869
>>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2869
>>X-RFC2646: Format=Flowed; Original
>>Message-ID: <uX1hB#QmGHA.4268@.TK2MSFTNGP05.phx.gbl>
>>Newsgroups: microsoft.public.sqlserver.server
>>NNTP-Posting-Host: host217-37-28-250.in-addr.btopenworld.com 217.37.28.250
>>Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP01.phx.gbl!TK2MSFTNGP05.phx.gbl
>>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.server:436220
>>X-Tomcat-NG: microsoft.public.sqlserver.server
>>Hi,
>>Is it possible to install SNORT with MSDE or SQL Server 2005 Express
>>Edition?
>>I'm trying to install this on a standalone desktop PC, running Windows XP
>>Pro SP2 that has been stripped of any non-essential services. I have
>>installed MSDE 2000A from
>>http://www.microsoft.com/downloads/details.aspx?FamilyID=413744d1-a0bc-479
f-bafa-e4b278eb9147&DisplayLang=en
>>and then installed the latest version of snort, and WinPcap3.1. However
when
>>I try and configure snort, I get an error message about ntwdblib.dll not
>>being found or registered. I have read an FAQ that says:
>>"This is the Microsoft SQL Server(tm) client DLL. This library is used by
>>client applications attempting to establish direct connections to an
>>installation of SQL Server, as opposed to connecting via ODBC or ADO. It
is
>>provided by Microsoft as part of their SQL Server product, and is
installed
>>as part of the SQL Server client package on the SQL Server CD-ROM.".
>>So I installed SQL Server 2005 Express Edition, in the hope that it would
>>install & register this file, but again, I'm receiving the same error.
>>Any help would be greatly appreciated.
>>Ben
>>|||Hi Vincent,
Thanks for the reply.
I think we have a spare SQL 2000 license from our MAPS subscription, if I
install it, and use this rather than the 2005 version, this should register
the ntwdblib.dll, and work? I don't think we need the latest version of SQL,
it's only for snort to log to, which is why I initially tried the MSDE, but
failing that, I assume it can do this using SQL 2000 as well.
Many thanks
Ben
"Vincent Xu [MSFT]" <v-xuwen@.online.microsoft.com> wrote in message
news:Gtf%23XxYmGHA.5184@.TK2MSFTNGXA01.phx.gbl...
> Hi Ben,
> None of the SQL Server 2005 client tools have any dependency on
> ntwdblib.dll and it is no longer shipped with SQL Server 2005.
> Ntwdblib.dll is the DLL for the old DB-Library API. DB-Library is
> deprecated with SQL Server 2005; SQL Server 2005 no longer includes the
> DB-Library dll, and anyone wanting to run a DB-Library application against
> SQL Server 2005 needs to get the dll from a previous version of SQL
> Server.
> From the SQL Server 2005 Books Online:
> http://msdn2.microsoft.com/en-us/library/ms143729(en-US,SQL.90).aspx
> 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 think you have to copy the ntwdblib.dll from another computer which
> contains and register it manually.
>
> Best regards,
> Vincent Xu
> Microsoft Online Partner Support
> ======================================================> Get Secure! - www.microsoft.com/security
> ======================================================> When responding to posts, please "Reply to Group" via your newsreader so
> that others
> may learn and benefit from this issue.
> ======================================================> This posting is provided "AS IS" with no warranties,and confers no rights.
> ======================================================>
> --
>>Reply-To: <benblackmore@.nospam.postalias>
>>From: <benblackmore@.nospam.postalias>
>>Subject: Running Snort with MSDE/Server Express 2005
>>Date: Mon, 26 Jun 2006 11:58:47 +0100
>>Lines: 27
>>X-Priority: 3
>>X-MSMail-Priority: Normal
>>X-Newsreader: Microsoft Outlook Express 6.00.2900.2869
>>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2869
>>X-RFC2646: Format=Flowed; Original
>>Message-ID: <uX1hB#QmGHA.4268@.TK2MSFTNGP05.phx.gbl>
>>Newsgroups: microsoft.public.sqlserver.server
>>NNTP-Posting-Host: host217-37-28-250.in-addr.btopenworld.com
>>217.37.28.250
>>Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP01.phx.gbl!TK2MSFTNGP05.phx.gbl
>>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.server:436220
>>X-Tomcat-NG: microsoft.public.sqlserver.server
>>Hi,
>>Is it possible to install SNORT with MSDE or SQL Server 2005 Express
>>Edition?
>>I'm trying to install this on a standalone desktop PC, running Windows XP
>>Pro SP2 that has been stripped of any non-essential services. I have
>>installed MSDE 2000A from
>>http://www.microsoft.com/downloads/details.aspx?FamilyID=413744d1-a0bc-479
> f-bafa-e4b278eb9147&DisplayLang=en
>>and then installed the latest version of snort, and WinPcap3.1. However
> when
>>I try and configure snort, I get an error message about ntwdblib.dll not
>>being found or registered. I have read an FAQ that says:
>>"This is the Microsoft SQL Server(tm) client DLL. This library is used by
>>client applications attempting to establish direct connections to an
>>installation of SQL Server, as opposed to connecting via ODBC or ADO. It
> is
>>provided by Microsoft as part of their SQL Server product, and is
> installed
>>as part of the SQL Server client package on the SQL Server CD-ROM.".
>>So I installed SQL Server 2005 Express Edition, in the hope that it would
>>install & register this file, but again, I'm receiving the same error.
>>Any help would be greatly appreciated.
>>Ben
>>
>|||Hi Ben
That should be fine if you have the licences. MSDE should have been fine but
I don't have enough information to say why it did not install this library.
John
"benblackmore@.nospam.postalias" wrote:
> Hi Vincent,
> Thanks for the reply.
> I think we have a spare SQL 2000 license from our MAPS subscription, if I
> install it, and use this rather than the 2005 version, this should register
> the ntwdblib.dll, and work? I don't think we need the latest version of SQL,
> it's only for snort to log to, which is why I initially tried the MSDE, but
> failing that, I assume it can do this using SQL 2000 as well.
> Many thanks
> Ben
> "Vincent Xu [MSFT]" <v-xuwen@.online.microsoft.com> wrote in message
> news:Gtf%23XxYmGHA.5184@.TK2MSFTNGXA01.phx.gbl...
> > Hi Ben,
> >
> > None of the SQL Server 2005 client tools have any dependency on
> > ntwdblib.dll and it is no longer shipped with SQL Server 2005.
> >
> > Ntwdblib.dll is the DLL for the old DB-Library API. DB-Library is
> > deprecated with SQL Server 2005; SQL Server 2005 no longer includes the
> > DB-Library dll, and anyone wanting to run a DB-Library application against
> > SQL Server 2005 needs to get the dll from a previous version of SQL
> > Server.
> > From the SQL Server 2005 Books Online:
> >
> > http://msdn2.microsoft.com/en-us/library/ms143729(en-US,SQL.90).aspx
> >
> > 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 think you have to copy the ntwdblib.dll from another computer which
> > contains and register it manually.
> >
> >
> > Best regards,
> >
> > Vincent Xu
> > Microsoft Online Partner Support
> >
> > ======================================================> > Get Secure! - www.microsoft.com/security
> > ======================================================> > When responding to posts, please "Reply to Group" via your newsreader so
> > that others
> > may learn and benefit from this issue.
> > ======================================================> > This posting is provided "AS IS" with no warranties,and confers no rights.
> > ======================================================> >
> >
> >
> > --
> >>Reply-To: <benblackmore@.nospam.postalias>
> >>From: <benblackmore@.nospam.postalias>
> >>Subject: Running Snort with MSDE/Server Express 2005
> >>Date: Mon, 26 Jun 2006 11:58:47 +0100
> >>Lines: 27
> >>X-Priority: 3
> >>X-MSMail-Priority: Normal
> >>X-Newsreader: Microsoft Outlook Express 6.00.2900.2869
> >>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2869
> >>X-RFC2646: Format=Flowed; Original
> >>Message-ID: <uX1hB#QmGHA.4268@.TK2MSFTNGP05.phx.gbl>
> >>Newsgroups: microsoft.public.sqlserver.server
> >>NNTP-Posting-Host: host217-37-28-250.in-addr.btopenworld.com
> >>217.37.28.250
> >>Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP01.phx.gbl!TK2MSFTNGP05.phx.gbl
> >>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.server:436220
> >>X-Tomcat-NG: microsoft.public.sqlserver.server
> >>
> >>Hi,
> >>
> >>Is it possible to install SNORT with MSDE or SQL Server 2005 Express
> >>Edition?
> >>
> >>I'm trying to install this on a standalone desktop PC, running Windows XP
> >>Pro SP2 that has been stripped of any non-essential services. I have
> >>installed MSDE 2000A from
> >>http://www.microsoft.com/downloads/details.aspx?FamilyID=413744d1-a0bc-479
> > f-bafa-e4b278eb9147&DisplayLang=en
> >>and then installed the latest version of snort, and WinPcap3.1. However
> > when
> >>I try and configure snort, I get an error message about ntwdblib.dll not
> >>being found or registered. I have read an FAQ that says:
> >>
> >>"This is the Microsoft SQL Server(tm) client DLL. This library is used by
> >>client applications attempting to establish direct connections to an
> >>installation of SQL Server, as opposed to connecting via ODBC or ADO. It
> > is
> >>provided by Microsoft as part of their SQL Server product, and is
> > installed
> >>as part of the SQL Server client package on the SQL Server CD-ROM.".
> >>
> >>So I installed SQL Server 2005 Express Edition, in the hope that it would
> >>install & register this file, but again, I'm receiving the same error.
> >>
> >>Any help would be greatly appreciated.
> >>
> >>Ben
> >>
> >>
> >>
> >
>
>|||Hi,
Glad to provide information. :)
Have a good day!
Best regards,
Vincent Xu
Microsoft Online Partner Support
======================================================Get Secure! - www.microsoft.com/security
======================================================When responding to posts, please "Reply to Group" via your newsreader so
that others
may learn and benefit from this issue.
======================================================This posting is provided "AS IS" with no warranties,and confers no rights.
======================================================>>Thread-Topic: Running Snort with MSDE/Server Express 2005
>>thread-index: AcaZ0SfQrlf7tnksTPWQc01FIfFYRQ==>>X-WBNR-Posting-Host: 62.6.139.10
>>From: =?Utf-8?B?Sm9obiBCZWxs?= <jbellnewsposts@.hotmail.com>
>>References: <uX1hB#QmGHA.4268@.TK2MSFTNGP05.phx.gbl>
<Gtf#XxYmGHA.5184@.TK2MSFTNGXA01.phx.gbl>
<u3ZK6dcmGHA.4952@.TK2MSFTNGP04.phx.gbl>
>>Subject: Re: Running Snort with MSDE/Server Express 2005
>>Date: Tue, 27 Jun 2006 03:05:02 -0700
>>Lines: 119
>>Message-ID: <42964C12-AE6E-4BA9-A759-8B190A508CAF@.microsoft.com>
>>MIME-Version: 1.0
>>Content-Type: text/plain;
>> charset="Utf-8"
>>Content-Transfer-Encoding: 7bit
>>X-Newsreader: Microsoft CDO for Windows 2000
>>Content-Class: urn:content-classes:message
>>Importance: normal
>>Priority: normal
>>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.1830
>>Newsgroups: microsoft.public.sqlserver.server
>>Path: TK2MSFTNGXA01.phx.gbl
>>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.server:436381
>>NNTP-Posting-Host: TK2MSFTNGXA01.phx.gbl 10.40.2.250
>>X-Tomcat-NG: microsoft.public.sqlserver.server
>>Hi Ben
>>That should be fine if you have the licences. MSDE should have been fine
but
>>I don't have enough information to say why it did not install this
library.
>>John
>>"benblackmore@.nospam.postalias" wrote:
>> Hi Vincent,
>> Thanks for the reply.
>> I think we have a spare SQL 2000 license from our MAPS subscription, if
I
>> install it, and use this rather than the 2005 version, this should
register
>> the ntwdblib.dll, and work? I don't think we need the latest version of
SQL,
>> it's only for snort to log to, which is why I initially tried the MSDE,
but
>> failing that, I assume it can do this using SQL 2000 as well.
>> Many thanks
>> Ben
>> "Vincent Xu [MSFT]" <v-xuwen@.online.microsoft.com> wrote in message
>> news:Gtf%23XxYmGHA.5184@.TK2MSFTNGXA01.phx.gbl...
>> > Hi Ben,
>> >
>> > None of the SQL Server 2005 client tools have any dependency on
>> > ntwdblib.dll and it is no longer shipped with SQL Server 2005.
>> >
>> > Ntwdblib.dll is the DLL for the old DB-Library API. DB-Library is
>> > deprecated with SQL Server 2005; SQL Server 2005 no longer includes
the
>> > DB-Library dll, and anyone wanting to run a DB-Library application
against
>> > SQL Server 2005 needs to get the dll from a previous version of SQL
>> > Server.
>> > From the SQL Server 2005 Books Online:
>> >
>> > http://msdn2.microsoft.com/en-us/library/ms143729(en-US,SQL.90).aspx
>> >
>> > 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 think you have to copy the ntwdblib.dll from another computer which
>> > contains and register it manually.
>> >
>> >
>> > Best regards,
>> >
>> > Vincent Xu
>> > Microsoft Online Partner Support
>> >
>> > ======================================================>> > Get Secure! - www.microsoft.com/security
>> > ======================================================>> > When responding to posts, please "Reply to Group" via your newsreader
so
>> > that others
>> > may learn and benefit from this issue.
>> > ======================================================>> > This posting is provided "AS IS" with no warranties,and confers no
rights.
>> > ======================================================>> >
>> >
>> >
>> > --
>> >>Reply-To: <benblackmore@.nospam.postalias>
>> >>From: <benblackmore@.nospam.postalias>
>> >>Subject: Running Snort with MSDE/Server Express 2005
>> >>Date: Mon, 26 Jun 2006 11:58:47 +0100
>> >>Lines: 27
>> >>X-Priority: 3
>> >>X-MSMail-Priority: Normal
>> >>X-Newsreader: Microsoft Outlook Express 6.00.2900.2869
>> >>X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2869
>> >>X-RFC2646: Format=Flowed; Original
>> >>Message-ID: <uX1hB#QmGHA.4268@.TK2MSFTNGP05.phx.gbl>
>> >>Newsgroups: microsoft.public.sqlserver.server
>> >>NNTP-Posting-Host: host217-37-28-250.in-addr.btopenworld.com
>> >>217.37.28.250
>> >>Path: TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP01.phx.gbl!TK2MSFTNGP05.phx.gbl
>> >>Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.sqlserver.server:436220
>> >>X-Tomcat-NG: microsoft.public.sqlserver.server
>> >>
>> >>Hi,
>> >>
>> >>Is it possible to install SNORT with MSDE or SQL Server 2005 Express
>> >>Edition?
>> >>
>> >>I'm trying to install this on a standalone desktop PC, running
Windows XP
>> >>Pro SP2 that has been stripped of any non-essential services. I have
>> >>installed MSDE 2000A from
>>http://www.microsoft.com/downloads/details.aspx?FamilyID=413744d1-a0bc-47
9
>> > f-bafa-e4b278eb9147&DisplayLang=en
>> >>and then installed the latest version of snort, and WinPcap3.1.
However
>> > when
>> >>I try and configure snort, I get an error message about ntwdblib.dll
not
>> >>being found or registered. I have read an FAQ that says:
>> >>
>> >>"This is the Microsoft SQL Server(tm) client DLL. This library is
used by
>> >>client applications attempting to establish direct connections to an
>> >>installation of SQL Server, as opposed to connecting via ODBC or
ADO. It
>> > is
>> >>provided by Microsoft as part of their SQL Server product, and is
>> > installed
>> >>as part of the SQL Server client package on the SQL Server CD-ROM.".
>> >>
>> >>So I installed SQL Server 2005 Express Edition, in the hope that it
would
>> >>install & register this file, but again, I'm receiving the same
error.
>> >>
>> >>Any help would be greatly appreciated.
>> >>
>> >>Ben
>> >>
>> >>
>> >>
>> >
>>
>>

Running Snort with MSDE/Server Express 2005

Hi,
Is it possible to install SNORT with MSDE or SQL Server 2005 Express
Edition?
I'm trying to install this on a standalone desktop PC, running Windows XP
Pro SP2 that has been stripped of any non-essential services. I have
installed MSDE 2000A from
http://www.microsoft.com/downloads/...&DisplayLang=en
and then installed the latest version of snort, and WinPcap3.1. However when
I try and configure snort, I get an error message about ntwdblib.dll not
being found or registered. I have read an FAQ that says:
"This is the Microsoft SQL Server(tm) client DLL. This library is used by
client applications attempting to establish direct connections to an
installation of SQL Server, as opposed to connecting via ODBC or ADO. It is
provided by Microsoft as part of their SQL Server product, and is installed
as part of the SQL Server client package on the SQL Server CD-ROM.".
So I installed SQL Server 2005 Express Edition, in the hope that it would
install & register this file, but again, I'm receiving the same error.
Any help would be greatly appreciated.
BenHi
ntwdblib.dll is for db-library which no longer supported, but your msde
install would have created it. Did you check the DLL exists and is it on you
r
PATH? It should be in the system32 directory.
John
"benblackmore@.nospam.postalias" wrote:

> Hi,
> Is it possible to install SNORT with MSDE or SQL Server 2005 Express
> Edition?
> I'm trying to install this on a standalone desktop PC, running Windows XP
> Pro SP2 that has been stripped of any non-essential services. I have
> installed MSDE 2000A from
> http://www.microsoft.com/downloads/...&DisplayLang=en
> and then installed the latest version of snort, and WinPcap3.1. However wh
en
> I try and configure snort, I get an error message about ntwdblib.dll not
> being found or registered. I have read an FAQ that says:
> "This is the Microsoft SQL Server(tm) client DLL. This library is used by
> client applications attempting to establish direct connections to an
> installation of SQL Server, as opposed to connecting via ODBC or ADO. It i
s
> provided by Microsoft as part of their SQL Server product, and is installe
d
> as part of the SQL Server client package on the SQL Server CD-ROM.".
> So I installed SQL Server 2005 Express Edition, in the hope that it would
> install & register this file, but again, I'm receiving the same error.
> Any help would be greatly appreciated.
> Ben
>
>|||Hi,
Thanks for the reply.
Yes, I even did a search of my entire C: drive for 'ntwdblib.dll', and it
found nothing.
Ben
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:0FE539E5-18EC-4D71-A4B7-13B014A34079@.microsoft.com...[vbcol=seagreen]
> Hi
> ntwdblib.dll is for db-library which no longer supported, but your msde
> install would have created it. Did you check the DLL exists and is it on
> your
> PATH? It should be in the system32 directory.
> John
> "benblackmore@.nospam.postalias" wrote:
>|||Hi Ben
An installation of MSDE with "MDAC with additional client components" will
install DB-Library. You may want to enable logging for your installation by
using the /L*v option see
http://support.microsoft.com/defaul...B;EN-US;Q324998
John
"benblackmore@.nospam.postalias" wrote:

> Hi,
> Thanks for the reply.
> Yes, I even did a search of my entire C: drive for 'ntwdblib.dll', and it
> found nothing.
> Ben
>
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:0FE539E5-18EC-4D71-A4B7-13B014A34079@.microsoft.com...
>
>|||Hi
ntwdblib.dll is for db-library which no longer supported, but your msde
install would have created it. Did you check the DLL exists and is it on you
r
PATH? It should be in the system32 directory.
John
"benblackmore@.nospam.postalias" wrote:

> Hi,
> Is it possible to install SNORT with MSDE or SQL Server 2005 Express
> Edition?
> I'm trying to install this on a standalone desktop PC, running Windows XP
> Pro SP2 that has been stripped of any non-essential services. I have
> installed MSDE 2000A from
> http://www.microsoft.com/downloads/...&DisplayLang=en
> and then installed the latest version of snort, and WinPcap3.1. However wh
en
> I try and configure snort, I get an error message about ntwdblib.dll not
> being found or registered. I have read an FAQ that says:
> "This is the Microsoft SQL Server(tm) client DLL. This library is used by
> client applications attempting to establish direct connections to an
> installation of SQL Server, as opposed to connecting via ODBC or ADO. It i
s
> provided by Microsoft as part of their SQL Server product, and is installe
d
> as part of the SQL Server client package on the SQL Server CD-ROM.".
> So I installed SQL Server 2005 Express Edition, in the hope that it would
> install & register this file, but again, I'm receiving the same error.
> Any help would be greatly appreciated.
> Ben
>
>|||Hi,
Thanks for the reply.
Yes, I even did a search of my entire C: drive for 'ntwdblib.dll', and it
found nothing.
Ben
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:0FE539E5-18EC-4D71-A4B7-13B014A34079@.microsoft.com...[vbcol=seagreen]
> Hi
> ntwdblib.dll is for db-library which no longer supported, but your msde
> install would have created it. Did you check the DLL exists and is it on
> your
> PATH? It should be in the system32 directory.
> John
> "benblackmore@.nospam.postalias" wrote:
>|||Hi Ben
An installation of MSDE with "MDAC with additional client components" will
install DB-Library. You may want to enable logging for your installation by
using the /L*v option see
http://support.microsoft.com/defaul...B;EN-US;Q324998
John
"benblackmore@.nospam.postalias" wrote:

> Hi,
> Thanks for the reply.
> Yes, I even did a search of my entire C: drive for 'ntwdblib.dll', and it
> found nothing.
> Ben
>
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:0FE539E5-18EC-4D71-A4B7-13B014A34079@.microsoft.com...
>
>|||Hi Ben,
None of the SQL Server 2005 client tools have any dependency on
ntwdblib.dll and it is no longer shipped with SQL Server 2005.
Ntwdblib.dll is the DLL for the old DB-Library API. DB-Library is
deprecated with SQL Server 2005; SQL Server 2005 no longer includes the
DB-Library dll, and anyone wanting to run a DB-Library application against
SQL Server 2005 needs to get the dll from a previous version of SQL Server.
From the SQL Server 2005 Books Online:
http://msdn2.microsoft.com/en-us/library/ms143729(en-US,SQL.90).aspx
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 think you have to copy the ntwdblib.dll from another computer which
contains and register it manually.
Best regards,
Vincent Xu
Microsoft Online Partner Support
========================================
==============
Get Secure! - www.microsoft.com/security
========================================
==============
When responding to posts, please "Reply to Group" via your newsreader so
that others
may learn and benefit from this issue.
========================================
==============
This posting is provided "AS IS" with no warranties,and confers no rights.
========================================
==============
--[vbcol=seagreen]
f-bafa-e4b278eb9147&DisplayLang=en[vbcol=seagreen]
when[vbcol=seagreen]
is[vbcol=seagreen]
installed[vbcol=seagreen]|||Hi Ben,
None of the SQL Server 2005 client tools have any dependency on
ntwdblib.dll and it is no longer shipped with SQL Server 2005.
Ntwdblib.dll is the DLL for the old DB-Library API. DB-Library is
deprecated with SQL Server 2005; SQL Server 2005 no longer includes the
DB-Library dll, and anyone wanting to run a DB-Library application against
SQL Server 2005 needs to get the dll from a previous version of SQL Server.
From the SQL Server 2005 Books Online:
http://msdn2.microsoft.com/en-us/library/ms143729(en-US,SQL.90).aspx
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 think you have to copy the ntwdblib.dll from another computer which
contains and register it manually.
Best regards,
Vincent Xu
Microsoft Online Partner Support
========================================
==============
Get Secure! - www.microsoft.com/security
========================================
==============
When responding to posts, please "Reply to Group" via your newsreader so
that others
may learn and benefit from this issue.
========================================
==============
This posting is provided "AS IS" with no warranties,and confers no rights.
========================================
==============
--[vbcol=seagreen]
f-bafa-e4b278eb9147&DisplayLang=en[vbcol=seagreen]
when[vbcol=seagreen]
is[vbcol=seagreen]
installed[vbcol=seagreen]|||Hi Vincent,
Thanks for the reply.
I think we have a spare SQL 2000 license from our MAPS subscription, if I
install it, and use this rather than the 2005 version, this should register
the ntwdblib.dll, and work? I don't think we need the latest version of SQL,
it's only for snort to log to, which is why I initially tried the MSDE, but
failing that, I assume it can do this using SQL 2000 as well.
Many thanks
Ben
"Vincent Xu [MSFT]" <v-xuwen@.online.microsoft.com> wrote in message
news:Gtf%23XxYmGHA.5184@.TK2MSFTNGXA01.phx.gbl...
> Hi Ben,
> None of the SQL Server 2005 client tools have any dependency on
> ntwdblib.dll and it is no longer shipped with SQL Server 2005.
> Ntwdblib.dll is the DLL for the old DB-Library API. DB-Library is
> deprecated with SQL Server 2005; SQL Server 2005 no longer includes the
> DB-Library dll, and anyone wanting to run a DB-Library application against
> SQL Server 2005 needs to get the dll from a previous version of SQL
> Server.
> From the SQL Server 2005 Books Online:
> http://msdn2.microsoft.com/en-us/library/ms143729(en-US,SQL.90).aspx
> 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 think you have to copy the ntwdblib.dll from another computer which
> contains and register it manually.
>
> Best regards,
> Vincent Xu
> Microsoft Online Partner Support
> ========================================
==============
> Get Secure! - www.microsoft.com/security
> ========================================
==============
> When responding to posts, please "Reply to Group" via your newsreader so
> that others
> may learn and benefit from this issue.
> ========================================
==============
> This posting is provided "AS IS" with no warranties,and confers no rights.
> ========================================
==============
>
> --
> f-bafa-e4b278eb9147&DisplayLang=en
> when
> is
> installed
>