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!
Best Answer
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...
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
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
What errors do you get? Check the Event Viewer on the SQL Server to see if you have any auditing errors
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.
