SQL Connection from Access uses windows account and gets permission denied
I have an 2010 Access Database where I am using a connection string to link (via MA Access Query) to a table on our SQL Server. I am using the connection string below. and it pulls back the table just fine.
However, when I ask someone to test it out, they cannot access the query and the error message shows it trying to access the server off of their windows authentication information (user id and password) and they do not have permission to that table with their authentication information.
The reason why I was able to see the data is because my windows login info has permissions for this table on the SQL Server. I need to how to adjust my conneciton string to totally by pass the windows authentication and use the ID and password I've hard coded in.
ODBC;DRIVER=SQL Server; SERVER=MAP\TEST;User Id=sbsvc;Password=Howdy!;DATABASE=Sales;
Thank you.
2 answers
Try add
Trusted_Connection=No;
to the connection string. Did that help?
Worked Perfect....Thank you!!!
Post an answer but please login first
Similar Questions
Connection string issue in connecting to SQL Server
I am trying to connect my C# code to SQL Server. My connection string is not working. It gives the following error: "Format of the initialization string does not conform to specification starting at index 0."
[Microsoft][ODBC Driver Manager] Data source file not found and no default driver specified.
I have a VBA code (in excel 2016) that i use to grab information from a MS SQL server (2008R). The connection works fine on the computer i wrote it on. When i run it on another computer i get the error "[Microsoft][ODBC Driver Manager] Data source file not found and no default driver specified".
Remote MySQL Linked Server in SQL Server, only show names of the tables.
Remote MySQL Linked Server deployed in SQL Express Management Studio do not show any content and structure, it only LIST NAME of the tables belongs to the remote connected MySQL database
connect from Oracle to MS SQL Server
I want to Connect from Oracle to MS SQL Server with a connection string to pass location (IP) / username / Password and SQL Database !
Excel 2016 VBA OLE SQL connection help
Excel 2016 VBA to create an OLE connection to a sql 2014 db and then execute a stored procedure returning the results starting cell A1 on sheet :StoredProcData. Server & instance is QGZZZ\MYINSTANCE db is data
how to use regional settings when connecting to SQL Server with a connection string? Is there a parameter for it?
How do i specifiy to use the regional settings (those settings in Windows control panel) for numbers, dates and currency? When defining a DSN connection in ODBC manager Windows i can check to use the regional settings.
Unable to connect to SQL Server 2014 via sConnString
Trying to connect to a SQL Server 2014 and receive the error : (System.Data.OleDb.OleDbException: '[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.')
Add MARS to connection string
Hi, I'm maintaining a C# .NET application. It is connected to an MSSQL database via ODBC connection. The constring is: Driver={SQL Server};Server=##.##.#.#;Database=QA;UID=SYS;PWD=__;
User Supplied OLEDB Password
Is it possible to supply a database password that is let's say supplied when the user logs into the website. Example "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Users\MyName\Documents\mywebsite_assets\database\database.mdb; Jet OLEDB:Database Password=" + strPassword
Password for ODBC Connections
Hi everyone I´m working with Visual studio data tools to create a DTSX that will work in SSIS. when I create the ODBC Connection I need to write a USER and PASSWORD for this connection but the password is not persistent.
- Load more posts