Re: Connection Manager + Remote SQL Clients
- From: "Claus" <cjobes@xxxxxxxxxxxxx>
- Date: Fri, 23 Nov 2007 12:59:20 -0500
If you use Access front ends you need an ODBC driver for SQL installed. When
you configure the ODBC driver you can use an authentication that is not
related to the user that logs on.
Running Vista against an SBS box you might also want to take a look at this
link:
http://support.microsoft.com/kb/926505
--
Claus
"Steve Mahon" <SteveMahon@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:2B3B2192-B676-4FFB-A74E-42385685B79C@xxxxxxxxxxxxxxxx
We have SBS2003R2 Prem, SQL2005, ISA2004. We have several MSAccess
frontend
applications. On a remote, non sbs domain member, Vista Ultimate machine
connected via connection manager I can browse the lan and copy a one of
the
Access frontends to vista machine.
When I run the app and open a page with data, I get the following SQL
Server
Login error:
Connection failed: SQLState: '28000' SQL Server Error: 18452
[Microsft][ODBC
SQL Server Driver][SQL Server]Login failed for user". The user is not
associated with a trusted SQL Server connection.
I get a similar error trying to connect with SQL MGMT Studio Express. The
server is configured for Windows Authentication, but I thought the
connection
manager takes care of the authentication. Perhaps it is a Vista issue. I
haven't tried yet with an XP client.
Any help is appreciated.
.
- Prev by Date: Re: Vista PC's
- Next by Date: Re: Exchange Appts & iPhones
- Previous by thread: Re: Vista PC's
- Next by thread: Re: Connection Manager + Remote SQL Clients
- Index(es):
Relevant Pages
|
