|
|
Posted by MVChauhan@googlemail.com on 10/02/64 11:50
I know there is no issue with Password.
I just realised one thing i dont know if it matters..
Between our webserver there is a firewall, do we need to punch a hole
that will allow communication between our webserver and DB Server.
Mits
pb648174 wrote:
> 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]
|