I just started as a consultant with a company who won't allow my notebook to
join the domain. No biggee - I can understand the security concerns. I am
able to get on the network and can Remote Desktop to the SQL Servers I need
to get to. However, life would be a heck of a lot better if I could map the
servers in EM. The problem is that the only user id I have in SQL is my
Windows id, not a local SQL Server id. And since I'm logged into my
notebook using cached credentials from a different domain, I can't register
the server in EM. I've read an article about using "net use \\<server>\ipc$
/user:<serverdomain>\<userid> <password>" and I was able to successfully run
this in a command window. I just don't really understand what it did for
me - because I still can't connect to the server in EM.
Is it possible to do what I want to do? If a solution is available in
Yukon, that would be acceptable too.
Thanks, AndreAndre,
you might try to start EM with the "run as" option, but I doubt it will
work. As an alternative you could try using the WebAdmin utility. It's
more limited than EM, but for most tasks it would be sufficient.
You can download it at
http://www.microsoft.com/downloads/...&displaylang=en
After install make sure you copy the updated
WebUIValidation.js file from
WINDOWS\Microsoft.NET\Framework\v1.1.4322
\ASP.NETClientFiles into {SQL Web Administrator
installation path}\Web\aspnet_client\system_web\1_1_4
322\
otherwise the programm hangs when you click the 'login' button.
Hope this helps
M|||Sorry, me again, must be the lack of coffee, but why don't you just
register the server using your SQL login ? Even though the server is in
a different domain this should work as long as your machine can resolve
the name.
M|||Hi,
as suggested try using sql login, or you could add / map yr windows login to
sql fixed role so that it will works for you.
regards|||I don't have a SQL login - only a Windows login that has been granted access
to SQL.
Andre
"MarkusB" <m.bohse@.quest-consultants.com> wrote in message
news:1129188096.681173.270080@.g49g2000cwa.googlegroups.com...
> Sorry, me again, must be the lack of coffee, but why don't you just
> register the server using your SQL login ? Even though the server is in
> a different domain this should work as long as your machine can resolve
> the name.
> M
>|||I tried to use the WebAdmin utility but I'm not getting it to work. Even
though I copied the file you mentioned, I'm never able to connect to sql -
even my local installation.
And even if I was able to get that to work, it still looks like the only
ways of connecting is using trusted or sql credentials. Unless I can trick
it by selecting sql credentials then typing in domain\username, I'm not sure
this would help me login to a sql server in another domain.
Any tips you have are appreciated.
Thanks, Andre|||Hi,
are you able to login and do work using QA !? what type of work you wants
to accomplish
Regards|||> are you able to login and do work using QA !? what type of work you
> wants
> to accomplish
No, I'm not able to. I want to register EM, be able to login to QA, and run
Profiler. I don't have a sql login and am not in the domain - so I can't
use trusted logins.
Andre|||Hi,
then you must ensure that you have proper privillages ,
using sp_adduser to add your users to fixeddb role,
to ensure the associated role for yr user get script from :
http://www.sql-server-performance.c...?TOPIC_ID=10504
HTH
Regards
Tuesday, March 6, 2012
Access SQL Server from Stand-Alone PC with Windows Authentication
I have a PC that is not joined to the domain. I want to be able to access
our SQL Server from it, but it is my active directory domain account that ha
s
access. How can I gain access to the SQL Server via Enterprise Manager or
Query Analyzer?Hello,
If the machine is in a workgroup, SQL server machine is in the domain, make
sure you can ping the SQL server machine from the machine you log on
successfully via IP address or machine name.
Create a same Local user account both on the machine and the SQL server
machine. The Local user account and password on both machines need to be
same . On the SQL server machine, add the Local user account as the SQL
server logins and grant the user right to access the database. By doing so,
you can access the SQL server via Query Analyzer with Windows
authentication.
Or you can access the SQL server using a SQL logins via Query Analyzer with
SQL authentication.
I hope the information is helpful.
Sophie Guo
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
========================================
=============
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.
our SQL Server from it, but it is my active directory domain account that ha
s
access. How can I gain access to the SQL Server via Enterprise Manager or
Query Analyzer?Hello,
If the machine is in a workgroup, SQL server machine is in the domain, make
sure you can ping the SQL server machine from the machine you log on
successfully via IP address or machine name.
Create a same Local user account both on the machine and the SQL server
machine. The Local user account and password on both machines need to be
same . On the SQL server machine, add the Local user account as the SQL
server logins and grant the user right to access the database. By doing so,
you can access the SQL server via Query Analyzer with Windows
authentication.
Or you can access the SQL server using a SQL logins via Query Analyzer with
SQL authentication.
I hope the information is helpful.
Sophie Guo
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
========================================
=============
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.
Access SQL Server from SOLARIS.
Hi All,
I heve one system that need access SQL Server 2005.
This system run on SOLARIS 10.
Have any way to do this?
Thanks
Hello Retf,
Microsoft don't supply their own drivers for non-Windows based clients any
longer, so you have to use a 3rd-party product.
To connect to SQL Server from SOLARIS, there are other third party ODBC
drivers for Solaris; and of course, the JDBC driver for SQL Server.
Your choices (in no particular order) are :
1. You could reverse engineer the undocumented TDS protocol yourself.
This
could and does change between versions of SQL Server, so only attempt this
if
you want an on-going maintenance challenge. Several people have done such
reverse engineering for the portions of TDS they needed and have reported
it's
not that difficult. Once such is the FreeTDS project that is reverse
engineering the TDS specification and is currently implementing CTLIB,
DBLIB,
and JDBC interfaces for TDS. ODBC and Perl DBD drivers are planned.
The FreeTDS JDBC driver is a type 4 driver and should work on any JVM. The
CTLIB and DBLIB interfaces are known to compile under AIX, Linux, and
FreeBSD
without any problems. More info from <http://sunsite.unc.edu/freetds/>
and/or
<http://metalab.unc.edu/freetds/index.html>.
The mailing list archive can be viewed at
<http://franklin.oit.unc.edu/cgi-bin/lyris.pl?enter=freetds>. Source-code
can be
downloaded from <ftp://freetds.internetcds.com/pub/freetds_dbd/>
<http://metalab.unc.edu/freetds/index.html>
2. If you can use Java/JDBC then see the "jdbc.txt" FAQ entry for details
of
that
3. The recommended option is that you acquire an ODBC/OLE-DB driver from a
driver vendor that will offer on-going support. However, many ODBC vendors
have either moved from pure client drivers to "3-tier" driver systems which
many people don't want, or they have moved from ODBC into OLE-DB.
Therefore
you may have trouble finding just what you want. (Success and failure
stories
welcome - but be persistent with whichever vendors you talk to - they may
not
be actively advertising what you want, but that doesn't mean they don't
still
have old but working copies of it buried in a cupboard somewhere).
Vendors to try are (in no particular order) :-
OpenLink www.openlinksw.com <http://www.openlinksw.com>
Merant (were Intersolv
<http://www.merant.com/datadirect/products/odbc/Connect/overview.asp>
Visigenic www.visigenic.com <http://www.visigenic.com>
Easysoft www.easysoft.com <http://www.easysoft.com>
(ODBC-ODBC
Bridge)
Applix corp.
4. For other pointers to ODBC/JDBC/OLEDB vendor's :-
<http://ourworld.compuserve.com/homepages/Ken_North/odbcvend.htm>
<http://ourworld.compuserve.com/homepages/Ken_North/jdbcvend.htm>
<http://ourworld.compuserve.com/homepages/Ken_North/oledbven.htm>
<http://www.unixodbc.org>
<http://www.algonet.se/~sommar/mssqlperl/unix.html>
Hope this will be helpful!
Sincerely,
Wei Lu
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.)
|||Hi ,
How is everything going? Please feel free to let me know if you need any
assistance.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
|||Hi,
Im searcheing for 3rdparty component that make it possible, tahnks
"Wei Lu [MSFT]" <weilu@.online.microsoft.com> escreveu na mensagem
news:LvO%23AF%23XHHA.296@.TK2MSFTNGHUB02.phx.gbl...
> Hi ,
> How is everything going? Please feel free to let me know if you need any
> assistance.
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ==================================================
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
I heve one system that need access SQL Server 2005.
This system run on SOLARIS 10.
Have any way to do this?
Thanks
Hello Retf,
Microsoft don't supply their own drivers for non-Windows based clients any
longer, so you have to use a 3rd-party product.
To connect to SQL Server from SOLARIS, there are other third party ODBC
drivers for Solaris; and of course, the JDBC driver for SQL Server.
Your choices (in no particular order) are :
1. You could reverse engineer the undocumented TDS protocol yourself.
This
could and does change between versions of SQL Server, so only attempt this
if
you want an on-going maintenance challenge. Several people have done such
reverse engineering for the portions of TDS they needed and have reported
it's
not that difficult. Once such is the FreeTDS project that is reverse
engineering the TDS specification and is currently implementing CTLIB,
DBLIB,
and JDBC interfaces for TDS. ODBC and Perl DBD drivers are planned.
The FreeTDS JDBC driver is a type 4 driver and should work on any JVM. The
CTLIB and DBLIB interfaces are known to compile under AIX, Linux, and
FreeBSD
without any problems. More info from <http://sunsite.unc.edu/freetds/>
and/or
<http://metalab.unc.edu/freetds/index.html>.
The mailing list archive can be viewed at
<http://franklin.oit.unc.edu/cgi-bin/lyris.pl?enter=freetds>. Source-code
can be
downloaded from <ftp://freetds.internetcds.com/pub/freetds_dbd/>
<http://metalab.unc.edu/freetds/index.html>
2. If you can use Java/JDBC then see the "jdbc.txt" FAQ entry for details
of
that
3. The recommended option is that you acquire an ODBC/OLE-DB driver from a
driver vendor that will offer on-going support. However, many ODBC vendors
have either moved from pure client drivers to "3-tier" driver systems which
many people don't want, or they have moved from ODBC into OLE-DB.
Therefore
you may have trouble finding just what you want. (Success and failure
stories
welcome - but be persistent with whichever vendors you talk to - they may
not
be actively advertising what you want, but that doesn't mean they don't
still
have old but working copies of it buried in a cupboard somewhere).
Vendors to try are (in no particular order) :-
OpenLink www.openlinksw.com <http://www.openlinksw.com>
Merant (were Intersolv
<http://www.merant.com/datadirect/products/odbc/Connect/overview.asp>
Visigenic www.visigenic.com <http://www.visigenic.com>
Easysoft www.easysoft.com <http://www.easysoft.com>
(ODBC-ODBC
Bridge)
Applix corp.
4. For other pointers to ODBC/JDBC/OLEDB vendor's :-
<http://ourworld.compuserve.com/homepages/Ken_North/odbcvend.htm>
<http://ourworld.compuserve.com/homepages/Ken_North/jdbcvend.htm>
<http://ourworld.compuserve.com/homepages/Ken_North/oledbven.htm>
<http://www.unixodbc.org>
<http://www.algonet.se/~sommar/mssqlperl/unix.html>
Hope this will be helpful!
Sincerely,
Wei Lu
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.)
|||Hi ,
How is everything going? Please feel free to let me know if you need any
assistance.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
|||Hi,
Im searcheing for 3rdparty component that make it possible, tahnks
"Wei Lu [MSFT]" <weilu@.online.microsoft.com> escreveu na mensagem
news:LvO%23AF%23XHHA.296@.TK2MSFTNGHUB02.phx.gbl...
> Hi ,
> How is everything going? Please feel free to let me know if you need any
> assistance.
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ==================================================
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ==================================================
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
Saturday, February 25, 2012
Access SQL Server from SOLARIS.
Hi All,
I heve one system that need access SQL Server 2005.
This system run on SOLARIS 10.
Have any way to do this?
ThanksHello Retf,
Microsoft don't supply their own drivers for non-Windows based clients any
longer, so you have to use a 3rd-party product.
To connect to SQL Server from SOLARIS, there are other third party ODBC
drivers for Solaris; and of course, the JDBC driver for SQL Server.
Your choices (in no particular order) are :
1. You could reverse engineer the undocumented TDS protocol yourself.
This
could and does change between versions of SQL Server, so only attempt this
if
you want an on-going maintenance challenge. Several people have done such
reverse engineering for the portions of TDS they needed and have reported
it's
not that difficult. Once such is the FreeTDS project that is reverse
engineering the TDS specification and is currently implementing CTLIB,
DBLIB,
and JDBC interfaces for TDS. ODBC and PERL DBD drivers are planned.
The FreeTDS JDBC driver is a type 4 driver and should work on any JVM. The
CTLIB and DBLIB interfaces are known to compile under AIX, Linux, and
FreeBSD
without any problems. More info from <http://sunsite.unc.edu/freetds/>
and/or
<http://metalab.unc.edu/freetds/index.html>.
The mailing list archive can be viewed at
<http://franklin.oit.unc.edu/cgi-bin...l?enter=freetds>. Source-code
can be
downloaded from <ftp://freetds.internetcds.com/pub/freetds_dbd/>
<http://metalab.unc.edu/freetds/index.html>
2. If you can use Java/JDBC then see the "jdbc.txt" FAQ entry for details
of
that
3. The recommended option is that you acquire an ODBC/OLE-DB driver from a
driver vendor that will offer on-going support. However, many ODBC vendors
have either moved from pure client drivers to "3-tier" driver systems which
many people don't want, or they have moved from ODBC into OLE-DB.
Therefore
you may have trouble finding just what you want. (Success and failure
stories
welcome - but be persistent with whichever vendors you talk to - they may
not
be actively advertising what you want, but that doesn't mean they don't
still
have old but working copies of it buried in a cupboard somewhere).
Vendors to try are (in no particular order) :-
OpenLink www.openlinksw.com <http://www.openlinksw.com>
Merant (were Intersolv
<http://www.merant.com/datadirect/pr...ct/overview.asp>
Visigenic www.visigenic.com <http://www.visigenic.com>
Easysoft www.easysoft.com <http://www.easysoft.com>
(ODBC-ODBC
Bridge)
Applix corp.
4. For other pointers to ODBC/JDBC/OLEDB vendor's :-
<http://ourworld.compuserve.com/home...th/odbcvend.htm>
<http://ourworld.compuserve.com/home...th/jdbcvend.htm>
<http://ourworld.compuserve.com/home...th/oledbven.htm>
<http://www.unixodbc.org>
<http://www.algonet.se/~sommar/mssqlperl/unix.html>
Hope this will be helpful!
Sincerely,
Wei Lu
Microsoft Online Community Support
========================================
==========
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscript...ault.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/subscript...t/default.aspx.
========================================
==========
(This posting is provided "AS IS", with no warranties, and confers no
rights.)|||Hi ,
How is everything going? Please feel free to let me know if you need any
assistance.
Sincerely,
Wei Lu
Microsoft Online Community Support
========================================
==========
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
==========
This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi,
Im searcheing for 3rdparty component that make it possible, tahnks
"Wei Lu [MSFT]" <weilu@.online.microsoft.com> escreveu na mensagem
news:LvO%23AF%23XHHA.296@.TK2MSFTNGHUB02.phx.gbl...
> Hi ,
> How is everything going? Please feel free to let me know if you need any
> assistance.
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ========================================
==========
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ========================================
==========
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
I heve one system that need access SQL Server 2005.
This system run on SOLARIS 10.
Have any way to do this?
ThanksHello Retf,
Microsoft don't supply their own drivers for non-Windows based clients any
longer, so you have to use a 3rd-party product.
To connect to SQL Server from SOLARIS, there are other third party ODBC
drivers for Solaris; and of course, the JDBC driver for SQL Server.
Your choices (in no particular order) are :
1. You could reverse engineer the undocumented TDS protocol yourself.
This
could and does change between versions of SQL Server, so only attempt this
if
you want an on-going maintenance challenge. Several people have done such
reverse engineering for the portions of TDS they needed and have reported
it's
not that difficult. Once such is the FreeTDS project that is reverse
engineering the TDS specification and is currently implementing CTLIB,
DBLIB,
and JDBC interfaces for TDS. ODBC and PERL DBD drivers are planned.
The FreeTDS JDBC driver is a type 4 driver and should work on any JVM. The
CTLIB and DBLIB interfaces are known to compile under AIX, Linux, and
FreeBSD
without any problems. More info from <http://sunsite.unc.edu/freetds/>
and/or
<http://metalab.unc.edu/freetds/index.html>.
The mailing list archive can be viewed at
<http://franklin.oit.unc.edu/cgi-bin...l?enter=freetds>. Source-code
can be
downloaded from <ftp://freetds.internetcds.com/pub/freetds_dbd/>
<http://metalab.unc.edu/freetds/index.html>
2. If you can use Java/JDBC then see the "jdbc.txt" FAQ entry for details
of
that
3. The recommended option is that you acquire an ODBC/OLE-DB driver from a
driver vendor that will offer on-going support. However, many ODBC vendors
have either moved from pure client drivers to "3-tier" driver systems which
many people don't want, or they have moved from ODBC into OLE-DB.
Therefore
you may have trouble finding just what you want. (Success and failure
stories
welcome - but be persistent with whichever vendors you talk to - they may
not
be actively advertising what you want, but that doesn't mean they don't
still
have old but working copies of it buried in a cupboard somewhere).
Vendors to try are (in no particular order) :-
OpenLink www.openlinksw.com <http://www.openlinksw.com>
Merant (were Intersolv
<http://www.merant.com/datadirect/pr...ct/overview.asp>
Visigenic www.visigenic.com <http://www.visigenic.com>
Easysoft www.easysoft.com <http://www.easysoft.com>
(ODBC-ODBC
Bridge)
Applix corp.
4. For other pointers to ODBC/JDBC/OLEDB vendor's :-
<http://ourworld.compuserve.com/home...th/odbcvend.htm>
<http://ourworld.compuserve.com/home...th/jdbcvend.htm>
<http://ourworld.compuserve.com/home...th/oledbven.htm>
<http://www.unixodbc.org>
<http://www.algonet.se/~sommar/mssqlperl/unix.html>
Hope this will be helpful!
Sincerely,
Wei Lu
Microsoft Online Community Support
========================================
==========
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscript...ault.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/subscript...t/default.aspx.
========================================
==========
(This posting is provided "AS IS", with no warranties, and confers no
rights.)|||Hi ,
How is everything going? Please feel free to let me know if you need any
assistance.
Sincerely,
Wei Lu
Microsoft Online Community Support
========================================
==========
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
========================================
==========
This posting is provided "AS IS" with no warranties, and confers no rights.|||Hi,
Im searcheing for 3rdparty component that make it possible, tahnks
"Wei Lu [MSFT]" <weilu@.online.microsoft.com> escreveu na mensagem
news:LvO%23AF%23XHHA.296@.TK2MSFTNGHUB02.phx.gbl...
> Hi ,
> How is everything going? Please feel free to let me know if you need any
> assistance.
> Sincerely,
> Wei Lu
> Microsoft Online Community Support
> ========================================
==========
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
> ========================================
==========
> This posting is provided "AS IS" with no warranties, and confers no
> rights.
>
Access SQL server from AS/400 DB2
Hi everyone,
I need to find a way to connect from AS/400 DB2 to SQL Server database. Is
there any way to do this? I know how to go the other way.
I see that there is DB2 Information Integrator but it seems to be very
pricey.
Thank you for any links!Hi Farmer,
From your descriptions, I understood that you would like to use SQL Server
as "Linked Server" in AS/400 DB2. Have I understood you? Correct me if I
was wrong.
Based on my scope, unfortuantely, SQL Server has no such funcationality to
do this. Anyway, I will do more research try to find whether IBM DB2 will
provide such funcaitonality. Please understand that I have rather limited
DB2 knowledge
Thank you for your patience and corperation. If you have any questions or
concerns, don't hesitate to let me know. We are here to be of assistance!
Sincerely yours,
Mingqing Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---
Introduction to Yukon! - http://www.microsoft.com/sql/yukon
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!|||Hi Farmer,
Thanks for your patience and corperation!
I searched in the DB2 forum and here is the link I used with search key,
connect sql server. It seems there are many useful information there and
hope it helps
http://www-106.ibm.com/developerwor...arch=true&cat=2
4&forum=339&q=connect+sql+server&forums=cid19&Go.x=12&Go.y=9
Moreover, don't hesitate to let me know whether there is anything I could
do to help on SQL Server side.
Sincerely yours,
Mingqing Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---
Introduction to Yukon! - http://www.microsoft.com/sql/yukon
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!
I need to find a way to connect from AS/400 DB2 to SQL Server database. Is
there any way to do this? I know how to go the other way.
I see that there is DB2 Information Integrator but it seems to be very
pricey.
Thank you for any links!Hi Farmer,
From your descriptions, I understood that you would like to use SQL Server
as "Linked Server" in AS/400 DB2. Have I understood you? Correct me if I
was wrong.
Based on my scope, unfortuantely, SQL Server has no such funcationality to
do this. Anyway, I will do more research try to find whether IBM DB2 will
provide such funcaitonality. Please understand that I have rather limited
DB2 knowledge
Thank you for your patience and corperation. If you have any questions or
concerns, don't hesitate to let me know. We are here to be of assistance!
Sincerely yours,
Mingqing Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---
Introduction to Yukon! - http://www.microsoft.com/sql/yukon
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!|||Hi Farmer,
Thanks for your patience and corperation!
I searched in the DB2 forum and here is the link I used with search key,
connect sql server. It seems there are many useful information there and
hope it helps
http://www-106.ibm.com/developerwor...arch=true&cat=2
4&forum=339&q=connect+sql+server&forums=cid19&Go.x=12&Go.y=9
Moreover, don't hesitate to let me know whether there is anything I could
do to help on SQL Server side.
Sincerely yours,
Mingqing Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
---
Introduction to Yukon! - http://www.microsoft.com/sql/yukon
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!
Access SQL server from AS/400 DB2
Hi everyone,
I need to find a way to connect from AS/400 DB2 to SQL Server database. Is
there any way to do this? I know how to go the other way.
I see that there is DB2 Information Integrator but it seems to be very
pricey.
Thank you for any links!
Hi Farmer,
From your descriptions, I understood that you would like to use SQL Server
as "Linked Server" in AS/400 DB2. Have I understood you? Correct me if I
was wrong.
Based on my scope, unfortuantely, SQL Server has no such funcationality to
do this. Anyway, I will do more research try to find whether IBM DB2 will
provide such funcaitonality. Please understand that I have rather limited
DB2 knowledge
Thank you for your patience and corperation. If you have any questions or
concerns, don't hesitate to let me know. We are here to be of assistance!
Sincerely yours,
Mingqing Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
Introduction to Yukon! - http://www.microsoft.com/sql/yukon
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!
|||Hi Farmer,
Thanks for your patience and corperation!
I searched in the DB2 forum and here is the link I used with search key,
connect sql server. It seems there are many useful information there and
hope it helps
http://www-106.ibm.com/developerwork...rch=true&cat=2
4&forum=339&q=connect+sql+server&forums=cid19&Go.x =12&Go.y=9
Moreover, don't hesitate to let me know whether there is anything I could
do to help on SQL Server side.
Sincerely yours,
Mingqing Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
Introduction to Yukon! - http://www.microsoft.com/sql/yukon
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!
I need to find a way to connect from AS/400 DB2 to SQL Server database. Is
there any way to do this? I know how to go the other way.
I see that there is DB2 Information Integrator but it seems to be very
pricey.
Thank you for any links!
Hi Farmer,
From your descriptions, I understood that you would like to use SQL Server
as "Linked Server" in AS/400 DB2. Have I understood you? Correct me if I
was wrong.
Based on my scope, unfortuantely, SQL Server has no such funcationality to
do this. Anyway, I will do more research try to find whether IBM DB2 will
provide such funcaitonality. Please understand that I have rather limited
DB2 knowledge
Thank you for your patience and corperation. If you have any questions or
concerns, don't hesitate to let me know. We are here to be of assistance!
Sincerely yours,
Mingqing Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
Introduction to Yukon! - http://www.microsoft.com/sql/yukon
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!
|||Hi Farmer,
Thanks for your patience and corperation!
I searched in the DB2 forum and here is the link I used with search key,
connect sql server. It seems there are many useful information there and
hope it helps
http://www-106.ibm.com/developerwork...rch=true&cat=2
4&forum=339&q=connect+sql+server&forums=cid19&Go.x =12&Go.y=9
Moreover, don't hesitate to let me know whether there is anything I could
do to help on SQL Server side.
Sincerely yours,
Mingqing Cheng
Online Partner Support Specialist
Partner Support Group
Microsoft Global Technical Support Center
Introduction to Yukon! - http://www.microsoft.com/sql/yukon
This posting is provided "as is" with no warranties and confers no rights.
Please reply to newsgroups only, many thanks!
access SQL Server from application
Hi,
I have recently transfered data from MS Access to MS SQL Server 2000 and created user interface in MS Access Project (ADP). Now I need to secure the data on server and want to access it ONLY through interface I created in MS Access. Every user has to log in the application (user id and password). Users may have the same access rights to the server (so maybe just one account or whatever I need for all of them). Can anyone advice me how to set it up? To access sql server from MS Access I am using ADO.
Thank you.
djLookup "Application Roles" in Books Online.
But be aware that it is better practice to limit your to establish security at the data level than the application level. Establishing Application Roles is no substitute for making sure that your database is locked down.|||Yes, I agree. I have no experience with SQL Server. In MS Access it was easy. So, how to lock down database. What I should create there to secure data? Any password? And then I need to access data through ADO. There is connection string where I have to pass a password.
Could you help me to clarify that.
Thanks
dj
I have recently transfered data from MS Access to MS SQL Server 2000 and created user interface in MS Access Project (ADP). Now I need to secure the data on server and want to access it ONLY through interface I created in MS Access. Every user has to log in the application (user id and password). Users may have the same access rights to the server (so maybe just one account or whatever I need for all of them). Can anyone advice me how to set it up? To access sql server from MS Access I am using ADO.
Thank you.
djLookup "Application Roles" in Books Online.
But be aware that it is better practice to limit your to establish security at the data level than the application level. Establishing Application Roles is no substitute for making sure that your database is locked down.|||Yes, I agree. I have no experience with SQL Server. In MS Access it was easy. So, how to lock down database. What I should create there to secure data? Any password? And then I need to access data through ADO. There is connection string where I have to pass a password.
Could you help me to clarify that.
Thanks
dj
Subscribe to:
Posts (Atom)