Tomas
06-16-2005, 01:53 PM
Hi Guys:
Last night I was determined to get the Plesk MSSQL connection going the easy way without the command line so everyone get a chance if things are not going as smooth as it should be. This howto will explain you how to change the MSSQL admin password (commonly known as "sa" user) and integrating it into Plesk for hosting use.
First of all, login to RDC using your windows (I think this is already known so I'll save it) and open an IE window from the VPS. Go to this address:
http://www.whitebearconsulting.com/Downloads.htm
And download the MSDE Manager. You will have to add the site to the trusted network, so please do so. After the download you can delete it if you are unsure about leaving it there.
Unzip the content of the file and proceed to install the program. The default settings will do for now, so go to "next, next next". Easy huh? Well, here's the "trick".
Open the MSDE Manager by going to:
Start --> All Programs --> MSDE Manager --> MSDE Manager 7
Once you get into the program, go to:
File --> Connect...
In "Server" leave it to "(local)" (no quotes please). For "Security" select "Use Integrated Security" and leave those 2 fields blank. Click "connect".
Now select: "Logins" and "Change a Login's Password".
Select the "sa" user and create a new password for it. Once this is done click on "Change Now".
Now you have changed the MSSQL administrator's password. You can close the program and logout of Remote Desktop (This is veyr important. Be sure to Logout from RDC from the start menu and do not close it from the "x" above".
Now login to Plesk and go to "System" --> "Server".
Select "Databases".
At the "Microsoft SQL Server" tab change the following:
Server Name: (get from My Computer -> System Properties -> Computer Name)
Administrator's Login: sa
Administrator's Password: The password you just set in MSDE Manager
Confirm Password: confirm it.
Click on "OK".
If you setup everything correctly, you'll see that the 2 buttons above will get colored instead of greyed out. This means that the database connection was completed successfully.
That's it!! Now you can go and start creating MSSQL databases from your Plesk Admin or for your customers once we get out of beta!!
If you have questions, don't hesitate to ask guys!!
Good luck!!
Last night I was determined to get the Plesk MSSQL connection going the easy way without the command line so everyone get a chance if things are not going as smooth as it should be. This howto will explain you how to change the MSSQL admin password (commonly known as "sa" user) and integrating it into Plesk for hosting use.
First of all, login to RDC using your windows (I think this is already known so I'll save it) and open an IE window from the VPS. Go to this address:
http://www.whitebearconsulting.com/Downloads.htm
And download the MSDE Manager. You will have to add the site to the trusted network, so please do so. After the download you can delete it if you are unsure about leaving it there.
Unzip the content of the file and proceed to install the program. The default settings will do for now, so go to "next, next next". Easy huh? Well, here's the "trick".
Open the MSDE Manager by going to:
Start --> All Programs --> MSDE Manager --> MSDE Manager 7
Once you get into the program, go to:
File --> Connect...
In "Server" leave it to "(local)" (no quotes please). For "Security" select "Use Integrated Security" and leave those 2 fields blank. Click "connect".
Now select: "Logins" and "Change a Login's Password".
Select the "sa" user and create a new password for it. Once this is done click on "Change Now".
Now you have changed the MSSQL administrator's password. You can close the program and logout of Remote Desktop (This is veyr important. Be sure to Logout from RDC from the start menu and do not close it from the "x" above".
Now login to Plesk and go to "System" --> "Server".
Select "Databases".
At the "Microsoft SQL Server" tab change the following:
Server Name: (get from My Computer -> System Properties -> Computer Name)
Administrator's Login: sa
Administrator's Password: The password you just set in MSDE Manager
Confirm Password: confirm it.
Click on "OK".
If you setup everything correctly, you'll see that the 2 buttons above will get colored instead of greyed out. This means that the database connection was completed successfully.
That's it!! Now you can go and start creating MSSQL databases from your Plesk Admin or for your customers once we get out of beta!!
If you have questions, don't hesitate to ask guys!!
Good luck!!