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
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Help - Local versus Domain account with SQL Server

Author  Topic 

dnpmoris
Starting Member

23 Posts
Posted - 2006-06-20 : 14:20:20
Hi,

I need some help in local versus domain account with SQL Server. I am recieving the below error when I imported a file (.log extention) and I think it has to be done with some local versus domain account. If any one can help me in this regards then it would be great.

Server: Msg 4861, Level 16, State 1, Procedure usp_ImportWebLog, Line 28
Could not bulk insert because file '\\wpscv4bh\WEBLOGS\wpscv5sw\w3svc1\ex051024.log' could not be opened. Operating system error code 5 (Access is denied.).

This has to do with local versus domain account with SQL Server Service and SQL Server Agent.

tkizer
Almighty SQL Goddess

38200 Posts
Posted - 2006-06-20 : 14:26:25
Is this from a job or are you just running BULK INSERT in Query Analyzer?

If from a job, is the account a domain account, local account, or setup to use Local System Account? If from Query Analyzer, are you connecting with a domain account?

Tara Kizer
aka tduggan
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

30421 Posts
Posted - 2006-06-20 : 14:27:25
I think it is the account that SQL Server is using, that don't have access to the file specified.


Peter Larsson
Helsingborg, Sweden
Go to Top of Page

dnpmoris
Starting Member

23 Posts
Posted - 2006-06-20 : 14:34:35
Yes, thi is from Query Analyzer and connecting with a Domain account. Is thaeir a way resolve this error.

Naveen

quote:
Originally posted by tkizer

Is this from a job or are you just running BULK INSERT in Query Analyzer?

If from a job, is the account a domain account, local account, or setup to use Local System Account? If from Query Analyzer, are you connecting with a domain account?

Tara Kizer
aka tduggan
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts
Posted - 2006-06-20 : 14:43:52
If you logged into the database server using your account, can you access the file via Start..Run:
\\wpscv4bh\WEBLOGS\wpscv5sw\w3svc1\ex051024.log

The path and file must be accessible from the database server's perspective.

Tara Kizer
aka tduggan
Go to Top of Page

dnpmoris
Starting Member

23 Posts
Posted - 2006-06-20 : 14:46:22
The file is accessible and still I am recieving the error.

quote:
Originally posted by tkizer

If you logged into the database server using your account, can you access the file via Start..Run:
\\wpscv4bh\WEBLOGS\wpscv5sw\w3svc1\ex051024.log

The path and file must be accessible from the database server's perspective.

Tara Kizer
aka tduggan
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts
Posted - 2006-06-20 : 14:54:11
What account are you using for the MSSQLSERVER service?

Tara Kizer
aka tduggan
Go to Top of Page

dnpmoris
Starting Member

23 Posts
Posted - 2006-06-20 : 15:15:08
I am using SQL Server Authentication Service.

Naveen
quote:
Originally posted by tkizer

What account are you using for the MSSQLSERVER service?

Tara Kizer
aka tduggan
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts
Posted - 2006-06-20 : 15:17:21
quote:
Originally posted by dnpmoris

I am using SQL Server Authentication Service.

Naveen
quote:
Originally posted by tkizer

What account are you using for the MSSQLSERVER service?

Tara Kizer
aka tduggan



I don't know what that is. Could you explain?

Tara Kizer
aka tduggan
Go to Top of Page

dnpmoris
Starting Member

23 Posts
Posted - 2006-06-20 : 15:22:48
I have been provided when I joined in the job and it will be residing on the remote machine. I am accessing database from my local machine with the authentication of the remote server. If you need some more info then feel free to ask me.

Naveen
quote:
Originally posted by tkizer

quote:
Originally posted by dnpmoris

I am using SQL Server Authentication Service.

Naveen
quote:
Originally posted by tkizer

What account are you using for the MSSQLSERVER service?

Tara Kizer
aka tduggan



I don't know what that is. Could you explain?

Tara Kizer
aka tduggan
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts
Posted - 2006-06-20 : 15:27:05
I still don't understand what you mean. In order to BULK INSERT to a remote path, the MSSQLSERVER service will need access to the file. So is the MSSQLSERVER service able to access the file? What is the account that the service is using?

Do you know what the MSSQLSERVER service is? If not, we can explain that part too.

Tara Kizer
aka tduggan
Go to Top of Page

dnpmoris
Starting Member

23 Posts
Posted - 2006-06-20 : 15:52:29
I donot know what the MSSQLSERVER Service is? I will be great if you can explain it to me.

Naveen
quote:
Originally posted by tkizer

I still don't understand what you mean. In order to BULK INSERT to a remote path, the MSSQLSERVER service will need access to the file. So is the MSSQLSERVER service able to access the file? What is the account that the service is using?

Do you know what the MSSQLSERVER service is? If not, we can explain that part too.

Tara Kizer
aka tduggan
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts
Posted - 2006-06-20 : 15:55:53
Right click on the server in Enterprise Manager. Go to security tab. What does it say in the Startup Service Account section?

You can also view this information on the database server in the Services Applet in Admin Tools.

Tara Kizer
aka tduggan
Go to Top of Page

dnpmoris
Starting Member

23 Posts
Posted - 2006-06-20 : 16:04:00
It did not say anything and no option is selected, it is simply greyed out (Not able to even change it).

Naveen

quote:
Originally posted by tkizer

Right click on the server in Enterprise Manager. Go to security tab. What does it say in the Startup Service Account section?

You can also view this information on the database server in the Services Applet in Admin Tools.

Tara Kizer
aka tduggan
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts
Posted - 2006-06-20 : 16:08:57
You need to talk to the sysadmin of your SQL Server then.

Tara Kizer
aka tduggan
Go to Top of Page

dnpmoris
Starting Member

23 Posts
Posted - 2006-06-20 : 16:16:29
Can you help me what I should talk to system admin?

Naveen
quote:
Originally posted by tkizer

You need to talk to the sysadmin of your SQL Server then.

Tara Kizer
aka tduggan
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts
Posted - 2006-06-20 : 16:23:58
Show him this thread. Let him know that you need to run BULK INSERT accessing a file remotely. He will need to look into the MSSQLSERVER service account.

Tara Kizer
aka tduggan
Go to Top of Page

dnpmoris
Starting Member

23 Posts
Posted - 2006-06-20 : 16:28:22
Thanks for your help tara.

Naveen
quote:
Originally posted by tkizer

Show him this thread. Let him know that you need to run BULK INSERT accessing a file remotely. He will need to look into the MSSQLSERVER service account.

Tara Kizer
aka tduggan
Go to Top of Page
   

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources

Articles

Forums

Blogs

Contact Us

About the Site