• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 247
  • Last Modified:

SQL login not working after XoSoft failover

We are replicating our SQL server database data using xoSoft Replication. While we were testing the failover scenario We noticed that data is replicated along with windows login but where ever we have SQl logins none of those logins work.

I thought it could be issue of SIDs and issued sp_change_users_login @Action='update_one', @UserNamePattern=, @LoginName=;

But still when i login using SQL logins I cannot access data.

Any idea how to fix this data?
0
vrao19
Asked:
vrao19
  • 4
  • 2
1 Solution
 
CboudrozCommented:
did you move the user at the server level?

if not you can do it like this:
http://support.microsoft.com/kb/246133


if yes you can try to fix the SID assosiation by this command:

execute sp_change_users_login 'auto_fix', 'UserName'

if still not working let me know what's the error message.

0
 
vrao19Author Commented:
The xoSoft replicated the server level login. I have executed the above command and this is not fixing the problem.

thanks
0
 
Racim BOUDJAKDJIDatabase Architect - Dba - Data ScientistCommented:
does xosoft support replicating database/object level priviledges replication.  If not, you'd better be using native SQL replication or database mirroring
0
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
vrao19Author Commented:
How will i know does xosoft support replicating database/object level priviledges replication?
0
 
Racim BOUDJAKDJIDatabase Architect - Dba - Data ScientistCommented:
I do not know.  I use only native replication.
0
 
vrao19Author Commented:
Found my mistake. I didnot had the SQL server under mixed mode..I know so dumb..but got resolved.
0
 
vrao19Author Commented:
Sql server in Mixed mode
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now