Friday, March 30, 2012
runtime error (-2147467259)(80004005)
Microsoft [ODBC SQL Driver][Named Pipes]Specified SQL Server not Found
This is the error i get when i install a VB Application to a client where i havent installed "SQL Client Network Utility" Please help me i cant give all users this Utility i need to connect to connect to SQL Server too ...
Please find me a way to connect to SQL through Network without the need to install "SQL Client Network Utility"
Very URGENTIt is possible that you need to set up a DSN on each client machine. The SQL Client Network Utility probably does this in some wizardy way. Check out the 'Data Sources (ODBC)' control in the control panel.
Wednesday, March 28, 2012
Running/Starting MSDE Server as Power User automatically
start (with the little icon in system tray showing the white circle
with a green play graphic).
I am able to use the server perfectly fine as a user under the
Administration group.
However, when I created a local account under POWER USER group, the
server does not start or connect to any servers.
I have to manually type in my computer's name at which point it will
start.
I have also had trouble installing the server and having it
successfully run under a POWER USER group.
Anyone have any soultions?
Gautam Lad
hi,
"Gautam Lad" <gautam@.hbfenn.com> ha scritto nel messaggio
news:3a492d07.0501031241.1e0cf675@.posting.google.c om
> I am able to install MSDE as an Administrator. The server will also
> start (with the little icon in system tray showing the white circle
> with a green play graphic).
> I am able to use the server perfectly fine as a user under the
> Administration group.
> However, when I created a local account under POWER USER group, the
> server does not start or connect to any servers.
> I have to manually type in my computer's name at which point it will
> start.
> I have also had trouble installing the server and having it
> successfully run under a POWER USER group.
> Anyone have any soultions?
as SQL Server requires a lot of admin privileges at startup, in order to
register services, install MDAC (if needed) and loo of COM server, the best
way to go is installing it as mmber of admins WinNT role...
as regard running SQL Server, it's services (MSSQLSERVER and SQLSERVERAGENT
for a default instance) usually run under LocalSystem WinNT special account,
but you can run them under any admin member WinNT account, as special
privileges for file system and registry access...
in usual solutions, MSDE is installed from admins and run under their
account (LocalSystem and/or standard WinNT local admin accounts), but WinNT
logged users are (as best practice) traditional non admin users, that's to
say power users or limited users, and you should not see problems this
way... you have to check the account the services are running under...
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtmhttp://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
-- remove DMO to reply
sql
Tuesday, March 20, 2012
running sql xml versions next to each other?
i have installed sql 2005 on my test machine, and it installed sql xml 4.0.
Now i wanted to try running BizTalk 2004 on it, but the install complains i
have to have sql xml 3.0 sp2 or higher...
So the question is, can i install sql xml 3.0sp3 on the machine, without
breaking the 4.0 or the sql 2005 install altogether?
thnx,
J.
Hello,
You should be able to use sqlxml 3.0 and sqlxml 4.0 side by side without
any problem.
Thanks,
Monica Frintu
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
running sql xml versions next to each other?
i have installed sql 2005 on my test machine, and it installed sql xml 4.0.
Now i wanted to try running BizTalk 2004 on it, but the install complains i
have to have sql xml 3.0 sp2 or higher...
So the question is, can i install sql xml 3.0sp3 on the machine, without
breaking the 4.0 or the sql 2005 install altogether?
thnx,
J.Hello,
You should be able to use sqlxml 3.0 and sqlxml 4.0 side by side without
any problem.
Thanks,
Monica Frintu
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
Running SQL Server on a Desktop Machine
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.
Running SQL Server at Home
I'm trying to run a copy of Enterprise Manager at home. I have a small wireless network and would like to install it on either one machine (stand-alone) or run it on my network.
The machine it is installed on is running Windows 2000 and the remote machine is running Windows XP Home <<< not sure if SQL Server will run on this.
I tried installing it previously as stand-alone on the Win2K machine, but kept getting a "Server not found or access denied" message whenever I tried to register or connect.
Any ideas on how best to set it up at home would be greatly appreciated.
Thanks,
TimCreate an entry for your sqlserver in hosts (or lmhosts) file. This should help with name/ip resolution. Also, it might be better to setup sqlserver in mixed mode (i.e. allow sql authentication).|||I hope you installed the SQL Server and not the client components alone. Probably, you accepted default values. When you register you can use one of the following: a dot (.), or (local) - including parenthesis - or your workstation computer name. All these are valid in a standalone computer.
Please check your registry under HKEY_LOCAL_MACHINE\Microsoft\MSSQLSERVER\SUPERSOCK ETNETLIB\NP and if the value is like \\.\pipe\sql\query then probably you accepted default value for Named Pipe as well as the instance. If you have decided to install this as an instance then you may see like \\.\pipe\<instance_name>\sql\query then probably you installed as a server.
Also under HKEY_LOCAL_MACHINE\Microsoft\MSSQLSERVER\SUPERSOCK ETNETLIB\TCP, you can determine the port number. If it is 1433 then you used default port.
Please make sure that MSSQLServer Service is running. You can check this through the Services.msc. If you do not see MSSQLServer Service then you have installed the client components only and install the server components. Start SQL Query Analyzer and enter any of the following:
Assumption: Your computer name is PRECAMBRIAN
1) .
2) (local)
3) PRECAMBRIAN
4) PRECAMBRIAN,1433 (or whatever port number is)
5) PRECAMBRIAN\InstanceName
Enter your SA account's password and you should be able to connect.
Running SQL server 2000 & 2005 side by side
Hai
My system is already installed with SQL server 2000 . Is it possible for me to install SQL server 2005 BETA CTP in the same machine and run both side by side.
Regards
I am not sure which CTP you have, since we have RTMed SQL 2005, it would be better if you want to evalute SQL Server to install the full SQL Server 2005 Eval version. Depening on which Beta you have, side-by-side installations may or may not work for you.
|||
hai bob
Thanks for your reply.
How can i check my version supports side by side execution.
Tuesday, February 21, 2012
Running Snort with MSDE/Server Express 2005
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
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
>