DNS CName and SQL 2005 Bulk Insert

[Guest dphelps]

I asked this question in the SQL forum and haven't received a reply so I

thought I'd ask you folks (your probably smarter). Does anyone know why a

SQL 2005 Bulk Insert can't read a file (Access Denied) that contains a CName

in the UNC but can read the same file when the UNC contains the server's

NetBOIS name? If you do, do you know a way around the CName issue? Could it

have something to do with the LoopbackCheck in SP1?

 

BTW, other than this SQL issue, the UNC works just fine with the CName. I

followed these two knowledge base articles to orginally get the CName to

work: http://support.microsoft.com/kb/926642 (I used Method 2) &

http://support.microsoft.com/?id=281308.

 

Thanks