Remotely accessing database

I'm developing a VB app to manipulate data in a table. I've created an SQL server (local) and have successfully connected to and manipulated data in a database that I created. I would like to be able to run the app on another machine and connect to the same server. I'm having trouble determining what the server name is. Tried a few things but get the "server does not exist" message. Server is set to authenticate SQL server and windows.

Is this happening because my server is (local)? If so how do I change it to permit remote access?

Any assistance would be appreciated.if you have only one sql server in that box, than the default name of the sql server is the name of the windows box. when you try to connect from another box, make sure that the client box has sql server drivers, create a DSN that point to the SQL Server box (using windows server name or ip address), every thing should go fine from there.|||C-Nag

Thanks! I thought there was a simple solution. I'm more familiear with MSAccess and should of thought of this. With access it would require the same.sql

Remote synchronization

Hi
We are considering an access front end app with back end tables on sql
server in our office. Is there a way to have a copy this app on a laptop
for a tele-worker and have it synchronised from time to time using either a
3G data connection, or the office LAN when the tele-worker is in the office?
I presume we will have to make copies of both access front end and sql
server backend on the laptop and then the laptop sql server will synchronise
with the office sql server. Is there a better way to handle this?
Thanks
Regards
have a look at DB Ghost - http://www.dbghost.com - I use it to synchronize my
laptop with the production database when I'm online so I have a database at
all times to run reports on.
"John" wrote:

> Hi
> We are considering an access front end app with back end tables on sql
> server in our office. Is there a way to have a copy this app on a laptop
> for a tele-worker and have it synchronised from time to time using either a
> 3G data connection, or the office LAN when the tele-worker is in the office?
> I presume we will have to make copies of both access front end and sql
> server backend on the laptop and then the laptop sql server will synchronise
> with the office sql server. Is there a better way to handle this?
> Thanks
> Regards
>
>
|||For occasional testing... I simply backup/restore or attach/detach... Mostly
I use backup/restore because the production database does not have to come
down ( and the backups are already made).
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"John" <John@.nospam.infovis.co.uk> wrote in message
news:eZjXQQABFHA.4004@.tk2msftngp13.phx.gbl...
> Hi
> We are considering an access front end app with back end tables on sql
> server in our office. Is there a way to have a copy this app on a laptop
> for a tele-worker and have it synchronised from time to time using either
a
> 3G data connection, or the office LAN when the tele-worker is in the
office?
> I presume we will have to make copies of both access front end and sql
> server backend on the laptop and then the laptop sql server will
synchronise
> with the office sql server. Is there a better way to handle this?
> Thanks
> Regards
>
|||I was under the impression that sql server supports synchronisation...or is
replication something different?
Thanks
Regards
"Wayne Snyder" <wayne.nospam.snyder@.mariner-usa.com> wrote in message
news:uzGwBYHBFHA.3140@.TK2MSFTNGP15.phx.gbl...
> For occasional testing... I simply backup/restore or attach/detach...
Mostly[vbcol=seagreen]
> I use backup/restore because the production database does not have to come
> down ( and the backups are already made).
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
> "John" <John@.nospam.infovis.co.uk> wrote in message
> news:eZjXQQABFHA.4004@.tk2msftngp13.phx.gbl...
laptop[vbcol=seagreen]
either
> a
> office?
> synchronise
>

Remote synchronization

Hi
We are considering an access front end app with back end tables on sql
server in our office. Is there a way to have a copy this app on a laptop
for a tele-worker and have it synchronised from time to time using either a
3G data connection, or the office LAN when the tele-worker is in the office?
I presume we will have to make copies of both access front end and sql
server backend on the laptop and then the laptop sql server will synchronise
with the office sql server. Is there a better way to handle this?
Thanks
Regardshave a look at DB Ghost - http://www.dbghost.com - I use it to synchronize m
y
laptop with the production database when I'm online so I have a database at
all times to run reports on.
"John" wrote:

