NekoManu Posted August 2, 2004 Posted August 2, 2004 I have 2 PC's connected in a network. I want to be able to access a database form both PC's. I can connect on my PC to the SQL server database, but from the other PC I can not. Can anyone tell me what is wrong? I have Sql Browser running on both PC's, Tcp and Np are both enabled. Still I get the message: TCP Provider: host has broken a connection (something like that; the message is in Dutch) Quote
samsmithnz Posted August 2, 2004 Posted August 2, 2004 Can access each computer normally using file share? I'm just wondering if its actually a network issue Quote Thanks Sam http://www.samsmith.co.nz
NekoManu Posted August 2, 2004 Author Posted August 2, 2004 We can access everything on each computer. It is just that we can connect to the SQL Server database on the other PC. Quote
samsmithnz Posted August 2, 2004 Posted August 2, 2004 So whats the exact message? Quote Thanks Sam http://www.samsmith.co.nz
NekoManu Posted August 2, 2004 Author Posted August 2, 2004 The exact message is: TCP Provider: de host heeft een verbinding verbroken Quote
VBAHole22 Posted August 2, 2004 Posted August 2, 2004 verbroken That doesn't sound good in any language! Have you tried something different like MS Access to set up an ODBC. Use the lizard and try it with ODBC and SQLServer providers. Also in Visual Studio you can get the same lizard using the Server Explorer window. Can you even ping the box that the SQL server is on? Quote Wanna-Be C# Superstar
Administrators PlausiblyDamp Posted August 2, 2004 Administrators Posted August 2, 2004 How is security set up in this environment? Are the two PCs in a domain or just a work group? If they are in a workgroup are you trying to connect with integrated security - if so you will need to make sure that you are using the same username and password on both boxes. Quote Posting Guidelines FAQ Post Formatting Intellectuals solve problems; geniuses prevent them. -- Albert Einstein
samsmithnz Posted August 2, 2004 Posted August 2, 2004 LOL, when you said it was Dutch, I thought it was a figure of speech, I didn't relieze it was actually Dutch! Anyway using my Outlook 2003 Translator, it means: "leaps about a connection has broken" ??? Quote Thanks Sam http://www.samsmith.co.nz
NekoManu Posted August 3, 2004 Author Posted August 3, 2004 To answer a few questions: the PC's are in the same workgroup and we are trying to connect with integrated security, but I don't know what you mean by "make sure that you are using the same username and password on both boxes". Anyway I lost SQL Server. It seems that you can not make a simple mistake in this thing. I tried to import my old data from MS Access, that failed for some reason. I got an error saying: "Connection failed". Result: SQL Server is gone. I can not see the server anymore with "sqlcmd -L" and I can not get connected. I suppose SQL Server is for perfect people only. NO mistakes allowed! Quote
Administrators PlausiblyDamp Posted August 3, 2004 Administrators Posted August 3, 2004 Are you logging onto both computers with the same username / password - if not then integrated security is likely to fail, it really only works well when there is a central domain so the username / passwords are consistent across all PCs. In a workgroup you may find SQL Standard security is a simpler choice. Have you tried rebooting the SQL server as I've never know SQL to disappear because of a failed data import. Quote Posting Guidelines FAQ Post Formatting Intellectuals solve problems; geniuses prevent them. -- Albert Einstein
NekoManu Posted August 3, 2004 Author Posted August 3, 2004 I did try and restart SQL Server, that didn't work. I rebooted my PC, didn't work and than I even tried reinstalling SQL Server without removing .NET Result: I can see the server when I type "sqlcmd -L" but I can't connect. So the only solution I see is to remove .NET again and reinstall evrything. Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.