non-shareable-shareable drive??

[Richard_Branson]

Hi

I have an XP machine that's shareable but nobody can access the Darn thing - I just installed SQL 7.0 and since then I can't access it?

What could be the problem?

[plenderj]

Check the permissions on the drive

[Richard_Branson]

I checked and re-checked the permissions and it's not the permissions.

What else could it be?

[plenderj]

What happens when someone tries to access the share?
What if someone types in : \\computername (where 'computername' is your computer name ?)

[Richard_Branson]

They get an error that says they don't have permission to access the network resource and they must consult the system administrator

I gave everybody Full access to the Hdd and other drives but absolutelly can access it

???

[papacorn]

Originally posted by Richard_Branson
They get an error that says they don't have permission to access the network resource and they must consult the system administrator

I gave everybody Full access to the Hdd and other drives but absolutelly can access it

???

Soooooo... it sounds as if you and the sys admin are two different people. Hey, I have an idea. Why dont you look in the event viewer and post back the errors that coinside with this activity.

[Richard_Branson]

Originally posted by papacorn
Soooooo... it sounds as if you and the sys admin are two different people. Hey, I have an idea. Why dont you look in the event viewer and post back the errors that coinside with this activity.

Nah - I'm actually the Sys Admin

[visualAd]

Originally posted by Richard_Branson
They get an error that says they don't have permission to access the network resource and they must consult the system administrator

I gave everybody Full access to the Hdd and other drives but absolutelly can access it

???

Have you checked the sharing permissions ? They are often different from the actual permissions.

[Richard_Branson]

How do you mean?

I've been changing the sharing permissions all along

?

[visualAd]

Originally posted by Richard_Branson
How do you mean?

I've been changing the sharing permissions all along

?

Was just checking. Was it working before you installed SQL 7?

Also try the following at the command prompt:
net use \\computername\c$ /User:Administrator

This should prompt you for the admin password. If it doesn't then there must be a system policy which has been set.

Also check your event logs for authentication faliures.

[Richard_Branson]

Yes, It was working before i installed SQL7

I installed SQL on my machine and when other people try to access my machine via the network they can't.

The problem is that I created a procedure (sp_makewebtask - a system procedure) and i want it to dump some information on my local machine (from the server) but it can't because it can't access my local drives

???

[visualAd]

Originally posted by Richard_Branson
Yes, It was working before i installed SQL7

I installed SQL on my machine and when other people try to access my machine via the network they can't.

The problem is that I created a procedure (sp_makewebtask - a system procedure) and i want it to dump some information on my local machine (from the server) but it can't because it can't access my local drives

???

Did you attempt that command that I posted? - If yes what happened?


What do your event logs say?

[Richard_Branson]

Originally posted by visualAd
Did you attempt that command that I posted? - If yes what happened?


What do your event logs say?

Where am Suposed to run that command from?
from my query or somewhere in windows?

[visualAd]

Open command prompt from the start menu and type the following at the prompt:

net use \\computername\c$ /User:Administrator

Replace "Administrator" with the name of your Administrators account. It should prompt you for a password. If you type it correctly then it should say "Command Completed Successfully"

If that works try the following at the command prompt:

• net view \\computername
  This should display a list of shares on the remote system.
• net use x: \\computername\<sharename> /Persistent:No
  
  Where <sharename> is the name of the share you are trying to access.
  
  This should map the share to the X drive and it should now be visible in My Computer

If all of the above work then it is clear you can access the computer as an Administrator. So next log out and log back in and try the same commands but using the username and password you normally connect with.

Remember that when you connect to a share in Windows you are required to supply a username and password which is valid for the system you are connecting to. When you make and attempt to connect to a share via windows it will first attempt to connect using the username and password you logged on with. If they do not work windows should prompt via a dialog for them.