bob on August 29th, 2008
Using Query Analyzer it is easy to coordinate with the database server while you would like to change the password, to change the SQL Server User name password, just connect to the database with Query Analyzer using the SQL Server Username that is being updated and the current password. Then run “sp_password” to change the password. This approach provides the flexibility to change the password at the most appropriate time for the application.
sp_password [ [ @old = ] ‘old_password’ , ]
{ [ @new =] ‘new_password’ }
[ , [ @loginame = ] ‘login’ ]
The Office Microsoft Documentation for sp_password
Here is a simple example that changes the current password from
“currentPassword” to “newPassword”;
sp_password ‘currentPassword’, ‘newPassword’
However make sure to use a strong password, “newPassword” is just an example. For a quick test to confirm that the new password is working, close Query Analyzer and then re-connect with the new password. That is all there is to it, except for changing your connections string.
It is obvious, but still critical to remember to change the password in your connection string if this SQL User name is used in your code. Once the password has been changed and tested with Query Analyzer, update the connection string with the new password and test that everything still works correctly, and you’re done.
bob on March 7th, 2008
A business web site should be able to organize and track transactions that are made as well as integrate with their own systems and track how the traffic flows between the different parts of the sites. Many businesses are operated through a separate entity such as a corporation, limited partnership or limited liability Company hence you will need to choose a web hosting company like micfo.com that will be able to do what you need it to do. Check out some of the web hosting review sites/hosting directories; they might be helpful for you to know on the who’s who in web hosting and the prevailing price structure.
Your website requires something more such as a shopping cart system; you will need to research the different shopping cart system, one being a shopping cart. There are free ones existing, but surely you’ll require at least some technical knowledge. A profit-making grade software is costly and while they are without doubt worth every penny, you will find that the majority of web hosts will not install them for you as it is not part of their system and could interrupt service from their users unless you spend more for customer business web hosting which can only be accomplished with hosting services like VPS or dedicated server hosting.
It is suggested that you find a developer to install the shopping cart and customize it well and read the knowledge base the web host provide separately as the learning curve is too great to start on your own.
