MSSQL, Multiple DB, 1 user

[ashish]

How can I set multiple MSSQL databases that can be accessed with 1 username+pwd?

Plesk compels me to have different users with different databases. But I have an application that needs me to have a single user for all databases.

Thanks in advance.

 

[JackL]

add databases with diffrent users, and then manually add first user to another database.
John S.G.

 

[ashish]

Can you please explain how to add first user to the other database?

While trying to do that I get the following error

Error: User user1 already exists.

Thanks.

 

[sergius]

How can I set multiple MSSQL databases that can be accessed with 1 username+pwd?

Plesk compels me to have different users with different databases. But I have an application that needs me to have a single user for all databases.

Thanks in advance.

This feature is scheduled for the future versions.

Now you should use MSSQL Web Admin to manage such users.

 

[ashish]

This feature is scheduled for the next versions.

The lack of this feature is a real annoyance! You should issue a patch.

Now you should use MSSQL Web Admin to manage such users.

Can you please elaborate on how to do this?

 

[sergius]

Can you please elaborate on how to do this?

Please navigate on page Plesk > Server > Database Servers > Local MS SQL server and click WebAdmin

 

[ashish]

Hell! The hosting provider has installed some free application for webAdmin and I couldn't figure out how to do that there.

Is this included in 8.3? If not, in which version is it expected to be there?

 

[sergius]

The feature 1 user for multiple databases is sheduled for Q4'08

 

[chfriley]

I did it via the command line (for 8.2 on Linux) and gave the steps here, if you want to see if you can get it to work on your configuration:

http://forum.swsoft.com/showthread.php?t=23205