> Hi
> We are considering an access front end app with back end tables on sql
> server in our office. Is there a way to have a copy this app on a laptop
> for a tele-worker and have it synchronised from time to time using either
a
> 3G data connection, or the office LAN when the tele-worker is in the offic
e?
> I presume we will have to make copies of both access front end and sql
> server backend on the laptop and then the laptop sql server will synchroni
se
> with the office sql server. Is there a better way to handle this?
> Thanks
> Regards
>
>|||For occasional testing... I simply backup/restore or attach/detach... Mostly
I use backup/restore because the production database does not have to come
down ( and the backups are already made).
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"John" <John@.nospam.infovis.co.uk> wrote in message
news:eZjXQQABFHA.4004@.tk2msftngp13.phx.gbl...
> Hi
> We are considering an access front end app with back end tables on sql
> server in our office. Is there a way to have a copy this app on a laptop
> for a tele-worker and have it synchronised from time to time using either
a
> 3G data connection, or the office LAN when the tele-worker is in the
office?
> I presume we will have to make copies of both access front end and sql
> server backend on the laptop and then the laptop sql server will
synchronise
> with the office sql server. Is there a better way to handle this?
> Thanks
> Regards
>|||I was under the impression that sql server supports synchronisation...or is
replication something different?
Thanks
Regards
"Wayne Snyder" <wayne.nospam.snyder@.mariner-usa.com> wrote in message
news:uzGwBYHBFHA.3140@.TK2MSFTNGP15.phx.gbl...
> For occasional testing... I simply backup/restore or attach/detach...
Mostly
> I use backup/restore because the production database does not have to come
> down ( and the backups are already made).
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
> "John" <John@.nospam.infovis.co.uk> wrote in message
> news:eZjXQQABFHA.4004@.tk2msftngp13.phx.gbl...
laptop[vbcol=seagreen]
either[vbcol=seagreen]
> a
> office?
> synchronise
>

Remote synchronization

Hi
We are considering an access front end app with back end tables on sql
server in our office. Is there a way to have a copy this app on a laptop
for a tele-worker and have it synchronised from time to time using either a
3G data connection, or the office LAN when the tele-worker is in the office?
I presume we will have to make copies of both access front end and sql
server backend on the laptop and then the laptop sql server will synchronise
with the office sql server. Is there a better way to handle this?
Thanks
Regardshave a look at DB Ghost - http://www.dbghost.com - I use it to synchronize my
laptop with the production database when I'm online so I have a database at
all times to run reports on.
"John" wrote:
> Hi
> We are considering an access front end app with back end tables on sql
> server in our office. Is there a way to have a copy this app on a laptop
> for a tele-worker and have it synchronised from time to time using either a
> 3G data connection, or the office LAN when the tele-worker is in the office?
> I presume we will have to make copies of both access front end and sql
> server backend on the laptop and then the laptop sql server will synchronise
> with the office sql server. Is there a better way to handle this?
> Thanks
> Regards
>
>|||For occasional testing... I simply backup/restore or attach/detach... Mostly
I use backup/restore because the production database does not have to come
down ( and the backups are already made).
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"John" <John@.nospam.infovis.co.uk> wrote in message
news:eZjXQQABFHA.4004@.tk2msftngp13.phx.gbl...
> Hi
> We are considering an access front end app with back end tables on sql
> server in our office. Is there a way to have a copy this app on a laptop
> for a tele-worker and have it synchronised from time to time using either
a
> 3G data connection, or the office LAN when the tele-worker is in the
office?
> I presume we will have to make copies of both access front end and sql
> server backend on the laptop and then the laptop sql server will
synchronise
> with the office sql server. Is there a better way to handle this?
> Thanks
> Regards
>|||I was under the impression that sql server supports synchronisation...or is
replication something different?
Thanks
Regards
"Wayne Snyder" <wayne.nospam.snyder@.mariner-usa.com> wrote in message
news:uzGwBYHBFHA.3140@.TK2MSFTNGP15.phx.gbl...
> For occasional testing... I simply backup/restore or attach/detach...
Mostly
> I use backup/restore because the production database does not have to come
> down ( and the backups are already made).
> --
> Wayne Snyder, MCDBA, SQL Server MVP
> Mariner, Charlotte, NC
> www.mariner-usa.com
> (Please respond only to the newsgroups.)
> I support the Professional Association of SQL Server (PASS) and it's
> community of SQL Server professionals.
> www.sqlpass.org
> "John" <John@.nospam.infovis.co.uk> wrote in message
> news:eZjXQQABFHA.4004@.tk2msftngp13.phx.gbl...
> > Hi
> >
> > We are considering an access front end app with back end tables on sql
> > server in our office. Is there a way to have a copy this app on a
laptop
> > for a tele-worker and have it synchronised from time to time using
either
> a
> > 3G data connection, or the office LAN when the tele-worker is in the
> office?
> > I presume we will have to make copies of both access front end and sql
> > server backend on the laptop and then the laptop sql server will
> synchronise
> > with the office sql server. Is there a better way to handle this?
> >
> > Thanks
> >
> > Regards
> >
> >
>

