receive files from remote site only if file does not exist in local directory

I need to only receive files via ftp when the file does not exist on my local machine. FIles are being added to the remote location on a weekly basis and they are being downloaded locally. I do not want to download all the files each time. Instead, just download what was not already downloaded. Is there a way to do this? I want to do this using SSIS / ftp task.

Thanks in advance.

One way to accomplish this is to use the Execute Process task to run ftp.exe to get a list of the files on the server, then compare that list to your local directory. You could compare the file lists through a script task. Then FTP each file that you need to pull down.|||Thanks very much. I will try that.

Rebuild SQL server 7 db

Our NT 4.0 server machine's motherboard burned out. After placed the hard
disk drives in a new box, we got a video issue and disk I/O error. Therefore
I installed SQL server 7 on a new Win2K server box. The hard disk drives on
the NT server are fine and placed in the new box. I can't use detach or
attach sp from the new box. How can I restore the db to the new box?
Thanks,
Eli>> I can't use detach or attach sp from the new box.
You mean, you are getting some errors while trying to attach the databases?
If so, what are they?
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Eli Feng" <efeng@.kerisys.com> wrote in message
news:uVLY7pbkFHA.2444@.tk2msftngp13.phx.gbl...
Our NT 4.0 server machine's motherboard burned out. After placed the hard
disk drives in a new box, we got a video issue and disk I/O error. Therefore
I installed SQL server 7 on a new Win2K server box. The hard disk drives on
the NT server are fine and placed in the new box. I can't use detach or
attach sp from the new box. How can I restore the db to the new box?
Thanks,
Eli|||Hi,
If you have all the physical files (MDF, NDF and LDF) belongs to SYSTEM and
User databases then you can do below:-
1. Install SQL Server 7 in the same folder as old installation
2. Apply the same service pack as old
3. Stop SQL Server service
4. COpy the new physical files to a new folder
5. Copy the physical files (MDF, NDF and LDF) from the old server to the
exact folders as old
6. Start the SQL Server service
7. Open enterprise manager and see if all the databases are ok.
Incase if this step fails then you need to:-
Restore the databases from last good backup.
Thanks
Hari
SQL Server MVP
"Eli Feng" <efeng@.kerisys.com> wrote in message
news:uVLY7pbkFHA.2444@.tk2msftngp13.phx.gbl...
> Our NT 4.0 server machine's motherboard burned out. After placed the hard
> disk drives in a new box, we got a video issue and disk I/O error.
> Therefore
> I installed SQL server 7 on a new Win2K server box. The hard disk drives
> on
> the NT server are fine and placed in the new box. I can't use detach or
> attach sp from the new box. How can I restore the db to the new box?
> Thanks,
> Eli
>|||Hi Narayana & Hai,
Thank you so much for your replies. Because the db was not normally
detached, therefore I didn't know how to attach it to a new SQL serverl.
I'll try Hai's instructions to see how it works. Thanks again, really
apreciate it.
Eli
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:ursSf8gkFHA.3828@.TK2MSFTNGP12.phx.gbl...
> Hi,
> If you have all the physical files (MDF, NDF and LDF) belongs to SYSTEM
and
> User databases then you can do below:-
> 1. Install SQL Server 7 in the same folder as old installation
> 2. Apply the same service pack as old
> 3. Stop SQL Server service
> 4. COpy the new physical files to a new folder
> 5. Copy the physical files (MDF, NDF and LDF) from the old server to the
> exact folders as old
> 6. Start the SQL Server service
> 7. Open enterprise manager and see if all the databases are ok.
> Incase if this step fails then you need to:-
> Restore the databases from last good backup.
> Thanks
> Hari
> SQL Server MVP
>
> "Eli Feng" <efeng@.kerisys.com> wrote in message
> news:uVLY7pbkFHA.2444@.tk2msftngp13.phx.gbl...
> > Our NT 4.0 server machine's motherboard burned out. After placed the
hard
> > disk drives in a new box, we got a video issue and disk I/O error.
> > Therefore
> > I installed SQL server 7 on a new Win2K server box. The hard disk drives
> > on
> > the NT server are fine and placed in the new box. I can't use detach or
> > attach sp from the new box. How can I restore the db to the new box?
> > Thanks,
> > Eli
> >
> >
>

Rebuild SQL server 7 db

Our NT 4.0 server machine's motherboard burned out. After placed the hard
disk drives in a new box, we got a video issue and disk I/O error. Therefore
I installed SQL server 7 on a new Win2K server box. The hard disk drives on
the NT server are fine and placed in the new box. I can't use detach or
attach sp from the new box. How can I restore the db to the new box?
Thanks,
Eli>> I can't use detach or attach sp from the new box.
You mean, you are getting some errors while trying to attach the databases?
If so, what are they?
--
HTH,
Vyas, MVP (SQL Server)
SQL Server Articles and Code Samples @. http://vyaskn.tripod.com/
"Eli Feng" <efeng@.kerisys.com> wrote in message
news:uVLY7pbkFHA.2444@.tk2msftngp13.phx.gbl...
Our NT 4.0 server machine's motherboard burned out. After placed the hard
disk drives in a new box, we got a video issue and disk I/O error. Therefore
I installed SQL server 7 on a new Win2K server box. The hard disk drives on
the NT server are fine and placed in the new box. I can't use detach or
attach sp from the new box. How can I restore the db to the new box?
Thanks,
Eli|||Hi,
If you have all the physical files (MDF, NDF and LDF) belongs to SYSTEM and
User databases then you can do below:-
1. Install SQL Server 7 in the same folder as old installation
2. Apply the same service pack as old
3. Stop SQL Server service
4. COpy the new physical files to a new folder
5. Copy the physical files (MDF, NDF and LDF) from the old server to the
exact folders as old
6. Start the SQL Server service
7. Open enterprise manager and see if all the databases are ok.
Incase if this step fails then you need to:-
Restore the databases from last good backup.
Thanks
Hari
SQL Server MVP
"Eli Feng" <efeng@.kerisys.com> wrote in message
news:uVLY7pbkFHA.2444@.tk2msftngp13.phx.gbl...
> Our NT 4.0 server machine's motherboard burned out. After placed the hard
> disk drives in a new box, we got a video issue and disk I/O error.
> Therefore
> I installed SQL server 7 on a new Win2K server box. The hard disk drives
> on
> the NT server are fine and placed in the new box. I can't use detach or
> attach sp from the new box. How can I restore the db to the new box?
> Thanks,
> Eli
>|||Hi Narayana & Hai,
Thank you so much for your replies. Because the db was not normally
detached, therefore I didn't know how to attach it to a new SQL serverl.
I'll try Hai's instructions to see how it works. Thanks again, really
apreciate it.
Eli
"Hari Prasad" <hari_prasad_k@.hotmail.com> wrote in message
news:ursSf8gkFHA.3828@.TK2MSFTNGP12.phx.gbl...
> Hi,
> If you have all the physical files (MDF, NDF and LDF) belongs to SYSTEM
and
> User databases then you can do below:-
> 1. Install SQL Server 7 in the same folder as old installation
> 2. Apply the same service pack as old
> 3. Stop SQL Server service
> 4. COpy the new physical files to a new folder
> 5. Copy the physical files (MDF, NDF and LDF) from the old server to the
> exact folders as old
> 6. Start the SQL Server service
> 7. Open enterprise manager and see if all the databases are ok.
> Incase if this step fails then you need to:-
> Restore the databases from last good backup.
> Thanks
> Hari
> SQL Server MVP
>
> "Eli Feng" <efeng@.kerisys.com> wrote in message
> news:uVLY7pbkFHA.2444@.tk2msftngp13.phx.gbl...
hard[vbcol=seagreen]
>sql

Reboot SQL Server 2000 server periodically ?

We currently reboot our Citrix and Application Server server/machines
periodically
Is it recommended to reboot the server/machine which hosts the SQL Server 2000
periodically ? If so how often ?
Our servers/machines are Windows 2003
Thanks
Well Why you reboot the server periodically.It is not recommended unless you
face any problems
"SQL Server newbie" wrote:

> We currently reboot our Citrix and Application Server server/machines
> periodically
> Is it recommended to reboot the server/machine which hosts the SQL Server 2000
> periodically ? If so how often ?
> Our servers/machines are Windows 2003
> Thanks
|||"SQL Server newbie" <SQLServernewbie@.discussions.microsoft.com> wrote in
message news:8076BE75-0E42-44DC-B461-2C59941F7420@.microsoft.com...
> We currently reboot our Citrix and Application Server server/machines
> periodically
> Is it recommended to reboot the server/machine which hosts the SQL Server
> 2000
> periodically ? If so how often ?
Hmm, I had one I tended to reboot every time we changed datacenters.
So perhaps once every 2-3 years.
Seriously, you should NOT need to reboot SQL Server.

> Our servers/machines are Windows 2003
> Thanks

Reboot SQL Server 2000 server periodically ?

We currently reboot our Citrix and Application Server server/machines
periodically
Is it recommended to reboot the server/machine which hosts the SQL Server 2000
periodically ? If so how often ?
Our servers/machines are Windows 2003
ThanksWell Why you reboot the server periodically.It is not recommended unless you
face any problems
"SQL Server newbie" wrote:
> We currently reboot our Citrix and Application Server server/machines
> periodically
> Is it recommended to reboot the server/machine which hosts the SQL Server 2000
> periodically ? If so how often ?
> Our servers/machines are Windows 2003
> Thanks|||"SQL Server newbie" <SQLServernewbie@.discussions.microsoft.com> wrote in
message news:8076BE75-0E42-44DC-B461-2C59941F7420@.microsoft.com...
> We currently reboot our Citrix and Application Server server/machines
> periodically
> Is it recommended to reboot the server/machine which hosts the SQL Server
> 2000
> periodically ? If so how often ?
Hmm, I had one I tended to reboot every time we changed datacenters.
So perhaps once every 2-3 years.
Seriously, you should NOT need to reboot SQL Server.
> Our servers/machines are Windows 2003
> Thanks

Reboot SQL Server 2000 server periodically ?

We currently reboot our Citrix and Application Server server/machines
periodically
Is it recommended to reboot the server/machine which hosts the SQL Server 20
00
periodically ? If so how often ?
Our servers/machines are Windows 2003
ThanksWell Why you reboot the server periodically.It is not recommended unless you
face any problems
"SQL Server newbie" wrote:

> We currently reboot our Citrix and Application Server server/machines
> periodically
> Is it recommended to reboot the server/machine which hosts the SQL Server
2000
> periodically ? If so how often ?
> Our servers/machines are Windows 2003
> Thanks|||"SQL Server newbie" <SQLServernewbie@.discussions.microsoft.com> wrote in
message news:8076BE75-0E42-44DC-B461-2C59941F7420@.microsoft.com...
> We currently reboot our Citrix and Application Server server/machines
> periodically
> Is it recommended to reboot the server/machine which hosts the SQL Server
> 2000
> periodically ? If so how often ?
Hmm, I had one I tended to reboot every time we changed datacenters.
So perhaps once every 2-3 years.
Seriously, you should NOT need to reboot SQL Server.

> Our servers/machines are Windows 2003
> Thanks

reboot reboot reboot

I have installed ss2005 and now I want to change some things (add the
AdventureWorks dbs). On one machine it worked fine but on the other System
Configuration Check keeps getting a reboot required message that says...
"A previous installation required a reboot of the machine for changes to
take effect. To proceed, restart your computer and then run SQL Server
Setup again."
So, I reboot but it keeps getting the same message. What can I do?
Tinn ManI presume that there is an installation issue.
and at every reboot, Sql server starts and detect a file problem, like a
missing or worng DLL, then the installer starts a repair process.
when the reinstallation is done, the system ask for a reboot.
but this reinstallation doesn't works really fine and at every reboot the
same event occurs.
you'll see some installer event log in the windows log if the installer
starts himself.
Try to reinstall SQL server interactively to catch some installation issues.
stop any SQL services , reboot, see if the installer starts, then do a clean
install or repair process.
"Tinn Man" <tm@.nospammeexcite.com> wrote in message
news:uw8ZVLQiGHA.4512@.TK2MSFTNGP02.phx.gbl...
>I have installed ss2005 and now I want to change some things (add the
>AdventureWorks dbs). On one machine it worked fine but on the other System
>Configuration Check keeps getting a reboot required message that says...
> "A previous installation required a reboot of the machine for changes to
> take effect. To proceed, restart your computer and then run SQL Server
> Setup again."
> So, I reboot but it keeps getting the same message. What can I do?
> Tinn Man
>

reboot reboot reboot

I have installed ss2005 and now I want to change some things (add the
AdventureWorks dbs). On one machine it worked fine but on the other System
Configuration Check keeps getting a reboot required message that says...
"A previous installation required a reboot of the machine for changes to
take effect. To proceed, restart your computer and then run SQL Server
Setup again."
So, I reboot but it keeps getting the same message. What can I do?
Tinn ManI presume that there is an installation issue.
and at every reboot, Sql server starts and detect a file problem, like a
missing or worng DLL, then the installer starts a repair process.
when the reinstallation is done, the system ask for a reboot.
but this reinstallation doesn't works really fine and at every reboot the
same event occurs.
you'll see some installer event log in the windows log if the installer
starts himself.
Try to reinstall SQL server interactively to catch some installation issues.
stop any SQL services , reboot, see if the installer starts, then do a clean
install or repair process.
"Tinn Man" <tm@.nospammeexcite.com> wrote in message
news:uw8ZVLQiGHA.4512@.TK2MSFTNGP02.phx.gbl...
>I have installed ss2005 and now I want to change some things (add the
>AdventureWorks dbs). On one machine it worked fine but on the other System
>Configuration Check keeps getting a reboot required message that says...
> "A previous installation required a reboot of the machine for changes to
> take effect. To proceed, restart your computer and then run SQL Server
> Setup again."
> So, I reboot but it keeps getting the same message. What can I do?
> Tinn Man
>

Really basic question...

I have bumbled along and managed to install a SQL server
on my machine... and with the install I have created a
user "Admin" along with a password ( yay )
Anyways... what I would like to know now is how to create
other users and allow them access to the DB.
Thanks
MeHi,
SQL Server supports 2 types of authentications,
1. SQL Server
2. OS Level
If it is SQL Server , Login to server using Enterprise manager then select
the security tab.
1. Right click on logins and add a new login.
2. Provide the user name and select SQL server authentication
3. Give a password and select the required servide wide roles
4. Give the database that user need access.
If it is OS Level , you have to create the user at OS level and use the same
security tab to give the roles and access to databases.
Thanks
Hari
MCDBA
"me" <anonymous@.discussions.microsoft.com> wrote in message
news:07cb01c3da5c$eb920e90$a301280a@.phx.gbl...
> I have bumbled along and managed to install a SQL server
> on my machine... and with the install I have created a
> user "Admin" along with a password ( yay )
> Anyways... what I would like to know now is how to create
> other users and allow them access to the DB.
> Thanks
> Me|||Use a tool like Enterprise Manager to create users. You need to create
logins in SQL Server and then map these logins to databases.
--
HTH,
SriSamp
Please reply to the whole group only!
http://www32.brinkster.com/srisamp
"me" <anonymous@.discussions.microsoft.com> wrote in message
news:07cb01c3da5c$eb920e90$a301280a@.phx.gbl...
> I have bumbled along and managed to install a SQL server
> on my machine... and with the install I have created a
> user "Admin" along with a password ( yay )
> Anyways... what I would like to know now is how to create
> other users and allow them access to the DB.
> Thanks
> Me|||Click the folder Security and expand
Right Click the folder Logins and select "New User"
The rest you will need to read up on.
If you need a bit more advise then email me. In reverse
order(to stop autospammers) my email is
moc.liamtoh.em_yrewolf_elttil
J
PS Never give your Admin password out to anyone - Keep it
safe, Keep it Secret.
>--Original Message--
>I have bumbled along and managed to install a SQL server
>on my machine... and with the install I have created a
>user "Admin" along with a password ( yay )
>Anyways... what I would like to know now is how to create
>other users and allow them access to the DB.
>Thanks
>Me
>.
>|||Which should be the prefferred way to add users?
SQL Server or OS level
>--Original Message--
>Hi,
>SQL Server supports 2 types of authentications,
>1. SQL Server
>2. OS Level
>If it is SQL Server , Login to server using Enterprise
manager then select
>the security tab.
>1. Right click on logins and add a new login.
>2. Provide the user name and select SQL server
authentication
>3. Give a password and select the required servide wide
roles
>4. Give the database that user need access.
>If it is OS Level , you have to create the user at OS
level and use the same
>security tab to give the roles and access to databases.
>Thanks
>Hari
>MCDBA
>"me" <anonymous@.discussions.microsoft.com> wrote in
message
>news:07cb01c3da5c$eb920e90$a301280a@.phx.gbl...
>> I have bumbled along and managed to install a SQL
server
>> on my machine... and with the install I have created a
>> user "Admin" along with a password ( yay )
>> Anyways... what I would like to know now is how to
create
>> other users and allow them access to the DB.
>> Thanks
>> Me
>
>.
>|||Thanks for all of the great help... Is there a way to do
this programmatically ?
Thanks
Me
>--Original Message--
>I have bumbled along and managed to install a SQL server
>on my machine... and with the install I have created a
>user "Admin" along with a password ( yay )
>Anyways... what I would like to know now is how to
create
>other users and allow them access to the DB.
>Thanks
>Me
>.
>

Really basic question...

I have bumbled along and managed to install a SQL server
on my machine... and with the install I have created a
user "Admin" along with a password ( yay )
Anyways... what I would like to know now is how to create
other users and allow them access to the DB.
Thanks
MeHi,
SQL Server supports 2 types of authentications,
1. SQL Server
2. OS Level
If it is SQL Server , Login to server using Enterprise manager then select
the security tab.
1. Right click on logins and add a new login.
2. Provide the user name and select SQL server authentication
3. Give a password and select the required servide wide roles
4. Give the database that user need access.
If it is OS Level , you have to create the user at OS level and use the same
security tab to give the roles and access to databases.
Thanks
Hari
MCDBA
"me" <anonymous@.discussions.microsoft.com> wrote in message
news:07cb01c3da5c$eb920e90$a301280a@.phx.gbl...

quote:

---

> I have bumbled along and managed to install a SQL server
> on my machine... and with the install I have created a
> user "Admin" along with a password ( yay )
> Anyways... what I would like to know now is how to create
> other users and allow them access to the DB.
> Thanks
> Me

---

