What the?
I installed a named instance of MSDE 2K on our server (its a long story..I wish they'd just upgrade the normal instance of 7.0, dont ask). When I go into the properties for the instance, its 'windows only'. I can change it but when I go back, its still 'windows only'. Any suggestions would help tremendously as I already know my www users arent going to have windows authentication. Be good ya'll.

Additionally, I try to register the instance in the Enterprise Manager on that machine (version 2k) and it allows me to use Windows auth, but when I try sa it tells me its not associated with a trusted connection. I know basically what the problem is, but I have NO idea how to change it. Any input would be greatly appreciated.

-Tremmorkeep
"Computers are like Men, they do exactly what you say...one's and zero's. Women are like Microsoft...they do what they think you meant."

When installing MSDE it is best to install it using the command line. There are specific switches that must be used in other to tell which security mode to install.

Use books online to reference which switches to use.

Insert from Books ONLINE.
In Microsoft Windows NT® 4.0 or Windows 2000, if SECURITYMODE=SQL is not specified, the instance will be configured for Windows Authentication and the Windows local administrator's group will be added to the SQL Server sysadmin role. If SECURITYMODE=SQL is specified, Setup configures the instance to use SQL Server Authentication.

Yeah, I figured it would be an install switch that I failed to set. So the question now is, can authentication be switched after its installed? Or must I uninstall MSDE, and then reinstall it with the switches in place?

-TK

Yes, it is best to un-install.

you can change the authentication mode to mixed mode from enterprise manage your, or if you can not access it, lokup the code to do that. Anyway, do not install MSDE on a server that has 7. use 7 instead!!!!

By the way, have you installed the security patches for MSDE, if not, you do that now.

Some times you have to also install the latest MDAC patches, but be warned, you also have a SQL Server 7 on that box. just install msde on a pc.

some times we have to say NO to our not as knowlegeable superiors. and we have to stick to it.



Sal

Cant use 7. It doesnt support user defined functions and we're doing some wiggy stuff with it. I have MSDE on my box also, and that WOULD work except the web server is never able to access the db due to security?? who knows what problem that is and I have no control over the network or permissions, lets just pretend its in a....very controlled environment.
  Odly enough I uninstalled, and installed it again with mixed mode but I still cannot register that db in my local enterprise manager, same message 'doesnt exist or access denied' even though i'm using the sa id/pwd. Life sucks..

yah, for some reason the 2 boxes dont see each other (server does not exist or access denied) still. we're on the same subnet, the first 2 of the octets in the IP addresses are the same. This is one of those issues that falls outside of my knowledge.
-TK:(