<div>
Hi,<br />
<br />
Create a login as a SQL login, and specify the username and password.<br />
<br />
HTH<br />
&nbsp; David
</div>


Hi,

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

HTH
  David

<div>
 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.<br />
<br />
<br />
<br />

</div>


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.





<div>
<div class="content wysiwyg-content">
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? <br />
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).<br />
<br />

</div>
</div>


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).



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

The .NET Framework is not specific to any one programming language; rather, it includes a library of functions that allows developers to rapidly build applications. Several supported languages include C#, VB.NET, C++ or ASP.NET.

.NET Programming

Windows Server 2003 was based on Windows XP and was released in four editions: Web, Standard, Enterprise and Datacenter. It also had derivative versions for clusters, storage and Microsoft’s Small Business Server. Important upgrades included integrating Internet Information Services (IIS), improvements to Active Directory (AD) and Group Policy (GP), and the migration to Automated System Recovery (ASR).

Windows Server 2003

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.