Location:
State:
Carrier
Country
Status

If I use a password to log in I can't acces other PC's on the network


I have a small Atom based PC which is on 24/7.
I use it for data gathering , temperatures, electrical flows etc and to run my central heating system and my solar panels.

If I log in to my PC with a password I cannot access this server. I always get a network error whether that is through file explorer or one of my programs that reads the data from the server.

If I use a local account with no password it all works fine.
Has anyone any idea's what is causing this problem please?

BTW The server is running windows 7 pro and I don't use a password on that.

Thanks

Mike

It really is not a server per say. Itis just a workstation is how Windows will always see it. How are you trying to connect to it? What software are you using to gather data points, along with Database software?

It really is not a server per say. Itis just a workstation is how Windows will always see it. How are you trying to connect to it? What software are you using to gather data points, along with Database software?
Thanks for your reply.
I write my own programs in .net.
One Program transfers data from a sql server instance on the 'WorkStation' to a clone sql server instance on my Main PC and then displays the historical data
the other one Just reads live Power Data and displays it on my Main Pc

File explorer won't connect either
They work fine if I don't use a password but won't connect if I do

To clarify :
When My Main PC has a Password both my programs get the error
sql Exception: The connection string is wrong :Login failed . The Login is from an untrusted domain and cannot be used with Windows authentication

if I try to use file explorer I get am asked to give a username and password.
That 'Workstation' does not have a password so I tried putting the username and the new password for my Main PC but that does not work. no idea what would.

Sql server management tool gives me ':Login failed . The Login is from an untrusted domain and cannot be used with Windows authentication' Microsoft sql server error: 18452

Remote desktop still works ok

So it's something about windows authentication but I just don't have the knowledge to correct it.
I usually run my Main PC without a Passord but sometimes I need one.

thanks for your help

What are you putting as your user name?

I try these fairly indiscriminately until one works...

  • user@outlook.com(if a MS account)
  • UserName@COMPUTERNAME
  • COMPUTERNAMEUserName
  • \COMPUTERNAMEUserName


You need the user ID and computer name of the PC you are connecting tonot the one you are connecting from.

OK! In file explorer I used usernam@computername and it worked!
Well so far!
only got into one Folder so I'll have to have another look at sharing.
That still leaves me with the sql server problems though

If I use a password to log in I can't acces other PC's on the network