471,071 Members | 1,472 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,071 software developers and data experts.

SQL 2000 TIMEOUT ERROR WHEN TRYING TO CONNECT USING C#

I have an application that runs fine on my machine(of course) that access the
local Sql Server. However, when trying to run this application from another
machine I receive a Sql timeout error. I thought it was my stored procedure
but that doesn't seem to be the case. The following are the connection
strings that I've tried:

//private string connstring = "integrated security=SSPI;data source=<ip
address>;"
// "persist security info=False;initial catalog=projectDB";

private string connstring = "pwd=<password>;uid=<username>;" +
"database=projectDB;server=<ip address>";

//private string connstring = "Data Source=<ip address>;" +
// "Initial Catalog=projectDB;" +
// "User Id=<username>;" +
// "Password=<password>";

Do anyone know how I can get over this hump? By the way I'm running the
application locally on the remote computer.
--
TC
Apr 4 '07 #1
4 2894
1. If the SQL Server and the app are not on the same computer, make sure the
SQL Server allows remote access.
2. Since you pass username/password in ConnectionString, make sure the SQL
Server has mixed security mode enabled (by default installed, only Windows
security mode is enabled).

"Terrance" <Te******@discussions.microsoft.comwrote in message
news:23**********************************@microsof t.com...
>I have an application that runs fine on my machine(of course) that access
the
local Sql Server. However, when trying to run this application from
another
machine I receive a Sql timeout error. I thought it was my stored
procedure
but that doesn't seem to be the case. The following are the connection
strings that I've tried:

//private string connstring = "integrated security=SSPI;data source=<ip
address>;"
// "persist security info=False;initial catalog=projectDB";

private string connstring = "pwd=<password>;uid=<username>;" +
"database=projectDB;server=<ip address>";

//private string connstring = "Data Source=<ip address>;" +
// "Initial Catalog=projectDB;" +
// "User Id=<username>;" +
// "Password=<password>";

Do anyone know how I can get over this hump? By the way I'm running the
application locally on the remote computer.
--
TC

Apr 4 '07 #2
How do I determine if the sql server does or does not allow remote access?
--
TC
"Norman Yuan" wrote:
1. If the SQL Server and the app are not on the same computer, make sure the
SQL Server allows remote access.
2. Since you pass username/password in ConnectionString, make sure the SQL
Server has mixed security mode enabled (by default installed, only Windows
security mode is enabled).

"Terrance" <Te******@discussions.microsoft.comwrote in message
news:23**********************************@microsof t.com...
I have an application that runs fine on my machine(of course) that access
the
local Sql Server. However, when trying to run this application from
another
machine I receive a Sql timeout error. I thought it was my stored
procedure
but that doesn't seem to be the case. The following are the connection
strings that I've tried:

//private string connstring = "integrated security=SSPI;data source=<ip
address>;"
// "persist security info=False;initial catalog=projectDB";

private string connstring = "pwd=<password>;uid=<username>;" +
"database=projectDB;server=<ip address>";

//private string connstring = "Data Source=<ip address>;" +
// "Initial Catalog=projectDB;" +
// "User Id=<username>;" +
// "Password=<password>";

Do anyone know how I can get over this hump? By the way I'm running the
application locally on the remote computer.
--
TC


Apr 4 '07 #3
I checked the Sql Server and it has Allow other SQL Servers to connect
remotely to this SQl using RPC. Is this what your were talking about?

--
TC
"Norman Yuan" wrote:
1. If the SQL Server and the app are not on the same computer, make sure the
SQL Server allows remote access.
2. Since you pass username/password in ConnectionString, make sure the SQL
Server has mixed security mode enabled (by default installed, only Windows
security mode is enabled).

"Terrance" <Te******@discussions.microsoft.comwrote in message
news:23**********************************@microsof t.com...
I have an application that runs fine on my machine(of course) that access
the
local Sql Server. However, when trying to run this application from
another
machine I receive a Sql timeout error. I thought it was my stored
procedure
but that doesn't seem to be the case. The following are the connection
strings that I've tried:

//private string connstring = "integrated security=SSPI;data source=<ip
address>;"
// "persist security info=False;initial catalog=projectDB";

private string connstring = "pwd=<password>;uid=<username>;" +
"database=projectDB;server=<ip address>";

//private string connstring = "Data Source=<ip address>;" +
// "Initial Catalog=projectDB;" +
// "User Id=<username>;" +
// "Password=<password>";

Do anyone know how I can get over this hump? By the way I'm running the
application locally on the remote computer.
--
TC


Apr 4 '07 #4
OK, if the SQL Server is accessible from other computer, you then need to
make sure it does accept username/pasword pair (that is, mixed security mode
is enabled).
"Terrance" <Te******@discussions.microsoft.comwrote in message
news:9C**********************************@microsof t.com...
>I checked the Sql Server and it has Allow other SQL Servers to connect
remotely to this SQl using RPC. Is this what your were talking about?

--
TC
"Norman Yuan" wrote:
>1. If the SQL Server and the app are not on the same computer, make sure
the
SQL Server allows remote access.
2. Since you pass username/password in ConnectionString, make sure the
SQL
Server has mixed security mode enabled (by default installed, only
Windows
security mode is enabled).

"Terrance" <Te******@discussions.microsoft.comwrote in message
news:23**********************************@microso ft.com...
>I have an application that runs fine on my machine(of course) that
access
the
local Sql Server. However, when trying to run this application from
another
machine I receive a Sql timeout error. I thought it was my stored
procedure
but that doesn't seem to be the case. The following are the connection
strings that I've tried:

//private string connstring = "integrated security=SSPI;data source=<ip
address>;"
// "persist security info=False;initial
catalog=projectDB";

private string connstring = "pwd=<password>;uid=<username>;" +
"database=projectDB;server=<ip address>";

//private string connstring = "Data Source=<ip address>;" +
// "Initial Catalog=projectDB;" +
// "User Id=<username>;" +
// "Password=<password>";

Do anyone know how I can get over this hump? By the way I'm running the
application locally on the remote computer.
--
TC



Apr 4 '07 #5

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

10 posts views Thread by noname | last post: by
3 posts views Thread by arnaud_brunet | last post: by
reply views Thread by Patrice de Boisgrollier | last post: by
3 posts views Thread by David Lozzi | last post: by
6 posts views Thread by Martin Eyles | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.