andrewl77
asked on
P2P Sql Server Express and Windows 8.1 Connection Problem
Hi,
I have recently been forced to get two new pc's both running windows 8.1 (don't/didn't have time to roll back to windows 7) that replaced two windows 7 pc's that have gone to the land of pc's that no longer work.
I have sucessfully reinstalled all the software to both however I have an application that uses sql express servers with windows authentication that is now not working on the pc that connects remotely.
TITLE: Connect to Server
-------------------------- ----
Cannot connect to taskbay1\sqlexpress.
-------------------------- ----
ADDITIONAL INFORMATION:
Login failed. The login is from an untrusted domain and cannot be used with Windows authentication. (Microsoft SQL Server, Error: 18452)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&EvtSrc=MSSQLServer&EvtID=18452&LinkId=20476
-------------------------- ----
BUTTONS:
OK
-------------------------- ----
How can i change PC2 to be trusted on PC1 so that the PC2 can connect to the databases?
They have both joined the same homegroup and all other settings are identical to my previous windows 7 setup that worked without fault.
I have recently been forced to get two new pc's both running windows 8.1 (don't/didn't have time to roll back to windows 7) that replaced two windows 7 pc's that have gone to the land of pc's that no longer work.
I have sucessfully reinstalled all the software to both however I have an application that uses sql express servers with windows authentication that is now not working on the pc that connects remotely.
TITLE: Connect to Server
--------------------------
Cannot connect to taskbay1\sqlexpress.
--------------------------
ADDITIONAL INFORMATION:
Login failed. The login is from an untrusted domain and cannot be used with Windows authentication. (Microsoft SQL Server, Error: 18452)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&EvtSrc=MSSQLServer&EvtID=18452&LinkId=20476
--------------------------
BUTTONS:
OK
--------------------------
How can i change PC2 to be trusted on PC1 so that the PC2 can connect to the databases?
They have both joined the same homegroup and all other settings are identical to my previous windows 7 setup that worked without fault.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Hi,
On the 'server', have you checked that network access is configured?
HTH
David
On the 'server', have you checked that network access is configured?
HTH
David
Andrewl77
Have you tried any of our suggestions?
Please give us feedback, so we know if the issue us solved or if more assistance is needed.
Have you tried any of our suggestions?
Please give us feedback, so we know if the issue us solved or if more assistance is needed.
ASKER
Yes. ended up having to change both PC's to the same name and use the same login details for both PC's to get the remote pc to open the SQL database. Not ideal but its working atleast.
Open in new window
within Web.config/app.config file in your project, to ensure the project will work fine with the database.