In this chapter, we used the sa account to connect to our database, even though earlier we created the SimpleCMSUser account for this purpose. There's nothing wrong with this for developing a site that will not be published on the Internet, but the sa account is the master account for your database and it's not a smart idea to use it on a production system. In addition, many hosts will not allow you to use it, and will make you create an account or use one they create for you. Fortunately, it's simple to change the account we use.
Assuming you created the account in SQL Server Management Studio, or by using your host's control panel, you simply need to change the connection string in the web.config
file. In your web.config
, you will find a line similar to:
<add name="SimpleCMS_DatabaseConnectionString" connectionString="Data Source=HP\SQLEXPRESS; Initial Catalog=SimpleCMS_Database; Persist Security Info=True; User ID=sa;Password=SimpleCMS" providerName...