Hello All! I have a problem with SSPI ! I have SQLServer and LAN On the same mashine. They have no connection between them. When I try to connect to SQLServer Without LAN He wrote : "Can't Create SSPI Context". Application that does it and SQL Server both in the same Mashine Without and Rem...more >>

Hi, I have a problem. My web server is a Windows 2k Server and my database server a Windows 2003. I use windows authentication to login at SQL Server, but when I access from a client machine that uses Win 2k Professional I always receive this message: "[Microsoft][ODBC SQL Server Driver][SQL ...more >>

Hi, My firm will soon need to join the domain of our global firm. Currently I have 4 SQL Servers in my old domain with replication setup. I have setup a test server and I have found that clients within the old domain have no access to the SQL Server in the new domain, but clients in the ne...more >>

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

In the following sceanrio Web application uses Analysis Services to present data. Web App (IIS) is installed on a different server to the SQL Server instance. Web app uses Windows Integrated authentication. It appears that the authentication is not correctly passed to AS and that...more >>

The service did not start due to login failure. ...more >>

Hi, I'm in the process of moving the data of an access database to SQL Server, but it doesn't seem to work. I've set up a data source, and I'm able to select the tables to link, but instead of the data I only get "#deleted" in all columns. It works if I import the table instead of linkin...more >>

With Enterprise manager, I can see a remote sql 2000 sp3 instance. I can also see that port 1433 is open. But, when I try to connect to it, I get the connection could not be estiablished. sql server does not exist or access denied. I have pretty much all the port except for 1433 tcp and ...more >>

I resently purchased a Virtual Windows 2003 Standard Server and I installed SQL 2000 with Service Pack 3 on it to make sure it was up to date. I can ftp on this server and everthing but when it comes to making a Microsoft ODBC connection from my local computer to the virtual server I am not able...more >>

We have clustered IIS .asp pages that query our clustered SQL server. Thes pages work when IIS is running on node 1 with SQL on either node. If the web (IIS) is failed over to node 2 the .asp pages stop rendering and we get 404 errors. The .html pages work fine. On pages that have both .asp a...more >>

Hi, I've just installed Sql 2000 (and sp3a) on my Win 2003 server. But I have trouble connecting to it from my client machine. I keep getting this error when registering: "User login failed: Not associated with a trusted Sql Server connection". The client machine is running on XP Home. The us...more >>

Helo, I nstalled two instances of sqlserver2000 on an win server 2000. first problem: changing the default tcp port from one instance ,also changes the port of the other one. No way to have two different ports. The eventviewer indicates a problem with one of the two instances: cannot connect to...more >>

Here I go for last time, I promise. I uninstalled MS DTC (in an stupid attemp to avoid a distributed transaction to start), by doing : net stop MSDTC MSDTC - uninstall After some charitative aim told me what I wanted to do is not possible, I decided to reinstall : MSDTC -install ...more >>

On my client computer, I have MSDE and use SQL EM to connect to the local DB and the server's db (server is running sql2k sp3a). I installed XP sp2 on my client computer and now the QA and all programs ---can--- access the sql server just fine, but the EM cannot connect ... it gives general o...more >>

Hi, I have a linked server to an Oracle database, to which I am executing some packages that return a resultset. Now, I'm trying to get those results into a local table using : Insert Into LocalTable Execute sp_StoredThatCallsAnOraclePackage but I get the error "'MSDORA' was un...more >>

I'm having a problem when i try to delete a table...I have run dbcc newalloc DBCC checkdb on the database and the newalloc came back without errors...the checkdb just hangs without returning anything...this is a developement database with the live version off site, so whatever i need to d...more >>

I installed SQL 2000 on Windows Server 2003 and am trying to import data from a SQL 7 installed on an NT 4.0 Server. I get an error that reads: Failed to copy objects from MS SQL server to MS SQL server. Any thoughts? Thanks in advance....more >>

We have SQL 2000 on Windows 2000 it has flat hierchy ADS. we had our database frezze up four time this month. The only pattern seems it happnes one time per week. Other then taht no time or date pattern. I check the evnt logs no errors at all. I check the sql logs the only thing that seem...more >>

Hi, I had a similar post before, and got some good suggestions on this, but so far I'm still unable to retrieve my database. Unfortunately, I made the mistake of not detaching my database when I was having some problems, and it got physically moved instead. I have tried several differ...more >>

I'm having a problem when i try to delete a table...I have run dbcc newalloc DBCC checkdb on the database and the newalloc came back without errors...the checkdb just hangs without returning anything...this is a developement database with the live version off site, so whatever i need to d...more >>

Hi, I have commercial asp webspace hosting an application that connects to an SQL machine on my local network. THe machine has both SQL 7 and SQL 2k running on it. Webspace and SQL are both running on Win2k. The connection string I am using is as follows: Application("Application_Connecti...more >>

Hi, The problem: Cannot attach my database back to its original state... getting locked up. The history: I installed Oracle on my server a week ago, and ever since then my server has not been running right. I ended up uninstalling Oracle, so that I could at least eliminate that pa...more >>

Gary Hindson <garyhindson@hotmail.com> wrote: > Error > Server: Msg 7399, Level 16, State 1, Line 1 > OLE DB provider 'OraOLEDB.oracle' reported an error. Access denied. > OLE DB error trace [OLE/DB Provider 'OraOLEDB.oracle' > IUnknown::QueryInterface returned 0x80070005: Access denied.]. ...more >>

test ...more >>

Hi, I need to know the IP addresses of the PCs that are connected to my SQL Server. The master.dbo.sysprocesses table contains the field net_address. This is supposed to be the MAC address of the client interface, but the real problem is to map this MAC address to the actual IP. I've tryed by ...more >>

I see many posts about this, but nothing is helping. Heres my situation. My application has been running smooth for months now. Suddenly, I get this error. Nothing has changed within the application and nothing has changed within the database. The next thing I have to look at is the network...more >>

Hi, I,ve tried to manage an SQL Server (MSDE) with Enterprise Manager. The Server was successfully registered. But when I try to show the servers properties, or to insert a new login there is always the following error: "Error 22528 [SQL-DMO]This server connection has been unexpectedly broken...more >>

I have a spid that was killed in the middle of a rollback. The status message states that the rollback is 100% complete. The query analyzer connection is not there anymore. I cannot kill that spid with the kill command. Is there any way to kill it without bouncing the server?...more >>

Our website uses asp and asp.net pages. Yesteray we started having problems with the asp pages. The asp pages are unable to connect to the database. The asp.net pages work fine. We receive the generic sql server error message that it can't find the stored procedure. However, when we go in...more >>

Hi folks, I have created a linked server on SQL server 2000 for an Oracle 8i database using Microsoft's OLE provider for ORACLE. The connection works fine and I am able to run queries (select queries) agaist the Oracle table from SQL query analyzer. But the problem is, the query is miserabl...more >>