Failed to Login as 'Domain\ComputerName' pyodbc with py2exe
Ok so I have a script that connects to a mssql db and i need to run as a service which I have already accomplished but when I run it as a service it overrides my credentials that I have put in when i connect to the db with the ad computer account.
It runs perfect when i run it on its own and not as a service.
My Connection String is:
'DRIVER={SQL Server};SERVER=MyServer;DATABASE=MyDB;UID=DOMAIN\myusername;PWD=A;Trusted_Connection=True'
The Error is:
Error: ('28000', "[28000] [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'DOMAIN\COMPUTERNAME')
Any Advice?
The following connection string will use Windows authentication, using the account running the service to authenticate with the database. Change the service account to one that has database access:
'DRIVER={SQL Server};SERVER=SERVERNAME;DATABASE=DBName;Trusted_Connection=yes'
To change service account:
- Start -> Run -> services.msc
- Right-click service -> Properties
- Log On tab
- OK/Apply to save changes
- VSCode Python extension loading forever, saying “Reactivating terminals”
- How to disable functools @lru_cache when developing locally
- Plotly: How to apply different titles for each different subplots?
- Does my code prevent directory traversal?
- sklearn can't find lapack in new conda environment
- pyinstaller error: OSError: [WinError 6] The handle is invalid
- Difficulty understanding nested loops with addition, range and print function
- Save json request to a file
- Hierarchical Bayes for R or Python
- What is the aim of cv2.Rodrigues() applying on rvec in context of camera calibration
- How to add scrollbar to Python Folium popup?
- Type hinting to return the same type of Sized iterable as the input?
- Differences between columns containing lists
- Escaping quotes in Python subprocesses for Windows
- How do I copy a string to the clipboard?
- Python code to retrieve system info in format
- Multidimensional matrix permutation Julia vs. Python disagreement
- How to use threading.Lock in async function while object can be accessed from multiple thread
- How to save data into two related tables in Django?
- How does defining what a function will return work
- How to improve pandas DF processing time on different combinations of calculated data
- How split (chunk) a list of customers along month/year?
- Sagemaker batch transformer with my own pre-trained model
- Given an array of N integers, return the max sum of 3 NON-adjacent elements
- Error "table ... already exits" when using to_sql(...,if_exists='append') with Pandas and SQLite
- Saving tkinter canvas with black background and white line objects using PIL results in fully white image
- change grid interval in astropy curved axis
- Qt/PySide6: What is the best way to implement an infinite data fetching loop with a QThread?
- Number of installations statistics for PyPI packages?
- how can I do a maximum likelihood regression using scipy.optimize.minimize