Runtime error while installing SQL 2005 Standard Edition

Dear All,
I have an instance of SQL 2000 and while Installing another instance of SQL
Server2005 Standard Edition on Windows 2003 with SP1 on Dell Server, I am
getting error
Microsoft Visual C++ Runtime Library
Runtime Error!
Program: C:\WINDOWS\system32\MsiExec.exe
The application has requested the Runtime to terminate it in an
unusual way.
Please contact the application's support team for more information.
All the hardware and software requirements are already there.
Any suggestions!
TIA
KayHi Kay
A couple of this to check
Make sure that you are up-to-date with windows update. Your hardware drivers
are the latest (especially video!). Also check out the SQL Server
installation log files http://msdn2.microsoft.com/en-us/library/ms143702.aspx
John
"Kay" wrote:
> Dear All,
> I have an instance of SQL 2000 and while Installing another instance of SQL
> Server2005 Standard Edition on Windows 2003 with SP1 on Dell Server, I am
> getting error
> Microsoft Visual C++ Runtime Library
> Runtime Error!
> Program: C:\WINDOWS\system32\MsiExec.exe
> The application has requested the Runtime to terminate it in an
> unusual way.
> Please contact the application's support team for more information.
>
> All the hardware and software requirements are already there.
> Any suggestions!
> TIA
> Kay
>
>

Running SSIS Packages in Management Studio

We are using SQL Server 2005 Standard edition.We have the development studio installed on a developer’s workstation.The SSIS package is accessing network folders using UNC and the tasks in packages are accessing SQL Server with a SQL Server id.

The SSIS package runs fine on the workstation. We deploy the SSIS package as a SSIS store on SQL Server.I receive Error 18456 Severity 14 State 8 error when I run the SSIS package as a SQL Agent job.

When I run the SSIS package from the Integration Services Management Studio, I get The AcquireConnection method call to the connection manager "dboSQLabm" failed with error code 0xC0202009.

I’m sure this is a permission based problem since it runs fine on my workstation.I tried logon onto the SQL Server with my id (I’m an admin to the server).I tried running the agent with my windows id.It looks like I’m getting problem connecting to the SQL Server tables since the logs are properly written to the network drive.

In SQL DTS 2000, all we needed to do was give the SQL agent id permission to the network folder. I tried to search the forums, but none of the solutions seem to work for my situation.

Do you use config files and do not save sensitive? This should take care of this issue.

There are quite a few posts about it in this forum

Philippe

|||The problem I was getting occurred whether I used a config file or not. I had the package set to EncryptSensitiveWithUserKey. I created another thread to get production deployment suggestions. We don't want our DBAs using BIDS to edit SQL connection manager settings when they migrate SSIS packages to production.|||

Then don't let them. Use configurations and the deployment wizard.

-Jamie

Running Sql Server Developer Edition with VS 2005 and ASP.NET

I am having problems installing Sql Server Developer edition (2005) with VS 2005 and getting any ASP.NET projects to work.

It says SQl Server express must be installed.

I would like to use the full developer edition to link to my projects.

Can someone help?

Thanks,

Mike G

In your connection string in web.config in your ASP.Net projects, are you pointing to SQLExpress, or have you configured it to connect to your Dev Edition SQL Server? More details on your configuration and error message would help.|||

I am having the same problem. When I try to add a new sql database to an asp.net web application using the following steps:

1. Right-click the App_Data folder

2. Select "Add New Item"

3. Select Sql Database

4. Change SQL Database name to xxxxxx.mdf

5. Click "Add"

I then get the following message:

"Connections to SQL Server Files (*.mdf) require SQL Server Express 2005 to function properly. Please verify the installation of the component or download from the URl: http:go.microsoft.com/fwlink/?linkID=49251."

I am using VS 2005 Professional and SQL Server 2005 Standard Edition. I want to be able to do this with SSE. In VS2005 I have gone to Tools...Options...Database Tools...Data Connections and changed the SQL Server Instance Name from SQLEXPRESS to MSSQLSERVER. Should I make it the name of my server?

Any help would be greatly appreciated.

John

|||

By using App_Data it appears you're forced into using SQL Express, because you're defining a connection to a physical database file, rather than establishing a connection string to an existing server.

In my web.config file I configure an application variable called ConnectionString containing something like this:

