Re: Diconnection Problem

Tech-Archive recommends: Fix windows errors by optimizing your registry

Thanks Aaron, I am able to connect to the SQL server on the LAN using
Access 2003/Access 2000 but not over the Internet VPN and I am using
SQL Authentication. Its all a bit of mystery.

Mike

aaron.kempf@xxxxxxxxx wrote:
> you need to install a patch for Access 2000 to work against SQL 2000.
> I'd just run officeupdate.microsoft.com or make sure you have the
> latest SP for office
>
> and you're doing SQL authentication.. right?
>
> I'd give that a shot

.

Relevant Pages

  • Re: crash on virtual dimensions
    ... SQL authentication doesn't work for SQL Server to anywhere. ... It is basically a way for access developers to start writing all of their ...
    (microsoft.public.sqlserver.olap)
  • Re: Failed to connect to SQL express on LAN
    ... Although I wrote that SQL Authentication worked with the sa account, ... I went on the DELL8300 server and tried to enable nore server roles for the ... For SQL Authentication, from your test, I think that SQL Authentication was ...
    (microsoft.public.sqlserver.connect)
  • Re: Permissions Issue
    ... If the problem is permissions, then enabling auditing should let you see the ... If the SQL client is running this application across the network using Named ... Pipes or Multi-Protocol to connect to the SQL server with SQL authentication ...
    (microsoft.public.win2000.security)
  • Re: Problems when trying to build Connection to SQL Server Express from ASP.NET application
    ... Your connection string contains a mix of both SQL authentication and Windows ... It looks like you want to use SQL Authentication so specify 'user01' and the ...
    (comp.databases.ms-sqlserver)
  • Re: cant connect to sql server with domain users? Help....
    ... Well I thought I had resolved this, but looks like this company's policy not allows sql authentication for the users, so I am back to step one. ... Martin ... >> Have you tried to connect with sql query analizer with your username ...
    (microsoft.public.dotnet.framework.aspnet)