Re: SQL 2000 TIMEOUT ERROR WHEN TRYING TO CONNECT USING C#
- From: "Norman Yuan" <NotReal@xxxxxxxxxxx>
- Date: Wed, 4 Apr 2007 12:03:09 -0700
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" <Terrance@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:9C6426C4-42AF-4BE1-A75C-86A7C520764B@xxxxxxxxxxxxxxxx
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" <Terrance@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:23E6BDEC-0994-4616-9AEB-19B3ED2E5890@xxxxxxxxxxxxxxxx
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
.
- References:
- Re: SQL 2000 TIMEOUT ERROR WHEN TRYING TO CONNECT USING C#
- From: Norman Yuan
- Re: SQL 2000 TIMEOUT ERROR WHEN TRYING TO CONNECT USING C#
- Prev by Date: Re: In WPF, add child to specific grid column and row using c# and not xaml
- Next by Date: Re: IsWindow()! IsWindow()! Not IsWindowEnabled()!
- Previous by thread: Re: SQL 2000 TIMEOUT ERROR WHEN TRYING TO CONNECT USING C#
- Index(es):
Relevant Pages
|
