universal naming convention. - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

universal naming convention.

Author

Topic

gongxia649
So Suave

344 Posts

Posted - 2006-08-21 : 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.

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2006-08-21 : 09:16:00

What error message do you get?
Do you have appropriate rights on the share?

Peter Larsson
Helsingborg, Sweden

gongxia649
So Suave

344 Posts

Posted - 2006-08-21 : 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

30421 Posts

Posted - 2006-08-21 : 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

344 Posts

Posted - 2006-08-21 : 09:27:03

im using windows authentication to run sql server.

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2006-08-21 : 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

344 Posts

Posted - 2006-08-21 : 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

30421 Posts

Posted - 2006-08-21 : 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

gongxia649
So Suave

344 Posts

Posted - 2006-08-21 : 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

30421 Posts

Posted - 2006-08-21 : 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

gongxia649
So Suave

344 Posts

Posted - 2006-08-21 : 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

30421 Posts

Posted - 2006-08-21 : 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

344 Posts

Posted - 2006-08-21 : 10:00:43

sql server isn't installed locally.

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2006-08-21 : 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

344 Posts

Posted - 2006-08-21 : 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

30421 Posts

Posted - 2006-08-21 : 10:23:08

You do have an IT leader? Or IT decision responsible?

Peter Larsson
Helsingborg, Sweden

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2006-08-21 : 14:10:09

Hey!
What happened to the rest of the posts in this thread?

Peter Larsson
Helsingborg, Sweden

pootle_flump

1064 Posts

Posted - 2006-08-22 : 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
Master Smack Fu Yak Hacker

1907 Posts

Posted - 2006-08-22 : 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

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources