Re: How to connect to SQL from machine without domain
- From: Marcin <TempNospam000@xxxxxxxxxxxxx>
- Date: Thu, 02 Nov 2006 13:46:03 +0100
Hello Luke,
thank you for your explanation!
Best Regards
Marcin
Luke Zhang [MSFT] napisał(a):
Hello Marcin,.
I think SQL authentication is the most proper solution for such an environment (without a trust domain). We cannot specify the user name as "domain/useraccount" in the connection string. Only SQL account is supported here.
A work around is to create a "mirror" account on both database server. For example, create an local account "user1" on the database server ( in the domain) and also same account "user1" on the client (in the workgroup), and also leave their password as same.Then on the client computer logon as "user1" and execute the VB script. The connection string should be like:
sConnectionString = "data source=MyServer;initial catalog=NorthWind;integrated security=SSPI;persist security info=False;";
Sincerely,
Luke Zhang
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues where an initial response from the community or a Microsoft Support Engineer within 1 business day is acceptable. Please note that each follow up response may take approximately 2 business days as the support professional working with you may need further investigation to reach the most efficient resolution. The offering is not appropriate for situations that require urgent, real-time or phone-based interactions or complex project analysis and dump analysis issues. Issues of this nature are best handled working with a dedicated Microsoft Support Engineer by contacting Microsoft Customer Support Services (CSS) at http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
- References:
- RE: How to connect to SQL from machine without domain
- From: Luke Zhang [MSFT]
- RE: How to connect to SQL from machine without domain
- Prev by Date: Re: Problem with mmc console folder creation
- Next by Date: Re: Displaying Script Status Or Counter
- Previous by thread: RE: How to connect to SQL from machine without domain
- Next by thread: Re: My new Script Library - opinions please
- Index(es):
Relevant Pages
|
