Hi everybody, I have a problem in SQL Server 2000. I need to connect as a linked server the AS400 database (V5R3). I read in the SQL documentation about the SP_ADDLINKEDSERVER stored procedure and the linked server from SQL Manager but I'm not to be able to have success using its. The b...more >>

We are intermittently getting this error on our SQL server. The front end is access and this happens every so often causing the users to have to exit out of access and reconnect. I'm by no means a SQL expert, and our programmer who manages this database isn't sure what it is either, he says it...more >>

Hi, I'm new to SQL and would like to connect to a remote sql server where a website is hosted and do some updates. I have a local sqlserver setup here, could you pl guide me some doc or urls. I have to backup the db frm the remote sqlserver, my host company told me to use dts to carry out ...more >>

Hi Thi sis probably another dumb question, but any advice would be great. I have an SQL db under a website that I have to get to with an Access fromt end, with ODBC. When ever I get to a table it has various prefixes added, so that when I load up Stored Procs locally they fail bercause the t...more >>

I have what I see from this forum and other places is a common symptom: "SQL Server does not exist or access denied". I have tried every approach I could glean from the responses posted, but nothing's worked. I did a little network sniffing (with Ethereal), and what I see when I try to est...more >>

Hi everyone, Please excuse the cross posting but I have been searching long and hard for an answer to this and haven't been able to find one. I can't be the only person who needs to do this. I have Exchange 2000 and SQL 2000 running on the same box. I have a number of tables in...more >>

I have to pass some data from Advantage Database Server (a database wich = is used generally with Delphy) to SQL-Server. In order to create a Linked Server from SQL-Server to the above = mentioned database- what should I do? If there is an ODBC for the database- should it be installed on the = ...more >>

I have two new win2003 server running sql2000. I am using mapped logins to get from a win2000/sql2000 to win2003/sql2000 and am getting access denied. Everything is set up exactly the same on machines running this config with win2000 and am having no problems. I have also enabled DTC access in th...more >>

The incident involves two Windows Server 2003 based computers S and C. They are hosted by two different hosting companies in two different countries. They both have SQL Server 2000 SP3 installed and running. The development is done on an XP Professional SP2 based desktop. The objective is to ...more >>

I work for DataDirect-Technologies. A customer of ours uses our ODBC driver on UNIX to connect to a SQL Server 2000 Named Instance. We have noticed that in the Enterprise Manager if you right-click on the Named instance and open the Properties menu and then open Network Configuration, TCP/IP a...more >>

I have an MS Access 2003 database that uses a SQL Server 2000 database as it's back-end. The database runs well most of the time but if the users dont use the database for a period of time (approx 10 minutes) and return to it then the connection hangs. When they try to perform any action that ...more >>

Hi all, I currently have an ASP .Net project running locally, and accessing a local SQL server 2000 database. The project runs fine since it is able to open the connection to the database, and perform operations on it locally using a connection dtata string pointing to the local data source....more >>

I am running a Windows Server 2003 machine as my web server. I would like to use Windows authentication for connections to my SQL Server 2000 instance on a Windows 2000 server. I've read where mirroring the ASPNET account and password on the web server and SQL server would work. However, with...more >>

Please help. On my default instance of SQL Server 2000, which could be accessed OK with both Windows and SQL server authentication, I now get the error in the subject line above. The message in the error window - in SQL server enterprise manager- suggest to verify the SQL server registration, b...more >>

Using PortQryV2 I got the result that on a remote server port 1434 is FILTERED. How can I change its state to LISTENING? Thanks, Dan ...more >>

Data source name not found and no default driver specified This is the error I get when attempting to install my copy of SQL Server 2000 developer edition. I had SQL Server installed on my workstation, functioning correctly. My computer crashed and it appears that there is some sort of reg...more >>

On system 1 when i try to connect to a remote server, i get the message " SQL Server does not exist or access denied " while on system 2 , i am able to work fine, without any issues. i tried replicating the problem scenario both with a global IP and a local LAN IP, and it works fine. what...more >>

