• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 204
  • Last Modified:

how do you add non-domain user accounts to SQL2005 Standard ?

Is there any way to add a user from another server (ie an ASP.NET user account) to SQL 2005 without both servers being on a domain?
Basically, we have standalone webservers that are in a workgroup (no PDC), but SQL2005 never lists any machines but their own (to pick windows accounts).

0
bd9000
Asked:
bd9000
1 Solution
 
David ToddSenior DBACommented:
Hi,

Create a login as a SQL login, and specify the username and password.

HTH
  David
0
 
iCoreKCCommented:
There is not a way to add a user from another computer's local accounts in the way that you described.  

Remember that a Domain is a Security boundary.  Each Domain will have its own accounts database and unless a trust is set up, that Domain is restricted to its own accounts and cannot even see other accounts.



0
 
JulianvaCommented:
try to connect from sqlserver to the webserver by ipaddress but with sql authentication. i am assuming that the webservers and sql server is on the workgroup.



0

Featured Post

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now