"Error creating MDAC instance" performing Bulk Insert

I get this error when trying to perform a bulk insert. This started
happening after the latest security fixes were loaded on the server.
Anyone know what this error means?
I was able to correct this by installing the latest sp of MDAC and SP3 of
SQLXML.
"DavidSp8" wrote:

> I get this error when trying to perform a bulk insert. This started
> happening after the latest security fixes were loaded on the server.
> Anyone know what this error means?

"Error creating MDAC instance" performing Bulk Insert

I get this error when trying to perform a bulk insert. This started
happening after the latest security fixes were loaded on the server.
Anyone know what this error means?I was able to correct this by installing the latest sp of MDAC and SP3 of
SQLXML.
"DavidSp8" wrote:

> I get this error when trying to perform a bulk insert. This started
> happening after the latest security fixes were loaded on the server.
> Anyone know what this error means?

"Custom Reports..." grayed out, SP2 (latest) installed

What am I missing, here? The "Custom Reports..." context menu appears, but
is grayed out, and no "Standard Reports" context menu item is there. I've
found no reference to additional steps to get these reports enabled/visible.
Help?
thanks,Where exactly you see all these things ?
Amarnath
"Stan Spotts [Computer Aid, Inc]" wrote:
> What am I missing, here? The "Custom Reports..." context menu appears, but
> is grayed out, and no "Standard Reports" context menu item is there. I've
> found no reference to additional steps to get these reports enabled/visible.
> Help?
> thanks,|||In SQL Server Management Studio.
"Amarnath" wrote:
> Where exactly you see all these things ?
> Amarnath
> "Stan Spotts [Computer Aid, Inc]" wrote:
> > What am I missing, here? The "Custom Reports..." context menu appears, but
> > is grayed out, and no "Standard Reports" context menu item is there. I've
> > found no reference to additional steps to get these reports enabled/visible.
> >
> > Help?
> >
> > thanks,

"confirm password" prompt after importing database

I'm running SQL Server 2000 on a Windows 2003 Server with the latest
SQL SP and hotfixes applied.
Today, I made a mistake while importing a new database into my SQL
Server. When choosing my options in the DTS wizard, I forgot to uncheck
the "Copy database users and database roles" and "copy object level
permissions" boxes under the Security options.
After running the import, whenever I try to edit any SQL user from a
remote client running Enterprise Manager, I am always prompted to
"confirm password." I cannot simply type in the password in that box
though, I have to actually type the password into the main user
properties window, then type it again to confirm the password. After
doing both, the changes are saved.
This ONLY happens from a remote Enterprise Manager client though. If I
use EM on the local server, I'm not prompted to confirm the password
when I edit users.
Can anyone provide some guidance on how I can fix this?
Thanks!
JasonThis can occur after appying MS03-031: Cumulative Security Patch for SQL
Server to the client running EM
FIX: You are prompted for password confirmation after you change a standard
SQL Server login
http://support.microsoft.com/?kbid=826161
--
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Jason S." <jasolution@.yahoo.com> wrote in message
news:1109789594.428951.221670@.g14g2000cwa.googlegroups.com...
> I'm running SQL Server 2000 on a Windows 2003 Server with the latest
> SQL SP and hotfixes applied.
> Today, I made a mistake while importing a new database into my SQL
> Server. When choosing my options in the DTS wizard, I forgot to uncheck
> the "Copy database users and database roles" and "copy object level
> permissions" boxes under the Security options.
> After running the import, whenever I try to edit any SQL user from a
> remote client running Enterprise Manager, I am always prompted to
> "confirm password." I cannot simply type in the password in that box
> though, I have to actually type the password into the main user
> properties window, then type it again to confirm the password. After
> doing both, the changes are saved.
> This ONLY happens from a remote Enterprise Manager client though. If I
> use EM on the local server, I'm not prompted to confirm the password
> when I edit users.
> Can anyone provide some guidance on how I can fix this?
> Thanks!
> Jason
>|||Jasper,
Thank you for taking time to respond.
I had found that posting, but I'd already patched the server with that
hotfix quite awhile ago, and the symptoms are not quite the same here.
With my issue, I am able to save the changes I made to the user, but it
just requires me to enter the password and confirm it every time I make
any change to a user. Also, this issue only occurs when I using
Enterprise Manager from a remote machine, but if I edit the users using
EM on the local machine, I do not get prompted to confirm the password.
Any other thoughts?
Thanks,
Jason|||The hotfix is for the client as well as the server (like you say it's
confined to the client and doesn't occur on the server). You need to run the
hotfix from the KB on the client.
--
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Jason S." <jasolution@.yahoo.com> wrote in message
news:1109790531.728123.199310@.f14g2000cwb.googlegroups.com...
> Jasper,
> Thank you for taking time to respond.
> I had found that posting, but I'd already patched the server with that
> hotfix quite awhile ago, and the symptoms are not quite the same here.
> With my issue, I am able to save the changes I made to the user, but it
> just requires me to enter the password and confirm it every time I make
> any change to a user. Also, this issue only occurs when I using
> Enterprise Manager from a remote machine, but if I edit the users using
> EM on the local machine, I do not get prompted to confirm the password.
> Any other thoughts?
> Thanks,
> Jason
>|||Jasper,
Thanks, that was it. I didn't realize that it was a patch for client EM
also.
Thanks again!
Jason