Hi Can SQL 2000 tools be installed onto a Windows 95 machine? When I try to run the install, the only option available is the client connectivity. Thanks Jono...more >>

We're running SQL EE SP3 on W2K3 and receive the following error when trying to execute a particular job. The proc in the job only contains several queries unioned together, any ideas on what could be causing this ? Executed as user: MYSERVER\ServiceAccount. [SQLSTATE 01000] (Message 0) Connec...more >>

Hi, No we are using connection strings like MACHINE_NAME\INSTANCE_NAME. This is not very flexible when we need to move the databases from one machine/instance to another machine/instance. What I would like is as follow: Create a DNS entry for example: PRODAPP1 - name voor Production e...more >>

I am installing a new Windows SBS 2000 Server running SQL version 7.0 with SP4. The customer runs a database written by a programmer which only runs on SQL 7.0. What is the best way to transfer this database from the old server to the new one and relink it to a fresh SQL install? Any help...more >>

Hi I connect to a SQL Server 2000 db over the internet using Enterprise manager. It is unfortunately extremely slow. It takes up to 20 minutes to retrieve the databases and then each click is a 5-10 minute wait... I connect using a username. What could be the problem? Is is also possible ...more >>

Hi there, I'm trying to connect to my AS400 server thru a LINKED SERVER, but = I'm having some troubles. If someone have this solution Running or has passed thru it before, = your help will be appreciated. Thank you very much. Below is the full script I'm Using to create ...more >>

I am running SQL Server 2000 on Windows 2000 Pro. I have an ASP page that is able to do a select and do an insert to tables on the SQL Server but it is not able to do a delete. I am logging in as "sa". I was able to use SQL Query Analizer to do the delete. What am I doing wrong?...more >>

I have VB application that needs to connect to SQL Server database, and need to send to the customer with the whole package. I know I need to change the connection string in VB application. But how can I send the SQL database? Export to a format to DTS? and ask the customer to import using DTS...more >>

I have a SQL Server 2000 server with multiple instances installed. The server has a DNS name (SQLP) that is not the same as the server name. I am in the process of moving our databases from an old SQL Server 7.0 server to the new SQL2K box and I am having some connectivity problems with the ap...more >>

i want to write a C program that accepts records and inserts records into a SQL server database. Kindly help me how I can connect to it. ********************************************************************** Sent via Fuzzy Software @ http://www.fuzzysoftware.com/ Comprehensive, categorised, sea...more >>

My agent have stop and not restart i have these errors [298] SQLServer Error: 18456, Login failed for user 'sa'. [SQLSTATE 28000] [000] Unable to connect to server '(local)'; SQLServerAgent cannot start i have change the "service startup account" from local system, to another users the he ...more >>

Hi ! We have 2 SQL server. Server A work very well without any connection problem. With server B, some client (3-4) can't connect with ODBC connection (including me)... And I found that I can't no longer connect to server B (from my PC) with Enterprise Manager (EM work well a few days-weeks ag...more >>

Hello, I hope someone out there can help me understand. I have an IIS Server and using FP2K, I'm trying to connect to a SQL2K Server, but I keep getting errors in attempting to connect. I have searched the newsgroups and had no luck in finding a solution. The error code that I get, refers to...more >>

Hello, I changed the LoginMode=2, in the Registry, create a user in MSDE fo Windows authentification with : sp_addlogin, sp_adduser, sp_grantdbaccess How can I create user with Windows authentification ? thank you ...more >>

My company's network is like this: T1 - router - hub - firewall - switch The web server with SQL Server is connected to the hub with static IP. And all other computers are connected to the switch with dynamic ip. The problem is: when other computers attempt to connect to the SQL Server remotel...more >>

We have a Novell 6 server & wish to install an sql engine & database. We are told it is not possible to install these on a novell server drive & they must be held locally on a client pc If this is so the database cannot be automatically backed up Is this correct?...more >>

Subject: Unable to connect to SQL2K hosted on W2K3 From: "Mark M." <mosefm@yahoo.com> Sent: 10/7/2003 11:34:15 AM Folks: Get this error: Project: Microsoft OLE DB Provider for SQL Server error '80004005' [DBNMPNTW]Specified SQL server not found. /help/PYR_DB1.asp, lin...more >>

We have about 75 users connecting to a SQL Server 7.0 database through a VB application using OLEDB. The donnection string is read from a UDL file. Intermittently, users will experience an error - 2147467259, [DBNMPNTW]ConnectionOpen (CreateFile()). All the references I can find in the K...more >>

Is there any logical way to cancel a query in SQL Server when the connection is through OLE DB which does not support async connection. Bryan ...more >>