Sql server 2005

[Silence]

Hi,

I recently have installed Sql Express 2005 in my windows 2003 server.

Well, i put the server in Plesk databases, so far so good...

i try to create a database with Expres...and it's all good..

The Problem:

My clients can't create the 2005 db's...the label it's not avaliable...

Solutions?


Thanks in Advance,

Tiago @ PTisp .pt

 

[avsokolov]

Hello,

It is not quite clear:

> Well, i put the server in Plesk databases, so far so
> good...

Can you as administrator add new database? Do you see Databases link on domain page?

Even if your clienta have no permissions to add databases, the database link must be present on the domain page.

Try to delete SQL Express from Plesk, add it again, in Plesk CP -> Server -> Components Management click "Refresh", then just check if you can add a database, go to Domains -> domain.tld -> Database, add new database. If you can do it, so you clients also should have this possibility.

 

[Silence]

Hi,


Thanks for the reply.

If i delete the database server, the databases that i create will desappear, right?

Thanks

 

[JackL]

1. You need to add SQL server in Plesk at Plesk CP-Server -Databases
2. After that clients will be able to create databases in Plesk.
If you uninstall SQL server databases will be gone, but you can backup them and attach later

John S.G.

 

[Silence]

Hi,

I've done that...put the database server in Plesk databases...


As login " admin " i can create them...

If i login with " client " can't do it...

strange thing?

Best regards.

 

[sergius]

Hi,

I've done that...put the database server in Plesk databases...


As login " admin " i can create them...

If i login with " client " can't do it...

strange thing?

Best regards.

It is designed behavior. We suppose to improve this feature in the next versions.