We are trying to stand up a new GSS server but cannot connect to GSS using a domain user. We are using Ghost 3.3 RU11 and SQL Express 2022 CU9 on a fully patch Windows 2019 server. We have local user called “ghost” (original I know) and GSS open under this user. When we log-in with on of our AD accounts and click the icon we are asked to connect to the site we put in the .\ghost and the password and get this error:
“Error connecting to the database server. Please check you database server to see that it is functioning properly.
State:2800,Native:18456,Origin:[Microsoft][ODBC SQL Server Driver][SQL Server]”
The steps that have gotten us to this point are the following:
1.) Install and patch the OS
2.) Join the domain
3.) Make ghost user
4.) Install SQL Express and patch it as ghost user
5.) Install GSS as ghost user with custom install using the ghost user as the log-in user for the database
6.) Now it works for the ghost user but not a domain user.
Has anybody else seen this? I would appreciate any assistance. Thanks in advance!
Sincerely,
Eric T Gadsby
Andrew Pratt