I am attemting to develop a link between a access and SQL2003 database on two different machines. The aim is to update information from a query within the access database to a table within the SQL2003 database - the stumbling block is that the SQL2003 database requires a user name and password to log into the database and append from the access database.
I need a solution where the user is not required to enter a user name or password and literally skip passed the security on SQL2003.
Any suggestion and recommendations would be greatly appreciated.
Thanks,
John
Trusted SQL Connections....
Hot Topic
- RS 2000 on WINDOWS 2003 Email Subscriptions not working
- SQL Server Express SP1 Setup Changes
- Creating a Job
- HTTP Access to Analysis Services 2005
- How to render to HTML with images?
- Can not open SQL Management Studio
- How to make tables & stored procedures in MSDE?
- Take Id-s From returned rows, and make a new SELECT
- Cannot create new SQL database file.
- ODBC connections and SSIS
SQL Server
- SQL 2005 - Partitioning Tables
- Creating a double entry book keeping system
- SQL Server Express SP1 Setup Changes
- INCLUDE Clause
- SQL Server Mobile Replication Error
- SQL 2005 SP1 on Win2003 R2 - Is it supported/ certified?
- Can not uncompress files during setup of beta 3 or sql2005eval
- rs:about the Scope parameter of a aggregate function
- Importing Tables with Identity properties (uisng Import wizard)
- Storing the ErrorDescription on DFT -> Flat file error output
Trusted SQL Connections....
cgoeters
Integrated security will solve this problem. Check BOL for details.
Paul