I'm confused. When I create an ODBC connection to a remote SQL server 2000 that uses a nonstandard TCP port, I have to give the port number to ODBC. Which makes sense. I just set up an Enterprise Manager "SQL Server Registration" for the same remote server, and I gave it the IP address of...more >>

On a newly installed workgroup computer, the client, I've been able to establish connections to the SQL Server on a different computer using SQL authentication via ODBC and Query Analyzer. Now I am trying to figure out how to connect with WIndows authentication. On the client computer (PCM...more >>

I have been using Windows XP SP 2 and SQL Server 2000 Developer's edition on one computer and it has worked fine. For testing, I've installed Query Analyzer on a 2nd, workgroup computer. I know the network itself is working. Files and printers are shared and working. The problem is that ...more >>

We are having one client PC running Win XP. SQL Server has been set to Windows Authentication, TCP/IP 1433, Windows 2003 (!). Via Cisco VPN we are making a connection. IAS has been configurated, so the local user profile doesn't matter. The server recognizes the user that is part of the dom...more >>

I have a ASP.NET time sheet management application I designed - today I put it live on the webserver and recreated the database on my SQL 2000 server. When I attempt to view, all of the pages where I query the database I catch the error "SQL Server does not exist or access denied". The conc...more >>

Hi, I'm trying to connect to my SQL Server 2000 over a VPN IPsec. The VPN connects succesfully, I can browse with the Windows Explorer the shared folders of my SQL Server. When I ping the server the servername is resolved, and when I use ping -a also resolve the dns. My pro...more >>

Hi , How does sql server client connect to SQL Server. Is there a sql.ini for sql server. If i add a alias entry in Client network utility where does it store the info. Thanks Neeraj...more >>

Hi, Can anyone help - I've got an Access 2002 Database which links to our = SQL Server 2000 Database via an ODBC connection. The connection is set = to use SQL Server authentication which works fine for myself but not for = a domain user who needs this. When I launch the Database and run t...more >>

Hello, I have some services that are dependent on MSSQLServer serivce but when the computer is restarted, my services don't start and I get an error message "Cannot open database requrent in login 'database name'. Login fails'. It seems like to me that these services come up before SQL Se...more >>

I can not connect to the production SQL SERVER 2000 using the Enterprise Manager or the Query Analyzer on my work station. I am getting the error, "A connection could not be established to "". Reason: SQL Sserver does not exist or access denied. ConnectionOpen(Connect(()).. This proble...more >>

I can not connect to the production SQL SERVER 2000 using the Enterprise Manager or the Query Analyzer on my work station. I am getting the error, "A connection could not be established to "". Reason: SQL Sserver does not exist or access denied. ConnectionOpen(Connect(()).. This proble...more >>

Hello, I developed a win32 .exe CGI that connects to a clustered SQLServer to report some data. The software is written with Borland C++Builder. This is the oledb string: Name=Provider=SQLOLEDB;Password=xxx;Persist Security Info=True;User ID=xxxx;Data Source=xxxxx;Initial Catalog=xxxxx;Network...more >>

I'm a newbie at SQL Server connections. I've contracted for a SQL 2000 database with my hosting ISP but have Client Network Utility and Enterprise Manager from SQL Server 7 which was loaded during my install of Visual Studio .NET 2003. I've read that I must "add an alias that points to \\comp...more >>

Needs some help, I recently recieved an evaluation copy of SQL Server2000 and I have installed it on a WindowsXPsp2 machine. I have updated to SQL Server to service pack3 and installed .net as well. I am still having connection problems. I am trying to setup an ODBC connection from another X...more >>

H friends I have a strange problem. i am trying to connect to my sqlserver from client machine to server machine But i am not able to connect to the server from the client machine. The strange thing is that i am able to connect through Named Pipes but not with TCP/IP and i get error SQL Serv...more >>

Hello I hope anyone can help me here with a Problem between my Microsoft SQL Server 2000 SP 3 and an Oracle 8 Server. I have to copy records from a Oracle table (3.000.000 records by now) to a SQL Server table (8.000.000 records by now) daily (somthing like an incremental backup). The Oracl...more >>

I have a remote server that I'm able to successfully register on a local sql 2000 server through EntMgr, and make successful selects on both remote and local server databases via odbc. Here's the question - Can I have a local server with some database/tables, a remote server with some dat...more >>

