Julie Kurpa
asked on
SQL Server 2016 R-Services
After several problems to install SQL Server 2016 by one of our developers, I got involved to try and assist. Too much to go into here but it seems they had apparently installed/de-installed/re- installed SQL Server several times before involving me.
Based on what they said they wanted installed, we were able to successfully install SQL Server 2016 except we got an error for R services saying the user "MSSQLSERVER01" user already existed.
I'm not a SQL server expert by far so I'm not entirely sure if this "error" means the R installation failed completely or if it simply wasn't able to create the user and so just continued on with the other steps it would have done.
In looking around, I see there are 20 MSSQLSERVERxx users in the Local Users Group (MSSQLSERVER01-MSSQLSERVER 20).
I have some questions:
1. Am I correct in assuming that this may be because of the multiple installation attempts? And that it's likely the last installation done may be using the MSSQLSERVER20 user instead of "01"?
2. How can can I know which MSSQLSERVERxx user is being used by R Service?
3. Can I uninstall the R-Services, delete the MSSQLSERVERxx users and install R-Services again?
4. Should I just uninstall SQL Server and do the clean up of the MSSQLSERVERxx users and try the install again.
This database is to used for the BizTalk Microsoft product and at this point we aren't sure if R Services is required. The developer is looking into that for me at this moment.
Thanks for your assistance. :)
Based on what they said they wanted installed, we were able to successfully install SQL Server 2016 except we got an error for R services saying the user "MSSQLSERVER01" user already existed.
I'm not a SQL server expert by far so I'm not entirely sure if this "error" means the R installation failed completely or if it simply wasn't able to create the user and so just continued on with the other steps it would have done.
In looking around, I see there are 20 MSSQLSERVERxx users in the Local Users Group (MSSQLSERVER01-MSSQLSERVER
I have some questions:
1. Am I correct in assuming that this may be because of the multiple installation attempts? And that it's likely the last installation done may be using the MSSQLSERVER20 user instead of "01"?
2. How can can I know which MSSQLSERVERxx user is being used by R Service?
3. Can I uninstall the R-Services, delete the MSSQLSERVERxx users and install R-Services again?
4. Should I just uninstall SQL Server and do the clean up of the MSSQLSERVERxx users and try the install again.
This database is to used for the BizTalk Microsoft product and at this point we aren't sure if R Services is required. The developer is looking into that for me at this moment.
Thanks for your assistance. :)
I would reinstall the entire server. Who knows what they else did.
ASKER
I completely uninstalled SQL Server, deleted those local MSSQLSERVERxx users, and reinstalled. All the features installed successfully with no errors.
However, all 20 of those MSSQLSERVER users were recreated. Googling showed that this is expected behavior when installing the R Services and is documented in MS SQL documentation. :)
However, all 20 of those MSSQLSERVER users were recreated. Googling showed that this is expected behavior when installing the R Services and is documented in MS SQL documentation. :)
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.