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.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 Create User from Windows

Author  Topic 

Nagac
Starting Member

5 Posts

Posted - 2015-03-24 : 16:08:00
Hi

I 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 Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

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.



Thanks
Naga

Go to Top of Page

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 Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

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
Go to Top of Page

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 Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page
   

- Advertisement -