|Originally posted by Mike Spragg|
On thing that caught me this week. If you do move to 2008 (and there is no reason not to) then you should use the new native client (v10). However, if you do this - you will find that the following occurs when you attempt to create remote user databases:
"Provider cannot be found. It may not be properly installed"
To fix this, you must install the SQL2005 Native Client on the pc/server running admin (where you are generating the remote dbs) - as it will use the SQL2005 Native Client to gen the dbs and not the SQL2008 native client.
Both Native Clients can co-exist without an issue. But, both are required on the server (but not the local PC/LAN clients - this should just be the SQL2008 NC).