Our solution stack consists of multiple services, each of which can be run on individual host machines. For a variety of reasons, the services are hosted as a windows service running under a virtual account. Many of these services need to connect to a MS SQL 2008R2 instance running on a remote host. Each of the host machines running the services thus need to added to the MS SQL2008R2 instances as logins. e.g if our services are running on hostnames machine1, machine2...machinen, machine accounts machine1$, machine2$... machinen$ need to be added to MS SQL as logins. I thought I could simplify this by adding each host machine to a machine group on the domain and add the machine group as a login on the MS SQL instance. This did not work. Am I missing some steps ? OR am I forever condemned to add each individual machine accounts to MS SQL instance ? I know that I can run the windows services under a domain user (or maybe have the services impersonate a domain user if possible) and add the domain user to the MS SQL instance but I do not want to try this approach as the password for the domain user now needs to be managed. Any help appreciated
Looking for a easy enough way to manage virtual machine accounts connecting to MS SQL 2008R2
30 views Asked by QFirstLast At
1
There are 1 answers
Related Questions in SQL-SERVER
- Dynamic query creation with Array like implementation
- 'pyodbc.Cursor' object has no attribute 'callproc', mssql with django
- Driver com.microsoft.sqlserver.jdbc.SQLServerDriver claims to not accept jdbcUrl, ${SPRING_DATASOURCE_URL}: GitHub Actions
- PHP Laravel SQLServer could not find driver
- Upsert huge amount of data by EFCore.BulkExtensions
- How to locate relevant tables or columns in a SQL Server database
- Cannot delete SQL datafile (.mdf) as its currently in use
- Writing query in CTE returning the wrong output
- Group By Sum and without Group by sum Amount is different
- plan_handle is always different for each query in SQL Server Cache
- Adding a different string to a table fails
- The specified data type in the EF modelBuilder doesn't correspond to the one that is created
- SQL71561: SqlComputedColumn: When column selected
- How to Solve Error Associated with Trusted Authority
- SQL Server Data Model and Insert Performance
Related Questions in VIRTUAL
- Premature updates on wijmo using virtual scrolling
- How to remove an android virtual device that is not in the list?
- Override virtual generic method
- ansible VRF aware on builtins for Ubuntu linux with VRFs
- Setting-up Virtual host on RHEL-based Apache Server - domain is pointing on a wrong project
- Shellshock command on pWnOS 1.0 doesnt work
- Power BI DAX: apply slicer values in virtual table
- How do I connect my Android smartphone using virtual USB to my computer
- I don't see the folders of my virtual environment in VS Code even though the Virtual Environment is created. - Newbie
- Using keyword with virtual inheritance in cpp
- Synthetic individual data using summary-level data
- Snabbdom - can not add TR to top of table with out full re-render of rows
- python virtual devices - How to reuse camera in more than one application?
- Python decorator for C++ class virtual methods using pybind11
- pybind11 undefined behaviour with virtual function
Related Questions in ACCOUNTS
- how can i connect to some existing account?
- macOS: Add CalDAV account (Settings/Internet Accounts/CalDAV account) programmatically
- I can declare a method Meteor onLogout within a constant?
- Meteor: How to create user without logging him in?
- How to use multiple github accounts with hub?
- meteor accounts-github pkg does not display username after logging in
- Android custom account retreive the password
- Meteor - Slack oAuth2 Accounts.LoginCancelledError
- Looking for a easy enough way to manage virtual machine accounts connecting to MS SQL 2008R2
- Php general ledger query
- PE Puppet Console and manage multiple node user accounts
- How to create parent accounts on Wordpress like 1 Google acc for Gmail, Youtube, Playstore..?
- Sage Accounts not picking up basket discount items from MySagePay
- Searching for locked accounts in Active Directory (Excel/VB)
- PayPal Sandbox transactions are not showing for seller
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
Popular Tags
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Once the server and workstation were rebooted, it worked. Now just having the security group on MS SQL and no individual machine account on MS SQL gets our solution stack up and running. Thank you SQLChao for keeping me on track.