Integrated Security=True;Data Source=MyServer;Initial Catalog=MyDatabase;Application Name=MyApp;

Then I configure a SQL Connection object and set the .ConnectionString property to the application connection string. After that all is well.

|||

So does that mean the App_Data folder is only used with SQL Server Express and not to be used with SQL Server 2005?

John

Running Sql Server Developer Edition with VS 2005 and ASP.NET

I am having problems installing Sql Server Developer edition (2005) with VS 2005 and getting any ASP.NET projects to work.

It says SQl Server express must be installed.

I would like to use the full developer edition to link to my projects.

Can someone help?

Thanks,

Mike G

In your connection string in web.config in your ASP.Net projects, are you pointing to SQLExpress, or have you configured it to connect to your Dev Edition SQL Server? More details on your configuration and error message would help.|||

I am having the same problem. When I try to add a new sql database to an asp.net web application using the following steps:

1. Right-click the App_Data folder

2. Select "Add New Item"

3. Select Sql Database

4. Change SQL Database name to xxxxxx.mdf

5. Click "Add"

I then get the following message:

"Connections to SQL Server Files (*.mdf) require SQL Server Express 2005 to function properly. Please verify the installation of the component or download from the URl: http:go.microsoft.com/fwlink/?linkID=49251."

I am using VS 2005 Professional and SQL Server 2005 Standard Edition. I want to be able to do this with SSE. In VS2005 I have gone to Tools...Options...Database Tools...Data Connections and changed the SQL Server Instance Name from SQLEXPRESS to MSSQLSERVER. Should I make it the name of my server?

Any help would be greatly appreciated.

John

|||

By using App_Data it appears you're forced into using SQL Express, because you're defining a connection to a physical database file, rather than establishing a connection string to an existing server.

In my web.config file I configure an application variable called ConnectionString containing something like this:

Integrated Security=True;Data Source=MyServer;Initial Catalog=MyDatabase;Application Name=MyApp;

Then I configure a SQL Connection object and set the .ConnectionString property to the application connection string. After that all is well.

|||

So does that mean the App_Data folder is only used with SQL Server Express and not to be used with SQL Server 2005?

John

Running SQL Server 2005 EE on Dual-Core CPU

