RE: connecting

Hi Leo,

Thank you for using MSDN Managed Newsgroup Support.

From you description, my understanding of this issue is: You want to use
the SQL authentication to connect to the SQL server in the access adp
project but all the application is disconnected. If I misunderstood your
concern, please feel free to let me know.

If you could connect to the SQL Server in ASP application with your SQL
account, this account should be OK. As for the disconnected issue in
Access, I would like to know some information:

1. What's the Office Version and if you have applied the latest Services
Pack of Office?

2. If you use other SQL login account, does this issue appeared? If you use
SA account, does this issue appeared? What about using Windows account?

3. What's the SQL Server Version? Is SQL 2000 or SQL 7.0 or SQL 2005?

Please let me know the information so that I can provide further assistance.

Sincerely,

Wei Lu
Microsoft Online Community Support

==================================================

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.


.

Relevant Pages

  • Re: SQL account rights
    ... Please advice what is the best, suitable rights rather than domain admin ... Warren Brunk - MCITP - SQL 2005, ... Add it as a login to the SQL Server ... files, or backups, make sure that the service account has Full ...
    (microsoft.public.sqlserver.security)
  • Re: User authentication
    ... There are 2 SQL Server 2005 ... 1 SQL Server 2000 installed on another server ... Windows account instead to run backup jobs. ...
    (microsoft.public.sqlserver.clients)
  • Re: SQL 2000 Server gets hacked
    ... Thank you Beth. ... > placed a strong password on the 'sa' account?) ... Your SQl Service itself shouldn't be running as a ... (SQL Agent requires more, but not SQL Server). ...
    (microsoft.public.sqlserver.security)
  • Re: SQL 2000 Server gets hacked
    ... Thank you Beth. ... > placed a strong password on the 'sa' account?) ... Your SQl Service itself shouldn't be running as a ... (SQL Agent requires more, but not SQL Server). ...
    (microsoft.public.sqlserver.security)
  • Re: Microsoft Search service cannot be administered under the present user error SP3
    ... - Have not modified Administrator account, but i ran the SQL script anyway. ... SQL account is not a local administrator. ... > has this server ever been upgrade from SQL Server 7.0 or is this SQL ...
    (microsoft.public.sqlserver.fulltext)
Loading