I'm the network admin for a non profit, and I'm installing ProCare for our children's center. Problem though, I've not used the SQL tools before, and the tech that I replaced (who had been here for nine years) didn't leave me the SQL login information. Windows Authentication doesn't appear to work for SQL on the sever I'm doing the install on, and I'm not sure where to go to find the SQL login information.
Also, how do I change SQL's setup to allow mixed authentication? I opened the SQL Server Configuration Manager, but don't find any security options for allowing mixed authentication. When I'm logged into the server (Windows 2008 r2 VM on a VMWare ESXi 4 host), it looks like the services for SQL Server are running under local system.
When allowing access to the ProCare software for users in AD, will I need to add users somehow in SQL as well? Or is it all integrated? Sorry if this stuff is really basic, but it's something I need to get done quickly and I didn't realize I'd run into this issue. Thanks for the assist!