I am programming a VB-SQL Server 2K application which connects the clients to the database through the internet. While I am testing the application within a LAN in which the database server as well as the client connect to the internet through a router I can't ensure that the client connects to t...more >>

Hi All: Our Software vendoe needs to log on to SQL Server (we have SBS 2003)through ISA server. I have followed microsoft direction and have opened port 1443. He still cannot on. He can log on through terminal services but had no access to sql server. Please advice. Thank you. I...more >>

Hello! Please, help me to link MS SQL Server 2000 Ent. edition sp3a to Oracle 9.2.0. Thank you in advance. Igor ...more >>

I've got this error message when trying to create a subscriber from a publisher through VPN in a non-trusted domain, I am using SQL server authentication: The schema script '\\MERCURY\G$\Program Files\Microsoft SQL Server\MSSQL$MERCURY\ReplData\unc\MERCURY$MERCURY_Northwind_NorthwindMercur...more >>

I need to get hold of a website to download Internet Information Services (IIS) 5.0 Manager. Can anyone help? v6 cannot do what I need it for. ...more >>

We have had two instances of installing Windows 2000 Service Pack 4 [*] on machines running SQL Server 2000 SP3a+HF and subsequently seeing errors from SQL Server client tools (QA and Enterprise Manager) Cannot generate SSPI contex SETSPN -L shows a valid service principle name, and the othe...more >>

I've been working with Microsoft support for over 3 weeks now on an intermittent General Network Error we're seeing in our production environment between our ASP.NET application and SQL Server 2000. They are continuing to work on the issue, but it seems as if our progress is grinding to a halt....more >>

Hi I have a customer whom is experiancing a connectivity problem with our software running on SQL server 2000 SP3 Windows 2000 Server SP4 and workstation Windows 2000 SP4. It also has the same problem from the Terminal Services server Windows 2000 SP4 The error is 80004005 and reads as...more >>

I am trying to connect two SQL servers in different non-trusted domains. SQLServer11 in Domain A and SQLServer22 in domain B. This is through a VPN connection. Domain A has the VPN server. On SQLServer22 I could ping SQLServer11.mydomain.local at IP address 192.168.100.50. On SQLServer22 I use...more >>

Hi, I have Windows 2003 SBS Premium installed on my server and working fine with SQL 2000 and Exchange 2003. I need to setup SQL to send out emails. When I try to setup SQL mail, it asks me setup a mapi profile. To do that I would need to run Outlook. So I install Office 2003 on the server but...more >>

SQL 7, SP4 windows NT 4, SP6 SQL Server Agent jobs are failing, history reports "ConnectionRead (SQLState 01000) Message 0 Communication Link Failure (SQL Sate 08S01) (Error 10004) Jobs have been working fine until yesterday. DBCC checkdb master, msdb, no errors reported. I can bac...more >>

I installed MSDE 2000 on my machine running XP home edition. I can connect with all client utilities, include, query analiser, enterprise manager, odbc, etc if i use the builtin/administrator id, but i cant connect in the SQL MODE. If i set up an odbc connection for test, i get the f...more >>

I have installed Microsoft SQL server 2000 on a server. My web server is having windows NT having all asp pages. I want to connect to SQL Server 2000 using a DSN less connection for my asp pages. Could anyone help me with that? Also, if I try to create system DSN on windows NT, it give...more >>

I am getting the following message when trying to use a linked server with Microsoft Jet 4.0 OLE DB PROVIDE Error 7399: OLE DB provider 'SQLOLEDB' reported an error OLE DB error trace [OLE/DB Provider 'SQLOLEDB' IDBInitialize::Initializ returned 0x80004005: ] Any help i can get would be grea...more >>

I remember once that the amount of memory being used by each SPID or connections to the database server is around 40 KB is this correct and is there an article somewhere that will confirm this. I currently have a SQL2000 Advanced Server with 8 GB Memory and 8 700MHZ processors. We curre...more >>

I hope this is the correct group for this question.I am a newbie to using SQL Server and need some help. I have a Access database that I am testing with SQL Sever 7. When I imported my tables into the SQL Server I just imported them into the Master Database that is already there. The per...more >>

Hi, We have a requirement to test connectivity of clients to the SQL 2000 database. I am very new to this :-( ... well, what I need to accomplish is when the database is running all the clients should be able to connect to it also when the SQL system goes down for some maintenance the cl...more >>

Hi, I'm trying to setup replication between 2 SQL server on 2 different sites. SQL server A is a W2k SP4 server with SQL7.0 with SQL2000 client tools SQL server B is a W2k SP4 server with SQL2000 Servers are in mixed mode. Servers both have MDAC version 2.6 sp2 Username used to login to ...more >>

Hi, I'm using Power Builder and I'm receiving the followin DbCode 10003 - Login Incorrect, any help? thx. in advance...more >>

In the office network domain I've already setup replication between two SQL Servers( SQL11Server & SQL22Server). Now I am extending replication with SQL servers in other non-trusted domains/workgroups (SQL33Server & SQL44Server). SQL33Server & SQL44Server are in non-trusted domains connecting to ...more >>

I have just setup a new SQL environment. The Server is a Win2K SP4 with SQL Server 2000 and SP3a. Our site does not have an MS domain, AD or WINS server. We do have DHCP and DNS running for IP managment and name resolution. I have setup a DNS name for the SQL server. I can resolve the name f...more >>

In trying to get replication working through a firewall, we followed the instructions found in at: http://support.microsoft.com/default.aspx?scid=kb;en-us;Q16466 However, this doesn't seem to work. Of course, this article applies to SQL 6.5, so not sure if there are updated instructions for SQL 2...more >>

Hi, Im trying to connect to my database through a .cmd file. I get this error: - Unable to connect: SQL Server is unavailable or does not exist. Unable to connect: SQL Server does not exist or network access denied. Please help. Any settings that need to be checked. I have given SQL ser...more >>

I have installed MSDE 2000 SP3a on Windows 2003 Server Web edition. I am trying to connect to this DB using enterprise manager from another machine (Windows 2000 Server where SQL Server is installed) with no luck. I am getting: SQL Server does not exist or access is denied. ConnectionOpen (Conne...more >>

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