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


"Abdul Hameed" <ahameed@xxxxxxxxxxxxxxxx> wrote in message
news:%23izcz75jGHA.5036@xxxxxxxxxxxxxxxxxxxxxxx
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.

Thanks in anticipations.

Abdul Hameed



This only means one thing. The user "sa" is not an user in the local
machine.
Do you have an user named "sa" in your computer or in your company?





.

Relevant Pages

  • Re: Web and SQL Security
    ... Your connection string needs to be a low privileged account. ... SQL auth is never recommended, ... Therefore web app communicates with the SQL server using ...
    (microsoft.public.sqlserver.security)
  • Re: help with changing some code from mdb to adp
    ... At the end of this post is an example of an ADO connection string to a SQL ... Server database, and '' to the UNC path/name of your instance of SQL ... Windows, you can't create a new UDL file directly, but you can create a new, ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Win2.3k and dotnet. Urgent please
    ... Did you install MSDE as an instance? ... connection string, unless it is the default instance. ... ASP.NET application and MSDE installed on our Win2k dev server. ... Then I installed SQL server client tools only. ...
    (microsoft.public.inetserver.asp.general)
  • RE: Login failed for user NT AUTHORITYLOCAL SERVICE.
    ... The error message did indicate that the login user doesn't have sufficient ... permission access the target database, and since you mentioned the error ... so thats SQL Server Engine I think? ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Event 1000 Windows SharePoint Services 2.0 Error
    ... First off what exact error message do you get? ... I've not seen Exchange pop connector get mangled by removing SQL so lets debug that separately. ... I had all SQL server instances to a complete stop. ... And this morning when I came to work, I discovered that when I try to access http://companyweb/, I receive the "Cannot connect to the configuration database." ...
    (microsoft.public.windows.server.sbs)