Greetings to the well of knowledge...
I have an Access front-end that talks to an SQL Server 2008R2 back-end (yes, I know I need to upgrade this). This front-end is used by users on a Server 2008R2 remote desktop server.
I am in the process of completing the build-out of a new Server 2012R2 remote desktop server. To make the migration easier, I have created new users for this server and have created SQL Logins for these users using the same properties as their old SQL logins.
When I launch the front-end in a session on the new RDP server using one of the new logins, I get SQL Error 18456. I checked the properties of the old and new users and they appear to be identical. I can't figure out why I'm getting the SQL Login error.
Any thoughts? I'm baffled.
Thanks,
Ken
I have an Access front-end that talks to an SQL Server 2008R2 back-end (yes, I know I need to upgrade this). This front-end is used by users on a Server 2008R2 remote desktop server.
I am in the process of completing the build-out of a new Server 2012R2 remote desktop server. To make the migration easier, I have created new users for this server and have created SQL Logins for these users using the same properties as their old SQL logins.
When I launch the front-end in a session on the new RDP server using one of the new logins, I get SQL Error 18456. I checked the properties of the old and new users and they appear to be identical. I can't figure out why I'm getting the SQL Login error.
Any thoughts? I'm baffled.
Thanks,
Ken