|
Posted by Erland Sommarskog on 10/02/77 11:50
(MVChauhan@googlemail.com) writes:
> We are planning to move over to SQL Server 2005 in near future.
>
> At the moment Website is on a seperate server then the Database.
> OS for both the server is Window 2003 and currently our data is on SQL
> Server 2000(on which everything works fine).
>
>
> Part of the testing process we tried to connect our website on SQL 2005
> and it does not work at all.
>
> I get this
>
> ----------------------------------------------------------------
> ADODB.Connection error '800a0e7a'
> Provider cannot be found. It may not be properly installed.
>
> When i use following connection string
> "Provider=SQLNCLI;Server=127.0.0.1;
Did you install SQL Native Client on the web server? SQL Native Client
is a DLL that contains versions of both the ODBC SQL Server Driver
and the SQL Server OLE DB Provider that has been enhanced with support
for SQL 2005.
SQL Native Client is freely distributable.
> This is the message i get for all the following connectiong string
>
> Microsoft OLE DB Provider for SQL Server error '80004005'
>
> [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or
> access denied.
Note that by default some editions of SQL 2005 by default only permits
local connections. You can modify this in the Surface Area Configuration
Tool.
You may also have to encure that the SQL Browser service is running.
--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
Navigation:
[Reply to this message]
|