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 |
|
Nagac
Starting Member
5 Posts |
 Posted - 2015-03-24 : 16:08:00
|
| HiI have a requirement to create user in Sql Server using the user id which was part of Domain(Doman\username) and the user should be able to login to Sql Server either sql authentication/windows authenticaiton.Can someone please advise how to achieve this?Thanks |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2015-03-24 : 16:24:37
|
| Add the domain account to SQL Server, grant the appropriate access and tell them to specify Windows authentication. Next tell them SQL authentication is not recommended for security reasons, and you can't grant that.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
 |
|
|
Nagac
Starting Member
5 Posts |
Posted - 2015-03-26 : 08:14:37
|
| Thanks tkizer for your response,Yes, you are true. But I am using this userid as batch id and we are going to use this in RedGate Backup software to take the backup's.It gives VDI access related error. I thought its because of lacking sql server authentication.ThanksNaga |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2015-03-26 : 13:22:49
|
| RedGate SQL Backup supports Windows authentication just fine. We used the product at my last job.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
|
|
|
Nagac
Starting Member
5 Posts |
Posted - 2015-03-26 : 13:46:21
|
| Do you have any idea how to resolve this issue with Red Gate?SQLVDI: Loc=CVDS::CreateEx. Desc=Create Memory. ErrorCode=(5)Access is denied. . Process=5356. Thread=1612. Client. Instance=. VD=Global\\SQLBACKUP_156C4973-E676-4BE9-B29A-66C355EA5276_SQLVDIMemoryName_0. Script works fine when I schedule via Task Scheduler, however it doesn't work when I manually execute it using the same user id in both the cases.I am using domain account as userid here |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2015-03-26 : 14:10:26
|
| That's a permissions issue. If it doesn't work when you manually execute it, then I would assume the permission issue is with your account.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
|
|
|
|
|
|
Create User from Windows