|
Posted by pb648174 on 10/02/32 11:50
The SQL 2005 password is case sensitive while 2000 wasn't, so code that
works on SQL 2000 for logging in may not work on 2005.
MVChauhan@googlemail.com wrote:
> 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]
|