I am running SQL Server 2000 Developer (with Service Pack 3a) on Windows XP Professional. After installing Windows XP Service Pack 2, I can no longer connect to SQL Server. From Enterprise Manager, the error shows up in a dialog when I click on the "Machinename\Machinename (Windows NT)" no...more >>

I have a small domain, one web server one sql server. The web server has client tools installed on it. I have applied sp3 to both machines. This afternoon, I installed Analysis services on the web machine and reran sp3. I can now no longer connect via ODBC to the sql server. I recieve...more >>

Hi, I have a problem with a few clients who try to launch an internal application. The application tries to connect to a SQL Server ODBC connection which is located at the SQL Server. The error message that appears is : Error: 08001 18 [Microsoft][ODBC SQL Server Driver][DNETLIB]SSL Secu...more >>

Hi, My company is running: SQL Server 2000 SP3 on Windows 2000 Advanced Server SP4 System Config: 4 Processor 2 GB Memory 80 GB Compaq SCSI Drive (Raid 4). we have recently apply SQL 2000 SP3 and have encountered the following error on the client applications: 1. [Microsoft][ODBC ...more >>

SQL 7.0/NT 4.0 We have a C++ application using an ODBC call "SQLConnect" to a SQL server which works just fine unless there's a problem, e.g., SQL server goes down or something similar that breaks the connection. Then the C++ application locks up as it retries to connect in a sort of ...more >>

Experiencing 2 different errors before being able to connect to the database. This happened 2 times, 7 days apart, and the problem was resolved by selecting OK thru the errors and allowing the program (Access) to connect. 1st error occurs twice and the 2nd error, which is an Access Error occu...more >>

Hi, I have 3 SQL servers 7, and since yesterday, some of my clients started receiving different error messages in the middle of doing something like reporting, or editing, however when i checked the event logs on all servers, there is no error message there. all different messages include...more >>

Does anyone know of a way to track this error back to a given machine or process/application. I've run traces and the only possibly useful information I've found is the Client Process ID, but I don't know how to use it to track it back to the culprit. It shows up in the error log about e...more >>

How many concurrent sessions can SQL 2000 take? thanks...more >>

Hello All, I am running SQL server 7 sp4 on an NT4.0 SP6a, I'll call it machin2. I = am=20 also running SQL server 7 sp2 on an NT4.0 SP6a, I'll call it machine 1. = Two=20 databases. I am trying to move the database on machine 1 to the server=20 machine 2. I have installed sql and installed al...more >>

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 acce...more >>

Hello, We are a small software developement group. Recently we decided to try out using MSDE, and one of our developers installed it on his PC. After some struggling with logging on it was discovered that by default it uses Windows authentication mode and reading KB articles we were able to ch...more >>

Hi, I am developing DTS that extract data from Oracle via Linked server. I'm using MS OLE DB for Oracle. The following error message prompted when I query to selected tables (12 tables out of 40+ tables) in Oracle. Server: Msg 7317, Level 16, State 1, Line 1 OLE DB provider 'MSDAORA' retur...more >>

Hi, I am developing DTS that extract data from Oracle via Linked server. I'm using MS OLE DB for Oracle. The following error message prompted when I query to selected tables (12 tables out of 40+ tables) in Oracle. Server: Msg 7317, Level 16, State 1, Line 1 OLE DB provider 'MSDAORA' retur...more >>

Hello, I am a new user. I am trying to connect to a SQL 2000 server running on a win 2003 server. I have installed SP3a on SQL server. I am getting the following error when trying to conenct: Unable to connect to server Msg 17, Level 16, State 1 SQL server does not exist or access i...more >>

Hi! Say, I want to connect to a SQL Server (through Enterprise Manager) using Windows Authentication. The user name that I'm gonna use though is an account other than the account I'm currently logged on. Is this possible? Thanks...more >>

when ever i open a connection through ado.net 2 connections are opened inthe sql server . but in my application i close my connection after it's use,why is it so ...more >>

In some SQL2K instances, I have (LOCAL) in others its (Local) and in development code the connect to server parameter is always local. Where is (local) associated to 127.0.0.1 or local server name? If I have 2 or more instances of SQL Server on my maching which one would (local) refer too? ...more >>

hello, i've been running fine with the same msft sql server set up for over a year now. each night i run some vba code which connects with the db and does some data updates. all of a sudden i'm having trouble communicating with the db. when i attempt to connect to the db via query analyz...more >>

I am connecting to a SQL Server database from ASP pages. The web site and SQL Server are on two different machines. The web server is running 2000 server. Everything works fine. I copied the web site to a 2003 server and I'm still connecting to SQL Server on another machine (the same ...more >>

We have a software(Hospital Informatiom System) which gets hanged and gives errors such as "ODBC SQL Server Time Out error & Time out expire / "TCP Socket error". It effects the complete HIS system and none of the Transaction can be saved during that time. We have been facing this probl...more >>