Home > IT Answers > Development > Microsoft SQL 2005 Networking
Help

Question

  Asked: Apr 9 2008   7:53 AM GMT
  Asked by: M2000

Microsoft SQL 2005 Networking


C, SQL Server 2005

Hi
I'm a software developer and i use Visual C# 2005 and Microsoft SQL 2005 to create my desktop applications


my application is a software will be installed in to client machines as 2 home PC
and i want to make the two software's connect throw Ethernet to my database which it located on one of the two PC's

:( i don't know haw to do this ... every time the application show me an error message code 40 which means the far pc dose not have the permeation to connect to the SQL

so had anyone know how to solve this problem

Eng.M2000

Subscribe to Alerts! Get questions and answers delivered to your Inbox.


E-mail me updates on this question



   SUBSCRIBE

hidden modal window
Help

Answer Wiki (Improve, edit or add to this answer)

IMPROVE THIS ANSWER
View History
 RATE THIS ANSWER
-1
Click to Vote:
  •   0
  •  -1
Last Answered: Apr 9 2008  1:27 PM GMT  by SQL Server and databases




First you should make sure that the two PCs know eachother on the Ethernet, so ping one another and see if you get a reply (open the DOS prompt and ping <machine name> ).
If this works then you might have a problem with permissions, so - either you use a Domain account that has permissions in the SQL Server or you use SQL login (which is less secured).
Please let us know if you need more guidance.

Michelle.
  • AddThis Social Bookmark Button

Browse more Questions and Answers on Development and SQL Server.

Looking for relevant Development Whitepapers? Visit the SearchSQLServer.com Research Library.


RSS - Discussions Help

Discuss This Answer


You must be logged-in to discuss a question. Log-in/Register

M2000  |   Apr 10 2008  3:50PM GMT

hi michelle

thanx fo replay

yes i’m shure each PC can see the other

so plz can you specefy in details and steps haw to make the second step tha you say