13-12-2018, 02:13 AM
I just installed 2018 with SQL express 2014. I selcted the trial license, and to use Integratd auth (I was logged in as an admin account). After installation was done, I enabled TCP/IP connections in SQL. I then installed the 2018 client on my workstation and attempted to connect to the DB. The login was denied. I linked Secuirty Groups from Active Directory that contained my non admin account. Login still denied and logs show SQL Event ID 18456
I pulled up the DB in SQL Server Management Studio, and sure enough, there was only sa and the single Windows Login of my admin account.
I manaually created a login in SQL with Windows Auth to match my login used on my workstation. I could then connect to the DB. SO things brings me to my question.
How are you expected to add a new user that has not logged into the database before? I would expect the app to handle that. Is this hidden during the trial?
I pulled up the DB in SQL Server Management Studio, and sure enough, there was only sa and the single Windows Login of my admin account.
I manaually created a login in SQL with Windows Auth to match my login used on my workstation. I could then connect to the DB. SO things brings me to my question.
How are you expected to add a new user that has not logged into the database before? I would expect the app to handle that. Is this hidden during the trial?
