The issue seems to be above my knowledge level at this point.

Aws For Visual Studio Toolkit Free Tier RDS

I am a college student working in a group with 4 other students on a project where we have created an SQL Server database using Amazon AWS free tier RDS service.

Aws For Visual Studio Toolkit How To Host Our

I am learning much of this on the fly as we werent given really any instruction for how to host our server for this project, so Ive created the RDS Instance on AWS and provided the server information and credentials.

I am able to connect and access this from SQL Server Management Studio and Visual Studio on my computer and have been able to add data to our tables, etc.

Verify that the instance name is correct and that the SQL Server is configured to allow remote connections.

Named Pipes Provider, Error: 40 - Could not open a connection to SQL Server)(Microsoft SQL Server, Error: 53).

Ive made sure that the DB instance allows public access on the AWS console.

Ive had him check to make sure port 1433 isnt restricted on his computer.

He does not need to be able to connect with the AWS Toolkit, but he does need to be able to connect to this server on his Visual StudioSSMS.

Ive spent hours Googling the issue and looking for solutions but I have yet to find this scenario where the connection works on 3 computers but does not work on 1, and the suggestions produced from those searches have not helped.

And if you follow the troubleshooting article in the link, if you test the connectivity and that is fine it is likely with the user authentication.

So Id be inclined to guess its along those lines with the user, how its configured or how they are connecting.

It looks like you may have gotten an error related to the default database the user has when connecting - do all users have the same default database, permissions, etc And in SSMS, click on the Options tab when the login window pops up.

There are additional settings you can use to compare with the connections that work and dont work.

Aws For Visual Studio Toolkit For Mac