Installing MDAC 2.5 on W2k sp3

I have tried installing MDAC 2.5 on a w2k sp3 machine and it fails with the following error:

Microsoft Data Access components 2.5 is already installed on the version of windows you are running. Setup cannot update the system. For more information .....

BUT, Mdac 2.5 is not installed on the machine and VB applications using it do not work.

Any ideas?

ThankQ1 Any ideas?

A1 Yes.

1 Check your MDAC component status with the compatibility checking tool. See:

http://www.microsoft.com/data/download.htm#CCinfo

http://download.microsoft.com/download/dasdk/CC/2.7/WIN98MeXP/EN-US/cc.exe

2 See MDAC Installation Notes at: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnmdac/html/data_mdacinstall.asp|||Thanks DBA,

This has let me discover that the latest PCs with W2k have sp3 installed by default which includes MDAC 2.6. It is therefore not possible to install MDAC 2.5 - it physically stops you.

It just means I have to change the references to the ADO 2.5 objects to 2.6...|||You are most welcome.

Hopefully 2.6 is otherwise fully compatible with your applications. Newer (and sometimes corrupt or third party) dll issues are not an uncommon source of spurious "already installed" and similar MDAC errors.sql

Installing Delphi 2005 Gives Security Exception..

After installing delphi 2005 I am getting a security exception when trying
to access the reports/report manager/web service of Reporting Services.
I think it is Borland related - the stack trace shows borland in there
now...How do I fix?
======================================================== Description: The application attempted to perform an operation not allowed
by the security policy. To grant this application the required permission
please contact your system administrator or change the application's trust
level in the configuration file.
Exception Details: System.Security.SecurityException: Request for the
permission of type System.Security.Permissions.EnvironmentPermission,
mscorlib, Version=1.0.5000.0, Culture=neutral,
PublicKeyToken=b77a5c561934e089 failed.
Source Error:
An unhandled exception was generated during the execution of the
current web request. Information regarding the origin and location of the
exception can be identified using the exception stack trace below.
Stack Trace:
[SecurityException: Request for the permission of type
System.Security.Permissions.EnvironmentPermission, mscorlib,
Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089
failed.]
System.Security.CodeAccessSecurityEngine.CheckHelper(PermissionSet
grantedSet, PermissionSet deniedSet, CodeAccessPermission demand,
PermissionToken permToken) +675
System.Security.CodeAccessSecurityEngine.Check(PermissionToken permToken,
CodeAccessPermission demand, StackCrawlMark& stackMark, Int32 checkFrames,
Int32 unrestrictedOverride) +0
System.Security.CodeAccessSecurityEngine.Check(CodeAccessPermission cap,
StackCrawlMark& stackMark) +88
System.Security.CodeAccessPermission.Demand() +62
System.Environment.GetEnvironmentVariable(String variable) +53
Borland.DbkAsp.DbkConnModule.getInstallRoot() +27
Borland.DbkAsp.DbkConnModule.OnBeginRequest(Object sender, EventArgs e)
+191
System.Web.SyncEventExecutionStep.System.Web.HttpApplication+IExecutionStep.Execute()
+60
System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean&
completedSynchronously) +87Hi Wayne,
Thanks for your posting!
It seems that the security module internal reports the error message, I
will make research to see whether others meet this issue before. You are
encouraged to see whether Borland guys have solutions to this issue.
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---
Get Secure! - http://www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!|||Search for 'Security Exception - Article ID : 887787'.
I uninstalled Delphi 2005 and the problem went away immediately.....
I look forward to your solution. (I imagine I just have to give rights to
some borland assembly or something for Rptsvs..)
"Michael Cheng [MSFT]" <v-mingqc@.online.microsoft.com> wrote in message
news:JFbg9w11EHA.1512@.cpmsftngxa10.phx.gbl...
> Hi Wayne,
> Thanks for your posting!
> It seems that the security module internal reports the error message, I
> will make research to see whether others meet this issue before. You are
> encouraged to see whether Borland guys have solutions to this issue.
>
> Sincerely yours,
> Michael Cheng
> Online Partner Support Specialist
> Partner Support Group
> Microsoft Global Technical Support Center
> ---
> Get Secure! - http://www.microsoft.com/security
> This posting is provided "as is" with no warranties and confers no rights.
> Please reply to newsgroups only, many thanks!
>|||Hi Wayne,
Unfortunately, I found the only workaround available now is uninstall
Delphi 2005.
Thank you for your patience and corporation. If you have any questions or
concerns, don't hesitate to let me know. We are always here to be of
assistance!
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---
Get Secure! - http://www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!|||Michael,
Exactly what did you find. What are we 'working around'? The problem
is what exactly? Isn't this an assembly rights issue, like when you install
that URL monitor DLL (security fix) from microsoft (forgot its name). You
would get these same sort of errors, until you put some magic entries into a
config file...
"Michael Cheng [MSFT]" <v-mingqc@.online.microsoft.com> wrote in message
news:g$%23vysC2EHA.3152@.cpmsftngxa10.phx.gbl...
> Hi Wayne,
> Unfortunately, I found the only workaround available now is uninstall
> Delphi 2005.
> Thank you for your patience and corporation. If you have any questions or
> concerns, don't hesitate to let me know. We are always here to be of
> assistance!
>
> Sincerely yours,
> Michael Cheng
> Online Partner Support Specialist
> Partner Support Group
> Microsoft Global Technical Support Center
> ---
> Get Secure! - http://www.microsoft.com/security
> This posting is provided "as is" with no warranties and confers no rights.
> Please reply to newsgroups only, many thanks!
>|||Hi Wayne,
Yes, you probably have to change the policy files to include some CAS (Code
Access Security) permissions for the Borland assemblies. See the following
information for more detailed information about how to set the Code Access
Security correctly
Code Access Security
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/htm
l/cpconCodeAccessSecurity.asp
Code Access Security in SQL Server 2000 Reporting Services
http://msdn.microsoft.com/data/default.aspx?pull=/library/en-us/dnsql2k/html
/dngrfCodeAccessSecurityInSQLServer2000ReportingServices.asp
Hope this helps and if you have any questions or concerns, don't hesitate
to let me know. We are always here to be of assistance!
Sincerely yours,
Michael Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---
Get Secure! - http://www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!|||Reinstall Delphi 2005 and press "No" when asked:
An entry needs to be added to the machine.config file to enable ASP
debugging for Delphi.
Would you like setup to add this entry for you now?
"Wayne Brantley" wrote:
> Michael,
> Exactly what did you find. What are we 'working around'? The problem
> is what exactly? Isn't this an assembly rights issue, like when you install
> that URL monitor DLL (security fix) from microsoft (forgot its name). You
> would get these same sort of errors, until you put some magic entries into a
> config file...
>
> "Michael Cheng [MSFT]" <v-mingqc@.online.microsoft.com> wrote in message
> news:g$%23vysC2EHA.3152@.cpmsftngxa10.phx.gbl...
> > Hi Wayne,
> >
> > Unfortunately, I found the only workaround available now is uninstall
> > Delphi 2005.
> >
> > Thank you for your patience and corporation. If you have any questions or
> > concerns, don't hesitate to let me know. We are always here to be of
> > assistance!
> >
> >
> > Sincerely yours,
> >
> > Michael Cheng
> >
> > Online Partner Support Specialist
> > Partner Support Group
> > Microsoft Global Technical Support Center
> > ---
> > Get Secure! - http://www.microsoft.com/security
> >
> > This posting is provided "as is" with no warranties and confers no rights.
> > Please reply to newsgroups only, many thanks!
> >
>
>

