December 23, 2004 at 7:20 am
I just brought up a new SQL Server to be our test server. I did the following steps, but when I tried to login to the database using an application I recieved the "Not Associated with a Trusted SQL Server Connection". Does anyone know why and how to resolve this issue? Thanks in advance for any help.
Michael
Steps I ran:
1. Scripted out the logins from the production server
2. Ran that script on the test server
3. Restored a backup of the database to the test server
4. Ran a script I wrote to revoke all users from that database and then re-grant them access and permissions
5. Manually revoked the username and re-added it through EM
December 23, 2004 at 10:13 am
Did you set the test server to allow SQL logins? Server | Properties | security tab
December 23, 2004 at 10:20 am
I assume that you are attempting to login with a SQL account? Sounds like the server is in Windows Mode only and will not allow SQL accounts.
There is a thread here that mentions a registry setting to fix this..
Good Hunting!
AJ Ahrens
webmaster@kritter.net
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply