Localhost Vs Servername in Connection string of SQL Server 2000

Hi,
Do you know how ADO will behave based upon the servername that is
specified in the connection string of SQL Server 2000? When does it
work with localhost and when does it not? Is it documented that this is
the expected behavior?
Thanks,
Regards,
Pramod
With SQL Server2000 or older, the server name is "Compuername" or "(local)",
(plus "\instanceName" if necessary). It is not "localhost", which is used to
refer to web server, not SQL Server (I may be wrong on this: you can use
"localhost' for SQL Server 2005, though).
<ipramod@.gmail.com> wrote in message
news:1164191517.623131.63680@.e3g2000cwe.googlegrou ps.com...
> Hi,
> Do you know how ADO will behave based upon the servername that is
> specified in the connection string of SQL Server 2000? When does it
> work with localhost and when does it not? Is it documented that this is
> the expected behavior?
> Thanks,
> Regards,
> Pramod
>
|||Hi,
Is there any difference when we use (local) or localhost in connection
strings of SQL Server 2000 ?
Thanks,
Pramod
Norman Yuan wrote:[vbcol=seagreen]
> With SQL Server2000 or older, the server name is "Compuername" or "(local)",
> (plus "\instanceName" if necessary). It is not "localhost", which is used to
> refer to web server, not SQL Server (I may be wrong on this: you can use
> "localhost' for SQL Server 2005, though).
> <ipramod@.gmail.com> wrote in message
> news:1164191517.623131.63680@.e3g2000cwe.googlegrou ps.com...

Localhost Vs Servername in Connection string of SQL Server 2000

Hi,
Do you know how ADO will behave based upon the servername that is
specified in the connection string of SQL Server 2000? When does it
work with localhost and when does it not? Is it documented that this is
the expected behavior?
Thanks,
Regards,
PramodWith SQL Server2000 or older, the server name is "Compuername" or "(local)",
(plus "\instanceName" if necessary). It is not "localhost", which is used to
refer to web server, not SQL Server (I may be wrong on this: you can use
"localhost' for SQL Server 2005, though).
<ipramod@.gmail.com> wrote in message
news:1164191517.623131.63680@.e3g2000cwe.googlegroups.com...
> Hi,
> Do you know how ADO will behave based upon the servername that is
> specified in the connection string of SQL Server 2000? When does it
> work with localhost and when does it not? Is it documented that this is
> the expected behavior?
> Thanks,
> Regards,
> Pramod
>|||Hi,
Is there any difference when we use (local) or localhost in connection
strings of SQL Server 2000 ?
Thanks,
Pramod
Norman Yuan wrote:[vbcol=seagreen]
> With SQL Server2000 or older, the server name is "Compuername" or "(local)
",
> (plus "\instanceName" if necessary). It is not "localhost", which is used
to
> refer to web server, not SQL Server (I may be wrong on this: you can use
> "localhost' for SQL Server 2005, though).
> <ipramod@.gmail.com> wrote in message
> news:1164191517.623131.63680@.e3g2000cwe.googlegroups.com...

Localhost Vs Servername in Connection string of SQL Server 2000

Hi,
Do you know how ADO will behave based upon the servername that is
specified in the connection string of SQL Server 2000? When does it
work with localhost and when does it not? Is it documented that this is
the expected behavior?
Thanks,
Regards,
PramodWith SQL Server2000 or older, the server name is "Compuername" or "(local)",
(plus "\instanceName" if necessary). It is not "localhost", which is used to
refer to web server, not SQL Server (I may be wrong on this: you can use
"localhost' for SQL Server 2005, though).
<ipramod@.gmail.com> wrote in message
news:1164191517.623131.63680@.e3g2000cwe.googlegroups.com...
> Hi,
> Do you know how ADO will behave based upon the servername that is
> specified in the connection string of SQL Server 2000? When does it
> work with localhost and when does it not? Is it documented that this is
> the expected behavior?
> Thanks,
> Regards,
> Pramod
>|||Hi,
Is there any difference when we use (local) or localhost in connection
strings of SQL Server 2000 ?
Thanks,
Pramod
Norman Yuan wrote:
> With SQL Server2000 or older, the server name is "Compuername" or "(local)",
> (plus "\instanceName" if necessary). It is not "localhost", which is used to
> refer to web server, not SQL Server (I may be wrong on this: you can use
> "localhost' for SQL Server 2005, though).
> <ipramod@.gmail.com> wrote in message
> news:1164191517.623131.63680@.e3g2000cwe.googlegroups.com...
> > Hi,
> >
> > Do you know how ADO will behave based upon the servername that is
> > specified in the connection string of SQL Server 2000? When does it
> > work with localhost and when does it not? Is it documented that this is
> > the expected behavior?
> >
> > Thanks,
> > Regards,
> > Pramod
> >

Local Admin

If you start your SQL services with local admin and you have a process that
uses xp_cmdshell to get files based upon date on a remote server. Can you do
that?
What permission will I need to apply on the remote server folders or from
within the Sql2005 box issuing the xp_cmdshell request.
Thanks.First, you need to enable xp_cmdshell by using sp_configure (it is disabled
by default for security reasons).
Second, you need to give permissions on the remote shared folder to the
account used to run the SQL Server service. Usually this should be a Windows
domain account so it can access resources on the network.
Hope this helps,
Ben Nevarez
Senior Database Administrator
AIG SunAmerica
"AHartman" wrote:
> If you start your SQL services with local admin and you have a process that
> uses xp_cmdshell to get files based upon date on a remote server. Can you do
> that?
> What permission will I need to apply on the remote server folders or from
> within the Sql2005 box issuing the xp_cmdshell request.
>
> Thanks.
>|||No. Local admin won't have the required permissions for remote system
access. You will need to use a domain level account for the sql services
logins and give that account appropriate access.
--
Kevin G. Boles
TheSQLGuru
Indicium Resources, Inc.
"AHartman" <Hoosbruin@.Kconline.com> wrote in message
news:0PmdnSu0MdRCWNHanZ2dnUVZ_gGdnZ2d@.kconline.com...
> If you start your SQL services with local admin and you have a process
> that uses xp_cmdshell to get files based upon date on a remote server. Can
> you do that?
> What permission will I need to apply on the remote server folders or from
> within the Sql2005 box issuing the xp_cmdshell request.
>
> Thanks.|||In addition to the other posts:
If the login who executes xp_cmdshell isn't sysadmin you also need to define a proxy account.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"AHartman" <Hoosbruin@.Kconline.com> wrote in message
news:0PmdnSu0MdRCWNHanZ2dnUVZ_gGdnZ2d@.kconline.com...
> If you start your SQL services with local admin and you have a process that uses xp_cmdshell to
> get files based upon date on a remote server. Can you do that?
> What permission will I need to apply on the remote server folders or from within the Sql2005 box
> issuing the xp_cmdshell request.
>
> Thanks.

Local Admin

If you start your SQL services with local admin and you have a process that
uses xp_cmdshell to get files based upon date on a remote server. Can you do
that?
What permission will I need to apply on the remote server folders or from
within the Sql2005 box issuing the xp_cmdshell request.
Thanks.First, you need to enable xp_cmdshell by using sp_configure (it is disabled
by default for security reasons).
Second, you need to give permissions on the remote shared folder to the
account used to run the SQL Server service. Usually this should be a Windows
domain account so it can access resources on the network.
Hope this helps,
Ben Nevarez
Senior Database Administrator
AIG SunAmerica
"AHartman" wrote:

> If you start your SQL services with local admin and you have a process tha
t
> uses xp_cmdshell to get files based upon date on a remote server. Can you
do
> that?
> What permission will I need to apply on the remote server folders or from
> within the Sql2005 box issuing the xp_cmdshell request.
>
> Thanks.
>|||No. Local admin won't have the required permissions for remote system
access. You will need to use a domain level account for the sql services
logins and give that account appropriate access.
Kevin G. Boles
TheSQLGuru
Indicium Resources, Inc.
"AHartman" <Hoosbruin@.Kconline.com> wrote in message
news:0PmdnSu0MdRCWNHanZ2dnUVZ_gGdnZ2d@.kc
online.com...
> If you start your SQL services with local admin and you have a process
> that uses xp_cmdshell to get files based upon date on a remote server. Can
> you do that?
> What permission will I need to apply on the remote server folders or from
> within the Sql2005 box issuing the xp_cmdshell request.
>
> Thanks.|||In addition to the other posts:
If the login who executes xp_cmdshell isn't sysadmin you also need to define
a proxy account.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi
"AHartman" <Hoosbruin@.Kconline.com> wrote in message
news:0PmdnSu0MdRCWNHanZ2dnUVZ_gGdnZ2d@.kc
online.com...
> If you start your SQL services with local admin and you have a process tha
t uses xp_cmdshell to
> get files based upon date on a remote server. Can you do that?
> What permission will I need to apply on the remote server folders or from
within the Sql2005 box
> issuing the xp_cmdshell request.
>
> Thanks.

Local Admin

If you start your SQL services with local admin and you have a process that
uses xp_cmdshell to get files based upon date on a remote server. Can you do
that?
What permission will I need to apply on the remote server folders or from
within the Sql2005 box issuing the xp_cmdshell request.
Thanks.
First, you need to enable xp_cmdshell by using sp_configure (it is disabled
by default for security reasons).
Second, you need to give permissions on the remote shared folder to the
account used to run the SQL Server service. Usually this should be a Windows
domain account so it can access resources on the network.
Hope this helps,
Ben Nevarez
Senior Database Administrator
AIG SunAmerica
"AHartman" wrote:

> If you start your SQL services with local admin and you have a process that
> uses xp_cmdshell to get files based upon date on a remote server. Can you do
> that?
> What permission will I need to apply on the remote server folders or from
> within the Sql2005 box issuing the xp_cmdshell request.
>
> Thanks.
>
|||No. Local admin won't have the required permissions for remote system
access. You will need to use a domain level account for the sql services
logins and give that account appropriate access.
Kevin G. Boles
TheSQLGuru
Indicium Resources, Inc.
"AHartman" <Hoosbruin@.Kconline.com> wrote in message
news:0PmdnSu0MdRCWNHanZ2dnUVZ_gGdnZ2d@.kconline.com ...
> If you start your SQL services with local admin and you have a process
> that uses xp_cmdshell to get files based upon date on a remote server. Can
> you do that?
> What permission will I need to apply on the remote server folders or from
> within the Sql2005 box issuing the xp_cmdshell request.
>
> Thanks.