question

sir avatar image
sir asked

sql server-2005 connection

Dear Sir, I have connected two computers using cable .I have made 1 application in pc 'A'using vb.net and sql server.I have installed all programs in drive 'c:' ,and i have shared that drive with PC 'B'. Now , I have made same application in PC 'B' also , and i want to add data inserted into PC 'B' to SQL Server Database which in PC 'A'. I have tried that i have given "dim con as new sqlconnection ="Data Source=A" , for acessing database but not working!! please give solution!

sql-server-2005connection
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

sp_lock avatar image
sp_lock answered
  1. Are you trying to connect using a SQL Login or a trusted connection (windows auth) http://msdn.microsoft.com/en-us/library/ms144284.aspx. Set in your DSN...

  2. Have you installed SQL Server as the default instance? If so you may need to enable/start the SQL browser service http://msdn.microsoft.com/en-us/library/ms181087.aspx

  3. If you are using TCPIP have you enabled the protocol in Config Manager? http://msdn.microsoft.com/en-us/library/ms174212%28SQL.90%29.aspx

  4. What errors do you get? Check the Event Viewer on the SQL Server to see if you have any auditing errors

10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Grant Fritchey avatar image
Grant Fritchey answered

These two machines are communicating across a network? They must be using a protocol, presumably TCPIP. Ensure that your SQL Server instance is allowing connections through TCPIP by checking in the Configuration Manager utility that installs with SQL Server.

10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.