market, and have a question concerning configuration. My
user interface is built in ADO.Net and VB7, and this is
the part I would like to sell. The end user would use
this UI to access a SQL Server database that I would have
at my location, on my own domain. Is this concept
feasible? Is it possible to grant access on SQL Server to
users from different domains? I am using Windows
Integrated Authentication on my server, and have to as it
is being used with BizTalk Server. Thanks.
JTHi JT,
Thank you for using MSDN Newsgroup! It's my pleasure to assist you with
your issue.
As my understanding of your question, you want to know if you client
application in their domain could access the SQL Server in another domain,
right. If I misunderstood, please feel free to let me know.
To access the SQL Server across domain is possible.
At first, make sure the connection between this two computers is OK.
Please refer to this article:
http://support.microsoft.com/?id=238949
You can test the application environment by the following steps to test
the connectivity:
To test general connectivity:
PING < SQL_Server ip>
To test we can connect to default SQL Server port 1433:
TELNET < SQL_Server ip> 1433
If we can connect, the screen will go blank. The server is awaiting more
commands. Hit any key to return.
If we CANNOT connect, you will get an error:
"Connecting To < ip > ..Could not open connection to the host, on port 1433
No connection could be made because the target machine actively refused
it."
NOTE:
Port 1433 is the default port number for SQL Server. You can check the
actual port number by Server Network Utility. You can get the actual port
number in use by check the properties of TCP/IP (which should be in the
"Enabled Protocols").
Then, use your Query Analyzer to check if it can access the database from
one domain to another.
For information you could refer to or ADO.NET programming, you can refer
to the following materials or ask questions in related newsgroup:
http://support.microsoft.com/?id=216415
http://msdn.microsoft.com/library/d...-us/dnauth/html
/dnauth_security.asp
http://support.microsoft.com/defaul...microsoft.com:
80/support/kb/articles/Q193/1/35.ASP&NoWebContent=1
http://support.microsoft.com/defaul...b;en-us;q176379
Hope this answered your questions. If you still have questions, please feel
free to post new message here and I am ready to help.
Best regards
Baisong Wei
Microsoft Online Support
----
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only. Thanks.|||Thanks Baisong,
What type of Authentication does the distant user need to
use? Is it possible for them to use Windows Auth, or do
the need to use SQL Server Auth? Thanks.
JT
quote:
>--Original Message--
>Hi JT,
>Thank you for using MSDN Newsgroup! It's my pleasure to
assist you with
quote:
>your issue.
>As my understanding of your question, you want to know if
you client
quote:
>application in their domain could access the SQL Server
in another domain,
quote:
>right. If I misunderstood, please feel free to let me
know.
quote:
>To access the SQL Server across domain is possible.
>At first, make sure the connection between this two
computers is OK.
quote:
>Please refer to this article:
>http://support.microsoft.com/?id=238949
>You can test the application environment by the
following steps to test
quote:
>the connectivity:
>To test general connectivity:
> PING < SQL_Server ip>
>To test we can connect to default SQL Server port 1433:
> TELNET < SQL_Server ip> 1433
>If we can connect, the screen will go blank. The server
is awaiting more
quote:
>commands. Hit any key to return.
>If we CANNOT connect, you will get an error:
>"Connecting To < ip > ..Could not open connection to the
host, on port 1433
quote:
> No connection could be made because the target machine
actively refused
quote:
>it."
>NOTE:
>Port 1433 is the default port number for SQL Server. You
can check the
quote:
>actual port number by Server Network Utility. You can get
the actual port
quote:
>number in use by check the properties of TCP/IP (which
should be in the
quote:
>"Enabled Protocols").
>Then, use your Query Analyzer to check if it can access
the database from
quote:
>one domain to another.
>For information you could refer to or ADO.NET
programming, you can refer
quote:
>to the following materials or ask questions in related
newsgroup:
quote:
>http://support.microsoft.com/?id=216415
>http://msdn.microsoft.com/library/default.asp?
url=/library/en-us/dnauth/html
quote:
>/dnauth_security.asp
>http://support.microsoft.com/default.aspx?
scid=http://support.microsoft.com:
quote:
>80/support/kb/articles/Q193/1/35.ASP&NoWebContent=1
>http://support.microsoft.com/default.aspx?scid=kb;en-
us;q176379
quote:
>Hope this answered your questions. If you still have
questions, please feel
quote:
>free to post new message here and I am ready to help.
>
>Best regards
>Baisong Wei
>Microsoft Online Support
>----
>Get Secure! - www.microsoft.com/security
>This posting is provided "as is" with no warranties and
confers no rights.
quote:|||Hi JT,
>Please reply to newsgroups only. Thanks.
>
>
>.
>
Thank you for using MSDN Newsgroup! It's my pleasure to assist you with
your issue.
Both Windows authentication and SQL Server authentication could be used
when your application access the SQL Server across domains. For Windows
Authentication Mode, when the domain that the SQL Server runs in trust the
domain of the application, it can access the SQL Server. For SQL
Authentication Mode, no relation with domain conception, you could add the
SQL Server account and your application could access the SQL Server through
IP.
Please refer to this article, which provide you detailed information of
programming:
HOW TO: Set Up SQL Server with Proxy Server
http://support.microsoft.com/defaul...kb;EN-US;216415
INF: TCP Ports Needed for Communication to SQL Server Through a Firewall
http://support.microsoft.com/?id=287932
HOWTO: Use ADO to Connect to a SQL Server That Is Behind a Firewall
http://support.microsoft.com/defaul...kb;EN-US;269882
Connecting to a SQL Server Data Source
http://msdn.microsoft.com/library/d...-us/adosql/adop
rg01_0ahx.asp
INF: Authentication Methods for Connections to SQL Server in Active Server
Pages
http://support.microsoft.com/?id=247931
Hope this information will be useful to your concern. If you still have
question, please feel free to post new message here and I am ready to help!
Best regards
Baisong Wei
Microsoft Online Support
----
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only. Thanks.|||Thank you very much.
JT
quote:
>--Original Message--
>Hi JT,
>Thank you for using MSDN Newsgroup! It's my pleasure to
assist you with
quote:
>your issue.
>Both Windows authentication and SQL Server
authentication could be used
quote:
>when your application access the SQL Server across
domains. For Windows
quote:
>Authentication Mode, when the domain that the SQL Server
runs in trust the
quote:
>domain of the application, it can access the SQL Server.
For SQL
quote:
>Authentication Mode, no relation with domain conception,
you could add the
quote:
>SQL Server account and your application could access the
SQL Server through
quote:
>IP.
>Please refer to this article, which provide you detailed
information of
quote:
>programming:
>HOW TO: Set Up SQL Server with Proxy Server
>http://support.microsoft.com/default.aspx?scid=kb;EN-
US;216415
quote:
>INF: TCP Ports Needed for Communication to SQL Server
Through a Firewall
quote:
>http://support.microsoft.com/?id=287932
>HOWTO: Use ADO to Connect to a SQL Server That Is Behind
a Firewall
quote:
>http://support.microsoft.com/default.aspx?scid=kb;EN-
US;269882
quote:
>Connecting to a SQL Server Data Source
>http://msdn.microsoft.com/library/default.asp?
url=/library/en-us/adosql/adop
quote:
>rg01_0ahx.asp
>INF: Authentication Methods for Connections to SQL
Server in Active Server
quote:
>Pages
>http://support.microsoft.com/?id=247931
>Hope this information will be useful to your concern. If
you still have
quote:
>question, please feel free to post new message here and
I am ready to help!
quote:
>Best regards
>Baisong Wei
>Microsoft Online Support
>----
>Get Secure! - www.microsoft.com/security
>This posting is provided "as is" with no warranties and
confers no rights.
quote:
>Please reply to newsgroups only. Thanks.
>.
>
No comments:
Post a Comment