Hi all, I am looking for a definitive guide to set up a linked server in SQL Server 2000. I want to add a linked server to an Access (95) database I have managed this on our production server (although I keep getting errors occasionally & have to restart the server service), but on a vani...more >>

In installed SQL Server under my Win2003 Server userID, specifying NT authentication. Then I down loaded MS JDBC, which requires Mixed mode authentication, so I modifyed SQL Server to that. Now in Query analyzer, I can log in to the db using windows authentication, but my user ID and password ...more >>

I'm getting this error in the SQL Server logs. Can anyone give me any ideas how I can begin troubleshooting this one? WARNING: Failed to commit contiguous memory of Size 65536. Users are getting "insufficinent to memory to execute query" messages and I'm seeing "maximum number of users ...more >>

Users in remote building (On the same VLAN? Not sure of network specifics) can connect to the sql server in the remote building with no issues. In my building (HQ), we were able to connect to it until this morning. Last night the domain controller in the remote building was upgraded to Windows 20...more >>

I'm running SQL Server 2000 under Windows 2000 Advanced Server. Authentication is set up as Windows Only. The Administrator account for the server is set up as an SQL user (this is done by default). I'm using the following ASP code to log onto a sample database (for which the Administrator has...more >>

I am running SQL 2000 on Windows 2003 Server. Right now it is on a stand alone laptop and I keep getting "Connection failed" when I try to telnet to it. Here is all that I know. SQL Server is set to listen on 1433 clidnfg shows it set to 1433 server config shows it set to 1433 netst...more >>

When trying to connect to 2 of my SQL Servers I am getting General Network Error. I have run Portqry against both of my servers and they both return that ms-sql-s Sevice is listening on port 1433. When I try running ODBCPing I get the following results: COULD NOT CONNECT TO SQL SERVER ...more >>

Im getting this error when starting the Mssql server 2000 SuperSocket Info: Bind failed on TCP port 1433. please advise also note thta it is only MSDE not the whole SQL Sever -- Posted using the http://www.dbforumz.com interface, at author's request Articles individually checked for conf...more >>

Hello All, I apology for posting to many groups but I wasn't sure which group would be best targeted with my question. I have inherited an ASP.Net application that requires some maintenance & bug fixes. I have been asked to also download a copy of the remote SQL Server database that it ...more >>

Hi, I have to gain exclusive access to a MS SQL Server 2000 Database from a VB application through ADO for a very short period of time in order to do special processing (data historization and computation) and preventing that others users can connect at the same time. Which is the best meth...more >>

I have an installation of SQL 2000 on a Windows 2003 Server, and another server with Oracle 9i. I've not been able to successfully make an OLEDB connection to the Oracle database from SQl 2000, either with a DTS package, or using <OPENROWSET('MSDAORA', etc.> in a stored procedure. I have dozens...more >>

Hi, Using VB .NET is there a way to return/track the reason why a connection has failed to open. I want to be able to track the following reasons for failure: 1. User doesn't have the correct permissions set to open the database 2. Unable to open the connection because the user setting are...more >>

The following is being attempted from the SQL Server itself via Remote Desktop. If I try to set up a linked server via ODBC to data that is on another server, I get an error stating that the server is unable to open the DBC file. However, if I try to simply execute a DSN-less query against th...more >>

Every time I start up Enterprise Manager which has several SQL 2k registrations, I get a series of entries like this in my Event | Security log: Any ideas? Event Type: Failure Audit Event Source: Security Event Category: Detailed Tracking Event ID: 599 Date: 2/3/2005 Time: 9:22:43 AM ...more >>

OpenDataSource gives "Unspecified Error" when connecting to local Excel spreadsheet file with account not in local administrators group, on Microsoft Windows 2003 / Microsoft SQL Server 2000 sp3a. I am having a permissions problem using the OpenDataSource command to open an Excel spreadsheet l...more >>

hi guys, how can you determine/find out the port number of your sql server instance on a sql 2000 server? I can figure out how to set the port number in 'client network utility', but can't figure out how to view it. many thanks. JJ...more >>