Hello!
We are planning following setup for our production SQL Server:
OS - Windows 2003 Enterprise Edition
SQL Server 2005 Enterprise Edition
16 GB RAM
4 Dual-Core CPUs 64 bit
I was wondering if anybody is running SQL Server 2005 on Dual-Core 64
bit CPUs. Are there any know issues with this? Would it be better to with
Intel or AMD?
Thank you in advance,
IgorHi
We are running SQL Server 2000 on HP 585's, 4 AMD Dual cores. We are very
happy with the performance.
Still awaiting the Intel Dual Core range, so no comparison yet.
Regards--
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"imarchenko" <igormarchenko@.hotmail.com> wrote in message
news:%23v5j5%23R$FHA.3104@.TK2MSFTNGP15.phx.gbl...
> Hello!
> We are planning following setup for our production SQL Server:
> OS - Windows 2003 Enterprise Edition
> SQL Server 2005 Enterprise Edition
> 16 GB RAM
> 4 Dual-Core CPUs 64 bit
> I was wondering if anybody is running SQL Server 2005 on Dual-Core 64
> bit CPUs. Are there any know issues with this? Would it be better to with
> Intel or AMD?
> Thank you in advance,
> Igor
>|||I haven't seen any Intel dual cores yet but I have seen several AMD dual
core servers and they work very well. From what I have heard the Intel
units will be a little faster than the AMD's but I don't know if that is
worth waiting for or not.
--
Andrew J. Kelly SQL MVP
"imarchenko" <igormarchenko@.hotmail.com> wrote in message
news:%23v5j5%23R$FHA.3104@.TK2MSFTNGP15.phx.gbl...
> Hello!
> We are planning following setup for our production SQL Server:
> OS - Windows 2003 Enterprise Edition
> SQL Server 2005 Enterprise Edition
> 16 GB RAM
> 4 Dual-Core CPUs 64 bit
> I was wondering if anybody is running SQL Server 2005 on Dual-Core 64
> bit CPUs. Are there any know issues with this? Would it be better to with
> Intel or AMD?
> Thank you in advance,
> Igor
>|||Mike,
Thanks a lot for your feedback. Since we are planning to run SQL 2005 on
our production env., it is critical for us to know whether SQL 2005/Dual
core CPU is stable enough configuration.
Igor
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:u$js9ES$FHA.3804@.TK2MSFTNGP14.phx.gbl...
> Hi
> We are running SQL Server 2000 on HP 585's, 4 AMD Dual cores. We are very
> happy with the performance.
> Still awaiting the Intel Dual Core range, so no comparison yet.
> Regards--
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "imarchenko" <igormarchenko@.hotmail.com> wrote in message
> news:%23v5j5%23R$FHA.3104@.TK2MSFTNGP15.phx.gbl...
>> Hello!
>> We are planning following setup for our production SQL Server:
>> OS - Windows 2003 Enterprise Edition
>> SQL Server 2005 Enterprise Edition
>> 16 GB RAM
>> 4 Dual-Core CPUs 64 bit
>> I was wondering if anybody is running SQL Server 2005 on Dual-Core 64
>> bit CPUs. Are there any know issues with this? Would it be better to
>> with Intel or AMD?
>> Thank you in advance,
>> Igor
>|||Thanks, Andrew. Would you happen to know if anyone is running SQL 2005/ Dual
core CPU configuration? Is this a stable enough environment?
Igor
"Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
news:%23pR7nOU$FHA.3908@.TK2MSFTNGP10.phx.gbl...
>I haven't seen any Intel dual cores yet but I have seen several AMD dual
>core servers and they work very well. From what I have heard the Intel
>units will be a little faster than the AMD's but I don't know if that is
>worth waiting for or not.
> --
> Andrew J. Kelly SQL MVP
>
> "imarchenko" <igormarchenko@.hotmail.com> wrote in message
> news:%23v5j5%23R$FHA.3104@.TK2MSFTNGP15.phx.gbl...
>> Hello!
>> We are planning following setup for our production SQL Server:
>> OS - Windows 2003 Enterprise Edition
>> SQL Server 2005 Enterprise Edition
>> 16 GB RAM
>> 4 Dual-Core CPUs 64 bit
>> I was wondering if anybody is running SQL Server 2005 on Dual-Core 64
>> bit CPUs. Are there any know issues with this? Would it be better to
>> with Intel or AMD?
>> Thank you in advance,
>> Igor
>|||"imarchenko" <igormarchenko@.hotmail.com> wrote in message
news:ekH$VRb$FHA.328@.TK2MSFTNGP14.phx.gbl...
> Mike,
> Thanks a lot for your feedback. Since we are planning to run SQL 2005
> on our production env., it is critical for us to know whether SQL
> 2005/Dual core CPU is stable enough configuration.
>
IMO Multi-Core x64 with 2 or 4 sockets is the basic hardware platform for
SQL Server 2005.
Talk to Dell or HP. The Dell PowerEdge 6850 and the HP DL580 or DL585 meet
your specs, and either one of them can help put your mind at ease about
running 64-bit Windows and 64-bit SQL Server 2005 in production.
David|||I have seen both with no problems on either that I know of.
--
Andrew J. Kelly SQL MVP
"imarchenko" <igormarchenko@.hotmail.com> wrote in message
news:%23xldESb$FHA.1288@.TK2MSFTNGP09.phx.gbl...
> Thanks, Andrew. Would you happen to know if anyone is running SQL 2005/
> Dual core CPU configuration? Is this a stable enough environment?
>
> Igor
>
> "Andrew J. Kelly" <sqlmvpnooospam@.shadhawk.com> wrote in message
> news:%23pR7nOU$FHA.3908@.TK2MSFTNGP10.phx.gbl...
>>I haven't seen any Intel dual cores yet but I have seen several AMD dual
>>core servers and they work very well. From what I have heard the Intel
>>units will be a little faster than the AMD's but I don't know if that is
>>worth waiting for or not.
>> --
>> Andrew J. Kelly SQL MVP
>>
>> "imarchenko" <igormarchenko@.hotmail.com> wrote in message
>> news:%23v5j5%23R$FHA.3104@.TK2MSFTNGP15.phx.gbl...
>> Hello!
>> We are planning following setup for our production SQL Server:
>> OS - Windows 2003 Enterprise Edition
>> SQL Server 2005 Enterprise Edition
>> 16 GB RAM
>> 4 Dual-Core CPUs 64 bit
>> I was wondering if anybody is running SQL Server 2005 on Dual-Core 64
>> bit CPUs. Are there any know issues with this? Would it be better to
>> with Intel or AMD?
>> Thank you in advance,
>> Igor
>>
>

