SQL connection timeout
-
Hi. I'm writing an application that it connect to a SQL Server 2000 database. For testing I have 2 PC running Windows XP and in one of them I'm running SQL Server 2000. When I run the application in the same PC where SQL is running the application works fine, but trying to connect from another PC it throws an exception connecting to the database. This is what I have: My connection string:
string source = "Server = DEC-DEMIAN; Database = Security; User ID = Terminal2;" + "Password = 123; Trusted_Connection = False;";Trying to connect from another PC it fails, thowing: "...SQLException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding". I can't figure out what I missed to configure in SQL Server to be able to get remote connections. I have checked Server Properties -> Connections in SQL and it's ok. Any help will be apreciatte. ThankxDemian. "I have always wished that my computer would be as easy to use as my telephone. My wish has come true. I no longer know how to use my telephone." -Bjarne Stroustrup, computer science professor, designer of C++ programming language (1950- )
-
Hi. I'm writing an application that it connect to a SQL Server 2000 database. For testing I have 2 PC running Windows XP and in one of them I'm running SQL Server 2000. When I run the application in the same PC where SQL is running the application works fine, but trying to connect from another PC it throws an exception connecting to the database. This is what I have: My connection string:
string source = "Server = DEC-DEMIAN; Database = Security; User ID = Terminal2;" + "Password = 123; Trusted_Connection = False;";Trying to connect from another PC it fails, thowing: "...SQLException: Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding". I can't figure out what I missed to configure in SQL Server to be able to get remote connections. I have checked Server Properties -> Connections in SQL and it's ok. Any help will be apreciatte. ThankxDemian. "I have always wished that my computer would be as easy to use as my telephone. My wish has come true. I no longer know how to use my telephone." -Bjarne Stroustrup, computer science professor, designer of C++ programming language (1950- )
On the server, have you enabled named pipes? I have had that same problem before, and It was because I didn't enable named pipes.
I get all the news I need from the weather report - Paul Simon (from "The Only Living Boy in New York")
-
On the server, have you enabled named pipes? I have had that same problem before, and It was because I didn't enable named pipes.
I get all the news I need from the weather report - Paul Simon (from "The Only Living Boy in New York")
I don't know. Where should I find the "named pipes"??.
Demian. "I have always wished that my computer would be as easy to use as my telephone. My wish has come true. I no longer know how to use my telephone." -Bjarne Stroustrup, computer science professor, designer of C++ programming language (1950- )
-
I don't know. Where should I find the "named pipes"??.
Demian. "I have always wished that my computer would be as easy to use as my telephone. My wish has come true. I no longer know how to use my telephone." -Bjarne Stroustrup, computer science professor, designer of C++ programming language (1950- )
I don't quite remember, Google it.
I get all the news I need from the weather report - Paul Simon (from "The Only Living Boy in New York")
-
I don't quite remember, Google it.
I get all the news I need from the weather report - Paul Simon (from "The Only Living Boy in New York")
These specify the time, in seconds, to wait for the server to respond before generating an error. The default value is 15 (seconds). "Connect Timeout=10;" -or- "Connection Timeout=10;"