Showing posts with label exist. Show all posts
Showing posts with label exist. Show all posts

Monday, March 19, 2012

Help! How do you remove a sql group when...

Hi all,
I am attempting to remove a sql server group from my list in enterprise
manager, none of the old registered sql servers in my group exist and the
connections to them times out. How does one get around this problem.
Cheers, LerpCan you not right click on the group in Enterprise Manager and choose
delete to delete the group? You will have to delete the server
registrations first.
Rand
This posting is provided "as is" with no warranties and confers no rights.

Help! How do you remove a sql group when...

Hi all,
I am attempting to remove a sql server group from my list in enterprise
manager, none of the old registered sql servers in my group exist and the
connections to them times out. How does one get around this problem.
Cheers, LerpCan you not right click on the group in Enterprise Manager and choose
delete to delete the group? You will have to delete the server
registrations first.
Rand
This posting is provided "as is" with no warranties and confers no rights.

Help! How do you remove a sql group when...

Hi all,
I am attempting to remove a sql server group from my list in enterprise
manager, none of the old registered sql servers in my group exist and the
connections to them times out. How does one get around this problem.
Cheers, Lerp
Can you not right click on the group in Enterprise Manager and choose
delete to delete the group? You will have to delete the server
registrations first.
Rand
This posting is provided "as is" with no warranties and confers no rights.

Monday, February 27, 2012

Help!

