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.
andrewl77Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Marten RuneSQL Expert/Infrastructure ArchitectCommented:
Create the EXACTLY same account on both PC's
I e, the same local account with identical names AND identical passwords.

Then use this account to Query SQL from the machine without SQL.

Ofcourse you need to assign permisstions to this account on the SQL Express instance.

Regards Marten

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
HuaMin ChenProblem resolverCommented:
Try to put this
	<connectionStrings>
		<add name="conn2" connectionString="Data Source=192.?.?.?\your_db_instance;Initial Catalog=your_db_schema;Integrated Security=False;User ID=your_db_login;Password=??????" providerName="System.Data.SqlClient"/>
	</connectionStrings>

Open in new window

within Web.config/app.config file in your project, to ensure the project will work fine with the database.
David ToddSenior Database AdministratorCommented:
Hi,

On the 'server', have you checked that network access is configured?

HTH
  David
Marten RuneSQL Expert/Infrastructure ArchitectCommented:
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.
andrewl77Author Commented:
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.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.