Normally, when you start programming on a machine for the first time or right after installing SQL Server, you need to change the authentication to mixed. The default authentication mode for SQL server 2000 is Windows only. It is especially important for web application since they run under a Windows user that is not allowed to access the database.
Here are the steps:
1) Open Enterprise manager.
2) Point to the server name that you want to change the mode for.
3) Right click and click on properties.
4) Click on security tab.
5) At security section select SQL server and Windows.
No comments:
Post a Comment