SQL server 6.5 security/server register problems
Posted on 2012-08-24
I am attempting to install and use a SQL server 6.5 database server on a server 2000 operating system due to a client conversion. The only error I get during install is that the password does not meet security requirements. My account does have admin rights. The local database server does not show up in the list of servers. I am able to register the server in Enterprise Manager. However, I get a login failed for trusted connection and Standard Security. I have attempted to go back thru set up and set the security to mixed mode. The install never prompted me to enter a sa password. The security setup feature did. However, I now get an error "The SQL server security options could not be successfully set. Setup could not connect to the SQL Server." I am open to any ideas.