SQL-Server 2008

[Peter Petersen22]

Hello, my hoster says, that there is a plesk-limitation: each user can manage one SQL-Server DB. Who knows something about this? Regards

 

[IgorG]

If you go to Domain's template you see how much databases allowed for creation. You can change this value there.

 

[Peter Petersen22]

Hello, thanks for your answer. In Default Domain i have unlimited SQL Server Databases. Why told my hoster me that there is a limit? My problem was: I cant connect from one db to another (i got a 916-Error), because each db has its own login/user.

 

[IgorG]

Right. When you create new DB, you should create own user for this DB.

 

[Peter Petersen22]

On my local server i have one login, two db's and for each db one user with the one login. So i could query in db1 data from db2. How could i realize this on the hosted server?