| Author |
 Topic  |
|
|
gongxia649
So Suave
Azores
344 Posts |
 Posted - 08/21/2006 : 09:11:38
|
how can i find the servername and sharefolder on my computer to access a file?
for the server name i used the ip aand sharefolder i used computer description.
i think its not right cause its not working. |
Edited by - gongxia649 on 08/21/2006 09:12:47
|
|
|
SwePeso
Patron Saint of Lost Yaks
Sweden
29138 Posts |
Posted - 08/21/2006 : 09:16:00
|
What error message do you get?
Do you have appropriate rights on the share?
Peter Larsson
Helsingborg, Sweden |
 |
|
|
gongxia649
So Suave
Azores
344 Posts |
Posted - 08/21/2006 : 09:20:32
|
Server: Msg 4861, Level 16, State 1, Line 2
Could not bulk insert because file '\\oit-isa1fsedoc4\edoc4-hava\daniel\1.txt' could not be opened. Operating system error code 5(Access is denied.).
|
|
|
|
SwePeso
Patron Saint of Lost Yaks
Sweden
29138 Posts |
Posted - 08/21/2006 : 09:22:21
|
With the account used for running SQL server, please make sure that the same account has at least read rights on the network share.
Peter Larsson
Helsingborg, Sweden |
|
|
|
gongxia649
So Suave
Azores
344 Posts |
Posted - 08/21/2006 : 09:27:03
|
| im using windows authentication to run sql server. |
|
|
|
SwePeso
Patron Saint of Lost Yaks
Sweden
29138 Posts |
Posted - 08/21/2006 : 09:28:51
|
You are using Windows Authentication to CONNECT to the SQL Server, yes. That's good!
How are you running the SQL Server Service? With LocalSystem or any other account?
Peter Larsson
Helsingborg, Sweden |
|
|
|
gongxia649
So Suave
Azores
344 Posts |
Posted - 08/21/2006 : 09:33:39
|
| im running the sql server sevice with any other account. but i dont know which account. iknow its not localsystem for sure. |
|
|
|
SwePeso
Patron Saint of Lost Yaks
Sweden
29138 Posts |
Posted - 08/21/2006 : 09:37:36
|
Rigth click "My computer" and choose Manage.
Under Services and Applications, expand Services node.
Look for MSSQLSERVER on the right and read the "Log On As" text. What does it read?
Peter Larsson
Helsingborg, Sweden |
Edited by - SwePeso on 08/21/2006 09:42:04 |
|
|
|
gongxia649
So Suave
Azores
344 Posts |
Posted - 08/21/2006 : 09:43:42
|
i cant find mssqlservere.
i found only
MSSQLServerADHelper
MSSQLServerOLAPService
and both are logon as local system account |
|
|
|
SwePeso
Patron Saint of Lost Yaks
Sweden
29138 Posts |
Posted - 08/21/2006 : 09:49:28
|
MSSQLServer should be right on top of the MSSQLServerADHelper.
Anyway, it seems to be quite possible that also MSSQLServer service is running under LOCALSYSTEM. What you have to do then, is to allow LOCALSYSTEM rights to read the network share.
Peter Larsson
Helsingborg, Sweden |
Edited by - SwePeso on 08/21/2006 09:49:40 |
|
|
|
gongxia649
So Suave
Azores
344 Posts |
Posted - 08/21/2006 : 09:54:29
|
mssqlserver is not on the services window. i know its suppose to be there, but it isnt. its weird.
how can i find out if mssqlserver service is running under localsystem? how to allow LOCALSYSTEM rights to read the network share? |
|
|
|
SwePeso
Patron Saint of Lost Yaks
Sweden
29138 Posts |
Posted - 08/21/2006 : 09:56:30
|
You have to do the procedure described above on the actual SQL Server machine. Are you running SQL Server locally?
Peter Larsson
Helsingborg, Sweden |
|
|
|
gongxia649
So Suave
Azores
344 Posts |
Posted - 08/21/2006 : 10:00:43
|
| sql server isn't installed locally. |
Edited by - gongxia649 on 08/21/2006 10:02:28 |
|
|
|
SwePeso
Patron Saint of Lost Yaks
Sweden
29138 Posts |
Posted - 08/21/2006 : 10:04:49
|
select serverproperty('MachineName') [This is the machine runnning SQL Server]
On this computer, you have to do the step described above to see which account SQL Server is running. This account you must give read access to the network share.
Peter Larsson
Helsingborg, Sweden |
|
|
|
gongxia649
So Suave
Azores
344 Posts |
Posted - 08/21/2006 : 10:16:04
|
| have to talk to whomever is in charge of that machine. i dont have privilege to do that. |
|
|
|
SwePeso
Patron Saint of Lost Yaks
Sweden
29138 Posts |
Posted - 08/21/2006 : 10:23:08
|
You do have an IT leader? Or IT decision responsible?
Peter Larsson
Helsingborg, Sweden |
|
|
|
SwePeso
Patron Saint of Lost Yaks
Sweden
29138 Posts |
Posted - 08/21/2006 : 14:10:09
|
Hey!
What happened to the rest of the posts in this thread?
Peter Larsson
Helsingborg, Sweden |
|
|
|
pootle_flump
Flowing Fount of Yak Knowledge
United Kingdom
1064 Posts |
Posted - 08/22/2006 : 04:05:48
|
quote:
Originally posted by Peso
Hey!
What happened to the rest of the posts in this thread?
Umm. perhaps this was covered but... if OP uses enterprise manager then (s)he can get the SQL Server startup service account by clicking the security tab of the of the server properties dialog. |
|
|
|
chiragkhabaria
Flowing Fount of Yak Knowledge
India
1907 Posts |
Posted - 08/22/2006 : 04:09:16
|
quote:
Originally posted by Peso
Hey!
What happened to the rest of the posts in this thread?
Peter Larsson
Helsingborg, Sweden
probably the user would have have deleted those thread
Chirag |
|
|
| |
Topic |
|
universal naming convention.
