Import access 2007 table get error: DB_SEC_E_AUTH_FAILED(0x80040E4D)

[smsmail]

Hi

I am trying to import an access table to sql server 2008 express database using the import wizard. I am getting the error: DB_SEC_E_AUTH_FAILED(0x80040E4D).

Any suggestions on where to look first. I suspect it is a permissions issue.

Thanks for you guidance in advance.

 

[SQLBill]

I don't know if this will help, but...

http://weblogs.asp.net/rosherove/ar...th-failed-exception-on-connection-string.aspx

-SQLBill

The following is part of my signature block and is only intended to be informational.
Posting advice: FAQ481-4875