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
August 2008


all groups > sql server connect > april 2004 > threads for april 1 - 7, 2004

Filter by week: 1 2 3 4 5

connect to cluster server issue
Posted by Yuling at 4/7/2004 4:11:07 PM
Hi I had SQL 2000 client, and tried to register to SQL 7 cluster server in Enterprise Manager. But the registering process hang Does anyone know the issue? It happen to other users as well Thanks yuling...more >>

Connection problem when registering a remote SQL2000
Posted by Charles at 4/7/2004 2:09:39 PM
Hello, I try to register a remote SQL Server 2000 installed in a W2003, but it doesn't work. Afer 6 or 7 seconds, it says: Timeout expired. In that network , port 1433 is open and what it really surpises me, is that I can connect via ODBC to any database of that remote SQL Server2000 !!! ...more >>

connecting to sql from ASP
Posted by Ngan Bui at 4/7/2004 12:42:14 PM
I created a webpage where someone can enter in new client info. Using asp, I want to connect to the sql db and add the new record. I'm using SQL2k in an W2K environment. I want to use the trusted connection so SQL would use the windows login to authenticate. Below is the code for conne...more >>

Unable to Connect to Database
Posted by Wolfgang at 4/7/2004 12:07:20 PM
I just upgraded a WIN98 PC to WINXP. The PC is running SQL Server 2000 Personal Edition. After upgrade to WINXP the SQL Server will not start. I get the following error:"An Error 1060 - The Specified Service Does Not Exist as an Installed Service..." There are no SQL Services listed un...more >>

Timeout expired. Help!!!
Posted by ak at 4/7/2004 10:34:13 AM
Hallo, when I try to perform a SELECT statement against a view with Enterprise Manager or with a VB 6.0 application, I get the following message: [Microsoft][ODBC SQL Server Driver] Timeout expired. This appears on both SQL Server 7.0 and 2000. The SELECT Statement works on the Query Analyz...more >>

sql server job failing
Posted by biju george at 4/7/2004 5:29:37 AM
Hi Guys, from sql server 2000 (desk top) i created a link to oracle 7.3 and created a procedure which will update sql tables and insert into oracle table. from query analyser i can execute this procedure. but when i configure a job to execute this procedure it is failing? any idea pls advi...more >>

Cannot connect via Linked Server
Posted by Frank Jones at 4/6/2004 6:16:03 PM
We have two servers, each with named instances of SQL Server 2000 SP3a installed. Server1\Instance1 has a linked server to Server2\Instance2. The linked server is using the SQLOLEODB provider. This linked server is setup with remote login and a correct password. We get an error #17: SQL Server d...more >>

Problem connection to SQL Server with ODBC
Posted by Ian Spanswick at 4/6/2004 10:12:37 AM
Hi, Getting very frustrated by the following problem, using SQL Server 2000 (inc SP3a), using an application that connects to a DB via ODBC and the following error message comes up: Connection failed: SQLSTATE: '01000' SQL Server Error: 1703 [Microsoft][ODBC SQL Server Driver][Shared Memo...more >>



MS Query Analyser and MS Access
Posted by Evan Tomlinson at 4/6/2004 5:07:47 AM
Hi, As far as I understand MS Access supports the SQL language, thus it should be possible to use tools such as MS SQL Query Analyser to connect to your MS Access database. But I cannot get this to work. My thought was to use the path to the file rather than the name of the server, but this...more >>

SERVERS
Posted by CHRIS MOOS at 4/5/2004 7:01:05 PM
HOW DO I GET CONECTIVITY FROM THE SERVER TO THE CLIENT?...more >>

How do I find I am administrator?
Posted by Sunny at 4/5/2004 3:26:18 PM
This is the first time I will be using SQL server although I have good experience in FoxPro and ACCESS database, I have limited knowledge of SQL server. We have installed SQL server 2000 on WIN2K. Our IT people has installed Enterprise Manager on my win2000 workstation. How do I find I am in a...more >>

In Plain English
Posted by Nick DiToro at 4/4/2004 11:33:45 AM
I am a project manager trying to implement a 3rd-party application at my company. The application has a FAT client and a SQL 2000 Server DB. The guidelines from our infrastructure security group are as follows: 1. Authentication to the SQL server must not use SQL authentication. 2. The crede...more >>

cannot connect to sql server 6.5 after installed the mdac 9.0
Posted by Simon Wu at 4/3/2004 12:05:15 PM
Hi all I cannot create the odbc connection, the error says this mdac I am using des not support sql. server 6.5 or older. Can anyone have ideas on it? Simon ...more >>

net session \\servername /delete
Posted by Winn, Chris at 4/2/2004 5:18:26 PM
Anyone know how to perform this on a remote server? Thanks, Chris ...more >>

Can't Connect to SQL Server
Posted by Me at 4/2/2004 4:27:13 PM
someone told me to delete BUILTIN\Adminiistrator becuase it was a security risk and now i cant access the Enterprise manager. can anyone help?...more >>

Weird Locking Issue
Posted by Randy at 4/2/2004 3:14:07 PM
I develop on an Access Database that is a Front End to SQL Server. We have been sailing along for years without any problems. Now, several of our customers are starting to have weird locking problems. Innocent seeming passthru queries are causing Table Locks. Simple COmbo box look ups on...more >>

Problem in starting local SQL SERVER
Posted by Siva at 4/1/2004 10:40:12 PM
When I try to start my local sql server it is giving the following error. "An error 23 - (Data error(cyclic redundancy check)) occurred while performing this service operation on the MSSQLServer Service." Can anybody help me out in this issue.. Thanks & Regards Siva...more >>

Connecting to a remote server
Posted by Murphy at 4/1/2004 9:13:02 PM
We are setting up a webserver (172.16.0.2) that lives in the DMZ behind our firewall (172.16.0.1) I would like this server to connect to a db that lives on an SQL Server (PDC: 192.168.16.2) on our internal lan. I have opened port 1433 on the firewall between 172.16.0.2 & 192.168.16.2 On the web...more >>


DevelopmentNow Blog