Connection pooling not working in Clustered Env.

Hi,
We had deployed a .NET application in a non clustered environment with conection pooling and was working fine. Now we had moved to a clustered env and connection pooling stopped working. Is there any cluster aware setting that we need to look at. Please let me know your thoughts.
Thanks in advanceCan you be more specific on what went wrong? Any error code, exception stack will be helpful.sqlsql

Connection Manager Deployment with master/detail package

Hallo,

I'm currently strugling with the setup of our packages for deployment to a new environment.

We are working with a master/detail package setup. One master package is created that will call all child packages. In the master package we don't have any connection towards our source and/or target databases/sourcesystems.

Everything works fine, however, starting to deploy the whole set of packages, it seems that we don't have the option to set specific properties of our detailed packages, e.g. connection properties. But this is just what we need.

When we are adding a job in the Job Agent for our master package to be scheduled, we want to be able to set all different connection manager properties, not only the one from the master package and definitely the ones from the detailed packages as there we switch the connections from the development environment towards the acceptance environment.

I tried to fix this with parent package variables, but I can't set the password property, only the ServerName and UserName can be set, not the Password.

Anyone an idea what the easiest and best approach is to solve this burden?

Thx

Children packages should use package configuration on their connection strings as well; then when deploying the packages to a different enviroment all you have to do is to change the configuration values.

Be warned that there is a known bug when using package configuration with 'parent variables' that, under certain circustances may prevent you to set connection in children packages properly. See details here: https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=126146

Because of that, my recommendation is to define package configurations to set connection strings on every child package(via XML file, SQL server table, env. variable, etc).

"When we are adding a job in the Job Agent for our master package to be scheduled, we want to be able to set all different connection manager properties, not only the one from the master package and definitely the ones from the detailed packages as there we switch the connections from the development environment towards the acceptance environment. "

I think you can only set properties of the invoked package from the command line...as I said before; use configuration packages for that.

connection issues

Hi,

what all I need to check / set in order to connect to the server using isql / osql / bcp , nothing is working for me. I am on server, using command prompt . I reinstalled client and I am able to connect to server using EM , QA no problem , only problem is using isql / osql / bcp as follows:

isql -Usa -SSQL2000 -Psa123

DB-Library: Unable to connect: SQL Server is unavailable or does not exist. Unable to connect: SQL Server does not exist or network access denied.
Net-Library error 67: ConnectionOpen (Connect()).

for BCP :

bcp ##abc1 out abc1.out -Usa -SSQL2000 -Psa123

SQLState = 08001, NativeError = 17
Error = [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.
SQLState = 01000, NativeError = 67
Warning = [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionOpen (Connect()).

need to fix it today. please reply !Q1 what all I need to check / set in order to connect to the server using isql / osql / bcp , nothing is working for me.

A1 It depends on what the issue is. For example:

you may wish to use osql -SSQL2000 -E or the file
ConnectSql2000.udl.txt to verify connectivity (remove .txt extension, double click and test).

Something to consider:
Is this a default instance on a server named Sql2000 or a named instance?

{More detailed information (including the Sql Server, MDAC, etc. versions involved, etc.), should make it easier for others to provide more useful / helpful feedback.}|||RE:
you may wish to use osql -SSQL2000 -E or the file
ConnectSql2000.udl.txt to verify connectivity (remove .txt extension, double click and test).|||Dear DBA Guru,

Thanks for your reply. I download your file , removed .txt and double clicked on it got error after I clicked on test connection on Data Link Properties , error is :

Test connection failed because of an error in initializing provider.
[DBNETLIB][ConnectioOpen] (Connect()),]SQL server does not exist or access denied.

Test connection succeeded, if I select 'Microsoft OLE DB Provider for ODBC Drivers, and select a data source which I created for my server.

More info : its a named server , not default server. Its installed using SQLEVAL.exe downloaded from microsoft.com, version is SQL Server 2000.

Please help.

Originally posted by DBA
Q1 what all I need to check / set in order to connect to the server using isql / osql / bcp , nothing is working for me.

A1 It depends on what the issue is. For example:

you may wish to use osql -SSQL2000 -E or the file
ConnectSql2000.udl.txt to verify connectivity (remove .txt extension, double click and test).

Something to consider:
Is this a default instance on a server named Sql2000 or a named instance?

{More detailed information (including the Sql Server, MDAC, etc. versions involved, etc.), should make it easier for others to provide more useful / helpful feedback.}|||RE:
Thanks for your reply.
error is :
Test connection failed because of an error in initializing provider.
[DBNETLIB][ConnectioOpen] (Connect()),]SQL server does not exist or access denied.
Test connection succeeded, if I select 'Microsoft OLE DB Provider for ODBC Drivers, and select a data source which I created for my server.
More info : its a named server , not default server. Its installed using SQLEVAL.exe downloaded from microsoft.com, version is SQL Server 2000.
Q2 Please help.

You are welcome.

A2 Use osql (Isql does not support named instances), and for example:

-SServerName\InstanceName (to specify the server and instance)|||Hi Guru,

it worked. -SSERVERNAME\INSTANCENAME. Worked for isql , osql and BCP.

Much thanks for your help.

Cheers!
Ram|||RE
Hi Guru,
it worked. -SSERVERNAME\INSTANCENAME. Worked for isql , osql and BCP. Much thanks for your help.
Cheers! Ram

You are welcome.

You may wish to consider using osql instead of isql. While the isql.exe distributed with the eval version may work with named instances, isql does not (officially) support connecting to a named instance of SQL Server 2000. (Applications developed relying on the behavior of isql.exe distributed with the evaluation version may not perform as expected in production.)|||I will take it, I just more use to isql because I worked as a Sybase DBA. learning MS SQL Server. but I will use OSQL .

Thanks and Regards,
Ram|||Originally posted by ramshree
I will take it, I just more use to isql because I worked as a Sybase DBA. learning MS SQL Server. but I will use OSQL .

Thanks and Regards,
Ram

You are welcome.

(Just trying to spare you some grief, MS has kind of ignored support for isql in the past several years, since releasing osql. Evaluation and beta product differences have caused considerable pain as well.)

As far as Sybase goes, you are in good company, the MS Sql Server DBMS "worked" as a Sybase DBMS entity before becoming a MS entity, as well (numerous vestiges of that lineage still remain, even in MS Sql Server 2k).|||Hi Guru,

How are you?

I like Sybase more but have no choice since lot of companies moving from Sybase to either MS SQL Server, Oracle or DB2. and since I know Sybase very well , the close one to learn is SQL Server, 95% its same except GUI stuff of EM but I am not impress. still I like to work on UNIX .
Have you tried Perl scripting using DBI to do stuff of SQL Server? I dont know if I can write Perl script using DBI to do SQL Server database work on NT / Windows. have you wrote perl scripts using DBI on NT / Windows? Please let me know.

Thanks,
Ram.

Connection Issues