Installing a SQL Server database on a Web Host

I will be installing a SQL Server 2000 database on a Web
Server. How do I secure the database so that only my Web
application can access it? I am concerned that someone
could access it over the internet, make a copy of it, or
corrupt it. The ASP.Net web application uses stored
procedures when talking to it.
ThanksHi Joe,
There are several factors to consider when protecting SQL Server. I think
a very good guide to securing SQL Server is found at this URL:
http://msdn.microsoft.com/library/d...-us/dnnetsec/ht
ml/ThreatCounter.asp. This URL references chapter 18 of a document titled
"Improving Web Application Security: Threats And Countermeasures".
This guide covers a lot of ground including account management for users
and services, physical protection of the data files and protection of the
server over the network.
You may want to begin your research with this guide.
Thank you.
Gary Whitley
This posting is provided "AS IS" with no warranties, and confers no rights.

Installed SQL2005: now can't access SQL2000 (Local) in EM

After installing SQL2005 (with a new instance), I couldn't access my previous
(local) server through Enterprise Mnager, although I can access it through
Query Analyser.
I deleted the connection in Enterprise manager and tried to recreate it
(using either windows security or SQL Autentication): get the message 'Client
unable to establish connection. TCP Provider: No connection could be made
because the target machine actively refused it.'
Ashley,
Earlier versions of SQL Server 2005 had a tendancy to trash the SQL Server
2000 tools, perhaps this is your issue. I always put SQL 2005 into a virtual
machine and will keep it there until it RTMs, unless I can install it on a
fresh machine without SQL Server 2000 on.
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
"Ashley Brewerton" wrote:

