problem with restore ms sql server 2008 database

[Ehsandamd]

im using plesk 11.0.9
i have a problem with restore ms sql server 2008 database after restoring the message
Error: Unable to creste database user: Database user name is invalid. Only latin letters are allowed in the database user nameerror

appear ??

how can i resolve this error

i created
database name : rastebazar
user : rastebazar
in plesk

 

[PeterWell]

im using plesk 11.0.9
i have a problem with restore ms sql server 2008 database after restoring the message
Error: Unable to creste database user: Database user name is invalid. Only latin letters are allowed in the database user nameerror

appear ??

how can i resolve this error

i created
database name : rastebazar
user : rastebazar
in plesk

Same here. Any help's appreciated.

 

[IgorG]

This is because of the domain's name starts with a number. While creating database user, by default Plesk adds domains name prefix.

Login to Plesk using "admin" and go to Home>Tools & Settings>Database Servers>Database hosting settings
Then uncheck "Add user's login name and underscore to the beginning of database names" and "Add user's login name and underscore to the beginning of database user names"

 

[hamed23100]

This is because of the domain's name starts with a number. While creating database user, by default Plesk adds domains name prefix.

Login to Plesk using "admin" and go to Home>Tools & Settings>Database Servers>Database hosting settings
Then uncheck "Add user's login name and underscore to the beginning of database names" and "Add user's login name and underscore to the beginning of database user names"

Hi, we unchecked both you said but still we get following error:

Unable to create database user: Database user name is invalid. Only Latin letters are allowed in the database user name

Regards,
Hamed

 

[InderS]

try to open the backup file in notepad or notepadd ++ search for the script which says add database user. Either remove that script or remove/change the username in script. Then try to restore again.