Hi,
I am working with a client whose primary software for their firm uses
MS SQL. They have been experiencing frequent issues with data missing
from query windows, or old data that has been deleted or archived
reappearing; the client closes the program and things are back to
normal. In talking with the support staff for the vendor, they assure
me that we have "an ideal enviroment" for running their software, but
are insisisting that the problems the client is experiencing are
"connection issues" and can't have not been able to point me in any
directions to check other than looking at the hardware environment
which they have said is "ideal". Can someone possibly explain what
other places we might look for connection issues? The client is
running SBS 2003 Premium, which includes SQL 2000. We have all
service packs installed on the server and the workstations.
If more info is needed please feel free to ask.
Thanks,
Mike Garoutte
Milwaukee, WII would look for transactions that are not being committed. In
general it is a Bad Thing for a transaction to remain open during any
user activity. It sounds like that is happening, and the connection
is being broken before or without the user doing whatever has to be
done to make the change final.
An alternate explanation would be that they application stages
transactions in other tables before updating the main tables, and the
user is not taking whatever final step there is that applies the data.
Roy Harvey
Beacon Falls, CT
On Tue, 29 Apr 2008 07:03:07 -0700 (PDT), Mike G <mgaroutte@.gmail.com>
wrote:
>Hi,
>I am working with a client whose primary software for their firm uses
>MS SQL. They have been experiencing frequent issues with data missing
>from query windows, or old data that has been deleted or archived
>reappearing; the client closes the program and things are back to
>normal. In talking with the support staff for the vendor, they assure
>me that we have "an ideal enviroment" for running their software, but
>are insisisting that the problems the client is experiencing are
>"connection issues" and can't have not been able to point me in any
>directions to check other than looking at the hardware environment
>which they have said is "ideal". Can someone possibly explain what
>other places we might look for connection issues? The client is
>running SBS 2003 Premium, which includes SQL 2000. We have all
>service packs installed on the server and the workstations.
>If more info is needed please feel free to ask.
>Thanks,
>Mike Garoutte
>Milwaukee, WI|||Hi Ron,
Thanks for your reply. I have to be honest that I am not sure how to
check for uncommitted transactions. When the record is saved, I would
assume it
would be updated in the database. One thing that frequently happens
while editing a record the
staff at the clients office will click the "Save & Close" button to
save the changes to the record and they get a message that the record
has
been deleted by another user, even though the record has not been
deleted. We are putting a gigabit nic in the server Thursday night.
Thanks for your help.
Mike
On Apr 29, 11:52=A0am, "Roy Harvey (SQL Server MVP)"
<roy_har...@.snet.net> wrote:
> I would look for transactions that are not being committed. =A0In
> general it is a Bad Thing for a transaction to remain open during any
> user activity. =A0It sounds like that is happening, and the connection
> is being broken before or without the user doing whatever has to be
> done to make the change final.
> An alternate explanation would be that they application stages
> transactions in other tables before updating the main tables, and the
> user is not taking whatever final step there is that applies the data.
> Roy Harvey
> Beacon Falls, CT
> On Tue, 29 Apr 2008 07:03:07 -0700 (PDT), Mike G <mgarou...@.gmail.com>
> wrote:
>
> >Hi,
> >I am working with a client whose primary software for their firm uses
> >MS SQL. =A0They have been experiencing frequent issues with data missing
> >from query windows, or old data that has been deleted or archived
> >reappearing; the client closes the program and things are back to
> >normal. =A0In talking with the support staff for the vendor, they assure
> >me that we have "an ideal enviroment" for running their software, but
> >are insisisting that the problems the client is experiencing are
> >"connection issues" and can't have not been able to point me in any
> >directions to check other than looking at the hardware environment
> >which they have said is "ideal". =A0Can someone possibly explain what
> >other places we might look for connection issues? =A0The client is
> >running SBS 2003 Premium, which includes SQL 2000. =A0We have all
> >service packs installed on the server and the workstations.
> >If more info is needed please feel free to ask.
> >Thanks,
> >Mike Garoutte
> >Milwaukee, WI- Hide quoted text -
> - Show quoted text -|||DBCC OPENTRAN can be used to find open transactions.
Roy Harvey
Beacon Falls, CT
On Wed, 30 Apr 2008 06:49:22 -0700 (PDT), Mike G <mgaroutte@.gmail.com>
wrote:
>Hi Ron,
>Thanks for your reply. I have to be honest that I am not sure how to
>check for uncommitted transactions. When the record is saved, I would
>assume it
>would be updated in the database. One thing that frequently happens
>while editing a record the
>staff at the clients office will click the "Save & Close" button to
>save the changes to the record and they get a message that the record
>has
>been deleted by another user, even though the record has not been
>deleted. We are putting a gigabit nic in the server Thursday night.
>Thanks for your help.
>Mike
>
>On Apr 29, 11:52 am, "Roy Harvey (SQL Server MVP)"
><roy_har...@.snet.net> wrote:
>> I would look for transactions that are not being committed. In
>> general it is a Bad Thing for a transaction to remain open during any
>> user activity. It sounds like that is happening, and the connection
>> is being broken before or without the user doing whatever has to be
>> done to make the change final.
>> An alternate explanation would be that they application stages
>> transactions in other tables before updating the main tables, and the
>> user is not taking whatever final step there is that applies the data.
>> Roy Harvey
>> Beacon Falls, CT
>> On Tue, 29 Apr 2008 07:03:07 -0700 (PDT), Mike G <mgarou...@.gmail.com>
>> wrote:
>>
>> >Hi,
>> >I am working with a client whose primary software for their firm uses
>> >MS SQL. They have been experiencing frequent issues with data missing
>> >from query windows, or old data that has been deleted or archived
>> >reappearing; the client closes the program and things are back to
>> >normal. In talking with the support staff for the vendor, they assure
>> >me that we have "an ideal enviroment" for running their software, but
>> >are insisisting that the problems the client is experiencing are
>> >"connection issues" and can't have not been able to point me in any
>> >directions to check other than looking at the hardware environment
>> >which they have said is "ideal". Can someone possibly explain what
>> >other places we might look for connection issues? The client is
>> >running SBS 2003 Premium, which includes SQL 2000. We have all
>> >service packs installed on the server and the workstations.
>> >If more info is needed please feel free to ask.
>> >Thanks,
>> >Mike Garoutte
>> >Milwaukee, WI- Hide quoted text -
>> - Show quoted text -

Connection is busy with results for another hstmt

I am working on Sql Server 2000 and Delphi 5. When I try to open a table :

Table1.open;

I get the following error message :

Connection is busy with results for another hstmt.

I am new to Sql Server so please keep the explanation simple !!!

I have already read this got something to do with forward-only, read-only cursor. But I don't know what a forward-only, read-only cursor mean. Please explain !!

Thanks
KarenHowdy

A cursor collects a record set from a database. The cursor has a pointer that can move around in the record set to read a particular row etc. A forward only cursor can only read down ( i.e. forward ) through the record set, so if you are trying to go backwards through the record set it may not let you.

I dont know anything about Delphi, but from SQL Books on Line :

----------

SQLTables
When restricted to the current database, SQLTables executes the Transact-SQL procedure sp_tables to report table catalog data for Microsoft SQL Server.

The following table shows SQLTables parameter mapping for sp_tables stored procedure execution.

SQLTables parameter name sp_tables parameter name
CatalogName table_qualifier
SchemaName table_owner
TableName table_name
TableType table_type

SQLTables can be executed on a static server cursor. An attempt to execute SQLTables on an updatable (dynamic or keyset) cursor will return SQL_SUCCESS_WITH_INFO indicating that the cursor type has been changed.

SQLTables reports tables from all databases when the CatalogName parameter is SQL_ALL_CATALOGS and all other parameters contain default values (NULL pointers). SQLTables does not make use of sp_tables in this special case.

To report available catalogs, schemas, and table types, SQLTables makes special use of empty strings (zero-length byte pointers). Empty strings are not default values (NULL pointers).

The SQL Server ODBC driver supports reporting information for tables on linked servers by accepting a two-part name for the CatalogName parameter: Linked_Server_Name.Catalog_Name.

SQLTables returns information about any tables whose names match TableName and are owned by the current user.

