|
Posted by MVChauhan@googlemail.com on 10/02/29 11:50
Hi Erland
Thanks for your reply.
I still cant conntect to SQL Server.
I downloaded SQL Native Client and installed on the web server.
I looked in SAC Tool and "Local and Remote Connection" and "Using Both
TCP/IP and Named Pipes" options are selected. I have checked SQL
Browser service is running.
Now when i use this string
"Provider=SQLNCLI;Server=127.0.0.1;Database=DBName;UID=UserName;PWD=UserPassword;"
i get
Microsoft SQL Native Client error '80040e4d'
Login failed for user 'UserName'.
I have created this user and this user has proper permission to access
the database i need.
Is there any special permissions that need? This is driving me crazy.
Mits
You may also have to encure that the SQL Browser service is running.
Erland Sommarskog wrote:
> (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]
|