Running SQL Server 2005 Dev Ed. and Express Ed. side by side.

Hi all,

Is it possible to run SQL Server 2005 Dev Ed. and the Express edition side by side on my development platform?

Thanks,

Andy

Yep works just fine, I do this on several machines|||

Have you been able to apply SP1 to SQL Svr 2005 Dev Ed. & SQl Svr Express Ed.? I have both installed in my development environment, its been working just fine so far. But, when I try to run SP1 for either Ed. the install fails.

Any ideas?

Sunni

|||

Be aware that the SP1 patch for Dev edition and the SP1 upgrade for Express Edition are two different things. There is not single download that will update both those editions.

You can download the Express Update from the Express download page. The patch for all non-Express Edtions, including Dev, can be found here.

The Express SP1 upgrade can both patch and install new instances, so be sure you're selecting your currently installed Instance Name when applying it to upgrade the existing instances.

I've not heard of specific issue for either of the SP1 updates, could you provide more information about the specific problems you're having? Any error messages? What does the log say?

Regards,

Mike Wachal
SQL Express team

-
Check out my tips for getting your answer faster and how to ask a good question: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=307712&SiteID=1

Running SQL Mail in developers edition

We have SQL Mail running on our servers, but Im often offline during
development (although my machine is on the internet). Can SQL Mail be
configured to run locally in SQL Server 200 Developers Edition? The
configuration docs for pop accounts are confusing in that regard (at least to
me), and I was hoping for some advice - if this is even possible.
Thanks, Mark
Hi
If you setup SQL Server to run under a domain account and use Outlook 2000
you should be ok see http://support.microsoft.com/kb/263556/. You should be
able to log out (but not shutdown!) and emails will still be processed.
John
"MarkAurit" wrote:

> We have SQL Mail running on our servers, but Im often offline during
> development (although my machine is on the internet). Can SQL Mail be
> configured to run locally in SQL Server 200 Developers Edition? The
> configuration docs for pop accounts are confusing in that regard (at least to
> me), and I was hoping for some advice - if this is even possible.
> Thanks, Mark

Running SQL Mail in developers edition

We have SQL Mail running on our servers, but Im often offline during
development (although my machine is on the internet). Can SQL Mail be
configured to run locally in SQL Server 200 Developers Edition? The
configuration docs for pop accounts are confusing in that regard (at least to
me), and I was hoping for some advice - if this is even possible.
Thanks, MarkHi
If you setup SQL Server to run under a domain account and use Outlook 2000
you should be ok see http://support.microsoft.com/kb/263556/. You should be
able to log out (but not shutdown!) and emails will still be processed.
John
"MarkAurit" wrote:
> We have SQL Mail running on our servers, but Im often offline during
> development (although my machine is on the internet). Can SQL Mail be
> configured to run locally in SQL Server 200 Developers Edition? The
> configuration docs for pop accounts are confusing in that regard (at least to
> me), and I was hoping for some advice - if this is even possible.
> Thanks, Mark

Running SQL Mail in developers edition

We have SQL Mail running on our servers, but Im often offline during
development (although my machine is on the internet). Can SQL Mail be
configured to run locally in SQL Server 200 Developers Edition? The
configuration docs for pop accounts are confusing in that regard (at least t
o
me), and I was hoping for some advice - if this is even possible.
Thanks, MarkHi
If you setup SQL Server to run under a domain account and use Outlook 2000
you should be ok see http://support.microsoft.com/kb/263556/. You should be
able to log out (but not shutdown!) and emails will still be processed.
John
"MarkAurit" wrote:

> We have SQL Mail running on our servers, but Im often offline during
> development (although my machine is on the internet). Can SQL Mail be
> configured to run locally in SQL Server 200 Developers Edition? The
> configuration docs for pop accounts are confusing in that regard (at least
to
> me), and I was hoping for some advice - if this is even possible.
> Thanks, Mark

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
>> >>
>> >>
>> >>
>> >
>>
>>