SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 universal naming convention.
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

gongxia649
So Suave

Azores
344 Posts

Posted - 08/21/2006 :  09:11:38  Show Profile  Visit gongxia649's Homepage  Reply with Quote
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
30219 Posts

Posted - 08/21/2006 :  09:16:00  Show Profile  Visit SwePeso's Homepage  Reply with Quote
What error message do you get?
Do you have appropriate rights on the share?


Peter Larsson
Helsingborg, Sweden
Go to Top of Page

gongxia649
So Suave

Azores
344 Posts

Posted - 08/21/2006 :  09:20:32  Show Profile  Visit gongxia649's Homepage  Reply with Quote
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.).
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

Sweden
30219 Posts

Posted - 08/21/2006 :  09:22:21  Show Profile  Visit SwePeso's Homepage  Reply with Quote
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
Go to Top of Page

gongxia649
So Suave

Azores
344 Posts

Posted - 08/21/2006 :  09:27:03  Show Profile  Visit gongxia649's Homepage  Reply with Quote
im using windows authentication to run sql server.
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

Sweden
30219 Posts

Posted - 08/21/2006 :  09:28:51  Show Profile  Visit SwePeso's Homepage  Reply with Quote
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
Go to Top of Page

gongxia649
So Suave

Azores
344 Posts

Posted - 08/21/2006 :  09:33:39  Show Profile  Visit gongxia649's Homepage  Reply with Quote
im running the sql server sevice with any other account. but i dont know which account. iknow its not localsystem for sure.
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

Sweden
30219 Posts

Posted - 08/21/2006 :  09:37:36  Show Profile  Visit SwePeso's Homepage  Reply with Quote
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
Go to Top of Page

gongxia649
So Suave

Azores
344 Posts

Posted - 08/21/2006 :  09:43:42  Show Profile  Visit gongxia649's Homepage  Reply with Quote
i cant find mssqlservere.

i found only
MSSQLServerADHelper
MSSQLServerOLAPService
and both are logon as local system account
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

Sweden
30219 Posts

Posted - 08/21/2006 :  09:49:28  Show Profile  Visit SwePeso's Homepage  Reply with Quote
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
Go to Top of Page

gongxia649
So Suave

Azores
344 Posts

Posted - 08/21/2006 :  09:54:29  Show Profile  Visit gongxia649's Homepage  Reply with Quote
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?
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

Sweden
30219 Posts

Posted - 08/21/2006 :  09:56:30  Show Profile  Visit SwePeso's Homepage  Reply with Quote
You have to do the procedure described above on the actual SQL Server machine. Are you running SQL Server locally?

Peter Larsson
Helsingborg, Sweden
Go to Top of Page

gongxia649
So Suave

Azores
344 Posts

Posted - 08/21/2006 :  10:00:43  Show Profile  Visit gongxia649's Homepage  Reply with Quote
sql server isn't installed locally.

Edited by - gongxia649 on 08/21/2006 10:02:28
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

Sweden
30219 Posts

Posted - 08/21/2006 :  10:04:49  Show Profile  Visit SwePeso's Homepage  Reply with Quote
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
Go to Top of Page

gongxia649
So Suave

Azores
344 Posts

Posted - 08/21/2006 :  10:16:04  Show Profile  Visit gongxia649's Homepage  Reply with Quote
have to talk to whomever is in charge of that machine. i dont have privilege to do that.
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

Sweden
30219 Posts

Posted - 08/21/2006 :  10:23:08  Show Profile  Visit SwePeso's Homepage  Reply with Quote
You do have an IT leader? Or IT decision responsible?

Peter Larsson
Helsingborg, Sweden
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

Sweden
30219 Posts

Posted - 08/21/2006 :  14:10:09  Show Profile  Visit SwePeso's Homepage  Reply with Quote
Hey!
What happened to the rest of the posts in this thread?

Peter Larsson
Helsingborg, Sweden
Go to Top of Page

pootle_flump
Flowing Fount of Yak Knowledge

United Kingdom
1064 Posts

Posted - 08/22/2006 :  04:05:48  Show Profile  Reply with Quote
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.
Go to Top of Page

chiragkhabaria
Flowing Fount of Yak Knowledge

India
1907 Posts

Posted - 08/22/2006 :  04:09:16  Show Profile  Visit chiragkhabaria's Homepage  Send chiragkhabaria a Yahoo! Message  Reply with Quote
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
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.28 seconds. Powered By: Snitz Forums 2000