Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sanalnambiar
Starting Member
1 Post |
 Posted - 2007-12-01 : 03:39:32
|
| Dear Members.. I am facing a problem with SQL server 2005 Secc. I have a Server with server collation Arabic_CI_AS. And i have a databse in it which has a collation SQL_Latin1_General_CP1256_CI_AS. The issue started with me when i am trying to create a Integrated seccuroty for some users in my firm. I have created a DatabaseRoll for in the database. There is no problem while creating it. I have added the user in the seccurity login on the server and then i added these users in the database Seccurity users. After that i applied the created roll to that users. It being created perfectly. But the issue is coming when i want to modify the seccurity policy (Seccurables) of any user from the database. (Properties of Users --> Seccurables )Its showing an error. as follows------------------------------Failed to retrieve data for this request. (Microsoft.SqlServer.Express.SmoEnum)------------------------------ADDITIONAL INFORMATION:urn could not be resolved at level DatabaseRole. ------------------------------I am not understanding why its coming with this situation.==========================================================Also sometimes its showing an error when i am trying to see the login prperties of that user in the database logins. Server--> Seccurity --> Logins --> Properties --> Seccurables -->Err.As follows------------------------------------------Failed to retrieve data for this request. (Microsoft.SqlServer.Express.SmoEnum)------------------------------ADDITIONAL INFORMATION:An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.Express.ConnectionInfo)------------------------------Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Arabic_CI_AS" in the UNION operation. (Microsoft SQL Server, Error: 468)------------------------------Hope some body can help me in this.... Thanks in Advance.... |
|
|
rizk_sobhi
Starting Member
1 Post |
Posted - 2011-07-31 : 22:29:45
|
| Hi, I have the problem at my machine, have you got your problem answered? |
 |
|
|
|
|
|
SQL Server 2005 Seccurity (Collation)