I couldn’t connect to the sql server instance (10.192.130.80\development2 and
10.192.130.80\development3) remotely on enterprise manager and query
analyzer. The error is sql server does not exist or access denied. I setup
well in the client network utility and put sever name and port number in it.
But I still got same error. Could someone give me some tips what reason is?
thanks.
Can you ping those servers?
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"Iter" <Iter@.discussions.microsoft.com> wrote in message
news:39D7F4E4-6CA8-4588-8FB7-2758A1D4A83F@.microsoft.com...
>I couldn't connect to the sql server instance (10.192.130.80\development2
>and
> 10.192.130.80\development3) remotely on enterprise manager and query
> analyzer. The error is sql server does not exist or access denied. I setup
> well in the client network utility and put sever name and port number in
> it.
> But I still got same error. Could someone give me some tips what reason
> is?
> thanks.
>
|||Yes, I can Ping them.
"Arnie Rowland" wrote:
> Can you ping those servers?
> --
> Arnie Rowland, Ph.D.
> Westwood Consulting, Inc
> Most good judgment comes from experience.
> Most experience comes from bad judgment.
> - Anonymous
> You can't help someone get up a hill without getting a little closer to the
> top yourself.
> - H. Norman Schwarzkopf
>
> "Iter" <Iter@.discussions.microsoft.com> wrote in message
> news:39D7F4E4-6CA8-4588-8FB7-2758A1D4A83F@.microsoft.com...
>
>
|||Is the SQL Server listening on TCP?
Check the SQL ERRORLOG for a line like:
SQL Server listening on tcp, shared memory, named pipes
Kevin Hill
3NF Consulting
http://www.3nf-inc.com/NewsGroups.htm
Real-world stuff I run across with SQL Server:
http://kevin3nf.blogspot.com
"Iter" <Iter@.discussions.microsoft.com> wrote in message
news:39D7F4E4-6CA8-4588-8FB7-2758A1D4A83F@.microsoft.com...
>I couldn't connect to the sql server instance (10.192.130.80\development2
>and
> 10.192.130.80\development3) remotely on enterprise manager and query
> analyzer. The error is sql server does not exist or access denied. I setup
> well in the client network utility and put sever name and port number in
> it.
> But I still got same error. Could someone give me some tips what reason
> is?
> thanks.
>
Showing posts with label remotely. Show all posts
Showing posts with label remotely. Show all posts
Sunday, 25 March 2012
connect to remote sql server failed
I couldn’t connect to the sql server instance (10.192.130.80\development2
and
10.192.130.80\development3) remotely on enterprise manager and query
analyzer. The error is sql server does not exist or access denied. I setup
well in the client network utility and put sever name and port number in it.
But I still got same error. Could someone give me some tips what reason is?
thanks.Can you ping those servers?
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"Iter" <Iter@.discussions.microsoft.com> wrote in message
news:39D7F4E4-6CA8-4588-8FB7-2758A1D4A83F@.microsoft.com...
>I couldn't connect to the sql server instance (10.192.130.80\development2
>and
> 10.192.130.80\development3) remotely on enterprise manager and query
> analyzer. The error is sql server does not exist or access denied. I setup
> well in the client network utility and put sever name and port number in
> it.
> But I still got same error. Could someone give me some tips what reason
> is?
> thanks.
>|||Yes, I can Ping them.
"Arnie Rowland" wrote:
> Can you ping those servers?
> --
> Arnie Rowland, Ph.D.
> Westwood Consulting, Inc
> Most good judgment comes from experience.
> Most experience comes from bad judgment.
> - Anonymous
> You can't help someone get up a hill without getting a little closer to th
e
> top yourself.
> - H. Norman Schwarzkopf
>
> "Iter" <Iter@.discussions.microsoft.com> wrote in message
> news:39D7F4E4-6CA8-4588-8FB7-2758A1D4A83F@.microsoft.com...
>
>|||Is the SQL Server listening on TCP?
Check the SQL ERRORLOG for a line like:
SQL Server listening on tcp, shared memory, named pipes
Kevin Hill
3NF Consulting
http://www.3nf-inc.com/NewsGroups.htm
Real-world stuff I run across with SQL Server:
http://kevin3nf.blogspot.com
"Iter" <Iter@.discussions.microsoft.com> wrote in message
news:39D7F4E4-6CA8-4588-8FB7-2758A1D4A83F@.microsoft.com...
>I couldn't connect to the sql server instance (10.192.130.80\development2
>and
> 10.192.130.80\development3) remotely on enterprise manager and query
> analyzer. The error is sql server does not exist or access denied. I setup
> well in the client network utility and put sever name and port number in
> it.
> But I still got same error. Could someone give me some tips what reason
> is?
> thanks.
>sqlsql
and
10.192.130.80\development3) remotely on enterprise manager and query
analyzer. The error is sql server does not exist or access denied. I setup
well in the client network utility and put sever name and port number in it.
But I still got same error. Could someone give me some tips what reason is?
thanks.Can you ping those servers?
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"Iter" <Iter@.discussions.microsoft.com> wrote in message
news:39D7F4E4-6CA8-4588-8FB7-2758A1D4A83F@.microsoft.com...
>I couldn't connect to the sql server instance (10.192.130.80\development2
>and
> 10.192.130.80\development3) remotely on enterprise manager and query
> analyzer. The error is sql server does not exist or access denied. I setup
> well in the client network utility and put sever name and port number in
> it.
> But I still got same error. Could someone give me some tips what reason
> is?
> thanks.
>|||Yes, I can Ping them.
"Arnie Rowland" wrote:
> Can you ping those servers?
> --
> Arnie Rowland, Ph.D.
> Westwood Consulting, Inc
> Most good judgment comes from experience.
> Most experience comes from bad judgment.
> - Anonymous
> You can't help someone get up a hill without getting a little closer to th
e
> top yourself.
> - H. Norman Schwarzkopf
>
> "Iter" <Iter@.discussions.microsoft.com> wrote in message
> news:39D7F4E4-6CA8-4588-8FB7-2758A1D4A83F@.microsoft.com...
>
>|||Is the SQL Server listening on TCP?
Check the SQL ERRORLOG for a line like:
SQL Server listening on tcp, shared memory, named pipes
Kevin Hill
3NF Consulting
http://www.3nf-inc.com/NewsGroups.htm
Real-world stuff I run across with SQL Server:
http://kevin3nf.blogspot.com
"Iter" <Iter@.discussions.microsoft.com> wrote in message
news:39D7F4E4-6CA8-4588-8FB7-2758A1D4A83F@.microsoft.com...
>I couldn't connect to the sql server instance (10.192.130.80\development2
>and
> 10.192.130.80\development3) remotely on enterprise manager and query
> analyzer. The error is sql server does not exist or access denied. I setup
> well in the client network utility and put sever name and port number in
> it.
> But I still got same error. Could someone give me some tips what reason
> is?
> thanks.
>sqlsql
Thursday, 22 March 2012
Connect to MSDE/SBS2003 remotely
I am writing a small app for a company using Access (adp) and MSDE. The MSDE
is installed on a Small Business Server and I have been told it is a
complete standard setup.
First question: I know MSDE is running because I recognise the icon in the
system tray. Also, locally I can connect to the MSDE so I know it is there.
However, from previous installations of MSDE I seem to recall that although
you don't get Enterprise Manager, Query Analyzer etc with MSDE, you do get
Client Network Utility etc. I have not been able to locate *any* utilities
for MSDE on the server. Is this normal?
This brings me onto my main question. I expect to do some alterations to the
database after the initial installation, and it is not feasible for me to
make a trip to the client for every alteration. I would therefore like to be
able to use Enterprise Manager that I have locally to connect to the remote
SBS/MSDE. How do I do that under the circumstances? I know they have a Cisco
firewall in place.
Any pointers in the right direction would be much appreciated.
What I have found out so far is that I need to check if Server Network
Utility (svrnetcn.exe) is present and has enabled TCP/IP protocol. But I am
sure that is not the end of the story...
"bobby" <bobby@.bobbys.com> wrote in message
news:%23arsRdOjEHA.3612@.TK2MSFTNGP12.phx.gbl...
> I am writing a small app for a company using Access (adp) and MSDE. The
MSDE
> is installed on a Small Business Server and I have been told it is a
> complete standard setup.
> First question: I know MSDE is running because I recognise the icon in the
> system tray. Also, locally I can connect to the MSDE so I know it is
there.
> However, from previous installations of MSDE I seem to recall that
although
> you don't get Enterprise Manager, Query Analyzer etc with MSDE, you do get
> Client Network Utility etc. I have not been able to locate *any* utilities
> for MSDE on the server. Is this normal?
> This brings me onto my main question. I expect to do some alterations to
the
> database after the initial installation, and it is not feasible for me to
> make a trip to the client for every alteration. I would therefore like to
be
> able to use Enterprise Manager that I have locally to connect to the
remote
> SBS/MSDE. How do I do that under the circumstances? I know they have a
Cisco
> firewall in place.
> Any pointers in the right direction would be much appreciated.
>
|||MSDE does not ship with any of the graphical utilities that you're used to
seeing. It does ship with a command line utility, osql.exe, that you can use
to manage it, assuming that you're familiar with T-SQL.
As to whether or not you're allowed to use the copy of SQL Server Enterprise
Manager you have to manage it remotely, I doubt it. Please see the FAQ page
at http://www.microsoft.com/sql/msde/howtobuy/msdeuse.asp. The sixth Q & A
is the following:
Q. Can I use SQL Server tools and services in conjunction with MSDE?
A. You can only use SQL Server tools and services in conjunction with
MSDE if you acquired MSDE through SQL Server 2000 (Developer Edition,
Standard Edition, or Enterprise Edition), and if you are using MSDE in
conjunction with a properly licensed copy of SQL Server 2000. Visit the How
to Buy page for information on obtaining a valid SQL Server license.
Note: The tools and services included with SQL Server Developer
Edition may not be used to manage production server environments.
The following utilities are installed by the MSDE setup application
and are provided without restrictions for use with the copy of MSDE that is
installed by your application: bcp.exe, cnfgsvr.exe, dcomscm.exe, osql.exe,
sqlmaint.exe, sqlmangr.exe, scm.exe, sqladhlp.exe, and svrnetcn.exe. The
dtsrun.exe utility is also provided, but can only be used to run existing
Data Transformation Services (DTS) packages against the copy of MSDE
installed by your application; it cannot be used to develop new DTS
packages.
It sounds to me like the small app that you're writing isn't being used in
conjuction with your copy of SQL Server 2000 and thus you won't be allowed
to use SQL Server Enterprise Manager against it.
As always, of course, I'm not a lawyer so you should consult yours. :-)
Sincerely,
Stephen Dybing
This posting is provided "AS IS" with no warranties, and confers no rights.
"bobby" <bobby@.bobbys.com> wrote in message
news:%23arsRdOjEHA.3612@.TK2MSFTNGP12.phx.gbl...
>I am writing a small app for a company using Access (adp) and MSDE. The
>MSDE
> is installed on a Small Business Server and I have been told it is a
> complete standard setup.
> First question: I know MSDE is running because I recognise the icon in the
> system tray. Also, locally I can connect to the MSDE so I know it is
> there.
> However, from previous installations of MSDE I seem to recall that
> although
> you don't get Enterprise Manager, Query Analyzer etc with MSDE, you do get
> Client Network Utility etc. I have not been able to locate *any* utilities
> for MSDE on the server. Is this normal?
> This brings me onto my main question. I expect to do some alterations to
> the
> database after the initial installation, and it is not feasible for me to
> make a trip to the client for every alteration. I would therefore like to
> be
> able to use Enterprise Manager that I have locally to connect to the
> remote
> SBS/MSDE. How do I do that under the circumstances? I know they have a
> Cisco
> firewall in place.
> Any pointers in the right direction would be much appreciated.
>
begin 666 ts.gif
J1TE&.#EA`0`!`( ``````/___R'Y! $`````+ `````!``$```(!1 `[
`
end
|||Hi bobby,
In addition, we've got a program called MSDE Manager that's free for
personal use. Details at our site.
HTH,
Greg Low [MVP]
MSDE Manager SQL Tools
www.whitebearconsulting.com
"Stephen Dybing [MSFT]" <stephd@.online.microsoft.com> wrote in message
news:O7dgcQrjEHA.1348@.TK2MSFTNGP15.phx.gbl...
> MSDE does not ship with any of the graphical utilities that you're used to
> seeing. It does ship with a command line utility, osql.exe, that you can
use
> to manage it, assuming that you're familiar with T-SQL.
> As to whether or not you're allowed to use the copy of SQL Server
Enterprise
> Manager you have to manage it remotely, I doubt it. Please see the FAQ
page
> at http://www.microsoft.com/sql/msde/howtobuy/msdeuse.asp. The sixth Q & A
> is the following:
> Q. Can I use SQL Server tools and services in conjunction with
MSDE?
> A. You can only use SQL Server tools and services in conjunction
with
> MSDE if you acquired MSDE through SQL Server 2000 (Developer Edition,
> Standard Edition, or Enterprise Edition), and if you are using MSDE in
> conjunction with a properly licensed copy of SQL Server 2000. Visit the
How
> to Buy page for information on obtaining a valid SQL Server license.
> Note: The tools and services included with SQL Server Developer
> Edition may not be used to manage production server environments.
> The following utilities are installed by the MSDE setup application
> and are provided without restrictions for use with the copy of MSDE that
is
> installed by your application: bcp.exe, cnfgsvr.exe, dcomscm.exe,
osql.exe,
> sqlmaint.exe, sqlmangr.exe, scm.exe, sqladhlp.exe, and svrnetcn.exe. The
> dtsrun.exe utility is also provided, but can only be used to run existing
> Data Transformation Services (DTS) packages against the copy of MSDE
> installed by your application; it cannot be used to develop new DTS
> packages.
>
> It sounds to me like the small app that you're writing isn't being used in
> conjuction with your copy of SQL Server 2000 and thus you won't be allowed
> to use SQL Server Enterprise Manager against it.
> As always, of course, I'm not a lawyer so you should consult yours. :-)
> --
> Sincerely,
> Stephen Dybing
> This posting is provided "AS IS" with no warranties, and confers no
rights.[vbcol=seagreen]
> "bobby" <bobby@.bobbys.com> wrote in message
> news:%23arsRdOjEHA.3612@.TK2MSFTNGP12.phx.gbl...
the[vbcol=seagreen]
get[vbcol=seagreen]
utilities[vbcol=seagreen]
to[vbcol=seagreen]
to
>
>
sqlsql
is installed on a Small Business Server and I have been told it is a
complete standard setup.
First question: I know MSDE is running because I recognise the icon in the
system tray. Also, locally I can connect to the MSDE so I know it is there.
However, from previous installations of MSDE I seem to recall that although
you don't get Enterprise Manager, Query Analyzer etc with MSDE, you do get
Client Network Utility etc. I have not been able to locate *any* utilities
for MSDE on the server. Is this normal?
This brings me onto my main question. I expect to do some alterations to the
database after the initial installation, and it is not feasible for me to
make a trip to the client for every alteration. I would therefore like to be
able to use Enterprise Manager that I have locally to connect to the remote
SBS/MSDE. How do I do that under the circumstances? I know they have a Cisco
firewall in place.
Any pointers in the right direction would be much appreciated.
What I have found out so far is that I need to check if Server Network
Utility (svrnetcn.exe) is present and has enabled TCP/IP protocol. But I am
sure that is not the end of the story...
"bobby" <bobby@.bobbys.com> wrote in message
news:%23arsRdOjEHA.3612@.TK2MSFTNGP12.phx.gbl...
> I am writing a small app for a company using Access (adp) and MSDE. The
MSDE
> is installed on a Small Business Server and I have been told it is a
> complete standard setup.
> First question: I know MSDE is running because I recognise the icon in the
> system tray. Also, locally I can connect to the MSDE so I know it is
there.
> However, from previous installations of MSDE I seem to recall that
although
> you don't get Enterprise Manager, Query Analyzer etc with MSDE, you do get
> Client Network Utility etc. I have not been able to locate *any* utilities
> for MSDE on the server. Is this normal?
> This brings me onto my main question. I expect to do some alterations to
the
> database after the initial installation, and it is not feasible for me to
> make a trip to the client for every alteration. I would therefore like to
be
> able to use Enterprise Manager that I have locally to connect to the
remote
> SBS/MSDE. How do I do that under the circumstances? I know they have a
Cisco
> firewall in place.
> Any pointers in the right direction would be much appreciated.
>
|||MSDE does not ship with any of the graphical utilities that you're used to
seeing. It does ship with a command line utility, osql.exe, that you can use
to manage it, assuming that you're familiar with T-SQL.
As to whether or not you're allowed to use the copy of SQL Server Enterprise
Manager you have to manage it remotely, I doubt it. Please see the FAQ page
at http://www.microsoft.com/sql/msde/howtobuy/msdeuse.asp. The sixth Q & A
is the following:
Q. Can I use SQL Server tools and services in conjunction with MSDE?
A. You can only use SQL Server tools and services in conjunction with
MSDE if you acquired MSDE through SQL Server 2000 (Developer Edition,
Standard Edition, or Enterprise Edition), and if you are using MSDE in
conjunction with a properly licensed copy of SQL Server 2000. Visit the How
to Buy page for information on obtaining a valid SQL Server license.
Note: The tools and services included with SQL Server Developer
Edition may not be used to manage production server environments.
The following utilities are installed by the MSDE setup application
and are provided without restrictions for use with the copy of MSDE that is
installed by your application: bcp.exe, cnfgsvr.exe, dcomscm.exe, osql.exe,
sqlmaint.exe, sqlmangr.exe, scm.exe, sqladhlp.exe, and svrnetcn.exe. The
dtsrun.exe utility is also provided, but can only be used to run existing
Data Transformation Services (DTS) packages against the copy of MSDE
installed by your application; it cannot be used to develop new DTS
packages.
It sounds to me like the small app that you're writing isn't being used in
conjuction with your copy of SQL Server 2000 and thus you won't be allowed
to use SQL Server Enterprise Manager against it.
As always, of course, I'm not a lawyer so you should consult yours. :-)
Sincerely,
Stephen Dybing
This posting is provided "AS IS" with no warranties, and confers no rights.
"bobby" <bobby@.bobbys.com> wrote in message
news:%23arsRdOjEHA.3612@.TK2MSFTNGP12.phx.gbl...
>I am writing a small app for a company using Access (adp) and MSDE. The
>MSDE
> is installed on a Small Business Server and I have been told it is a
> complete standard setup.
> First question: I know MSDE is running because I recognise the icon in the
> system tray. Also, locally I can connect to the MSDE so I know it is
> there.
> However, from previous installations of MSDE I seem to recall that
> although
> you don't get Enterprise Manager, Query Analyzer etc with MSDE, you do get
> Client Network Utility etc. I have not been able to locate *any* utilities
> for MSDE on the server. Is this normal?
> This brings me onto my main question. I expect to do some alterations to
> the
> database after the initial installation, and it is not feasible for me to
> make a trip to the client for every alteration. I would therefore like to
> be
> able to use Enterprise Manager that I have locally to connect to the
> remote
> SBS/MSDE. How do I do that under the circumstances? I know they have a
> Cisco
> firewall in place.
> Any pointers in the right direction would be much appreciated.
>
begin 666 ts.gif
J1TE&.#EA`0`!`( ``````/___R'Y! $`````+ `````!``$```(!1 `[
`
end
|||Hi bobby,
In addition, we've got a program called MSDE Manager that's free for
personal use. Details at our site.
HTH,
Greg Low [MVP]
MSDE Manager SQL Tools
www.whitebearconsulting.com
"Stephen Dybing [MSFT]" <stephd@.online.microsoft.com> wrote in message
news:O7dgcQrjEHA.1348@.TK2MSFTNGP15.phx.gbl...
> MSDE does not ship with any of the graphical utilities that you're used to
> seeing. It does ship with a command line utility, osql.exe, that you can
use
> to manage it, assuming that you're familiar with T-SQL.
> As to whether or not you're allowed to use the copy of SQL Server
Enterprise
> Manager you have to manage it remotely, I doubt it. Please see the FAQ
page
> at http://www.microsoft.com/sql/msde/howtobuy/msdeuse.asp. The sixth Q & A
> is the following:
> Q. Can I use SQL Server tools and services in conjunction with
MSDE?
> A. You can only use SQL Server tools and services in conjunction
with
> MSDE if you acquired MSDE through SQL Server 2000 (Developer Edition,
> Standard Edition, or Enterprise Edition), and if you are using MSDE in
> conjunction with a properly licensed copy of SQL Server 2000. Visit the
How
> to Buy page for information on obtaining a valid SQL Server license.
> Note: The tools and services included with SQL Server Developer
> Edition may not be used to manage production server environments.
> The following utilities are installed by the MSDE setup application
> and are provided without restrictions for use with the copy of MSDE that
is
> installed by your application: bcp.exe, cnfgsvr.exe, dcomscm.exe,
osql.exe,
> sqlmaint.exe, sqlmangr.exe, scm.exe, sqladhlp.exe, and svrnetcn.exe. The
> dtsrun.exe utility is also provided, but can only be used to run existing
> Data Transformation Services (DTS) packages against the copy of MSDE
> installed by your application; it cannot be used to develop new DTS
> packages.
>
> It sounds to me like the small app that you're writing isn't being used in
> conjuction with your copy of SQL Server 2000 and thus you won't be allowed
> to use SQL Server Enterprise Manager against it.
> As always, of course, I'm not a lawyer so you should consult yours. :-)
> --
> Sincerely,
> Stephen Dybing
> This posting is provided "AS IS" with no warranties, and confers no
rights.[vbcol=seagreen]
> "bobby" <bobby@.bobbys.com> wrote in message
> news:%23arsRdOjEHA.3612@.TK2MSFTNGP12.phx.gbl...
the[vbcol=seagreen]
get[vbcol=seagreen]
utilities[vbcol=seagreen]
to[vbcol=seagreen]
to
>
>
sqlsql
Tuesday, 20 March 2012
Connect to CE Remotely
If I have SQL 2005 Standard installed on a server and I log on locally to that server. Can I connect to other machines through Management Studio-->Object Explorer that have SQLCE installed and manage the CE DB?
I think you can only connect to either local .sdf files or ones located on a device attached by USB to the local machine, but I have had some difficulty finding a definitive statement on that.
Thanks
SQL CE is in process database (a bunch of DLLs loaded by your application) , it has no remote connectivity. There’s a very special remote provider which allows you to access files on device from desktop.
You also might be able to “connect” (quoted because you’re not really connecting to anything – SQL CE is within your process) to the database located on a file shares though it might have some issues like sharing.
Monday, 19 March 2012
Connect remotely to sql server
I have in my company a server with SQL Server.
how do i connect to my server (using a vb6 application made by me) from my
home?
thanks for any helpIdeally, you would create a VPC connection with your office LAN via an ISA
server. Once the VPC connection is established you have a secure link to the
systems on the office domain--just as if you were in the office. I'm asking
Peter if you really need an ISA server... Some might suggest connecting to a
public facing IP address. I think that's problematic at best and very risky.
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
----
---
"Ricardo Teixeira" <ricardoteixeira@.hotmail.com> wrote in message
news:eoIM$jnYHHA.2268@.TK2MSFTNGP06.phx.gbl...
>I have in my company a server with SQL Server.
> how do i connect to my server (using a vb6 application made by me) from my
> home?
> thanks for any help
>
how do i connect to my server (using a vb6 application made by me) from my
home?
thanks for any helpIdeally, you would create a VPC connection with your office LAN via an ISA
server. Once the VPC connection is established you have a secure link to the
systems on the office domain--just as if you were in the office. I'm asking
Peter if you really need an ISA server... Some might suggest connecting to a
public facing IP address. I think that's problematic at best and very risky.
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
----
---
"Ricardo Teixeira" <ricardoteixeira@.hotmail.com> wrote in message
news:eoIM$jnYHHA.2268@.TK2MSFTNGP06.phx.gbl...
>I have in my company a server with SQL Server.
> how do i connect to my server (using a vb6 application made by me) from my
> home?
> thanks for any help
>
Connect remotely to sql server
I have in my company a server with SQL Server.
how do i connect to my server (using a vb6 application made by me) from my
home?
thanks for any help
Ideally, you would create a VPC connection with your office LAN via an ISA
server. Once the VPC connection is established you have a secure link to the
systems on the office domain--just as if you were in the office. I'm asking
Peter if you really need an ISA server... Some might suggest connecting to a
public facing IP address. I think that's problematic at best and very risky.
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
------
"Ricardo Teixeira" <ricardoteixeira@.hotmail.com> wrote in message
news:eoIM$jnYHHA.2268@.TK2MSFTNGP06.phx.gbl...
>I have in my company a server with SQL Server.
> how do i connect to my server (using a vb6 application made by me) from my
> home?
> thanks for any help
>
how do i connect to my server (using a vb6 application made by me) from my
home?
thanks for any help
Ideally, you would create a VPC connection with your office LAN via an ISA
server. Once the VPC connection is established you have a secure link to the
systems on the office domain--just as if you were in the office. I'm asking
Peter if you really need an ISA server... Some might suggest connecting to a
public facing IP address. I think that's problematic at best and very risky.
____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________
Visit www.hitchhikerguides.net to get more information on my latest book:
Hitchhiker's Guide to Visual Studio and SQL Server (7th Edition)
and Hitchhiker's Guide to SQL Server 2005 Compact Edition (EBook)
------
"Ricardo Teixeira" <ricardoteixeira@.hotmail.com> wrote in message
news:eoIM$jnYHHA.2268@.TK2MSFTNGP06.phx.gbl...
>I have in my company a server with SQL Server.
> how do i connect to my server (using a vb6 application made by me) from my
> home?
> thanks for any help
>
Subscribe to:
Posts (Atom)