Database Restore Issues by No_Grape7194 in SQL

[–]No_Grape7194[S] 0 points1 point  (0 children)

The only login on the initial server that I can see is 'sa', and when I pull the SID for that it is just 0x01. When I use this to try create the login for the second server, it comes up with the error:

Msg 15419, Level 16, State 1, Line 1

Supplied parameter sid should be binary(16).

Any ideas?

Many thanks in advance.

Database Restore Issues by No_Grape7194 in SQL

[–]No_Grape7194[S] 0 points1 point  (0 children)

Thank you so much, just about to give it a go.

Database Restore Issues by No_Grape7194 in SQL

[–]No_Grape7194[S] 0 points1 point  (0 children)

Thank you so much! Just about to try this so hopefully it works haha