> After installing SQL2005 (with a new instance), I couldn't access my previous
> (local) server through Enterprise Mnager, although I can access it through
> Query Analyser.
> I deleted the connection in Enterprise manager and tried to recreate it
> (using either windows security or SQL Autentication): get the message 'Client
> unable to establish connection. TCP Provider: No connection could be made
> because the target machine actively refused it.'
|||You should re-register SQLDMO.DLL using:
regsvr32 "C:\Program Files\Microsoft SQL
Server\80\Tools\Binn\sqldmo.dll"
Razvan
|||Thanks Razvan: after restarting the services that worked perfectly.
Ashley
"Razvan Socol" wrote:

> You should re-register SQLDMO.DLL using:
> regsvr32 "C:\Program Files\Microsoft SQL
> Server\80\Tools\Binn\sqldmo.dll"
> Razvan
>

Installed SQL2005: now can't access SQL2000 (Local) in EM

After installing SQL2005 (with a new instance), I couldn't access my previou
s
(local) server through Enterprise Mnager, although I can access it through
Query Analyser.
I deleted the connection in Enterprise manager and tried to recreate it
(using either windows security or SQL Autentication): get the message 'Clien
t
unable to establish connection. TCP Provider: No connection could be made
because the target machine actively refused it.'Ashley,
Earlier versions of SQL Server 2005 had a tendancy to trash the SQL Server
2000 tools, perhaps this is your issue. I always put SQL 2005 into a virtual
machine and will keep it there until it RTMs, unless I can install it on a
fresh machine without SQL Server 2000 on.
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
"Ashley Brewerton" wrote:

> After installing SQL2005 (with a new instance), I couldn't access my previ
ous
> (local) server through Enterprise Mnager, although I can access it through
> Query Analyser.
> I deleted the connection in Enterprise manager and tried to recreate it
> (using either windows security or SQL Autentication): get the message 'Cli
ent
> unable to establish connection. TCP Provider: No connection could be made
> because the target machine actively refused it.'|||You should re-register SQLDMO.DLL using:
regsvr32 "C:\Program Files\Microsoft SQL
Server\80\Tools\Binn\sqldmo.dll"
Razvan|||Thanks Razvan: after restarting the services that worked perfectly.
Ashley
"Razvan Socol" wrote:

> You should re-register SQLDMO.DLL using:
> regsvr32 "C:\Program Files\Microsoft SQL
> Server\80\Tools\Binn\sqldmo.dll"
> Razvan
>sql

Installed SQL2005: now can't access SQL2000 (Local) in EM