|||Use a tool like Enterprise Manager to create users. You need to create
logins in SQL Server and then map these logins to databases.
--
HTH,
SriSamp
Please reply to the whole group only!
http://www32.brinkster.com/srisamp
"me" <anonymous@.discussions.microsoft.com> wrote in message
news:07cb01c3da5c$eb920e90$a301280a@.phx.gbl...

quote:

---

> I have bumbled along and managed to install a SQL server
> on my machine... and with the install I have created a
> user "Admin" along with a password ( yay )
> Anyways... what I would like to know now is how to create
> other users and allow them access to the DB.
> Thanks
> Me

---

|||Which should be the prefferred way to add users?
SQL Server or OS level

quote:

---

>--Original Message--
>Hi,
>SQL Server supports 2 types of authentications,
>1. SQL Server
>2. OS Level
>If it is SQL Server , Login to server using Enterprise

---

manager then select

quote:

---

>the security tab.
>1. Right click on logins and add a new login.
>2. Provide the user name and select SQL server

---

authentication

quote:

---

>3. Give a password and select the required servide wide

---

roles

quote:

---

>4. Give the database that user need access.
>If it is OS Level , you have to create the user at OS

---

level and use the same

quote:

---

>security tab to give the roles and access to databases.
>Thanks
>Hari
>MCDBA
>"me" <anonymous@.discussions.microsoft.com> wrote in

---

message

quote:

---

>news:07cb01c3da5c$eb920e90$a301280a@.phx.gbl...
server[QUOTE]
create[QUOTE]
>
>.
>

---

Real Simple Quetion - I think!

