Archived Months
June 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007


all groups > sql server connect > april 2004 > threads for april 22 - 28, 2004

Filter by week: 1 2 3 4 5

IIS 6.0 with sql backend connectivity
Posted by Bahij Nahhas at 4/27/2004 6:47:05 PM
Can somebody please send me a link or reference on how to configure a website using IIS 6.0 to connect to a SQL on the backend? Thank you....more >>

still ongoing
Posted by Chris Brighton at 4/27/2004 5:51:24 AM
i have just been informed we are running MSDE, not the full SQL server. i am running the OSQL service that comes with it, and looking through the information i have found so far. still if anyone knows what i should be doing it would be greatly appriciated as i have spent too long on this ...more >>

SQL only allows administrators access
Posted by Chris Brighton at 4/27/2004 3:38:09 AM
I am running SQL on our network to use a program called BSquared: Connecting Steps. this program stores information on a database on the server and uses SQL to access it. when running the program on an administrators profile everything works fine, however when i attempt to run the progr...more >>

URGENT: MSDE TCP Problem
Posted by snehaltiwari NO[at]SPAM yahoo.com at 4/27/2004 3:33:06 AM
I have installed MSDE 2000 on an XP Prof. box. I am able to connet to this instance locally from the server, but when i try to connect to it from other machines, i get an error stating Server does not exist or access denied I have traced this problem to msde not listening on port 1433 on my ...more >>

general network error; no event logged
Posted by Mike Doyle at 4/26/2004 2:10:56 PM
When running a job under SQLAgent we have intermittently received the following message: ConnectionCheckForData (CheckforData()). [SQLSTATE 01000] (Message 10054) General network error. Check your network documentation. [SQLSTATE 08S01] (Error 11). The step failed. The job had been r...more >>

Disconnect error while running re-indexing job.
Posted by clotho42 NO[at]SPAM yahoo.com at 4/26/2004 9:26:59 AM
Hi, I have a 24Gb database with half a dozen indexes against various tables which is failing during the reindexing task (as part of the maintenance plan) at least 80% of the time. The error given in the logs is: "[Microsoft SQL-DMO (ODBC SQLState: 01000)] Error 0: This server has been di...more >>

how to query database through proxy
Posted by Daniela Tsigarovska at 4/26/2004 1:39:49 AM
Hi, I want to know what is the name of the manager used in MSSQL Server 2000 that queries a database through a proxy. The name of that manager in Oracle is Connection manager....more >>

MSDE over firewall
Posted by Ed Morra at 4/23/2004 2:39:11 PM
Succesfully created a MSDE 2000 rel A backend on 2003 server. I can connect a MS Access project frontend to it from an XP client on the same LAN segment. I can connect the same frontend over the internet to this server when set out in the firewall's DMZ. And now for my next trick! When I...more >>



How to enable SSL encryption as BOTH client and server
Posted by Yuh-MIng Shyy at 4/23/2004 10:45:57 AM
We have an application that requires bi-directional data transfer between 2 SQL servers. To ensure the data transfer is encrypted, we are considering to use SQL server SSL encryption. However, the problem is for this case, each machine is acting as both client and server for SSL encryption. So i...more >>

Views from Oracle using linked server
Posted by marcus.brodd NO[at]SPAM ibitec.se at 4/23/2004 6:17:11 AM
Hi all! I have a serious problem....(Who doesn´t...;) I have a SQL Server 2000 and a Oracle 8.1.7 Database. I have set up a number of views in SQL Server that are populated via a linked server connection. In almost all cases this works great, but for one view. The view displays OK, BUT one ...more >>

connection sql server with asp.net
Posted by Zalizan at 4/22/2004 8:46:18 PM
hello all.....i'm got a little problem here...i hope youu guys can help me... ok...first, i'm using asp.net for my web application. when i run it in my own server, it's ok....got nothing problem with connection to my database(in the same server) but...when i'm bring it to my web server wi...more >>

Trusted Connection=Yes
Posted by YUNG LIE at 4/22/2004 2:52:46 PM
My connection from a web page to my SQL Server was working when my connection string is: ....Trusted Connection=no; uid=sa; pwd=sapassword;" It stopped working when I change it to: ....Trusted Connection=yes;" I get this error message: Microsoft OLE DB Provider for SQL Server error '80040...more >>

Encryption Not Supported Error
Posted by Footix at 4/22/2004 12:16:06 PM
When running .Net apps against a local SQL Server (2000, SP3) I get the following error Connection failed ConnectionOpen (PreLoginHandshake() Connection faile Encryption not supported on SQL Serve Any help will be greatly appreciated Thanks...more >>

DTC Error
Posted by David Liu at 4/22/2004 12:05:28 PM
I have a project with two SQL servers on two seperate subnet, following distribute query will run on B server. update [xxx.xxx.xxx.xxx].[abce].[dbo].[abcede] set uploadstatus='InProgress' If I include this statement in Transaction Like this way: Begin Tran update [xxx.xxx.xxx.xxx].[ab...more >>


DevelopmentNow Blog