A few days ago, I was learning how to operate databases in C. There has been no problem. However, after re-installing SQL Server2000, I found that it was not usable when I was writing a connection to the database.
Conn. connectonstring = "Server = localhost; database = pubs; uid = sa; Pwd ='' "to connect to the server.
Later, I found that the installation was done by clicking Next during my installation, which is indeed not feasible because the access mode set to Windows authentication is used, if you want to use the preceding connection string to connect to the database, you must use Windows Authentication and SQL Server Authentication in hybrid mode.
After the installation is complete, you can modify the settings:
Go to the SQL Enterprise Manager. Right-click the server instance and choose Properties. On the "Security" Page, choose SQL Server and windows as the options in the "Identity Authentication" column.
The default account for SQL Server authentication is Sa.