Example
// Get a list of all tables in the current database.
SQLTables(hstmt, NULL, 0, NULL, 0, NULL, 0, NULL,0);
// Get a list of all tables in all databases.
SQLTables(hstmt, (SQLCHAR*) "%", SQL_NTS, NULL, 0, NULL, 0, NULL,0);
// Get a list of databases on the current connection's server.
SQLTables(hstmt, (SQLCHAR*) "%", SQL_NTS, (SQLCHAR*)"", 0, (SQLCHAR*)"",
0, NULL, 0);

Cheers,

SG

Connection fails SQL 2000

One of our customers has SQl server 2000 installed
This has been working perfectly untill last Friday.
At this point various databases began to return errors
when querries were run on the data.
There appeasr to be no pattern to which databases still
work as I have two backup copies of the main databse they
use. The main one and one of the backups produce errors
yet the other backup, taken on the same day does not.
Looking at the error log (attached) there seems to be a
lot of "corrupt" entires.
Any suggestions
Date Source Message
---
--
---
--...
004 DC771 Module(sqlservr+000DC771) (ExecuteSql
(class CParamExchange *,class CXVariant *,
004 A9DE2 Module(sqlservr+000A9DE2)
(CXteHashMatch::ExecCompile(class CExecCompContext *)
004 A9E93 Module(sqlservr+000A9E93)
(CXteHashMatch::ExecCompile(class CExecCompContext *)
004 A70B6 Module(sqlservr+000A70B6)
(CXteHashMatch::IntermediateCompile(class IMemObj *,c
004 A8B35 Module(sqlservr+000A8B35)
(CXteHashMatch::CreateBailoutPlan(class CRemapContext
0041 F796 Module(sqlservr+0001F796)
(CSQLObject::FTransform(class CParamExchange *)+00000
0041 FDDD Module(sqlservr+0001FDDD)
(CSQLObject::FTransform2(class CSQLComment *,class CP
00415080 Module(sqlservr+00015080)
(CSQLSource::FTransform(class CParamExchange *)
+0000037C)
0041534 F Module(sqlservr+0001534F)
(CSQLSource::Execute(class CParamExchange *)+00000176
00415410 Module(sqlservr+00015410)
(CSQLSource::Execute(class CParamExchange *)
+00000343)
00415765 Module(sqlservr+00015765)
(CMsqlExecContext::Execute(class CCompPlan *,class
CParamExchange *)+000001C7)
004160 DB Module(sqlservr+000160DB)
(CMsqlExecContext::ExecuteStmts(class ExecutionContex
0041767 E Module(sqlservr+0001767E) (process_commands
(struct srv_proc *)+000001E7)
0043 B7EF Module(sqlservr+0003B7EF) (execute_rpc
(struct srv_proc *)+00000019)
00447078 Module(sqlservr+00047078)
(CCompPlan::FCompileStep(class CAlgStmt *,class
CStatement * *)+00000AE7)
004510 FE Module(sqlservr+000510FE)
(CProchdr::FCompile(class CCompPlan *,class CParamExc
0049 CB9F Module(sqlservr+0009CB9F)
(CStmtExec::XretExecute(class CMsqlExecContext *)cons
0049 CD0A Module(sqlservr+0009CD0A)
(CStmtExec::XretLocalExec(class CMsqlExecContext *,un
0049 C6F4 Module(sqlservr+0009C6F4)
(CSQLObject::FGetFromDisk(class CParamExchange *)+000
0049 DA48 Module(sqlservr+0009DA48)
(CStmtSelect::Init(class CAlgStmt *,class CCompPlan *
00563 F78 Module(sqlservr+00163F78)
(CStmtQuery::InitQuery(class CAlgStmt *,class CCompPl
00564019 Module(sqlservr+00164019)
(BuildQueryFromTree(class TREE *,class IMemObj
*,class IMemObj *,class IQueryOb
005642 CD Module(sqlservr+001642CD)
(CCvtTree::PqryFromTree(class TREE *,class IMemObj *,
0056701 F Module(sqlservr+0016701F)
(CBndOutputs::RemapValrefs(class CRemapContext *,int)
00567536 Module(sqlservr+00167536)
(CXte::ExecCompile(class CExecCompContext *)
+000000B7)
00567536 Module(sqlservr+00167536)
(CXte::ExecCompile(class CExecCompContext *)
+000000B7)
005688 A4 Module(sqlservr+001688A4) (CQuery::Prepare
(void)+00000116)
0061 DDB6 Module(sqlservr+0021DDB6)
(CSpecProc::Execute(class CParamExchange *)+00000092)
0061 DA3E Module(sqlservr+0021DA3E)
(CSpecProc::ExecuteSpecial(class CParamExchange *,uns
0063 C71D Module(sqlservr+0023C71D) (execrpc(struct
srv_proc *)+000004A8)
00703 A1C Module(sqlservr+00303A1C)
(CXteHashMatch::CreateInputScan(class IMemObj *,class
2003-11-05 12:36:10.29 server Microsoft SQL Server
2000 - 8.00.194 (Intel X86) ...
2003-11-05 12:36:10.54 server Logging SQL Server
messages in file 'd:\Program Files\Microsoft SQL
Server\MSSQ
2003-11-05 12:36:10.54 server Server Process ID is 1700.
2003-11-05 12:36:10.54 server All rights reserved.
2003-11-05 12:36:10.54 server Copyright (C) 1988-2000
Microsoft Corporation.
2003-11-05 12:36:10.99 server SQL Server is starting at
priority class 'normal'(4 CPUs detected).
2003-11-05 12:36:13.00 server SQL Server configured for
thread mode processing.
2003-11-05 12:36:13.23 server Using dynamic lock
allocation. [2500] Lock Blocks, [5000] Lock Owner Blocks.
2003-11-05 12:36:13.62 server Attempting to initialize
Distributed Transaction Coordinator.
2003-11-05 12:36:19.92 spid2 Starting up
database 'master'.
2003-11-05 12:36:27.70 spid5 Starting up
database 'model'.
2003-11-05 12:36:27.70 server Using 'SSNETLIB.DLL'
version '8.0.194'.
2003-11-05 12:36:27.73 spid2 Server name is 'WRLW2S002'.
2003-11-05 12:36:27.79 spid12 Starting up
database 'powerway'.
2003-11-05 12:36:27.79 spid11 Starting up
database 'dbWheelset_Live'.
2003-11-05 12:36:27.79 spid10 Starting up
database 'Northwind'.
2003-11-05 12:36:27.79 spid9 Starting up
database 'pubs'.
2003-11-05 12:36:27.79 spid8 Starting up
database 'msdb'.
2003-11-05 12:36:27.81 spid14 Starting up
database 'dbWheelSets_LIVE'.
2003-11-05 12:36:27.81 spid13 Starting up
database 'dbWheelSets_TEST'.
2003-11-05 12:36:27.89 spid16 Starting up
database 'dbWheelsets_ARCH_TEST'.
2003-11-05 12:36:27.89 spid15 Starting up
database 'dbWheelsets_BACKUP'.
2003-11-05 12:36:27.98 spid17 Starting up
database 'dbWheelsets_DATA_TEST'.
2003-11-05 12:36:28.43 spid5 Clearing tempdb database.
2003-11-05 12:36:28.51 spid11 Analysis of
database 'dbWheelset_Live' (7) is 100% complete
(approximately 0 mo
2003-11-05 12:36:28.65 spid12 Analysis of
database 'powerway' (8) is 100% complete (approximately 0
more seco
2003-11-05 12:36:28.87 server SQL Server is ready for
client connections
2003-11-05 12:36:28.87 server SQL server listening on
172.20.120.23:1433, 127.0.0.1:1433.
2003-11-05 12:36:28.87 server SQL server listening on
TCP, Shared Memory, Named Pipes.
2003-11-05 12:36:29.76 spid13 Analysis of
database 'dbWheelSets_TEST' (9) is 100% complete
(approximately 0 m
2003-11-05 12:36:38.67 spid5 Starting up
database 'tempdb'.
2003-11-05 12:36:41.85 spid2 Recovery complete.
2003-11-05 12:36:49.51 spid51 Using 'xpsqlbot.dll'
version '2000.80.194' to execute extended stored procedure
2003-11-05 12:36:51.96 spid51 Using 'xpstar.dll'
version '2000.80.194' to execute extended stored
procedure '
2003-11-05 13:15:27.45 spid55 Using 'sqlimage.dll'
version '4.0.5'...
2003-11-05 13:15:27.46 spid55 SqlDumpExceptionHandler:
Process 55 generated fatal exception c0000005 EXCEPTIO
2003-11-05 13:15:27.46 spid55 Error: 0, Severity: 19,
State: 0
410735 D0 Module(UMS+000035D0) (ProcessWorkRequests
(class UmsWorkQueue *)+00000264)
4107382 C Module(UMS+0000382C) (ThreadStartRoutine
(void *)+000000BC)
7 C57B382 Module(KERNEL32+0000B382)
(lstrcmpiW+000000B7)
78008454 Module(MSVCRT+00008454)
(_endthread+000000C1)Have you tried running DBCC CHECKDB
--
HTH
Ryan Waight, MCDBA, MCSE
"john kinghorn" <anonymous@.discussions.microsoft.com> wrote in message
news:076a01c3a787$7e28ea20$a401280a@.phx.gbl...
> One of our customers has SQl server 2000 installed
> This has been working perfectly untill last Friday.
> At this point various databases began to return errors
> when querries were run on the data.
> There appeasr to be no pattern to which databases still
> work as I have two backup copies of the main databse they
> use. The main one and one of the backups produce errors
> yet the other backup, taken on the same day does not.
> Looking at the error log (attached) there seems to be a
> lot of "corrupt" entires.
> Any suggestions
>
> Date Source Message
> ---
> --
> ---
> --...
> 004 DC771 Module(sqlservr+000DC771) (ExecuteSql
> (class CParamExchange *,class CXVariant *,
> 004 A9DE2 Module(sqlservr+000A9DE2)
> (CXteHashMatch::ExecCompile(class CExecCompContext *)
> 004 A9E93 Module(sqlservr+000A9E93)
> (CXteHashMatch::ExecCompile(class CExecCompContext *)
> 004 A70B6 Module(sqlservr+000A70B6)
> (CXteHashMatch::IntermediateCompile(class IMemObj *,c
> 004 A8B35 Module(sqlservr+000A8B35)
> (CXteHashMatch::CreateBailoutPlan(class CRemapContext
> 0041 F796 Module(sqlservr+0001F796)
> (CSQLObject::FTransform(class CParamExchange *)+00000
> 0041 FDDD Module(sqlservr+0001FDDD)
> (CSQLObject::FTransform2(class CSQLComment *,class CP
> 00415080 Module(sqlservr+00015080)
> (CSQLSource::FTransform(class CParamExchange *)
> +0000037C)
> 0041534 F Module(sqlservr+0001534F)
> (CSQLSource::Execute(class CParamExchange *)+00000176
> 00415410 Module(sqlservr+00015410)
> (CSQLSource::Execute(class CParamExchange *)
> +00000343)
> 00415765 Module(sqlservr+00015765)
> (CMsqlExecContext::Execute(class CCompPlan *,class
> CParamExchange *)+000001C7)
> 004160 DB Module(sqlservr+000160DB)
> (CMsqlExecContext::ExecuteStmts(class ExecutionContex
> 0041767 E Module(sqlservr+0001767E) (process_commands
> (struct srv_proc *)+000001E7)
> 0043 B7EF Module(sqlservr+0003B7EF) (execute_rpc
> (struct srv_proc *)+00000019)
> 00447078 Module(sqlservr+00047078)
> (CCompPlan::FCompileStep(class CAlgStmt *,class
> CStatement * *)+00000AE7)
> 004510 FE Module(sqlservr+000510FE)
> (CProchdr::FCompile(class CCompPlan *,class CParamExc
> 0049 CB9F Module(sqlservr+0009CB9F)
> (CStmtExec::XretExecute(class CMsqlExecContext *)cons
> 0049 CD0A Module(sqlservr+0009CD0A)
> (CStmtExec::XretLocalExec(class CMsqlExecContext *,un
> 0049 C6F4 Module(sqlservr+0009C6F4)
> (CSQLObject::FGetFromDisk(class CParamExchange *)+000
> 0049 DA48 Module(sqlservr+0009DA48)
> (CStmtSelect::Init(class CAlgStmt *,class CCompPlan *
> 00563 F78 Module(sqlservr+00163F78)
> (CStmtQuery::InitQuery(class CAlgStmt *,class CCompPl
> 00564019 Module(sqlservr+00164019)
> (BuildQueryFromTree(class TREE *,class IMemObj
> *,class IMemObj *,class IQueryOb
> 005642 CD Module(sqlservr+001642CD)
> (CCvtTree::PqryFromTree(class TREE *,class IMemObj *,
> 0056701 F Module(sqlservr+0016701F)
> (CBndOutputs::RemapValrefs(class CRemapContext *,int)
> 00567536 Module(sqlservr+00167536)
> (CXte::ExecCompile(class CExecCompContext *)
> +000000B7)
> 00567536 Module(sqlservr+00167536)
> (CXte::ExecCompile(class CExecCompContext *)
> +000000B7)
> 005688 A4 Module(sqlservr+001688A4) (CQuery::Prepare
> (void)+00000116)
> 0061 DDB6 Module(sqlservr+0021DDB6)
> (CSpecProc::Execute(class CParamExchange *)+00000092)
> 0061 DA3E Module(sqlservr+0021DA3E)
> (CSpecProc::ExecuteSpecial(class CParamExchange *,uns
> 0063 C71D Module(sqlservr+0023C71D) (execrpc(struct
> srv_proc *)+000004A8)
> 00703 A1C Module(sqlservr+00303A1C)
> (CXteHashMatch::CreateInputScan(class IMemObj *,class
> 2003-11-05 12:36:10.29 server Microsoft SQL Server
> 2000 - 8.00.194 (Intel X86) ...
> 2003-11-05 12:36:10.54 server Logging SQL Server
> messages in file 'd:\Program Files\Microsoft SQL
> Server\MSSQ
> 2003-11-05 12:36:10.54 server Server Process ID is 1700.
> 2003-11-05 12:36:10.54 server All rights reserved.
> 2003-11-05 12:36:10.54 server Copyright (C) 1988-2000
> Microsoft Corporation.
> 2003-11-05 12:36:10.99 server SQL Server is starting at
> priority class 'normal'(4 CPUs detected).
> 2003-11-05 12:36:13.00 server SQL Server configured for
> thread mode processing.
> 2003-11-05 12:36:13.23 server Using dynamic lock
> allocation. [2500] Lock Blocks, [5000] Lock Owner Blocks.
> 2003-11-05 12:36:13.62 server Attempting to initialize
> Distributed Transaction Coordinator.
> 2003-11-05 12:36:19.92 spid2 Starting up
> database 'master'.
> 2003-11-05 12:36:27.70 spid5 Starting up
> database 'model'.
> 2003-11-05 12:36:27.70 server Using 'SSNETLIB.DLL'
> version '8.0.194'.
> 2003-11-05 12:36:27.73 spid2 Server name is 'WRLW2S002'.
> 2003-11-05 12:36:27.79 spid12 Starting up
> database 'powerway'.
> 2003-11-05 12:36:27.79 spid11 Starting up
> database 'dbWheelset_Live'.
> 2003-11-05 12:36:27.79 spid10 Starting up
> database 'Northwind'.
> 2003-11-05 12:36:27.79 spid9 Starting up
> database 'pubs'.
> 2003-11-05 12:36:27.79 spid8 Starting up
> database 'msdb'.
> 2003-11-05 12:36:27.81 spid14 Starting up
> database 'dbWheelSets_LIVE'.
> 2003-11-05 12:36:27.81 spid13 Starting up
> database 'dbWheelSets_TEST'.
> 2003-11-05 12:36:27.89 spid16 Starting up
> database 'dbWheelsets_ARCH_TEST'.
> 2003-11-05 12:36:27.89 spid15 Starting up
> database 'dbWheelsets_BACKUP'.
> 2003-11-05 12:36:27.98 spid17 Starting up
> database 'dbWheelsets_DATA_TEST'.
> 2003-11-05 12:36:28.43 spid5 Clearing tempdb database.
> 2003-11-05 12:36:28.51 spid11 Analysis of
> database 'dbWheelset_Live' (7) is 100% complete
> (approximately 0 mo
> 2003-11-05 12:36:28.65 spid12 Analysis of
> database 'powerway' (8) is 100% complete (approximately 0
> more seco
> 2003-11-05 12:36:28.87 server SQL Server is ready for
> client connections
> 2003-11-05 12:36:28.87 server SQL server listening on
> 172.20.120.23:1433, 127.0.0.1:1433.
> 2003-11-05 12:36:28.87 server SQL server listening on
> TCP, Shared Memory, Named Pipes.
> 2003-11-05 12:36:29.76 spid13 Analysis of
> database 'dbWheelSets_TEST' (9) is 100% complete
> (approximately 0 m
> 2003-11-05 12:36:38.67 spid5 Starting up
> database 'tempdb'.
> 2003-11-05 12:36:41.85 spid2 Recovery complete.
> 2003-11-05 12:36:49.51 spid51 Using 'xpsqlbot.dll'
> version '2000.80.194' to execute extended stored procedure
> 2003-11-05 12:36:51.96 spid51 Using 'xpstar.dll'
> version '2000.80.194' to execute extended stored
> procedure '
> 2003-11-05 13:15:27.45 spid55 Using 'sqlimage.dll'
> version '4.0.5'...
> 2003-11-05 13:15:27.46 spid55 SqlDumpExceptionHandler:
> Process 55 generated fatal exception c0000005 EXCEPTIO
> 2003-11-05 13:15:27.46 spid55 Error: 0, Severity: 19,
> State: 0
> 410735 D0 Module(UMS+000035D0) (ProcessWorkRequests
> (class UmsWorkQueue *)+00000264)
> 4107382 C Module(UMS+0000382C) (ThreadStartRoutine
> (void *)+000000BC)
> 7 C57B382 Module(KERNEL32+0000B382)
> (lstrcmpiW+000000B7)
> 78008454 Module(MSVCRT+00008454)
> (_endthread+000000C1)
>

Connection fails and currupt log

One of our customers has SQL server 2000 installed
This has been working perfectly for over a year
Now various databases have started to return errors when queries are
run on the data from VB or Query Analyser.
A typical error is:
[Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionCheckForData
(CheckForData()).
Server: Msg 11, Level 16, State 1, Line 0
General Network Error. Check your network documentation
Connection broken
Not all the database produce errors but there appears to be no pattern
to which databases still work.
I have two backup copies of the main database they use. The main
database its self and one of the backups produce errors yet the other
backup, taken on the same day does not.
Looking at the error log (attached) there seems to be a lot of
"corrupt" entires.
Any suggestions* If you see corruption, then --
1. Check system and app event logs for details on any hardware corruption.
2. contact your hardware vendors to run some tests, diagnostics, etc and
also check for firmware upgrades.
3. Only then, RESTORE from your last healthy SQL Backup.
4. If you dont have a backup, then you could try to "Repair" the database
using "dbcc checkdb".
Thanks,
Vikram
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.

connection error with SQL server 2000

Hello All,
I am working in vwd using C#. In my web develpent I am Connecting to the Sql server 2000's pubs table and displaying result in GridView Control.
My Coding is

SqlConnection con =new SqlConnection("Server=local host;uid=sa;pwd=**secret**;database=pubs");
string str ="select * from authors";
 SqlDataAdapter da =new SqlDataAdapter(str, con);
 DataSet ds =new DataSet();
 da.Fill(ds);
 GridView1.DataSource = ds;
 GridView1.DataBind();

his is a very simple Code.
Now I got a error which is

An error has occurred while establishing a connection to the server.
When connecting to SQL Server 2005,
this failure may be caused by the fact that under the default settings
SQL Server does not allow remote connections.
(provider: Named Pipes Provider, error: 40 - Could not open a
connection to SQL Server)

Can you tell me what is the problem here

rajkumar sharma

Connect using TCP/IP, or use the Surface Area Configuration tool to enable remote connections using named pipes.

|||

I will be thankful if you explain me in some detail.

rajkumar sharma

Connection error in sql server compact edition 2005

HI friends,

i m working on device application ..i m using sql server ce 2005 with c#.net ... but when i m trying to connect to database it shows me error that

"the database path not found ... please check the path [,,,filename,,,]"

my code is as below

private string ConnStr = "Data Source =\\My Documents\\Employee.sdf;";

private void cmdCheckConnecton_Click(object sender, EventArgs e)
{
try
{
cn = new System.Data.SqlServerCe.SqlCeConnection(ConnStr);
cn.Open();
MessageBox.Show(cn.State.ToString());
}
catch (SqlCeException ex)
{
MessageBox.Show(ex.Message.ToString());
}
}

i have my database in My Documents and the path is right still it shows the error

pls help if any one have a solution regarding this problem

thanxx

Zalak Shah

This is just a guess, but looking at my connection strings they have quotes around the Data Source, so maybe try adding those in.

private string ConnStr = "Data Source =\"\\My Documents\\Employee.sdf\";";

|||hi

i have done it but still it doesn't work

one more thing i want to tell u .. if i create the database on the same location even it is there it will create once again and no files will be create at that location that 's just a file in a memory .... and after that that memory file will accessed by that code and working perfectly as i needed

can u tell me one thing that location is in mobile device (Emulator) 's location or my hard drive's location

Connection error in sql server compact edition 2005

HI friends,

i m working on device application ..i m using sql server ce 2005 with c#.net ... but when i m trying to connect to database it shows me error that

"the database path not found ... please check the path [,,,filename,,,]"

my code is as below

private string ConnStr = "Data Source =\\My Documents\\Employee.sdf;";

private void cmdCheckConnecton_Click(object sender, EventArgs e)
{
try
{
cn = new System.Data.SqlServerCe.SqlCeConnection(ConnStr);
cn.Open();
MessageBox.Show(cn.State.ToString());
}
catch (SqlCeException ex)
{
MessageBox.Show(ex.Message.ToString());
}
}

i have my database in My Documents and the path is right still it shows the error

pls help if any one have a solution regarding this problem

thanxx

Zalak Shah

This is just a guess, but looking at my connection strings they have quotes around the Data Source, so maybe try adding those in.

private string ConnStr = "Data Source =\"\\My Documents\\Employee.sdf\";";

|||hi

i have done it but still it doesn't work

one more thing i want to tell u .. if i create the database on the same location even it is there it will create once again and no files will be create at that location that 's just a file in a memory .... and after that that memory file will accessed by that code and working perfectly as i needed

can u tell me one thing that location is in mobile device (Emulator) 's location or my hard drive's location

Connection error - please help

I'm setting up a development environment on XP Pro. I'm working with classi
c
ASP. IIS is working great, but when trying to connect to my SQL Server
Database, I get:
Microsoft OLE DB Provider for SQL Server (0x80004005)
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or
access
denied.
I've checked and re-checked both the name of the database and server, plus
everything looks configured correctly in Enterprise Manager (SQL server and
Windows is checked).
In ODBC, after I configure my System DSN, I test it and it connects
correctly. But this dang error persists. I'm at my wits end with it all,
can you help?
Any comments would be very very appreciated.
Thank you.Try making a network trace from the IIS machine to SQL and review the
traffic.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.|||Why IIS machine, what is the relation between IIS and SQL
server here? What kind of trace should I do, can you
explain it in a simple way.
Thanks a lot-Rob

>--Original Message--
>Try making a network trace from the IIS machine to SQL
and review the
>traffic.
>Thanks,
>Kevin McDonnell
>Microsoft Corporation
>This posting is provided AS IS with no warranties, and
confers no rights.
>
>.
>|||IIS is the client to SQL. I"m asuming that they are two different machines.
client -->IIS-->SQL
IIS is opening and closing all the connection to SQL, not the client
browser. So, making a network trace from IIS will show the traffic to the
server.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.|||I have the same problem. Help.
****************************************
******************************
Sent via Fuzzy Software @. http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET
resources...

Connection error - please help

I'm setting up a development environment on XP Pro. I'm working with classic
ASP. IIS is working great, but when trying to connect to my SQL Server
Database, I get:
Microsoft OLE DB Provider for SQL Server (0x80004005)
[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access
denied.
I've checked and re-checked both the name of the database and server, plus
everything looks configured correctly in Enterprise Manager (SQL server and
Windows is checked).
In ODBC, after I configure my System DSN, I test it and it connects
correctly. But this dang error persists. I'm at my wits end with it all,
can you help?
Any comments would be very very appreciated.
Thank you.
Try making a network trace from the IIS machine to SQL and review the
traffic.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.
|||Why IIS machine, what is the relation between IIS and SQL
server here? What kind of trace should I do, can you
explain it in a simple way.
Thanks a lot-Rob

>--Original Message--
>Try making a network trace from the IIS machine to SQL
and review the
>traffic.
>Thanks,
>Kevin McDonnell
>Microsoft Corporation
>This posting is provided AS IS with no warranties, and
confers no rights.
>
>.
>
|||IIS is the client to SQL. I"m asuming that they are two different machines.
client -->IIS-->SQL
IIS is opening and closing all the connection to SQL, not the client
browser. So, making a network trace from IIS will show the traffic to the
server.
Thanks,
Kevin McDonnell
Microsoft Corporation
This posting is provided AS IS with no warranties, and confers no rights.
|||I have the same problem. Help.
************************************************** ********************
Sent via Fuzzy Software @. http://www.fuzzysoftware.com/
Comprehensive, categorised, searchable collection of links to ASP & ASP.NET resources...

connection error

Hi guys, my asp.net web page was working fine on my laptop. Until i transferred it into my friend's.. an error msg popped out. My SQL Northwind database was been copied over but still there seems to be a problem with the connection, can any one help me?
Personal guess: You are using an sa username/password in the connection string, and the other server you are connecting to is not set up for SQL security, only Windows security.
Show the connection string you are using (with any passwords obscured, of course).
|||

SqlConnection conn=new SqlConnection("server=localhost;uid=sa;pwd=;database=Northwind");

SqlCommand cmd = conn.CreateCommand();

cmd.CommandText = "SELECT * FROM tblDoor";

conn.Open();
//how to find out what user id to use?

|||Do you have SQL Server or MSDE? If SQL Server, then you should be able to use Enterprise Manager to try and figure out what the SA password is, as well as determining whether SQL Server security is enabled. If you have Enterprise manager, right click the SQL Server and select Porperties. In the properties window, go to the Security tab make sure authentication is set to SQL Server and Windows.|||oh it is working already, thanks man!

connection could not be made to Report Server

Hi,

My report server and report manager was working fine till yesterday. But suddenly today when i tried to deploy a report i got error: "A connection could not be made with report server at https://webserver1/ReportServer "

So when i tried to browse the report manager from IIS, I get error:"Could not establish trust relationship with remote server."

I think its someting to do with SSL. Please help me with that 'czo out of the blue today I have started getting this error.

Thanks

Hi,

try this :

- open "c:\program files\microsoft sql server\mssql.3\reporting services\reportserver\web.config"

- remove the xmlns="http://schemas.microsoft.com..." attribute in the first <configuration> tag

- restart RS service

Also check that the certificate name maps with the server name in the RSWebApplication.config file.

Fabrice

connection could not be established

Hi there,
Im running SQL server 2000 on SBS2k3. I have a couple of databases working
fine and then all of a sudden i was locked out of them when I go to server
enterprise manager with the following msg:
A connection could not be established to <server>
Reason: login failed for user '<domain>\administrator'
Please verify SQL Server is running and check your SQL Server registration
properties and try again.
Could someone please help me. I have checked and the service MSSQL Server
is running.
thank you
MikeMike
Perhasps you have changde a password for this login and your SQL Server was
registered (EM)by an old password.
"Mike Hunt" <ncc4@.hotmail.com> wrote in message
news:%23CXAyyprFHA.3836@.TK2MSFTNGP12.phx.gbl...
> Hi there,
> Im running SQL server 2000 on SBS2k3. I have a couple of databases
> working fine and then all of a sudden i was locked out of them when I go
> to server enterprise manager with the following msg:
> A connection could not be established to <server>
> Reason: login failed for user '<domain>\administrator'
> Please verify SQL Server is running and check your SQL Server registration
> properties and try again.
> Could someone please help me. I have checked and the service MSSQL Server
> is running.
> thank you
> Mike
>

Connection busy with results for another hstmt...

Hi mates,

I am getting this strange error while working on SQL server through JDBC.
I am using a connection-pooling mechanism. Have written my own connection pool. The pool holds a number of connections and has methods for requesting and returning connections from the clients. The issue is - when I get a connection from the pool and execute a select query, it works fine. Then I return the connection to the pool (at the top). On next request for connection, this same connection object is provided. When another select query is fired on this connection, I get an error - "connection is busy with results for another hstmt"... The error occurs at the time of executing the query and not while obtaining the statement object from the connection object.
If I don't use the connection pool and create new connection every time, everything works fine (except the performance!)...
I'll be grateful if anyone can shed some light on this....
Cheers!That's because each connection can only have 1 active (pending results) statement per connection.

It sounds like you are not closing/dropping the statements, or the driver is not. It might be your connection handling code. You might also try a different jdbc driver. Are you using an sql specific driver? It you use the default jdbc-odbc bridge, you can get bad behavior. That driver doen't work well. There are 3 kinds of replacements:

1) Free Jdbc drivers for SQL Server. MS provides one, and there is an open source one out there.

2) A ready for deployment JDBC-ODBC Bridge from a vendor. There are several.

3) A commercial JDBC Driver.

What you need is dependant on your budget, time and architecture.

Jay Grubb
Technical Consultant
OpenLink Software
Web: http://www.openlinksw.com:
Product Weblogs:
Virtuoso: http://www.openlinksw.com/weblogs/virtuoso
UDA: http://www.openlinksw.com/weblogs/uda
Universal Data Access & Virtual Database Technology Providers

connection

Please help me resolve I'm stuck and a novice
I have a connection string in a VB app that I am working
on but when i execute app I get
Run time Error -2147467259 (80004005) Login failed for
user *** reseaon not a trusted SQL Server connection.
I am set up on SQL server I can run enterprise manage from
my PC and run queries against server but I can not through
my application, I am set up using my windows user info..Hi, Chuck.
Refer to the following site:
http://www.able-consulting.com/ado_conn.htm
You can see many connection examples. This may help you.
"Chuck" <anonymous@.discussions.microsoft.com> wrote in message
news:051d01c3bbd7$20610da0$a501280a@.phx.gbl...
> Please help me resolve I'm stuck and a novice
> I have a connection string in a VB app that I am working
> on but when i execute app I get
> Run time Error -2147467259 (80004005) Login failed for
> user *** reseaon not a trusted SQL Server connection.
> I am set up on SQL server I can run enterprise manage from
> my PC and run queries against server but I can not through
> my application, I am set up using my windows user info..

Connecting to SQL Server 2005 over VPN Not working

I am having trouble connecting to SQL Server 2005 from my home via VPN
connection to my office. I have enabled remote connections on the
server. I can actually connect to my local SQL Server instance from
the Server machine while connected to the VPN but not the other way
around. I can browse shared folders from the Server machine so my vpn
connection is good. Other machines in the office can remotely connect
to the SQL Server instance on the server machine.
Is there some setting on the server, such as somewhere in RRAS, that I
need to configure to allow me to connect?
FYI: I am using SQL Authentication
ThanksHi
"chack.busedge@.gmail.com" wrote:

> I am having trouble connecting to SQL Server 2005 from my home via VPN
> connection to my office. I have enabled remote connections on the
> server. I can actually connect to my local SQL Server instance from
> the Server machine while connected to the VPN but not the other way
> around. I can browse shared folders from the Server machine so my vpn
> connection is good. Other machines in the office can remotely connect
> to the SQL Server instance on the server machine.
> Is there some setting on the server, such as somewhere in RRAS, that I
> need to configure to allow me to connect?
> FYI: I am using SQL Authentication
> Thanks
>
Check out http://support.microsoft.com/kb/287932 on the ports that you will
need to have access to for the connection. Have you tried terminal services
or Remote desktop to access the server?
John|||On Jun 28, 12:32 pm, John Bell <jbellnewspo...@.hotmail.com> wrote:
> Hi
>
>
> "chack.buse...@.gmail.com" wrote:
>
>
>
> Check outhttp://support.microsoft.com/kb/287932on the ports that you will
> need to have access to for the connection. Have you tried terminal service
s
> or Remote desktop to access the server?
> John- Hide quoted text -
> - Show quoted text -
The VPN was configured using the RRAS console. Is there something I
need to configure there to allow port 1433 access via VPN?
Yes, I can remote desktop into the server. That's how I am
configuring the VPN.
Thanks|||On Jun 28, 1:39 pm, chack.buse...@.gmail.com wrote:
> On Jun 28, 12:32 pm, John Bell <jbellnewspo...@.hotmail.com> wrote:
>
>
>
>
>
>
>
>
>
>
> TheVPNwas configured using the RRAS console. Is there something I
> need to configure there to allow port 1433 access viaVPN?
> Yes, I can remote desktop into theserver. That's how I am
> configuring theVPN.
> Thanks- Hide quoted text -
> - Show quoted text -
Ok, I finally got something to work. I was reviewing this article
http://support.microsoft.com/kb/265808 when I found the IPAll Dynamic
Ports value to be 1033. On a whim I decided to set my server name
value for my connection to...
SERVER\INSTANCENAME,1033
And voila, it freeking worked. I don't know why, but at this point I
don't care. I am thrilled to have a connection that I can use at
home. I sure hope this helps out someone else in the future.|||Hi
"chack.busedge@.gmail.com" wrote:

> On Jun 28, 1:39 pm, chack.buse...@.gmail.com wrote:
> Ok, I finally got something to work. I was reviewing this article
> http://support.microsoft.com/kb/265808 when I found the IPAll Dynamic
> Ports value to be 1033. On a whim I decided to set my server name
> value for my connection to...
> SERVER\INSTANCENAME,1033
> And voila, it freeking worked. I don't know why, but at this point I
> don't care. I am thrilled to have a connection that I can use at
> home. I sure hope this helps out someone else in the future.
>
You had not said that you had a named instance of SQL Server!! By default
that will use a dynamic port instead of 1433 see
http://msdn2.microsoft.com/en-us/library/ms177440.aspx You have forced the
server to use a specific port (which seems to be open!!)
Ports from 1024 through 49151 are IANA registered ports, and 1033 is
registered for netinfo. IANA recommend that dynamic or Private Ports from
49152 through 65535 are used.
John

Connecting to SQL Server 2005 over VPN Not working

I am having trouble connecting to SQL Server 2005 from my home via VPN
connection to my office. I have enabled remote connections on the
server. I can actually connect to my local SQL Server instance from
the Server machine while connected to the VPN but not the other way
around. I can browse shared folders from the Server machine so my vpn
connection is good. Other machines in the office can remotely connect
to the SQL Server instance on the server machine.
Is there some setting on the server, such as somewhere in RRAS, that I
need to configure to allow me to connect?
FYI: I am using SQL Authentication
Thanks
Hi
"chack.busedge@.gmail.com" wrote:

> I am having trouble connecting to SQL Server 2005 from my home via VPN
> connection to my office. I have enabled remote connections on the
> server. I can actually connect to my local SQL Server instance from
> the Server machine while connected to the VPN but not the other way
> around. I can browse shared folders from the Server machine so my vpn
> connection is good. Other machines in the office can remotely connect
> to the SQL Server instance on the server machine.
> Is there some setting on the server, such as somewhere in RRAS, that I
> need to configure to allow me to connect?
> FYI: I am using SQL Authentication
> Thanks
>
Check out http://support.microsoft.com/kb/287932 on the ports that you will
need to have access to for the connection. Have you tried terminal services
or Remote desktop to access the server?
John
|||On Jun 28, 12:32 pm, John Bell <jbellnewspo...@.hotmail.com> wrote:
> Hi
>
>
> "chack.buse...@.gmail.com" wrote:
>
>
> Check outhttp://support.microsoft.com/kb/287932on the ports that you will
> need to have access to for the connection. Have you tried terminal services
> or Remote desktop to access the server?
> John- Hide quoted text -
> - Show quoted text -
The VPN was configured using the RRAS console. Is there something I
need to configure there to allow port 1433 access via VPN?
Yes, I can remote desktop into the server. That's how I am
configuring the VPN.
Thanks
|||On Jun 28, 1:39 pm, chack.buse...@.gmail.com wrote:
> On Jun 28, 12:32 pm, John Bell <jbellnewspo...@.hotmail.com> wrote:
>
>
>
>
>
>
> TheVPNwas configured using the RRAS console. Is there something I
> need to configure there to allow port 1433 access viaVPN?
> Yes, I can remote desktop into theserver. That's how I am
> configuring theVPN.
> Thanks- Hide quoted text -
> - Show quoted text -
Ok, I finally got something to work. I was reviewing this article
http://support.microsoft.com/kb/265808 when I found the IPAll Dynamic
Ports value to be 1033. On a whim I decided to set my server name
value for my connection to...
SERVER\INSTANCENAME,1033
And voila, it freeking worked. I don't know why, but at this point I
don't care. I am thrilled to have a connection that I can use at
home. I sure hope this helps out someone else in the future.
|||Hi
"chack.busedge@.gmail.com" wrote:

> On Jun 28, 1:39 pm, chack.buse...@.gmail.com wrote:
> Ok, I finally got something to work. I was reviewing this article
> http://support.microsoft.com/kb/265808 when I found the IPAll Dynamic
> Ports value to be 1033. On a whim I decided to set my server name
> value for my connection to...
> SERVER\INSTANCENAME,1033
> And voila, it freeking worked. I don't know why, but at this point I
> don't care. I am thrilled to have a connection that I can use at
> home. I sure hope this helps out someone else in the future.
>
You had not said that you had a named instance of SQL Server!! By default
that will use a dynamic port instead of 1433 see
http://msdn2.microsoft.com/en-us/library/ms177440.aspx You have forced the
server to use a specific port (which seems to be open!!)
Ports from 1024 through 49151 are IANA registered ports, and 1033 is
registered for netinfo. IANA recommend that dynamic or Private Ports from
49152 through 65535 are used.
John

Connecting to SQL Server 2005 over VPN Not working

I am having trouble connecting to SQL Server 2005 from my home via VPN
connection to my office. I have enabled remote connections on the
server. I can actually connect to my local SQL Server instance from
the Server machine while connected to the VPN but not the other way
around. I can browse shared folders from the Server machine so my vpn
connection is good. Other machines in the office can remotely connect
to the SQL Server instance on the server machine.
Is there some setting on the server, such as somewhere in RRAS, that I
need to configure to allow me to connect?
FYI: I am using SQL Authentication
ThanksHi
"chack.busedge@.gmail.com" wrote:
> I am having trouble connecting to SQL Server 2005 from my home via VPN
> connection to my office. I have enabled remote connections on the
> server. I can actually connect to my local SQL Server instance from
> the Server machine while connected to the VPN but not the other way
> around. I can browse shared folders from the Server machine so my vpn
> connection is good. Other machines in the office can remotely connect
> to the SQL Server instance on the server machine.
> Is there some setting on the server, such as somewhere in RRAS, that I
> need to configure to allow me to connect?
> FYI: I am using SQL Authentication
> Thanks
>
Check out http://support.microsoft.com/kb/287932 on the ports that you will
need to have access to for the connection. Have you tried terminal services
or Remote desktop to access the server?
John|||On Jun 28, 12:32 pm, John Bell <jbellnewspo...@.hotmail.com> wrote:
> Hi
>
>
> "chack.buse...@.gmail.com" wrote:
> > I am having trouble connecting to SQL Server 2005 from my home via VPN
> > connection to my office. I have enabled remote connections on the
> > server. I can actually connect to my local SQL Server instance from
> > the Server machine while connected to the VPN but not the other way
> > around. I can browse shared folders from the Server machine so my vpn
> > connection is good. Other machines in the office can remotely connect
> > to the SQL Server instance on the server machine.
> > Is there some setting on the server, such as somewhere in RRAS, that I
> > need to configure to allow me to connect?
> > FYI: I am using SQL Authentication
> > Thanks
> Check outhttp://support.microsoft.com/kb/287932on the ports that you will
> need to have access to for the connection. Have you tried terminal services
> or Remote desktop to access the server?
> John- Hide quoted text -
> - Show quoted text -
The VPN was configured using the RRAS console. Is there something I
need to configure there to allow port 1433 access via VPN?
Yes, I can remote desktop into the server. That's how I am
configuring the VPN.
Thanks|||On Jun 28, 1:39 pm, chack.buse...@.gmail.com wrote:
> On Jun 28, 12:32 pm, John Bell <jbellnewspo...@.hotmail.com> wrote:
>
>
> > Hi
> > "chack.buse...@.gmail.com" wrote:
> > > I am having trouble connecting toSQLServer2005from my home viaVPN
> > > connection to my office. I have enabled remote connections on the
> > >server. I can actually connect to my localSQLServerinstance from
> > > theServermachine while connected to theVPNbut not the other way
> > > around. I can browse shared folders from theServermachine so myvpn
> > > connection is good. Other machines in the office can remotely connect
> > > to theSQLServerinstance on theservermachine.
> > > Is there some setting on theserver, such as somewhere in RRAS, that I
> > > need to configure to allow me to connect?
> > > FYI: I am usingSQLAuthentication
> > > Thanks
> > Check outhttp://support.microsoft.com/kb/287932onthe ports that you will
> > need to have access to for the connection. Have you tried terminal services
> > or Remote desktop to access theserver?
> > John- Hide quoted text -
> > - Show quoted text -
> TheVPNwas configured using the RRAS console. Is there something I
> need to configure there to allow port 1433 access viaVPN?
> Yes, I can remote desktop into theserver. That's how I am
> configuring theVPN.
> Thanks- Hide quoted text -
> - Show quoted text -
Ok, I finally got something to work. I was reviewing this article
http://support.microsoft.com/kb/265808 when I found the IPAll Dynamic
Ports value to be 1033. On a whim I decided to set my server name
value for my connection to...
SERVER\INSTANCENAME,1033
And voila, it freeking worked. I don't know why, but at this point I
don't care. I am thrilled to have a connection that I can use at
home. I sure hope this helps out someone else in the future.|||Hi
"chack.busedge@.gmail.com" wrote:
> On Jun 28, 1:39 pm, chack.buse...@.gmail.com wrote:
> > On Jun 28, 12:32 pm, John Bell <jbellnewspo...@.hotmail.com> wrote:
> >
> >
> >
> >
> >
> > > Hi
> >
> > > "chack.buse...@.gmail.com" wrote:
> > > > I am having trouble connecting toSQLServer2005from my home viaVPN
> > > > connection to my office. I have enabled remote connections on the
> > > >server. I can actually connect to my localSQLServerinstance from
> > > > theServermachine while connected to theVPNbut not the other way
> > > > around. I can browse shared folders from theServermachine so myvpn
> > > > connection is good. Other machines in the office can remotely connect
> > > > to theSQLServerinstance on theservermachine.
> >
> > > > Is there some setting on theserver, such as somewhere in RRAS, that I
> > > > need to configure to allow me to connect?
> >
> > > > FYI: I am usingSQLAuthentication
> >
> > > > Thanks
> >
> > > Check outhttp://support.microsoft.com/kb/287932onthe ports that you will
> > > need to have access to for the connection. Have you tried terminal services
> > > or Remote desktop to access theserver?
> >
> > > John- Hide quoted text -
> >
> > > - Show quoted text -
> >
> > TheVPNwas configured using the RRAS console. Is there something I
> > need to configure there to allow port 1433 access viaVPN?
> >
> > Yes, I can remote desktop into theserver. That's how I am
> > configuring theVPN.
> >
> > Thanks- Hide quoted text -
> >
> > - Show quoted text -
> Ok, I finally got something to work. I was reviewing this article
> http://support.microsoft.com/kb/265808 when I found the IPAll Dynamic
> Ports value to be 1033. On a whim I decided to set my server name
> value for my connection to...
> SERVER\INSTANCENAME,1033
> And voila, it freeking worked. I don't know why, but at this point I
> don't care. I am thrilled to have a connection that I can use at
> home. I sure hope this helps out someone else in the future.
>
You had not said that you had a named instance of SQL Server!! By default
that will use a dynamic port instead of 1433 see
http://msdn2.microsoft.com/en-us/library/ms177440.aspx You have forced the
server to use a specific port (which seems to be open!!)
Ports from 1024 through 49151 are IANA registered ports, and 1033 is
registered for netinfo. IANA recommend that dynamic or Private Ports from
49152 through 65535 are used.
John