Hi I am trying to connect to SQL 2000 (SP3 installed) running on windows 2k3 from a webserver(windows 2000) using DSN connection in asp page and not able to connect.I am not getting any error and the asp page is not responding at all. But I was able to create DSN on the web server by pointing...more >>

Hi I have 140GB data base with maintenance plan schedule every sunday. when it run Optimizer plan I get the error and the job failed if I rerun the job some time it will completed but 1 out of 4 time it will failed on middle of reindex with the error [Microsoft SQL-DMO (ODBC SQLState: 010...more >>

I am trying to create the initial database from a snapshot on my SHED1 MS SQL server. Whenever I run the code below, I get the following error: 'The subscription to publication 'SteelPMOSql1' has expired or does not exist' When I installed MSDE 2000, I did not set the install option to cha...more >>

Hi, Pleae consider this scenario, where I have 2 systems on the same domain and named as system1 and system2. Two systems have Administrator logins as their local login, not part of domain and these two have same password say 123456 System1 has database installed with that and NT authenticatio...more >>

Hi, All SQL2000/sp3 and Sybase 11.5 There is a SP on Sybase CREATE PROC sp_test @t VARCHAR(32) = 'default string' AS SELECT @t I want execute that from SQL SELECT * FROM OPENROWSET('MSDASQL', 'MySybase';'uid';'pwd', 'exec sp_test') works file. But with the parameter it fails ...more >>

I have sql server 2000 installed on windows 2000 server. I just replaced new workstation (win2K) and installed SQL Client Tools. Now I am trying to register my SQL server but it says login failed. I use same login and password to log on SQL 2000 server directly from windows 2000 server and it wo...more >>

...more >>

I am trying to set up a linked server from a SQL 7 sp3 box to a SQL 2000 sp3 named instance server. I keep getting the following error. Server: Msg 11, Level 16, State 1, Line 1 General network error. Check your network documentation. I can however connect from a SQL Server 7 sp4 box with...more >>

I can't connect to Analysis Services accroding execl pivottable. The error message is "Unable to open connection. Cannot connect to cube file. '10.97.69.212',file may be in use." The TCP/IP is well but the client is not a domain user.What is the prolem? How to resolve it?...more >>

Hi very new to this field. I have set up both server in very much the default settings Can someone explain how i can use sql over the net? i have tried the examples, and nothing works Is there a process for setting it up to be web available that i have missed regard Antz...more >>

I am attempting to execute a query on a linked oracle server. The link is fine and I can execute the query from query analyser but when I create the stored procedure I get this error: Microsoft SQL-DMO (ODBC SQL State:42000) Error 7405: Hetergenous queries require the ANSI NULLS and ANSI WAR...more >>

Hi all, Apologies for the cross-post. Just wasn't sure where to put this one: I'm getting this error sporadically on an ADO connection. When it happens I also cannot connect through the Enterprise Manager (or anything else!). The environment is SQL Server 2000 running on Windows 2000 Ad...more >>

Hi, I have an error on my Application Server, it uses analysis services and a SQL Server databases. When I try to obtain information from the OLAP databases it send me the next error: Error Type: ADODB.Connection(0x800A0E7A) Provider cannot be found, It may not be properly i...more >>

Is there a way to veryify SQL Connection information within a stored procedure. I want to be able to pass in a user id and password to a custom stored procedure then check the creditials against SQL Server. In other words let say I run a stored procedure and i pass in a different user id and passwor...more >>

Can someone please give me step by step instructions for setting up two SQL servers to use security account delegation. Please leave out nothing. I've been working on this for a week and still get "Error 18456: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'." I've setup SPN for bo...more >>

HI AL I have tow domains, in the same forest. From one domain, which has a SQL Server A , I want to use the Enterprise manager or the Query Analyzer to connect the SQL Server B in the other domain and vise versa. Could any one elaborate all the method to do that thank you very much....more >>

Dear. In recently , I cannot use Enterprise Manager to browse datase the database. Waiting are long long time. However,when I use Query Analyzer that is ok, no problem. Could you help me. Thanks. ...more >>

So how does one get around the 1000 row limit when retrieving data from Active Directory via a linked server using the ADSDSOOBJECT ? -Kevin ...more >>

Hi All, I have a client using SQL Server 7.0 Sp3, and they have clients connecting to it via ODBC (32) bit driver, some of them are receiving a error message of communication Link failure. They have MDAC 2.7.1 installed, they tried using TCP/IP, and Name pipes, the error keeps happening. ...more >>

Does anyone have an idea why some of the scheduled jobs end with the following error message: Executed as user: DATABASE\Administrator. ConnectionCheckForData (CheckforData()). [SQLSTATE 01000] (Message 10054) General network error. Check your network documentation. [SQLSTATE 08S01] (Err...more >>

I have MSDE installed on one of my computers in my peer to peer network (all computers XP Professional). All computers on the network can see each other. However, I cannot use Query Analyzer or Enterprise Manager to connect to MSDE except from the computer that contains MSDE. Is it possible ...more >>

I am having great difficulty connecting to my sql box, I vpn'd in from work and connected via remote desktop, setup the SQL connection locally, and connected fine, which I am wondering if it was cause I was VPN'd in, but I disconnected from remote desktop and was still able to hit my sql s...more >>

Here goes: (good luck understanding all this) I have data in SQL Server that needs to be inserted into DB2. I have installed the IBM DB2 Client Configuration Assistant on the SQL Server and created a DSN. I can use the IBM Command Center to execute commands (both reads and writes) successfully...more >>

Is it possible to restore a backup of a 6.5 database to SQL 2000 server? Is it also possible to connect to a 6.5 server from EM? If so, how? Thanks ...more >>

Hi all, I install MSDE with SP3a on my server. The service starts well and with the local host I'm able to access the MSDE server, but if I want to access it from another workstation the connection always failed. I troubleshoot the problem and I found that MSDE 2000 doesn't listen on the port ...more >>

Hi, I have a Compact Proliant ML370, Windows 2000 Server SP3, SQL 2000 Server. I want to run a Visal Basic 6.00 Application from a client machine, from SQL Server I generated Client Components and already are installed in client machine, but when a run the application 462, The remote server machi...more >>

Hello I have MS SQL 7.00.1094 on NT 4.0 When I connect a Network Drive (net use.../User:local User on Remote System) with SQL Server Agent I cannot access this. If I take the same command on the desktop (Command Shell) the access is o.K. The SQL Server Agent is started with the same Acco...more >>

I have a sql server, and when connecting to it via the local ip of 127.0.0.1, I am able to connect. I want to see what is happening when I try to connect with the external ip address which is failing. I want to be able to see if the IP ports are a problem, or other some other reason Is ther...more >>

I'm very new at trying to create an ASP.NET Web Application in Visual Studio. I was doing a tutorial and followed all the steps but when I try to start it, it keeps getting an error saying "Login failed for user 'PSW\ASPNET" . I set up my SQL 2000 by just using the windows authenticate options. Wh...more >>