After installing SQL2005 (with a new instance), I couldn't access my previous
(local) server through Enterprise Mnager, although I can access it through
Query Analyser.
I deleted the connection in Enterprise manager and tried to recreate it
(using either windows security or SQL Autentication): get the message 'Client
unable to establish connection. TCP Provider: No connection could be made
because the target machine actively refused it.'Ashley,
Earlier versions of SQL Server 2005 had a tendancy to trash the SQL Server
2000 tools, perhaps this is your issue. I always put SQL 2005 into a virtual
machine and will keep it there until it RTMs, unless I can install it on a
fresh machine without SQL Server 2000 on.
--
Mark Allison, SQL Server MVP
http://www.markallison.co.uk
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602m.html
"Ashley Brewerton" wrote:
> After installing SQL2005 (with a new instance), I couldn't access my previous
> (local) server through Enterprise Mnager, although I can access it through
> Query Analyser.
> I deleted the connection in Enterprise manager and tried to recreate it
> (using either windows security or SQL Autentication): get the message 'Client
> unable to establish connection. TCP Provider: No connection could be made
> because the target machine actively refused it.'|||You should re-register SQLDMO.DLL using:
regsvr32 "C:\Program Files\Microsoft SQL
Server\80\Tools\Binn\sqldmo.dll"
Razvan|||Thanks Razvan: after restarting the services that worked perfectly.
Ashley
"Razvan Socol" wrote:
> You should re-register SQLDMO.DLL using:
> regsvr32 "C:\Program Files\Microsoft SQL
> Server\80\Tools\Binn\sqldmo.dll"
> Razvan
>

Installation in Server

Hi,
I have reports which need public access.
I have a web application in 1 server which has public access.Database in 1 Server and the Reporting Services in another server(Database and Reporting Services are behind the firewall).I have links in my webapplication which will create pdf's and excels using reporting services.
Right now inside the network everything works perfectly fine.I access the databse and Reports using IP address(internal) of the servers.
When I try to access the application through the internet I cannot open the reports bcoz the IP addresses provided are internal ones and cannot be used outside firewall.I don't want to open up my database and Reporting services server to the public.
How can I go about it?
Pls help.You have to use Forms Authentication for Reporting Services to able to do
that..
Check this page
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql2k/html/ufairs.asp
"Sudha" <Sudha@.discussions.microsoft.com> wrote in message
news:BA8A7E9C-33F6-4FE7-B12B-6C4E93BE5E28@.microsoft.com...
> Hi,
> I have reports which need public access.
> I have a web application in 1 server which has public access.Database in 1
Server and the Reporting Services in another server(Database and Reporting
Services are behind the firewall).I have links in my webapplication which
will create pdf's and excels using reporting services.
> Right now inside the network everything works perfectly fine.I access the
databse and Reports using IP address(internal) of the servers.
> When I try to access the application through the internet I cannot open
the reports bcoz the IP addresses provided are internal ones and cannot be
used outside firewall.I don't want to open up my database and Reporting
services server to the public.
> How can I go about it?
> Pls help.

Installation fails for SQL Server 2000

I have attempted to install SQL Server 2000 as the default
instance. Maybe, it is because I attempt to install via
Remote Access.
In this way, I terminate the task. However, I am not able
to remove the default instance (That is terminated before)
AND when I attempt to install again, it asks me to create
a new instance.
Would it be possible for me to remove the corrupted
default instance and install it again ?
Thanks
Peter
In Add/Remove programs (Control Panel) you can uninstall SQL Server , can't
you?
"Peter" <anonymous@.discussions.microsoft.com> wrote in message
news:072701c5b1da$cf5d43f0$a601280a@.phx.gbl...
>I have attempted to install SQL Server 2000 as the default
> instance. Maybe, it is because I attempt to install via
> Remote Access.
> In this way, I terminate the task. However, I am not able
> to remove the default instance (That is terminated before)
> AND when I attempt to install again, it asks me to create
> a new instance.
> Would it be possible for me to remove the corrupted
> default instance and install it again ?
> Thanks
|||Hi,
Restart ur machine and try to unstall sql server.
else u can go to control panal remove /add programes and remove sql
server.
or u can over write a new installation on ur previous installation
hope this helps u
from
doller
|||I am not able to uninstall SQL Server via Remove / Add programmes.
I have attempted to run setup.exe and try the uninstall option but it still
doesn't work.
Thanks
"doller" <sufianarif@.gmail.com> wrote in message
news:1125901237.773629.261220@.g47g2000cwa.googlegr oups.com...
> Hi,
> Restart ur machine and try to unstall sql server.
> else u can go to control panal remove /add programes and remove sql
> server.
> or u can over write a new installation on ur previous installation
> hope this helps u
> from
> doller
>

