Can't change to Mixed Mode

[BobRodes]

Hello all,

I'm trying to connect to a remote SQL Server database. I've set up an account on it with a password. When I try to access it on the network, in several different ways (ODBC .dsn file, OLE DB SQL provider using VB data environment, I get the "not associated with a trusted connection" error although I provide the username and password.

A little digging shows that I hadn't set the server up for mixed security, and here's where I've run into a problem. I go into enterprise manager, right click on "(local) (Windows NT)", select Properties, and then the security tab. From there, under Authentication, I select the SQL Server and Windows option button. Then I hit ok. However, when I go back to the properties window again, the option button is set back to Windows only, and I still can't access the db.

What am I missing?

Thanks for any help.

Bob Rodes

 

[flstffatboy]

You need to restart SQL Server after the change before it can take effect.

FLSTF

 

[BobRodes]

Thanks for your suggestion, flst. I should have tried that, but it still didn't work. If I set the property, and then immediately open the window again after hitting ok, it has been set back. Restarting SQL Server has no effect on this behavior.

Any other ideas?

Thx

Bob

 

[flstffatboy]

Have you tried to login remotely even though the properties in Enterprise Manager are not showing mixed mode? The only reason I say this is I've had a lot of experience where Enterprise Manager does not show changes I've made even when I have refreshed it. I'm in the habit now that after I make any changes in EM close then reopen it.

 

[BobRodes]

Sorry to be slow to close this. I rebooted my machine and everything worked as it should.

Thanks,

Bob