Quote:
Originally Posted by BinaryFox
How to put a password? I tested several passwords and restart the sql server several times but it remains the same problem, would you have an encrypt for the password of the .opt files maybe I'm doing things wrong
|
The DES encrypt tool should be with the files make sure you are using the one that came with the files.
The new one is different from the old one cant remember exactly when it changed.
Put the encrypted password in the opt file and re-encrypt the .opt file in the encryption tool
Set the password in MSSQL. Expand the security folder in your MSSQL server tree, expand the logins folder, right click user sa and select properties, set sa password in the window that opens.
Make sure your SQL server is set for mixed authentication. You may have set it up for Windows authentication only. Right click your server in your server list in MSSQL and click on properties, select the security tab when it opens, authentication settings are at the top.
Quote:
Originally Posted by BinaryFox
I also have the service "Agent sql server" which does not start
|
Have you restarted the computer yet?
