We are upgraded our vendor software (Jenzabar EX) from SQL7 to SQL2000. In the process, we are also moving the databases to a new server. Everything seemed to go fine until we tried to log on to one of Jenzabar EX modules. We have tried several different things, including the sp_change_users (whi...more >>

Hello, We're getting a random error throughout our sites which use our SQL Server... Microsoft OLE DB Provider for SQL Server error '80004005' [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. .... the error pops up on any page in any spot on the p...more >>

I am try to connect to our server using odbc its test okay but when i open the program i get sql server login connection failed. thanks...more >>

SQL2000, sp3, Give windows authintication permission to NT group "Test" with 50 users but not work, but it works when give 50 users windows authintication permission individually. Anybody can help me? Any setting problem for NT group or SQL server? Thanks...more >>

All We are trying to connect one of our custom's SQL Server Database outside our firewall. Our Custom opened the Port #1433 for us. We also open the port on our side. However, we stil can not connect. We got "SQL Server Does Not Exist or Access Denied" errors. Can anyone help us? We even could n...more >>

Problem with Website and SQL synchronization We have one web server, which is running on Win2K server, MS-SQL and Sharepoint. Last week it went down and i found this error message "The list or view of a list that is referenced here no longer exists". Kindly help us. "The list or vie...more >>

Does anyone know how to connect SQL Server 7.0 (my home computer) to SQL Server 2000 (hosting server) remotely so that I can view the database in SQL Server 2000? Thanks. Tze ...more >>

I'm getting the following error on Windows XP clients only: [DBNETLIB][ConnectionWrite(WrapperWrite()).]General network error. Check your network documentation. This error seems to occur at random times of inactivity on my application. Here is how I am configured: Windows 2000 Server - ...more >>

How does a machine know what SQL servers are available. For instance: when I create a data link using OLE DB there is a ComboBox that lists all of the available SQL Servers to connect to. How does this list get generated and refreshed? I ask this because I see a particular server in the li...more >>

I have been trying to register a SQL server in my server group in Enterprise Manager but it cannot find the server. The SQL server (SQLServer2k) resides on a server machine running WinServer2K. I am trying to gain access from a remote PC running Win2k. I am able to see the server in the...more >>

I'm running SQL Server 2000 SP3 on my XP Pro laptop and everything works fine without firewall client enabled. When I VPN in to the network and enable the ISA server firewall client, I can't connect to my local instance using Enterprise Manager or Query Analyzer, although I can connect to anothe...more >>

Hi i use a program that use SQL 2000 server, by any days for three pc i receive the follow message when i try to open my programm or i try to create new odbc: connection failed sqlstate "HYT00" sql server error: 0 Timeout expired i have many pc on my network and don't undestand why only th...more >>

I have the following SP. the problem is when the execute is performed it gets another DB with a similar name. physicianlaboratories_Interface. I am leaning towards the name is to long. if so what is max length for a unique name. Alter Procedure ADP_CompleteXMLOrderImport @Storename varc...more >>

Operating System: Win2000 pro Product: Sql Server 2000 Sp3 Host Name: DATAPROD I am having problems with my DTS Packages failing. I tracked the problem down to the Client Network Utility. Inside the network utility, all protocals are disabled except for tcp/ip. When I click on the alias...more >>

Hello: I'm trying to remotely access one of my SQL server, unfortunately, I've forgotten the 'sa' password. I do, however, have the Windows administrator password on me and was wondering if I could use the server administrator ID (or another Windows ID belonging to the administrators gr...more >>

Dear all, I build a table in MSSQL 2000 with several fields with nvarchar(500). If I used the Return All Rows functions of the Open table, all fields in the table were displayed properly. However, when I used the Query Analyzer with a simple SQL select statement on the same table, the q...more >>

I am fairly new to both the technologies. Scenario: I have an Exchange server on one machine, with Outlook. I am looking for a way to get the information from Exchange servers (mainly public folders) to SQL-server that is located on a different machine. My problem is as follows: a. I...more >>

I'm running MSDE on a WIN2K and I'm having a problem accessing the MSDE from a laptop with WINXP Professional. I'm using a NETGEAR MR314 cable router w/ firewall to connect the two computers and I'm getting the following error: Unable to connec to server SERVERNAME Server: Msg 17, Level 16,...more >>

I have a new web server I am trying to get some code working on. I can connect from it to the database via client tools without issue. I have System DSN's set up that test fine. These dsn are accessed via my dlls. When code is run, the first time the DLL accesses the database I get the access de...more >>

Hello, When I use the command netstat I can see the current connections. This is what I see: 1. myservername : microsoft-ds OMNIBACK:3296 ESTABLISHED 2. myservername : ms-sql-s ox.ntntc.edu.tw:37720 TIME_WAIT 3. myservername : ms-sql-s ERPSERVER:15372 TIME_WAIT What does this mean? Can ...more >>

I am using SQL Server 2000 Enterprise Manager to try to connect to a remote SQL Server 7.0 database which resides at my web hosting company. I had no trouble establishing the connection to the server, but when I click on Databases under the server name the program hangs and can only be stopped ...more >>