Our sql server started to this...
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access
denied.
We added new, quite huge sql-based site to our iis farm and after that we
get some times these error messages. Pages wich report these erros are fully
working. Why do get these errors? In last day we have recieved about ten of
these erors. Eroros are coming from all kins of asp. and .net pages at the
same time. After error occusr everything works fine again.
Wha can we do to prevent this happening? What causes these type of error
messages?
Server and connection strings are configured well, this is not error of miss
spelled program or connectionstrings. Theese erros are caused somewhere
else.
t
Hi
DSN, Did you configure an alias in Client Network Utility?
"TLehtinen" <timo@.raa.to> wrote in message
news:44155ecc$0$7489$39db0f71@.news.song.fi...
> Our sql server started to this...
> [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access
> denied.
> We added new, quite huge sql-based site to our iis farm and after that we
> get some times these error messages. Pages wich report these erros are
> fully working. Why do get these errors? In last day we have recieved about
> ten of these erors. Eroros are coming from all kins of asp. and .net pages
> at the same time. After error occusr everything works fine again.
> Wha can we do to prevent this happening? What causes these type of error
> messages?
>
> Server and connection strings are configured well, this is not error of
> miss spelled program or connectionstrings. Theese erros are caused
> somewhere else.
>
> t
>
|||Hello!
alias?
Everything has worked fine before we added this quite huge new web page
thing... Now pages applications that have worked before are reporting theese
error. not all the time only about ten error / day (and we do have now quite
a bit of transactions).
T
"Uri Dimant" <urid@.iscar.co.il> kirjoitti
viestiss:utVxLcpRGHA.5468@.TK2MSFTNGP14.phx.gbl...
> Hi
> DSN, Did you configure an alias in Client Network Utility?
>
> "TLehtinen" <timo@.raa.to> wrote in message
> news:44155ecc$0$7489$39db0f71@.news.song.fi...
>
|||The error is pretty clear. It could not find the server. Did you connect to
SQL Server on this (new one) web page?
"TLehtinen" <timo@.raa.to> wrote in message
news:441564a0$0$7479$39db0f71@.news.song.fi...
> Hello!
> alias?
> Everything has worked fine before we added this quite huge new web page
> thing... Now pages applications that have worked before are reporting
> theese error. not all the time only about ten error / day (and we do have
> now quite a bit of transactions).
>
> T
>
> "Uri Dimant" <urid@.iscar.co.il> kirjoitti
> viestiss:utVxLcpRGHA.5468@.TK2MSFTNGP14.phx.gbl...
>
|||aargh!!
Yes I know it seems like pretty clear to you and to me. But theese erros are
not systmaticly hapepening. These erros are occuring becouse of something
else. But what is that something else?
Normally every page are workin fine then I see from our eroor log that in
same minute (in same ten seconds) many applications are reporting this
error. And after that many hours without errors...
Does SQL server report theese erros if there is too much load on that time?
Or what might cause theese erros...
t
"Uri Dimant" <urid@.iscar.co.il> kirjoitti
viestiss:e%23YXTvpRGHA.5924@.TK2MSFTNGP09.phx.gbl. ..
> The error is pretty clear. It could not find the server. Did you connect
> to SQL Server on this (new one) web page?
>
> "TLehtinen" <timo@.raa.to> wrote in message
> news:441564a0$0$7479$39db0f71@.news.song.fi...
>
|||Could my prblem be related to this?
http://support.microsoft.com/default...b;en-us;328476
We have one SQL-server and 2 separate iis server as cluster. I run netstat
and found out that both IIS machines have nearly 2000 TIME-WAIT tcp session
open to our SQLserver. What shoud I do to prevent these erros happening?
T
"Uri Dimant" <urid@.iscar.co.il> kirjoitti
viestiss:e%23YXTvpRGHA.5924@.TK2MSFTNGP09.phx.gbl. ..
> The error is pretty clear. It could not find the server. Did you connect
> to SQL Server on this (new one) web page?
>
> "TLehtinen" <timo@.raa.to> wrote in message
> news:441564a0$0$7479$39db0f71@.news.song.fi...
>

Help!

Our sql server started to this...
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or
access
denied.
We added new, quite huge sql-based site to our iis farm and after that we
get some times these error messages. Pages wich report these erros are fully
working. Why do get these errors? In last day we have recieved about ten of
these erors. Eroros are coming from all kins of asp. and .net pages at the
same time. After error occusr everything works fine again.
Wha can we do to prevent this happening? What causes these type of error
messages?
Server and connection strings are configured well, this is not error of miss
spelled program or connectionstrings. Theese erros are caused somewhere
else.
tHi
DSN, Did you configure an alias in Client Network Utility?
"TLehtinen" <timo@.raa.to> wrote in message
news:44155ecc$0$7489$39db0f71@.news.song.fi...
> Our sql server started to this...
> [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist o
r access
> denied.
> We added new, quite huge sql-based site to our iis farm and after that we
> get some times these error messages. Pages wich report these erros are
> fully working. Why do get these errors? In last day we have recieved about
> ten of these erors. Eroros are coming from all kins of asp. and .net pages
> at the same time. After error occusr everything works fine again.
> Wha can we do to prevent this happening? What causes these type of error
> messages?
>
> Server and connection strings are configured well, this is not error of
> miss spelled program or connectionstrings. Theese erros are caused
> somewhere else.
>
> t
>|||Hello!
alias?
Everything has worked fine before we added this quite huge new web page
thing... Now pages applications that have worked before are reporting theese
error. not all the time only about ten error / day (and we do have now quite
a bit of transactions).
T
"Uri Dimant" <urid@.iscar.co.il> kirjoitti
viestiss:utVxLcpRGHA.5468@.TK2MSFTNGP14.phx.gbl...
> Hi
> DSN, Did you configure an alias in Client Network Utility?
>
> "TLehtinen" <timo@.raa.to> wrote in message
> news:44155ecc$0$7489$39db0f71@.news.song.fi...
>|||The error is pretty clear. It could not find the server. Did you connect to
SQL Server on this (new one) web page?
"TLehtinen" <timo@.raa.to> wrote in message
news:441564a0$0$7479$39db0f71@.news.song.fi...
> Hello!
> alias?
> Everything has worked fine before we added this quite huge new web page
> thing... Now pages applications that have worked before are reporting
> theese error. not all the time only about ten error / day (and we do have
> now quite a bit of transactions).
>
> T
>
> "Uri Dimant" <urid@.iscar.co.il> kirjoitti
> viestiss:utVxLcpRGHA.5468@.TK2MSFTNGP14.phx.gbl...
>|||aargh!!
Yes I know it seems like pretty clear to you and to me. But theese erros are
not systmaticly hapepening. These erros are occuring becouse of something
else. But what is that something else?
Normally every page are workin fine then I see from our eroor log that in
same minute (in same ten seconds) many applications are reporting this
error. And after that many hours without errors...
Does SQL server report theese erros if there is too much load on that time?
Or what might cause theese erros...
t
"Uri Dimant" <urid@.iscar.co.il> kirjoitti
viestiss:e%23YXTvpRGHA.5924@.TK2MSFTNGP09.phx.gbl...
> The error is pretty clear. It could not find the server. Did you connect
> to SQL Server on this (new one) web page?
>
> "TLehtinen" <timo@.raa.to> wrote in message
> news:441564a0$0$7479$39db0f71@.news.song.fi...
>|||Could my prblem be related to this?
http://support.microsoft.com/defaul...kb;en-us;328476
We have one SQL-server and 2 separate iis server as cluster. I run netstat
and found out that both IIS machines have nearly 2000 TIME-WAIT tcp session
open to our SQLserver. What shoud I do to prevent these erros happening?
T
"Uri Dimant" <urid@.iscar.co.il> kirjoitti
viestiss:e%23YXTvpRGHA.5924@.TK2MSFTNGP09.phx.gbl...
> The error is pretty clear. It could not find the server. Did you connect
> to SQL Server on this (new one) web page?
>
> "TLehtinen" <timo@.raa.to> wrote in message
> news:441564a0$0$7479$39db0f71@.news.song.fi...
>

Help!

Our sql server started to this...
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access
denied.
We added new, quite huge sql-based site to our iis farm and after that we
get some times these error messages. Pages wich report these erros are fully
working. Why do get these errors? In last day we have recieved about ten of
these erors. Eroros are coming from all kins of asp. and .net pages at the
same time. After error occusr everything works fine again.
Wha can we do to prevent this happening? What causes these type of error
messages?
Server and connection strings are configured well, this is not error of miss
spelled program or connectionstrings. Theese erros are caused somewhere
else.
tHi
DSN, Did you configure an alias in Client Network Utility?
"TLehtinen" <timo@.raa.to> wrote in message
news:44155ecc$0$7489$39db0f71@.news.song.fi...
> Our sql server started to this...
> [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access
> denied.
> We added new, quite huge sql-based site to our iis farm and after that we
> get some times these error messages. Pages wich report these erros are
> fully working. Why do get these errors? In last day we have recieved about
> ten of these erors. Eroros are coming from all kins of asp. and .net pages
> at the same time. After error occusr everything works fine again.
> Wha can we do to prevent this happening? What causes these type of error
> messages?
>
> Server and connection strings are configured well, this is not error of
> miss spelled program or connectionstrings. Theese erros are caused
> somewhere else.
>
> t
>|||Hello!
alias?
Everything has worked fine before we added this quite huge new web page
thing... Now pages applications that have worked before are reporting theese
error. not all the time only about ten error / day (and we do have now quite
a bit of transactions).
T
"Uri Dimant" <urid@.iscar.co.il> kirjoitti
viestissä:utVxLcpRGHA.5468@.TK2MSFTNGP14.phx.gbl...
> Hi
> DSN, Did you configure an alias in Client Network Utility?
>
> "TLehtinen" <timo@.raa.to> wrote in message
> news:44155ecc$0$7489$39db0f71@.news.song.fi...
>> Our sql server started to this...
>> [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or
>> access denied.
>> We added new, quite huge sql-based site to our iis farm and after that we
>> get some times these error messages. Pages wich report these erros are
>> fully working. Why do get these errors? In last day we have recieved
>> about ten of these erors. Eroros are coming from all kins of asp. and
>> .net pages at the same time. After error occusr everything works fine
>> again.
>> Wha can we do to prevent this happening? What causes these type of error
>> messages?
>>
>> Server and connection strings are configured well, this is not error of
>> miss spelled program or connectionstrings. Theese erros are caused
>> somewhere else.
>>
>> t
>|||The error is pretty clear. It could not find the server. Did you connect to
SQL Server on this (new one) web page?
"TLehtinen" <timo@.raa.to> wrote in message
news:441564a0$0$7479$39db0f71@.news.song.fi...
> Hello!
> alias?
> Everything has worked fine before we added this quite huge new web page
> thing... Now pages applications that have worked before are reporting
> theese error. not all the time only about ten error / day (and we do have
> now quite a bit of transactions).
>
> T
>
> "Uri Dimant" <urid@.iscar.co.il> kirjoitti
> viestissä:utVxLcpRGHA.5468@.TK2MSFTNGP14.phx.gbl...
>> Hi
>> DSN, Did you configure an alias in Client Network Utility?
>>
>> "TLehtinen" <timo@.raa.to> wrote in message
>> news:44155ecc$0$7489$39db0f71@.news.song.fi...
>> Our sql server started to this...
>> [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or
>> access denied.
>> We added new, quite huge sql-based site to our iis farm and after that
>> we get some times these error messages. Pages wich report these erros
>> are fully working. Why do get these errors? In last day we have recieved
>> about ten of these erors. Eroros are coming from all kins of asp. and
>> .net pages at the same time. After error occusr everything works fine
>> again.
>> Wha can we do to prevent this happening? What causes these type of error
>> messages?
>>
>> Server and connection strings are configured well, this is not error of
>> miss spelled program or connectionstrings. Theese erros are caused
>> somewhere else.
>>
>> t
>>
>|||aargh!!
Yes I know it seems like pretty clear to you and to me. But theese erros are
not systmaticly hapepening. These erros are occuring becouse of something
else. But what is that something else?
Normally every page are workin fine then I see from our eroor log that in
same minute (in same ten seconds) many applications are reporting this
error. And after that many hours without errors...
Does SQL server report theese erros if there is too much load on that time?
Or what might cause theese erros...
t
"Uri Dimant" <urid@.iscar.co.il> kirjoitti
viestissä:e%23YXTvpRGHA.5924@.TK2MSFTNGP09.phx.gbl...
> The error is pretty clear. It could not find the server. Did you connect
> to SQL Server on this (new one) web page?
>
> "TLehtinen" <timo@.raa.to> wrote in message
> news:441564a0$0$7479$39db0f71@.news.song.fi...
>> Hello!
>> alias?
>> Everything has worked fine before we added this quite huge new web page
>> thing... Now pages applications that have worked before are reporting
>> theese error. not all the time only about ten error / day (and we do have
>> now quite a bit of transactions).
>>
>> T
>>
>> "Uri Dimant" <urid@.iscar.co.il> kirjoitti
>> viestissä:utVxLcpRGHA.5468@.TK2MSFTNGP14.phx.gbl...
>> Hi
>> DSN, Did you configure an alias in Client Network Utility?
>>
>> "TLehtinen" <timo@.raa.to> wrote in message
>> news:44155ecc$0$7489$39db0f71@.news.song.fi...
>> Our sql server started to this...
>> [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or
>> access denied.
>> We added new, quite huge sql-based site to our iis farm and after that
>> we get some times these error messages. Pages wich report these erros
>> are fully working. Why do get these errors? In last day we have
>> recieved about ten of these erors. Eroros are coming from all kins of
>> asp. and .net pages at the same time. After error occusr everything
>> works fine again.
>> Wha can we do to prevent this happening? What causes these type of
>> error messages?
>>
>> Server and connection strings are configured well, this is not error of
>> miss spelled program or connectionstrings. Theese erros are caused
>> somewhere else.
>>
>> t
>>
>>
>|||Could my prblem be related to this?
http://support.microsoft.com/default.aspx?scid=kb;en-us;328476
We have one SQL-server and 2 separate iis server as cluster. I run netstat
and found out that both IIS machines have nearly 2000 TIME-WAIT tcp session
open to our SQLserver. What shoud I do to prevent these erros happening?
T
"Uri Dimant" <urid@.iscar.co.il> kirjoitti
viestissä:e%23YXTvpRGHA.5924@.TK2MSFTNGP09.phx.gbl...
> The error is pretty clear. It could not find the server. Did you connect
> to SQL Server on this (new one) web page?
>
> "TLehtinen" <timo@.raa.to> wrote in message
> news:441564a0$0$7479$39db0f71@.news.song.fi...
>> Hello!
>> alias?
>> Everything has worked fine before we added this quite huge new web page
>> thing... Now pages applications that have worked before are reporting
>> theese error. not all the time only about ten error / day (and we do have
>> now quite a bit of transactions).
>>
>> T
>>
>> "Uri Dimant" <urid@.iscar.co.il> kirjoitti
>> viestissä:utVxLcpRGHA.5468@.TK2MSFTNGP14.phx.gbl...
>> Hi
>> DSN, Did you configure an alias in Client Network Utility?
>>
>> "TLehtinen" <timo@.raa.to> wrote in message
>> news:44155ecc$0$7489$39db0f71@.news.song.fi...
>> Our sql server started to this...
>> [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or
>> access denied.
>> We added new, quite huge sql-based site to our iis farm and after that
>> we get some times these error messages. Pages wich report these erros
>> are fully working. Why do get these errors? In last day we have
>> recieved about ten of these erors. Eroros are coming from all kins of
>> asp. and .net pages at the same time. After error occusr everything
>> works fine again.
>> Wha can we do to prevent this happening? What causes these type of
>> error messages?
>>
>> Server and connection strings are configured well, this is not error of
>> miss spelled program or connectionstrings. Theese erros are caused
>> somewhere else.
>>
>> t
>>
>>
>

Friday, February 24, 2012

Help with xp_fileexist

Hello,
I am wanting to test to see if we have photos that exist on our photo
server. We store the photo names in a database and want to run a cursor to
check whether the physical photo is there. When I run the following:
select @.File = '\\photoserver-l-01\iphotos\hoco\ali\dcp_2965.jpg'
exec master..xp_fileexist @.File, @.i out
if @.i = 1
print ' exists'
else
print @.File + ' does not exists'
I get the does not exist msg. If I change the @.File to a file locally on the
dbserver box I get the exists msg. I seem to have a permission issue. The
instance on the dbserver is running on a local admin account that is not
part of the domain. Is there a way to run the script and impersonate someone
within the domain? Any ideas would be greatly appreciated.
Jake
Depedning on how this is run, either your NT login, or the NT login SQL
Server uses, or the login SQL Agent uses ( if a scheduled TSQL task) must
have the appropriate permissions...
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
"Jake" <rondican@.hotmail.com> wrote in message
news:%23tqjBTF7EHA.2180@.TK2MSFTNGP10.phx.gbl...
> Hello,
> I am wanting to test to see if we have photos that exist on our photo
> server. We store the photo names in a database and want to run a cursor to
> check whether the physical photo is there. When I run the following:
> select @.File = '\\photoserver-l-01\iphotos\hoco\ali\dcp_2965.jpg'
> exec master..xp_fileexist @.File, @.i out
> if @.i = 1
> print ' exists'
> else
> print @.File + ' does not exists'
>
> I get the does not exist msg. If I change the @.File to a file locally on
the
> dbserver box I get the exists msg. I seem to have a permission issue. The
> instance on the dbserver is running on a local admin account that is not
> part of the domain. Is there a way to run the script and impersonate
someone
> within the domain? Any ideas would be greatly appreciated.
> Jake
>
|||Wayne,
I login query analyzer using windows authentication. When I run the code
I still get the "does not exist" msg. However I can goto windows explorer
and open the file. So I have appropriate permissions. Any ideas on why else
it would tell me the file doesn't exist?
Jake
"Wayne Snyder" <wayne.nospam.snyder@.mariner-usa.com> wrote in message
news:OTxbuWF7EHA.3616@.TK2MSFTNGP11.phx.gbl...
> Depedning on how this is run, either your NT login, or the NT login SQL
> Server uses, or the login SQL Agent uses ( if a scheduled TSQL task) must
> have the appropriate permissions...
> --
> 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
> "Jake" <rondican@.hotmail.com> wrote in message
> news:%23tqjBTF7EHA.2180@.TK2MSFTNGP10.phx.gbl...
> the
> someone
>
|||The problem is that SQL is running under a local account. This doesn't have
access to the remote fileshare. You would need to run under a domain user
account.
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Jake" <rondican@.hotmail.com> wrote in message
news:%23tqjBTF7EHA.2180@.TK2MSFTNGP10.phx.gbl...
> Hello,
> I am wanting to test to see if we have photos that exist on our photo
> server. We store the photo names in a database and want to run a cursor to
> check whether the physical photo is there. When I run the following:
> select @.File = '\\photoserver-l-01\iphotos\hoco\ali\dcp_2965.jpg'
> exec master..xp_fileexist @.File, @.i out
> if @.i = 1
> print ' exists'
> else
> print @.File + ' does not exists'
>
> I get the does not exist msg. If I change the @.File to a file locally on
> the dbserver box I get the exists msg. I seem to have a permission issue.
> The instance on the dbserver is running on a local admin account that is
> not part of the domain. Is there a way to run the script and impersonate
> someone within the domain? Any ideas would be greatly appreciated.
> Jake
>
|||"Jake" <rondican@.hotmail.com> wrote in message
news:u8kiNjF7EHA.1408@.TK2MSFTNGP10.phx.gbl...
> Wayne,
> I login query analyzer using windows authentication. When I run the
code
> I still get the "does not exist" msg. However I can goto windows explorer
> and open the file. So I have appropriate permissions. Any ideas on why
else
> it would tell me the file doesn't exist?
I'm pretty sure the SERVER needs to have permissions. What account is SQL
Server running under?
[vbcol=seagreen]
> Jake
>
>
> "Wayne Snyder" <wayne.nospam.snyder@.mariner-usa.com> wrote in message
> news:OTxbuWF7EHA.3616@.TK2MSFTNGP11.phx.gbl...
must[vbcol=seagreen]
photo[vbcol=seagreen]
on[vbcol=seagreen]
The[vbcol=seagreen]
not
>
|||Greg,
SqlServer is running on an admin account of the local box only. The box
has been joined to the domain but the user that sql runs under doesn't exist
in the domain. I would prefer not to have sql run under a domain account if
there is a way to impersonate a user of the domain during the script but if
SQL needs to run under a domain user then I guess that's what needs to be
done. Do you have any further suggestions?
Jake
"Greg D. Moore (Strider)" <mooregr_deleteth1s@.greenms.com> wrote in message
news:QN%zd.77824$Uf.41443@.twister.nyroc.rr.com...
> "Jake" <rondican@.hotmail.com> wrote in message
> news:u8kiNjF7EHA.1408@.TK2MSFTNGP10.phx.gbl...
> code
> else
> I'm pretty sure the SERVER needs to have permissions. What account is SQL
> Server running under?
>
> must
> photo
> on
> The
> not
>
|||Yup, Jasper is right... If your SQL Server is running under localsystem, it
does, and can not have access to any network resources..
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
"Jake" <rondican@.hotmail.com> wrote in message
news:%23tqjBTF7EHA.2180@.TK2MSFTNGP10.phx.gbl...
> Hello,
> I am wanting to test to see if we have photos that exist on our photo
> server. We store the photo names in a database and want to run a cursor to
> check whether the physical photo is there. When I run the following:
> select @.File = '\\photoserver-l-01\iphotos\hoco\ali\dcp_2965.jpg'
> exec master..xp_fileexist @.File, @.i out
> if @.i = 1
> print ' exists'
> else
> print @.File + ' does not exists'
>
> I get the does not exist msg. If I change the @.File to a file locally on
the
> dbserver box I get the exists msg. I seem to have a permission issue. The
> instance on the dbserver is running on a local admin account that is not
> part of the domain. Is there a way to run the script and impersonate
someone
> within the domain? Any ideas would be greatly appreciated.
> Jake
>

Help with xp_fileexist

Hello,
I am wanting to test to see if we have photos that exist on our photo
server. We store the photo names in a database and want to run a cursor to
check whether the physical photo is there. When I run the following:
select @.File = '\\photoserver-l-01\iphotos\hoco\ali\dcp_2965.jpg'
exec master..xp_fileexist @.File, @.i out
if @.i = 1
print ' exists'
else
print @.File + ' does not exists'
I get the does not exist msg. If I change the @.File to a file locally on the
dbserver box I get the exists msg. I seem to have a permission issue. The
instance on the dbserver is running on a local admin account that is not
part of the domain. Is there a way to run the script and impersonate someone
within the domain? Any ideas would be greatly appreciated.
JakeDepedning on how this is run, either your NT login, or the NT login SQL
Server uses, or the login SQL Agent uses ( if a scheduled TSQL task) must
have the appropriate permissions...
--
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
"Jake" <rondican@.hotmail.com> wrote in message
news:%23tqjBTF7EHA.2180@.TK2MSFTNGP10.phx.gbl...
> Hello,
> I am wanting to test to see if we have photos that exist on our photo
> server. We store the photo names in a database and want to run a cursor to
> check whether the physical photo is there. When I run the following:
> select @.File = '\\photoserver-l-01\iphotos\hoco\ali\dcp_2965.jpg'
> exec master..xp_fileexist @.File, @.i out
> if @.i = 1
> print ' exists'
> else
> print @.File + ' does not exists'
>
> I get the does not exist msg. If I change the @.File to a file locally on
the
> dbserver box I get the exists msg. I seem to have a permission issue. The
> instance on the dbserver is running on a local admin account that is not
> part of the domain. Is there a way to run the script and impersonate
someone
> within the domain? Any ideas would be greatly appreciated.
> Jake
>|||Wayne,
I login query analyzer using windows authentication. When I run the code
I still get the "does not exist" msg. However I can goto windows explorer
and open the file. So I have appropriate permissions. Any ideas on why else
it would tell me the file doesn't exist?
Jake
"Wayne Snyder" <wayne.nospam.snyder@.mariner-usa.com> wrote in message
news:OTxbuWF7EHA.3616@.TK2MSFTNGP11.phx.gbl...
> Depedning on how this is run, either your NT login, or the NT login SQL
> Server uses, or the login SQL Agent uses ( if a scheduled TSQL task) must
> have the appropriate permissions...
> --
> 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
> "Jake" <rondican@.hotmail.com> wrote in message
> news:%23tqjBTF7EHA.2180@.TK2MSFTNGP10.phx.gbl...
>> Hello,
>> I am wanting to test to see if we have photos that exist on our photo
>> server. We store the photo names in a database and want to run a cursor
>> to
>> check whether the physical photo is there. When I run the following:
>> select @.File = '\\photoserver-l-01\iphotos\hoco\ali\dcp_2965.jpg'
>> exec master..xp_fileexist @.File, @.i out
>> if @.i = 1
>> print ' exists'
>> else
>> print @.File + ' does not exists'
>>
>> I get the does not exist msg. If I change the @.File to a file locally on
> the
>> dbserver box I get the exists msg. I seem to have a permission issue. The
>> instance on the dbserver is running on a local admin account that is not
>> part of the domain. Is there a way to run the script and impersonate
> someone
>> within the domain? Any ideas would be greatly appreciated.
>> Jake
>>
>|||The problem is that SQL is running under a local account. This doesn't have
access to the remote fileshare. You would need to run under a domain user
account.
--
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Jake" <rondican@.hotmail.com> wrote in message
news:%23tqjBTF7EHA.2180@.TK2MSFTNGP10.phx.gbl...
> Hello,
> I am wanting to test to see if we have photos that exist on our photo
> server. We store the photo names in a database and want to run a cursor to
> check whether the physical photo is there. When I run the following:
> select @.File = '\\photoserver-l-01\iphotos\hoco\ali\dcp_2965.jpg'
> exec master..xp_fileexist @.File, @.i out
> if @.i = 1
> print ' exists'
> else
> print @.File + ' does not exists'
>
> I get the does not exist msg. If I change the @.File to a file locally on
> the dbserver box I get the exists msg. I seem to have a permission issue.
> The instance on the dbserver is running on a local admin account that is
> not part of the domain. Is there a way to run the script and impersonate
> someone within the domain? Any ideas would be greatly appreciated.
> Jake
>|||"Jake" <rondican@.hotmail.com> wrote in message
news:u8kiNjF7EHA.1408@.TK2MSFTNGP10.phx.gbl...
> Wayne,
> I login query analyzer using windows authentication. When I run the
code
> I still get the "does not exist" msg. However I can goto windows explorer
> and open the file. So I have appropriate permissions. Any ideas on why
else
> it would tell me the file doesn't exist?
I'm pretty sure the SERVER needs to have permissions. What account is SQL
Server running under?
> Jake
>
>
> "Wayne Snyder" <wayne.nospam.snyder@.mariner-usa.com> wrote in message
> news:OTxbuWF7EHA.3616@.TK2MSFTNGP11.phx.gbl...
> > Depedning on how this is run, either your NT login, or the NT login SQL
> > Server uses, or the login SQL Agent uses ( if a scheduled TSQL task)
must
> > have the appropriate permissions...
> >
> > --
> > 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
> >
> > "Jake" <rondican@.hotmail.com> wrote in message
> > news:%23tqjBTF7EHA.2180@.TK2MSFTNGP10.phx.gbl...
> >> Hello,
> >>
> >> I am wanting to test to see if we have photos that exist on our
photo
> >> server. We store the photo names in a database and want to run a cursor
> >> to
> >> check whether the physical photo is there. When I run the following:
> >>
> >> select @.File = '\\photoserver-l-01\iphotos\hoco\ali\dcp_2965.jpg'
> >> exec master..xp_fileexist @.File, @.i out
> >> if @.i = 1
> >> print ' exists'
> >> else
> >> print @.File + ' does not exists'
> >>
> >>
> >> I get the does not exist msg. If I change the @.File to a file locally
on
> > the
> >> dbserver box I get the exists msg. I seem to have a permission issue.
The
> >> instance on the dbserver is running on a local admin account that is
not
> >> part of the domain. Is there a way to run the script and impersonate
> > someone
> >> within the domain? Any ideas would be greatly appreciated.
> >>
> >> Jake
> >>
> >>
> >
> >
>|||Greg,
SqlServer is running on an admin account of the local box only. The box
has been joined to the domain but the user that sql runs under doesn't exist
in the domain. I would prefer not to have sql run under a domain account if
there is a way to impersonate a user of the domain during the script but if
SQL needs to run under a domain user then I guess that's what needs to be
done. Do you have any further suggestions?
Jake
"Greg D. Moore (Strider)" <mooregr_deleteth1s@.greenms.com> wrote in message
news:QN%zd.77824$Uf.41443@.twister.nyroc.rr.com...
> "Jake" <rondican@.hotmail.com> wrote in message
> news:u8kiNjF7EHA.1408@.TK2MSFTNGP10.phx.gbl...
>> Wayne,
>> I login query analyzer using windows authentication. When I run the
> code
>> I still get the "does not exist" msg. However I can goto windows explorer
>> and open the file. So I have appropriate permissions. Any ideas on why
> else
>> it would tell me the file doesn't exist?
> I'm pretty sure the SERVER needs to have permissions. What account is SQL
> Server running under?
>
>> Jake
>>
>>
>> "Wayne Snyder" <wayne.nospam.snyder@.mariner-usa.com> wrote in message
>> news:OTxbuWF7EHA.3616@.TK2MSFTNGP11.phx.gbl...
>> > Depedning on how this is run, either your NT login, or the NT login SQL
>> > Server uses, or the login SQL Agent uses ( if a scheduled TSQL task)
> must
>> > have the appropriate permissions...
>> >
>> > --
>> > 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
>> >
>> > "Jake" <rondican@.hotmail.com> wrote in message
>> > news:%23tqjBTF7EHA.2180@.TK2MSFTNGP10.phx.gbl...
>> >> Hello,
>> >>
>> >> I am wanting to test to see if we have photos that exist on our
> photo
>> >> server. We store the photo names in a database and want to run a
>> >> cursor
>> >> to
>> >> check whether the physical photo is there. When I run the following:
>> >>
>> >> select @.File = '\\photoserver-l-01\iphotos\hoco\ali\dcp_2965.jpg'
>> >> exec master..xp_fileexist @.File, @.i out
>> >> if @.i = 1
>> >> print ' exists'
>> >> else
>> >> print @.File + ' does not exists'
>> >>
>> >>
>> >> I get the does not exist msg. If I change the @.File to a file locally
> on
>> > the
>> >> dbserver box I get the exists msg. I seem to have a permission issue.
> The
>> >> instance on the dbserver is running on a local admin account that is
> not
>> >> part of the domain. Is there a way to run the script and impersonate
>> > someone
>> >> within the domain? Any ideas would be greatly appreciated.
>> >>
>> >> Jake
>> >>
>> >>
>> >
>> >
>>
>|||Yup, Jasper is right... If your SQL Server is running under localsystem, it
does, and can not have access to any network resources..
--
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
"Jake" <rondican@.hotmail.com> wrote in message
news:%23tqjBTF7EHA.2180@.TK2MSFTNGP10.phx.gbl...
> Hello,
> I am wanting to test to see if we have photos that exist on our photo
> server. We store the photo names in a database and want to run a cursor to
> check whether the physical photo is there. When I run the following:
> select @.File = '\\photoserver-l-01\iphotos\hoco\ali\dcp_2965.jpg'
> exec master..xp_fileexist @.File, @.i out
> if @.i = 1
> print ' exists'
> else
> print @.File + ' does not exists'
>
> I get the does not exist msg. If I change the @.File to a file locally on
the
> dbserver box I get the exists msg. I seem to have a permission issue. The
> instance on the dbserver is running on a local admin account that is not
> part of the domain. Is there a way to run the script and impersonate
someone
> within the domain? Any ideas would be greatly appreciated.
> Jake
>

Help with xp_fileexist

Hello,
I am wanting to test to see if we have photos that exist on our photo
server. We store the photo names in a database and want to run a cursor to
check whether the physical photo is there. When I run the following:
select @.File = '\\photoserver-l-01\iphotos\hoco\ali\dcp_2965.jpg'
exec master..xp_fileexist @.File, @.i out
if @.i = 1
print ' exists'
else
print @.File + ' does not exists'
I get the does not exist msg. If I change the @.File to a file locally on the
dbserver box I get the exists msg. I seem to have a permission issue. The
instance on the dbserver is running on a local admin account that is not
part of the domain. Is there a way to run the script and impersonate someone
within the domain? Any ideas would be greatly appreciated.
JakeDepedning on how this is run, either your NT login, or the NT login SQL
Server uses, or the login SQL Agent uses ( if a scheduled TSQL task) must
have the appropriate permissions...
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
"Jake" <rondican@.hotmail.com> wrote in message
news:%23tqjBTF7EHA.2180@.TK2MSFTNGP10.phx.gbl...
> Hello,
> I am wanting to test to see if we have photos that exist on our photo
> server. We store the photo names in a database and want to run a cursor to
> check whether the physical photo is there. When I run the following:
> select @.File = '\\photoserver-l-01\iphotos\hoco\ali\dcp_2965.jpg'
> exec master..xp_fileexist @.File, @.i out
> if @.i = 1
> print ' exists'
> else
> print @.File + ' does not exists'
>
> I get the does not exist msg. If I change the @.File to a file locally on
the
> dbserver box I get the exists msg. I seem to have a permission issue. The
> instance on the dbserver is running on a local admin account that is not
> part of the domain. Is there a way to run the script and impersonate
someone
> within the domain? Any ideas would be greatly appreciated.
> Jake
>|||Wayne,
I login query analyzer using windows authentication. When I run the code
I still get the "does not exist" msg. However I can goto windows explorer
and open the file. So I have appropriate permissions. Any ideas on why else
it would tell me the file doesn't exist?
Jake
"Wayne Snyder" <wayne.nospam.snyder@.mariner-usa.com> wrote in message
news:OTxbuWF7EHA.3616@.TK2MSFTNGP11.phx.gbl...
> Depedning on how this is run, either your NT login, or the NT login SQL
> Server uses, or the login SQL Agent uses ( if a scheduled TSQL task) must
> have the appropriate permissions...
> --
> 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
> "Jake" <rondican@.hotmail.com> wrote in message
> news:%23tqjBTF7EHA.2180@.TK2MSFTNGP10.phx.gbl...
> the
> someone
>|||The problem is that SQL is running under a local account. This doesn't have
access to the remote fileshare. You would need to run under a domain user
account.
HTH
Jasper Smith (SQL Server MVP)
http://www.sqldbatips.com
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Jake" <rondican@.hotmail.com> wrote in message
news:%23tqjBTF7EHA.2180@.TK2MSFTNGP10.phx.gbl...
> Hello,
> I am wanting to test to see if we have photos that exist on our photo
> server. We store the photo names in a database and want to run a cursor to
> check whether the physical photo is there. When I run the following:
> select @.File = '\\photoserver-l-01\iphotos\hoco\ali\dcp_2965.jpg'
> exec master..xp_fileexist @.File, @.i out
> if @.i = 1
> print ' exists'
> else
> print @.File + ' does not exists'
>
> I get the does not exist msg. If I change the @.File to a file locally on
> the dbserver box I get the exists msg. I seem to have a permission issue.
> The instance on the dbserver is running on a local admin account that is
> not part of the domain. Is there a way to run the script and impersonate
> someone within the domain? Any ideas would be greatly appreciated.
> Jake
>|||"Jake" <rondican@.hotmail.com> wrote in message
news:u8kiNjF7EHA.1408@.TK2MSFTNGP10.phx.gbl...
> Wayne,
> I login query analyzer using windows authentication. When I run the
code
> I still get the "does not exist" msg. However I can goto windows explorer
> and open the file. So I have appropriate permissions. Any ideas on why
else
> it would tell me the file doesn't exist?
I'm pretty sure the SERVER needs to have permissions. What account is SQL
Server running under?

> Jake
>
>
> "Wayne Snyder" <wayne.nospam.snyder@.mariner-usa.com> wrote in message
> news:OTxbuWF7EHA.3616@.TK2MSFTNGP11.phx.gbl...
must[vbcol=seagreen]
photo[vbcol=seagreen]
on[vbcol=seagreen]
The[vbcol=seagreen]
not[vbcol=seagreen]
>|||Greg,
SqlServer is running on an admin account of the local box only. The box
has been joined to the domain but the user that sql runs under doesn't exist
in the domain. I would prefer not to have sql run under a domain account if
there is a way to impersonate a user of the domain during the script but if
SQL needs to run under a domain user then I guess that's what needs to be
done. Do you have any further suggestions?
Jake
"Greg D. Moore (Strider)" <mooregr_deleteth1s@.greenms.com> wrote in message
news:QN%zd.77824$Uf.41443@.twister.nyroc.rr.com...
> "Jake" <rondican@.hotmail.com> wrote in message
> news:u8kiNjF7EHA.1408@.TK2MSFTNGP10.phx.gbl...
> code
> else
> I'm pretty sure the SERVER needs to have permissions. What account is SQL
> Server running under?
>
> must
> photo
> on
> The
> not
>|||Yup, Jasper is right... If your SQL Server is running under localsystem, it
does, and can not have access to any network resources..
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
"Jake" <rondican@.hotmail.com> wrote in message
news:%23tqjBTF7EHA.2180@.TK2MSFTNGP10.phx.gbl...
> Hello,
> I am wanting to test to see if we have photos that exist on our photo
> server. We store the photo names in a database and want to run a cursor to
> check whether the physical photo is there. When I run the following:
> select @.File = '\\photoserver-l-01\iphotos\hoco\ali\dcp_2965.jpg'
> exec master..xp_fileexist @.File, @.i out
> if @.i = 1
> print ' exists'
> else
> print @.File + ' does not exists'
>
> I get the does not exist msg. If I change the @.File to a file locally on
the
> dbserver box I get the exists msg. I seem to have a permission issue. The
> instance on the dbserver is running on a local admin account that is not
> part of the domain. Is there a way to run the script and impersonate
someone
> within the domain? Any ideas would be greatly appreciated.
> Jake
>