Archive for the 'IT' Category

MSSQL Login Failed

I tried to login to my SQL Server with a new user I created and got following error:
Login failed for user ‘root’. The user is not associated with a trusted SQL Server connection.

You need to activate MS Sql Authentication and Windows Authentication Mode:
1. Open MS SQL Server Manegement Studio
2. Right click on the server
3. Properties
4. Security
5. Change from Windows Authentication Mode to SQL Server and Windows Authentication mode

No Comments »

admin on May 11th 2008 in IT, MSSQL

MUST_CHANGE is ON

I tried to remove the check_policy and check_expiration from a user and got following error in MS SQL Server:

I forgot to remove the must change password flag when I created the user. A simple SQL query to change the users password solved the problem:

ALTER LOGIN %USERNAME% WITH PASSWORD='%PASSWORD%'

									

No Comments »

admin on May 11th 2008 in IT, MSSQL

Install Debian Web Server

I don’t have a lot of experience in Linux environment but anyway I got the job to install a new webserver at my work. The old server was running on debian already so I decided to take the same linux distribution.

The newest ISO you get from here from here:
www.debian.org

For my installation I just needed the CD1. Because I wanted to try it out first I decided to install debian on VMWare Server. So I booted the ISO file in VMWare and did the standard installation without the GUI. We don’t really need a GUI (Graphic User Interface) for a web server. The installation is actually straight forward.

So now we are logged in as root and are in the command line. So what now???

Follow the instructions on this webpage:
www.mysql-apache-php.com

I actually got some error when I tried to install apache and php with apt-get. To add some more sources to the apt source.list file solved the problem.

To edit the source do following:

You might want to use your own source list. This one worked for me:

No Comments »

admin on May 7th 2008 in IT, Linux

Version MS SQL Server

Here a simple MS Query to get the version of MS SQL Server:
select @@version

No Comments »

admin on May 6th 2008 in IT, MSSQL

Backup and Restore MySQL Complete

I had to backup and restore a MySQL database on a debian linux machine to another server at work. First I tried to do it trough phpmyadmin which is not very efficient when it comes to big db. So I decided to do it through the MySQL command prompt.

Backup all dbs command into a dump file
mysqldump -u root -p –all-databases > xxxxxxx.sql

Restore all dbs command from a dump file
mysql –f -u root -p < xxxxxxx.sql

Of course you need to replace x with the filename you would like to use.

As always… it worked for me but there is no warranty. You need to decide yourself if you want to use it!

No Comments »

admin on May 4th 2008 in MySQL




Check out new movies online website. Download and buy movies now.