Installation fails for SQL Server 2000

I have attempted to install SQL Server 2000 as the default
instance. Maybe, it is because I attempt to install via
Remote Access.
In this way, I terminate the task. However, I am not able
to remove the default instance (That is terminated before)
AND when I attempt to install again, it asks me to create
a new instance.
Would it be possible for me to remove the corrupted
default instance and install it again ?
ThanksPeter
In Add/Remove programs (Control Panel) you can uninstall SQL Server , can't
you?
"Peter" <anonymous@.discussions.microsoft.com> wrote in message
news:072701c5b1da$cf5d43f0$a601280a@.phx.gbl...
>I have attempted to install SQL Server 2000 as the default
> instance. Maybe, it is because I attempt to install via
> Remote Access.
> In this way, I terminate the task. However, I am not able
> to remove the default instance (That is terminated before)
> AND when I attempt to install again, it asks me to create
> a new instance.
> Would it be possible for me to remove the corrupted
> default instance and install it again ?
> Thanks|||Hi,
Restart ur machine and try to unstall sql server.
else u can go to control panal remove /add programes and remove sql
server.
or u can over write a new installation on ur previous installation
hope this helps u
from
doller|||I am not able to uninstall SQL Server via Remove / Add programmes.
I have attempted to run setup.exe and try the uninstall option but it still
doesn't work.
Thanks
"doller" <sufianarif@.gmail.com> wrote in message
news:1125901237.773629.261220@.g47g2000cwa.googlegroups.com...
> Hi,
> Restart ur machine and try to unstall sql server.
> else u can go to control panal remove /add programes and remove sql
> server.
> or u can over write a new installation on ur previous installation
> hope this helps u
> from
> doller
>

Installation fails for SQL Server 2000

I have attempted to install SQL Server 2000 as the default
instance. Maybe, it is because I attempt to install via
Remote Access.
In this way, I terminate the task. However, I am not able
to remove the default instance (That is terminated before)
AND when I attempt to install again, it asks me to create
a new instance.
Would it be possible for me to remove the corrupted
default instance and install it again ?
ThanksPeter
In Add/Remove programs (Control Panel) you can uninstall SQL Server , can't
you?
"Peter" <anonymous@.discussions.microsoft.com> wrote in message
news:072701c5b1da$cf5d43f0$a601280a@.phx.gbl...
>I have attempted to install SQL Server 2000 as the default
> instance. Maybe, it is because I attempt to install via
> Remote Access.
> In this way, I terminate the task. However, I am not able
> to remove the default instance (That is terminated before)
> AND when I attempt to install again, it asks me to create
> a new instance.
> Would it be possible for me to remove the corrupted
> default instance and install it again ?
> Thanks|||Hi,
Restart ur machine and try to unstall sql server.
else u can go to control panal remove /add programes and remove sql
server.
or u can over write a new installation on ur previous installation
hope this helps u
from
doller|||I am not able to uninstall SQL Server via Remove / Add programmes.
I have attempted to run setup.exe and try the uninstall option but it still
doesn't work.
Thanks
"doller" <sufianarif@.gmail.com> wrote in message
news:1125901237.773629.261220@.g47g2000cwa.googlegroups.com...
> Hi,
> Restart ur machine and try to unstall sql server.
> else u can go to control panal remove /add programes and remove sql
> server.
> or u can over write a new installation on ur previous installation
> hope this helps u
> from
> doller
>