• Halloween is coming! To celebrate the occasion, we dusted off a couple of old skins, and even created a brand new one (Pixel).
    To get into the festive spirit, install the Skins extension.
  • The new Python extension is now available. It allows customers to deploy and manage WSGI-based Python applications on their websites directly from Plesk.
  • The Plesk Mobile apps for iOS and Android and the Plesk Mobile Center extension have been deprecated, and are no longer available for new installations. In Plesk Obsidian 18.0.84, the Plesk Mobile Center extension will be removed from servers during the upgrade, and the Plesk Mobile apps will lose their server management features.
  • The Social Login extension has been deprecated and will be removed in Plesk Obsidian 18.0.84. After that, it will no longer be possible to log in to Plesk with a Google, Facebook, GitHub account, or with a passkey. Plesk usernames and passwords, as well as logging in with a WebPros Account, are not affected.

change collation on ms sql problem

T

TALz

Guest
i got plesk 7.5 installed on a windows 2003 machine, a few days ago a client called me saying he want`s to change the collation on his db, and it wont let him.
so at first i thought it`s because i got the MSDE that comes by default, so i upgraded and installed MSSQL2000, but he still got the same problem and he asks for the SA password.
my question is, what do i need to do so that client can do what ever he want`s with his DB w/o giving him the SA password, cause if he changes the collation wont that new set will be by default for all new DB`s that will be created ?
how can he change it only to his DB?

this is a big problem which i need help with ASAP,
thank you for ur help guys.!

Tal,
 
You must log in or register to reply here.

Similar threads

Mark Bailey
Issue Customer-Facing Upsells
Replies
2
Views
2K
Sebahat.hadzhi
Sebahat.hadzhi
kristobal1969
Issue password reset for mail not working properly
Replies
3
Views
3K
Sebahat.hadzhi
Sebahat.hadzhi
Fastamir
Question IMAP Email Creation Issue with Outlook 365 on New Lenovo Laptop and Plesk Server
Replies
9
Views
4K
Fastamir
Fastamir
akira9000
upgrade to Mariadb 10.11 now Wordpress only connects to DB on 127.0.0.1
Replies
3
Views
3K
Sebahat.hadzhi
Sebahat.hadzhi
E
Resolved Made a mistake, changed server hostname, please advise
Replies
2
Views
2K
elliotpa04
E
Back
Top