Re: CONNECTION PROBLEM USING VB6 TO SQL SEVER 2000 PERSONAL EDITON

"Paul Clement" <UseAdddressAtEndofMessage@xxxxxxxxxxxxxx> wrote in message
news:5t5092hr66b9b3brn8eq3igic2t3qruphn@xxxxxxxxxx
On Wed, 14 Jun 2006 15:40:16 +0500, "Abdul Hameed"
<ahameed@xxxxxxxxxxxxxxxx> wrote:

¤ I am having a problem in my vb6 application when I try to connect to sql
¤ server 2000 personal editon with the following connection string.( I am
¤ using windows XP professional service pack 2. and VB6 and installed sql
¤ server on the same system)
¤
¤ db.Open "Provider=sqloledb;Data Source=HAMEED;Initial Catalog=NTL;User
¤ Id=sa;Password=;"
¤
¤
¤ the error message is :
¤
¤ "Run time error '-2147467259 (80004005)');
¤ login failed for user 'sa' . Reason: Not associated with a trusted SQL
¤ server connection.
¤
¤
¤ When I check with the server the server is running fine and I can open
every
¤ table of the database NTL.using SQL server enterprise manager.
¤
¤ can anybody help me in this regard.
¤

Is your SQL Server configured for both SQL Server and Windows
authentication? Based upon the error
message it would appear that it is configured for Windows authentication
only.


Paul
~~~~
Microsoft MVP (Visual Basic)

Thanks a lot Paul for your valuable suggestions. I have changed the
configuration of SQL server for both window and sql server and its running
fine.

Once again thank u very much.

A.Hameed


.

Relevant Pages

  • Re: Sql Server 2005 Dev. Ed. on Windows Server 2003
    ... Check out this KB which is about transferring Logins: http://support.microsoft.com/kb/246133 ... Also, since this is running on a newly installed Windows Server 2003, is ... them from your older SQL Server instance to the newer one. ...
    (microsoft.public.sqlserver.setup)
  • Re: New Windows Infrastructure
    ... vendor's application runs on windows with an SQL database and I will also need a web server for a separate module which will allow our customers to access account data online. ... I would think that if the app runs on windows, I do not need the citrix server. ... It makes sense to have separate DCs though, because let's say you want to upgrade your Active Directory in two weeks time, with separate DCs it's easy, but if you've got a bunch of apps installed it could be a nightmare. ...
    (microsoft.public.win2000.setup_deployment)
  • How can I avoid using SQL Authentication with the Office Web Parts?
    ... We have a machine running Windows 2003 Server, IIS 6, and Windows SharePoint ... We are using Office Web Parts on several Web ... Part pages to display data retrieved from a SQL Server (SQL 2000 SP3 running ...
    (microsoft.public.sharepoint.portalserver.development)
  • How can I avoid using SQL Authentication with the Office Web Parts?
    ... We have a machine running Windows 2003 Server, IIS 6, and Windows SharePoint ... We are using Office Web Parts on several Web ... Part pages to display data retrieved from a SQL Server (SQL 2000 SP3 running ...
    (microsoft.public.office.developer.web.components)
  • How can I avoid using SQL Authentication with the Office Web Parts?
    ... We have a machine running Windows 2003 Server, IIS 6, and Windows SharePoint ... We are using Office Web Parts on several Web ... Part pages to display data retrieved from a SQL Server (SQL 2000 SP3 running ...
    (microsoft.public.inetserver.iis)