Remote Sync -- SQL 2000

I am just beginning development of a new app and I need a little advice on
the best way to go about doing something.

The app is a project management tool for a construction company. Users in
the field will need to do remote updates both receiving and submitting data
back to the main office. I can't just make it a live web app because the
users will have to be able to work off line and sync data later (presumably
with a VPN connection).

What is the best way to go about this? I planned on using MSDE 2000 w/Access
front end. I will install MSDE on each laptop but what is the safest/most
reliable way to sync only that information which pertains to a specific user
along with other general information.

Any books that helpful with this specific issue? Any one have reusable
modules/code they'd be willing to send me?

TIA,

--JakeCXonsider replication, transactional or merge. Transactional is the
easier of the tow options but does mean that oly one side can make
changes to the data. With merge both sides cna change the data and you
create a set of rules to decide whic update is accepted.

Jake Jessup wrote:

> I am just beginning development of a new app and I need a little advice on
> the best way to go about doing something.
> The app is a project management tool for a construction company. Users in
> the field will need to do remote updates both receiving and submitting data
> back to the main office. I can't just make it a live web app because the
> users will have to be able to work off line and sync data later (presumably
> with a VPN connection).
> What is the best way to go about this? I planned on using MSDE 2000 w/Access
> front end. I will install MSDE on each laptop but what is the safest/most
> reliable way to sync only that information which pertains to a specific user
> along with other general information.
> Any books that helpful with this specific issue? Any one have reusable
> modules/code they'd be willing to send me?
> TIA,
> --Jake
>

Remote Laptop SA Password

Hi All,

We have remote users using sql server 7 on laptops. They use a vb app and replicate with the main server.

I have just discovered they have weak passwords on their sa account.
Others are suggesting that the laptops do not need strong passwords for their sa account as they are only subscribers . Are they talking rubbish?

Thanks,
JJCYou may want to give a look at the article in BOL about xp_cmdshell. Basically, if a dba (or many programmers for that matter) can get your sa password, that dba/programmer can own your laptop. There was a virus that searched the internet for SQL Servers that had no sa password, and it was shockingly effective.

If the laptops are only subscribers, and you do not allow anonymous pull subscriptions, you should be ok at the central server, but those laptops really should have their security beefed up.|||END USERS SHOULD NOT BE USING SA ACCOUNTS!

Even DBAs shouldn't be using the SA account!

Even System Administrators should not use the SA account! They should set up an account that grants themselves only the permissions necessary to do their day-to-day tasks, and only log in as SA when absolutely necessary. Otherwise, sooner or later you WILL do something you wish that you hadn't. Don't think of user accounts as restricitions. Think of them as safeguards!

Give all your users SQL logins or NT logins, and then change your sa password.

blindman|||If possible, set your users' laptops to Windows Authentication only. This way you'll come out clean without having to remember each laptop's SA password, or having to create a user on each laptop.

Remote connecton

I made a 1 form app(to learn with) in VB Express. I published it, installed it on my pc and everything is fine(I used a db from my main app I'm building which was made in VBE(but I didnt install the db in my project, I only connected to it) anyhow

With my 1 form application, I can add,edit the records in the db, no problem there but

when I took it to another pc and installed it, it installed fine, but when you launch the app I got an exception stating

That it cannot find a SQL connection etc...

I do have remote connections checked in SQL.

Is there something that you have to do to a remote pc to make it visible?

We have a simple peer to peer network.

I have an existing app(Access) that I use mapped drives to share the data, I did open the folder for those mdb's and they were there which eliminates connectivity problems from pc to pc.

What did I do!!

Davids Learning

Fixed my problem!

Davids Learning

|||

Please post the solution you came to so that others can also learn.

|||

Learned from a remote pc that .\SQLServer doesnt work

Try the name of the pc and \SQLServer

Davids Learning

|||

That is corect. When you use the .\SQLExpress the . notion is a short form for the local machine.

BTW Thanks for posting the answer.