Hi Folks!
I am trying to use 1 computer running XP home networked to a machine using
XP Proand SQL Server (Desktop Edition from Developer) on 1 other computer.
My MSACESS ADP refuses to see the SQL server even though I can do file
shares/printer shares between the two. Is XP home or Desktop SQL incapable
of this? I really don't want to spend an exasperating weekend if its
futile!!
Thanks for youe help and advice,,,
JimHi
Try comnection with the IP address, and not the machine name.
Also, if you are running Windows XP SP2:
SQL 2000 and XP SP2:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_ts_7eur.asp
Regards
Mike
"JimD" wrote:
> Hi Folks!
> I am trying to use 1 computer running XP home networked to a machine using
> XP Proand SQL Server (Desktop Edition from Developer) on 1 other computer.
> My MSACESS ADP refuses to see the SQL server even though I can do file
> shares/printer shares between the two. Is XP home or Desktop SQL incapable
> of this? I really don't want to spend an exasperating weekend if its
> futile!!
> Thanks for youe help and advice,,,
> Jim
>
>|||Hi,
If you have the XP SP2 firewall running then it may be blocking traffic to
SQL Server on port 1433.
It will by default. Take a look in the firewall.log file when you try to
connect...
"JimD" <jimd4115@.verizon.net> wrote in message
news:HcI5e.1264$1p4.1219@.trndny06...
> Hi Folks!
> I am trying to use 1 computer running XP home networked to a machine using
> XP Proand SQL Server (Desktop Edition from Developer) on 1 other computer.
> My MSACESS ADP refuses to see the SQL server even though I can do file
> shares/printer shares between the two. Is XP home or Desktop SQL incapable
> of this? I really don't want to spend an exasperating weekend if its
> futile!!
> Thanks for youe help and advice,,,
> Jim
>|||Hi And Thank You!
I have firewall completely shut off on both machines and Norton AutoProtect
shutoff as well on both. I have TCP/IP ports set at 1433 on both as well. I
need to connect with the machine name as the app is written that way. Could
it possibly be something to do with accounts? I've tried Guest both on and
off to no avail on the marching running SQL Developer (Desktop) Edition. I
have tried for the last 12 hours and cannot even get Enterprise Manager to
connect. I'm going crazy and this is business critical. If anyone can
suggest anything else I'm, all ears...I need this connectivity by Monday
morning or I'm in big trouble...I've tried everything I can thing of...
Thanks so much...
Jim
jimd@.aries.com
"Mercury" <me@.spam.com> wrote in message
news:d38h1r$nn8$1@.lust.ihug.co.nz...
> Hi,
> If you have the XP SP2 firewall running then it may be blocking traffic to
> SQL Server on port 1433.
> It will by default. Take a look in the firewall.log file when you try to
> connect...
>
> "JimD" <jimd4115@.verizon.net> wrote in message
> news:HcI5e.1264$1p4.1219@.trndny06...
>> Hi Folks!
>> I am trying to use 1 computer running XP home networked to a machine
>> using
>> XP Proand SQL Server (Desktop Edition from Developer) on 1 other
>> computer.
>> My MSACESS ADP refuses to see the SQL server even though I can do file
>> shares/printer shares between the two. Is XP home or Desktop SQL
>> incapable
>> of this? I really don't want to spend an exasperating weekend if its
>> futile!!
>> Thanks for youe help and advice,,,
>> Jim
>>
>|||JimD wrote:
> I've tried Guest both on and off to no avail on the
> marching running SQL Developer (Desktop) Edition. I have tried for
> the last 12 hours and cannot even get Enterprise Manager to connect.
>
I'm confused. Do you have a SQL account to log in to the server? It
sounds like you may not know a valid account to use. Can you connect
using the IP address?
--
David Gugick
Imceda Software
www.imceda.com|||look at the following MS KB Article:
http://support.microsoft.com/kb/319930/EN-US/
and you may want to look at the following too:
http://support.microsoft.com/default.aspx?scid=kb;EN-US;q325003
Good luck!
"JimD" <jimd4115@.verizon.net> wrote in message
news:Kh06e.1815$4v3.304@.trndny03...
> Hi And Thank You!
> I have firewall completely shut off on both machines and Norton
AutoProtect
> shutoff as well on both. I have TCP/IP ports set at 1433 on both as well.
I
> need to connect with the machine name as the app is written that way.
Could
> it possibly be something to do with accounts? I've tried Guest both on and
> off to no avail on the marching running SQL Developer (Desktop) Edition. I
> have tried for the last 12 hours and cannot even get Enterprise Manager to
> connect. I'm going crazy and this is business critical. If anyone can
> suggest anything else I'm, all ears...I need this connectivity by Monday
> morning or I'm in big trouble...I've tried everything I can thing of...
> Thanks so much...
> Jim
> jimd@.aries.com
> "Mercury" <me@.spam.com> wrote in message
> news:d38h1r$nn8$1@.lust.ihug.co.nz...
> > Hi,
> >
> > If you have the XP SP2 firewall running then it may be blocking traffic
to
> > SQL Server on port 1433.
> > It will by default. Take a look in the firewall.log file when you try to
> > connect...
> >
> >
> > "JimD" <jimd4115@.verizon.net> wrote in message
> > news:HcI5e.1264$1p4.1219@.trndny06...
> >> Hi Folks!
> >>
> >> I am trying to use 1 computer running XP home networked to a machine
> >> using
> >> XP Proand SQL Server (Desktop Edition from Developer) on 1 other
> >> computer.
> >> My MSACESS ADP refuses to see the SQL server even though I can do file
> >> shares/printer shares between the two. Is XP home or Desktop SQL
> >> incapable
> >> of this? I really don't want to spend an exasperating weekend if its
> >> futile!!
> >>
> >> Thanks for youe help and advice,,,
> >> Jim
> >>
> >>
> >
> >
>|||You should be able to find odbcping on the bin folder for sql server. lookup
BOL for info on how to use it.
(I didn't see it mentioned in the above links - but I could be blind).
"JimD" <jimd4115@.verizon.net> wrote in message
news:Kh06e.1815$4v3.304@.trndny03...
> Hi And Thank You!
> I have firewall completely shut off on both machines and Norton
> AutoProtect shutoff as well on both. I have TCP/IP ports set at 1433 on
> both as well. I need to connect with the machine name as the app is
> written that way. Could it possibly be something to do with accounts? I've
> tried Guest both on and off to no avail on the marching running SQL
> Developer (Desktop) Edition. I have tried for the last 12 hours and cannot
> even get Enterprise Manager to connect. I'm going crazy and this is
> business critical. If anyone can suggest anything else I'm, all ears...I
> need this connectivity by Monday morning or I'm in big trouble...I've
> tried everything I can thing of...
> Thanks so much...
> Jim
> jimd@.aries.com
> "Mercury" <me@.spam.com> wrote in message
> news:d38h1r$nn8$1@.lust.ihug.co.nz...
>> Hi,
>> If you have the XP SP2 firewall running then it may be blocking traffic
>> to SQL Server on port 1433.
>> It will by default. Take a look in the firewall.log file when you try to
>> connect...
>>
>> "JimD" <jimd4115@.verizon.net> wrote in message
>> news:HcI5e.1264$1p4.1219@.trndny06...
>> Hi Folks!
>> I am trying to use 1 computer running XP home networked to a machine
>> using
>> XP Proand SQL Server (Desktop Edition from Developer) on 1 other
>> computer.
>> My MSACESS ADP refuses to see the SQL server even though I can do file
>> shares/printer shares between the two. Is XP home or Desktop SQL
>> incapable
>> of this? I really don't want to spend an exasperating weekend if its
>> futile!!
>> Thanks for youe help and advice,,,
>> Jim
>>
>>
>|||Hope this helps.
Search for the hosts file in your machine. you edit it with your notepad and
enter the machine name together with its IP address.
The downside of this is when your machine doesn't have a static IP, an
example of this is when it is getting its IP address from DHCP server, unless
you configure the DHCP server to reserve a certain IP address for the
machine, the IP address your machine will get may vary and you may need to
edit your hosts file everytime the IP address changes.
You may want to use DNS server in your network.
"JimD" wrote:
> Hi And Thank You!
> I have firewall completely shut off on both machines and Norton AutoProtect
> shutoff as well on both. I have TCP/IP ports set at 1433 on both as well. I
> need to connect with the machine name as the app is written that way. Could
> it possibly be something to do with accounts? I've tried Guest both on and
> off to no avail on the marching running SQL Developer (Desktop) Edition. I
> have tried for the last 12 hours and cannot even get Enterprise Manager to
> connect. I'm going crazy and this is business critical. If anyone can
> suggest anything else I'm, all ears...I need this connectivity by Monday
> morning or I'm in big trouble...I've tried everything I can thing of...
> Thanks so much...
> Jim
> jimd@.aries.com
> "Mercury" <me@.spam.com> wrote in message
> news:d38h1r$nn8$1@.lust.ihug.co.nz...
> > Hi,
> >
> > If you have the XP SP2 firewall running then it may be blocking traffic to
> > SQL Server on port 1433.
> > It will by default. Take a look in the firewall.log file when you try to
> > connect...
> >
> >
> > "JimD" <jimd4115@.verizon.net> wrote in message
> > news:HcI5e.1264$1p4.1219@.trndny06...
> >> Hi Folks!
> >>
> >> I am trying to use 1 computer running XP home networked to a machine
> >> using
> >> XP Proand SQL Server (Desktop Edition from Developer) on 1 other
> >> computer.
> >> My MSACESS ADP refuses to see the SQL server even though I can do file
> >> shares/printer shares between the two. Is XP home or Desktop SQL
> >> incapable
> >> of this? I really don't want to spend an exasperating weekend if its
> >> futile!!
> >>
> >> Thanks for youe help and advice,,,
> >> Jim
> >>
> >>
> >
> >
>
>|||Are you using MSDE SP3a? If so, network access is turned off by default for
security reasons (slammer is one of the reasons). You'll need to turn it
back on so you can access your MSDE from a remote machine via the network.
joe.
"JimD" <jimd4115@.verizon.net> wrote in message
news:Kh06e.1815$4v3.304@.trndny03...
> Hi And Thank You!
> I have firewall completely shut off on both machines and Norton
AutoProtect
> shutoff as well on both. I have TCP/IP ports set at 1433 on both as well.
I
> need to connect with the machine name as the app is written that way.
Could
> it possibly be something to do with accounts? I've tried Guest both on and
> off to no avail on the marching running SQL Developer (Desktop) Edition. I
> have tried for the last 12 hours and cannot even get Enterprise Manager to
> connect. I'm going crazy and this is business critical. If anyone can
> suggest anything else I'm, all ears...I need this connectivity by Monday
> morning or I'm in big trouble...I've tried everything I can thing of...
> Thanks so much...
> Jim
> jimd@.aries.com
> "Mercury" <me@.spam.com> wrote in message
> news:d38h1r$nn8$1@.lust.ihug.co.nz...
> > Hi,
> >
> > If you have the XP SP2 firewall running then it may be blocking traffic
to
> > SQL Server on port 1433.
> > It will by default. Take a look in the firewall.log file when you try to
> > connect...
> >
> >
> > "JimD" <jimd4115@.verizon.net> wrote in message
> > news:HcI5e.1264$1p4.1219@.trndny06...
> >> Hi Folks!
> >>
> >> I am trying to use 1 computer running XP home networked to a machine
> >> using
> >> XP Proand SQL Server (Desktop Edition from Developer) on 1 other
> >> computer.
> >> My MSACESS ADP refuses to see the SQL server even though I can do file
> >> shares/printer shares between the two. Is XP home or Desktop SQL
> >> incapable
> >> of this? I really don't want to spend an exasperating weekend if its
> >> futile!!
> >>
> >> Thanks for youe help and advice,,,
> >> Jim
> >>
> >>
> >
> >
>

Real Simple Quetion - I think!

Hi Folks!
I am trying to use 1 computer running XP home networked to a machine using
XP Proand SQL Server (Desktop Edition from Developer) on 1 other computer.
My MSACESS ADP refuses to see the SQL server even though I can do file
shares/printer shares between the two. Is XP home or Desktop SQL incapable
of this? I really don't want to spend an exasperating weekend if its
futile!!
Thanks for youe help and advice,,,
Jim
Hi
Try comnection with the IP address, and not the machine name.
Also, if you are running Windows XP SP2:
SQL 2000 and XP SP2:
http://msdn.microsoft.com/library/de...ar_ts_7eur.asp
Regards
Mike
"JimD" wrote:

> Hi Folks!
> I am trying to use 1 computer running XP home networked to a machine using
> XP Proand SQL Server (Desktop Edition from Developer) on 1 other computer.
> My MSACESS ADP refuses to see the SQL server even though I can do file
> shares/printer shares between the two. Is XP home or Desktop SQL incapable
> of this? I really don't want to spend an exasperating weekend if its
> futile!!
> Thanks for youe help and advice,,,
> Jim
>
>
|||Hi,
If you have the XP SP2 firewall running then it may be blocking traffic to
SQL Server on port 1433.
It will by default. Take a look in the firewall.log file when you try to
connect...
"JimD" <jimd4115@.verizon.net> wrote in message
news:HcI5e.1264$1p4.1219@.trndny06...
> Hi Folks!
> I am trying to use 1 computer running XP home networked to a machine using
> XP Proand SQL Server (Desktop Edition from Developer) on 1 other computer.
> My MSACESS ADP refuses to see the SQL server even though I can do file
> shares/printer shares between the two. Is XP home or Desktop SQL incapable
> of this? I really don't want to spend an exasperating weekend if its
> futile!!
> Thanks for youe help and advice,,,
> Jim
>
|||Hi And Thank You!
I have firewall completely shut off on both machines and Norton AutoProtect
shutoff as well on both. I have TCP/IP ports set at 1433 on both as well. I
need to connect with the machine name as the app is written that way. Could
it possibly be something to do with accounts? I've tried Guest both on and
off to no avail on the marching running SQL Developer (Desktop) Edition. I
have tried for the last 12 hours and cannot even get Enterprise Manager to
connect. I'm going crazy and this is business critical. If anyone can
suggest anything else I'm, all ears...I need this connectivity by Monday
morning or I'm in big trouble...I've tried everything I can thing of...
Thanks so much...
Jim
jimd@.aries.com
"Mercury" <me@.spam.com> wrote in message
news:d38h1r$nn8$1@.lust.ihug.co.nz...
> Hi,
> If you have the XP SP2 firewall running then it may be blocking traffic to
> SQL Server on port 1433.
> It will by default. Take a look in the firewall.log file when you try to
> connect...
>
> "JimD" <jimd4115@.verizon.net> wrote in message
> news:HcI5e.1264$1p4.1219@.trndny06...
>
|||JimD wrote:
> I've tried Guest both on and off to no avail on the
> marching running SQL Developer (Desktop) Edition. I have tried for
> the last 12 hours and cannot even get Enterprise Manager to connect.
>
I'm confused. Do you have a SQL account to log in to the server? It
sounds like you may not know a valid account to use. Can you connect
using the IP address?
David Gugick
Imceda Software
www.imceda.com
|||look at the following MS KB Article:
http://support.microsoft.com/kb/319930/EN-US/
and you may want to look at the following too:
http://support.microsoft.com/default...;EN-US;q325003
Good luck!
"JimD" <jimd4115@.verizon.net> wrote in message
news:Kh06e.1815$4v3.304@.trndny03...
> Hi And Thank You!
> I have firewall completely shut off on both machines and Norton
AutoProtect
> shutoff as well on both. I have TCP/IP ports set at 1433 on both as well.
I
> need to connect with the machine name as the app is written that way.
Could[vbcol=seagreen]
> it possibly be something to do with accounts? I've tried Guest both on and
> off to no avail on the marching running SQL Developer (Desktop) Edition. I
> have tried for the last 12 hours and cannot even get Enterprise Manager to
> connect. I'm going crazy and this is business critical. If anyone can
> suggest anything else I'm, all ears...I need this connectivity by Monday
> morning or I'm in big trouble...I've tried everything I can thing of...
> Thanks so much...
> Jim
> jimd@.aries.com
> "Mercury" <me@.spam.com> wrote in message
> news:d38h1r$nn8$1@.lust.ihug.co.nz...
to
>
|||You should be able to find odbcping on the bin folder for sql server. lookup
BOL for info on how to use it.
(I didn't see it mentioned in the above links - but I could be blind).
"JimD" <jimd4115@.verizon.net> wrote in message
news:Kh06e.1815$4v3.304@.trndny03...
> Hi And Thank You!
> I have firewall completely shut off on both machines and Norton
> AutoProtect shutoff as well on both. I have TCP/IP ports set at 1433 on
> both as well. I need to connect with the machine name as the app is
> written that way. Could it possibly be something to do with accounts? I've
> tried Guest both on and off to no avail on the marching running SQL
> Developer (Desktop) Edition. I have tried for the last 12 hours and cannot
> even get Enterprise Manager to connect. I'm going crazy and this is
> business critical. If anyone can suggest anything else I'm, all ears...I
> need this connectivity by Monday morning or I'm in big trouble...I've
> tried everything I can thing of...
> Thanks so much...
> Jim
> jimd@.aries.com
> "Mercury" <me@.spam.com> wrote in message
> news:d38h1r$nn8$1@.lust.ihug.co.nz...
>
|||Hope this helps.
Search for the hosts file in your machine. you edit it with your notepad and
enter the machine name together with its IP address.
The downside of this is when your machine doesn't have a static IP, an
example of this is when it is getting its IP address from DHCP server, unless
you configure the DHCP server to reserve a certain IP address for the
machine, the IP address your machine will get may vary and you may need to
edit your hosts file everytime the IP address changes.
You may want to use DNS server in your network.
"JimD" wrote:

> Hi And Thank You!
> I have firewall completely shut off on both machines and Norton AutoProtect
> shutoff as well on both. I have TCP/IP ports set at 1433 on both as well. I
> need to connect with the machine name as the app is written that way. Could
> it possibly be something to do with accounts? I've tried Guest both on and
> off to no avail on the marching running SQL Developer (Desktop) Edition. I
> have tried for the last 12 hours and cannot even get Enterprise Manager to
> connect. I'm going crazy and this is business critical. If anyone can
> suggest anything else I'm, all ears...I need this connectivity by Monday
> morning or I'm in big trouble...I've tried everything I can thing of...
> Thanks so much...
> Jim
> jimd@.aries.com
> "Mercury" <me@.spam.com> wrote in message
> news:d38h1r$nn8$1@.lust.ihug.co.nz...
>
>
|||Are you using MSDE SP3a? If so, network access is turned off by default for
security reasons (slammer is one of the reasons). You'll need to turn it
back on so you can access your MSDE from a remote machine via the network.
joe.
"JimD" <jimd4115@.verizon.net> wrote in message
news:Kh06e.1815$4v3.304@.trndny03...
> Hi And Thank You!
> I have firewall completely shut off on both machines and Norton
AutoProtect
> shutoff as well on both. I have TCP/IP ports set at 1433 on both as well.
I
> need to connect with the machine name as the app is written that way.
Could[vbcol=seagreen]
> it possibly be something to do with accounts? I've tried Guest both on and
> off to no avail on the marching running SQL Developer (Desktop) Edition. I
> have tried for the last 12 hours and cannot even get Enterprise Manager to
> connect. I'm going crazy and this is business critical. If anyone can
> suggest anything else I'm, all ears...I need this connectivity by Monday
> morning or I'm in big trouble...I've tried everything I can thing of...
> Thanks so much...
> Jim
> jimd@.aries.com
> "Mercury" <me@.spam.com> wrote in message
> news:d38h1r$nn8$1@.lust.ihug.co.nz...
to
>

Real Simple Quetion - I think!

Hi Folks!
I am trying to use 1 computer running XP home networked to a machine using
XP Proand SQL Server (Desktop Edition from Developer) on 1 other computer.
My MSACESS ADP refuses to see the SQL server even though I can do file
shares/printer shares between the two. Is XP home or Desktop SQL incapable
of this? I really don't want to spend an exasperating weekend if its
futile!!
Thanks for youe help and advice,,,
JimHi
Try comnection with the IP address, and not the machine name.
Also, if you are running Windows XP SP2:
SQL 2000 and XP SP2:
http://msdn.microsoft.com/library/d...br />
7eur.asp
Regards
Mike
"JimD" wrote:

> Hi Folks!
> I am trying to use 1 computer running XP home networked to a machine using
> XP Proand SQL Server (Desktop Edition from Developer) on 1 other computer.
> My MSACESS ADP refuses to see the SQL server even though I can do file
> shares/printer shares between the two. Is XP home or Desktop SQL incapable
> of this? I really don't want to spend an exasperating weekend if its
> futile!!
> Thanks for youe help and advice,,,
> Jim
>
>|||Hi,
If you have the XP SP2 firewall running then it may be blocking traffic to
SQL Server on port 1433.
It will by default. Take a look in the firewall.log file when you try to
connect...
"JimD" <jimd4115@.verizon.net> wrote in message
news:HcI5e.1264$1p4.1219@.trndny06...
> Hi Folks!
> I am trying to use 1 computer running XP home networked to a machine using
> XP Proand SQL Server (Desktop Edition from Developer) on 1 other computer.
> My MSACESS ADP refuses to see the SQL server even though I can do file
> shares/printer shares between the two. Is XP home or Desktop SQL incapable
> of this? I really don't want to spend an exasperating weekend if its
> futile!!
> Thanks for youe help and advice,,,
> Jim
>|||Hi And Thank You!
I have firewall completely shut off on both machines and Norton AutoProtect
shutoff as well on both. I have TCP/IP ports set at 1433 on both as well. I
need to connect with the machine name as the app is written that way. Could
it possibly be something to do with accounts? I've tried Guest both on and
off to no avail on the marching running SQL Developer (Desktop) Edition. I
have tried for the last 12 hours and cannot even get Enterprise Manager to
connect. I'm going crazy and this is business critical. If anyone can
suggest anything else I'm, all ears...I need this connectivity by Monday
morning or I'm in big trouble...I've tried everything I can thing of...
Thanks so much...
Jim
jimd@.aries.com
"Mercury" <me@.spam.com> wrote in message
news:d38h1r$nn8$1@.lust.ihug.co.nz...
> Hi,
> If you have the XP SP2 firewall running then it may be blocking traffic to
> SQL Server on port 1433.
> It will by default. Take a look in the firewall.log file when you try to
> connect...
>
> "JimD" <jimd4115@.verizon.net> wrote in message
> news:HcI5e.1264$1p4.1219@.trndny06...
>|||JimD wrote:
> I've tried Guest both on and off to no avail on the
> marching running SQL Developer (Desktop) Edition. I have tried for
> the last 12 hours and cannot even get Enterprise Manager to connect.
>
I'm confused. Do you have a SQL account to log in to the server? It
sounds like you may not know a valid account to use. Can you connect
using the IP address?
David Gugick
Imceda Software
www.imceda.com|||look at the following MS KB Article:
http://support.microsoft.com/kb/319930/EN-US/
and you may want to look at the following too:
http://support.microsoft.com/defaul...b;EN-US;q325003
Good luck!
"JimD" <jimd4115@.verizon.net> wrote in message
news:Kh06e.1815$4v3.304@.trndny03...
> Hi And Thank You!
> I have firewall completely shut off on both machines and Norton
AutoProtect
> shutoff as well on both. I have TCP/IP ports set at 1433 on both as well.
I
> need to connect with the machine name as the app is written that way.
Could
> it possibly be something to do with accounts? I've tried Guest both on and
> off to no avail on the marching running SQL Developer (Desktop) Edition. I
> have tried for the last 12 hours and cannot even get Enterprise Manager to
> connect. I'm going crazy and this is business critical. If anyone can
> suggest anything else I'm, all ears...I need this connectivity by Monday
> morning or I'm in big trouble...I've tried everything I can thing of...
> Thanks so much...
> Jim
> jimd@.aries.com
> "Mercury" <me@.spam.com> wrote in message
> news:d38h1r$nn8$1@.lust.ihug.co.nz...
to[vbcol=seagreen]
>|||You should be able to find odbcping on the bin folder for sql server. lookup
BOL for info on how to use it.
(I didn't see it mentioned in the above links - but I could be blind).
"JimD" <jimd4115@.verizon.net> wrote in message
news:Kh06e.1815$4v3.304@.trndny03...
> Hi And Thank You!
> I have firewall completely shut off on both machines and Norton
> AutoProtect shutoff as well on both. I have TCP/IP ports set at 1433 on
> both as well. I need to connect with the machine name as the app is
> written that way. Could it possibly be something to do with accounts? I've
> tried Guest both on and off to no avail on the marching running SQL
> Developer (Desktop) Edition. I have tried for the last 12 hours and cannot
> even get Enterprise Manager to connect. I'm going crazy and this is
> business critical. If anyone can suggest anything else I'm, all ears...I
> need this connectivity by Monday morning or I'm in big trouble...I've
> tried everything I can thing of...
> Thanks so much...
> Jim
> jimd@.aries.com
> "Mercury" <me@.spam.com> wrote in message
> news:d38h1r$nn8$1@.lust.ihug.co.nz...
>|||Hope this helps.
Search for the hosts file in your machine. you edit it with your notepad and
enter the machine name together with its IP address.
The downside of this is when your machine doesn't have a static IP, an
example of this is when it is getting its IP address from DHCP server, unles
s
you configure the DHCP server to reserve a certain IP address for the
machine, the IP address your machine will get may vary and you may need to
edit your hosts file everytime the IP address changes.
You may want to use DNS server in your network.
"JimD" wrote:

> Hi And Thank You!
> I have firewall completely shut off on both machines and Norton AutoProtec
t
> shutoff as well on both. I have TCP/IP ports set at 1433 on both as well.
I
> need to connect with the machine name as the app is written that way. Coul
d
> it possibly be something to do with accounts? I've tried Guest both on and
> off to no avail on the marching running SQL Developer (Desktop) Edition. I
> have tried for the last 12 hours and cannot even get Enterprise Manager to
> connect. I'm going crazy and this is business critical. If anyone can
> suggest anything else I'm, all ears...I need this connectivity by Monday
> morning or I'm in big trouble...I've tried everything I can thing of...
> Thanks so much...
> Jim
> jimd@.aries.com
> "Mercury" <me@.spam.com> wrote in message
> news:d38h1r$nn8$1@.lust.ihug.co.nz...
>
>|||Are you using MSDE SP3a? If so, network access is turned off by default for
security reasons (slammer is one of the reasons). You'll need to turn it
back on so you can access your MSDE from a remote machine via the network.
joe.
"JimD" <jimd4115@.verizon.net> wrote in message
news:Kh06e.1815$4v3.304@.trndny03...
> Hi And Thank You!
> I have firewall completely shut off on both machines and Norton
AutoProtect
> shutoff as well on both. I have TCP/IP ports set at 1433 on both as well.
I
> need to connect with the machine name as the app is written that way.
Could
> it possibly be something to do with accounts? I've tried Guest both on and
> off to no avail on the marching running SQL Developer (Desktop) Edition. I
> have tried for the last 12 hours and cannot even get Enterprise Manager to
> connect. I'm going crazy and this is business critical. If anyone can
> suggest anything else I'm, all ears...I need this connectivity by Monday
> morning or I'm in big trouble...I've tried everything I can thing of...
> Thanks so much...
> Jim
> jimd@.aries.com
> "Mercury" <me@.spam.com> wrote in message
> news:d38h1r$nn8$1@.lust.ihug.co.nz...
to[vbcol=seagreen]
>

Real Simple Question

Hi Folks!
I am trying to use 1 computer running XP home networked to a machine using
XP Proand SQL Server (Desktop Edition from Developer) on 1 other computer.
My MSACESS ADP refuses to see the SQL server even though I can do file
shares/printer shares between the two. Is XP home or Desktop SQL incapable
of this? I really don't want to spend an exasperating weekend if its
futile!!
Thanks for youe help and advice,,,
Jim
Hi
Answered in .Setup
Pleae do not multi-post.
Regards
Mike
"JimD" wrote:

> Hi Folks!
> I am trying to use 1 computer running XP home networked to a machine using
> XP Proand SQL Server (Desktop Edition from Developer) on 1 other computer.
> My MSACESS ADP refuses to see the SQL server even though I can do file
> shares/printer shares between the two. Is XP home or Desktop SQL incapable
> of this? I really don't want to spend an exasperating weekend if its
> futile!!
> Thanks for youe help and advice,,,
> Jim
>
>

Real Simple Question

Hi Folks!
I am trying to use 1 computer running XP home networked to a machine using
XP Proand SQL Server (Desktop Edition from Developer) on 1 other computer.
My MSACESS ADP refuses to see the SQL server even though I can do file
shares/printer shares between the two. Is XP home or Desktop SQL incapable
of this? I really don't want to spend an exasperating weekend if its
futile!!
Thanks for youe help and advice,,,
JimHi
Answered in .Setup
Pleae do not multi-post.
Regards
Mike
"JimD" wrote:

> Hi Folks!
> I am trying to use 1 computer running XP home networked to a machine using
> XP Proand SQL Server (Desktop Edition from Developer) on 1 other computer.
> My MSACESS ADP refuses to see the SQL server even though I can do file
> shares/printer shares between the two. Is XP home or Desktop SQL incapable
> of this? I really don't want to spend an exasperating weekend if its
> futile!!
> Thanks for youe help and advice,,,
> Jim
>
>