Ok, here's the scenario. On a Windows 2003 Server I have MSSQL 2000 installed. On another test server I have Windows 2003 server, IIS 6 and Coldfusion installed. There has been an account created in SQL and assigned permissions. My coldfusion web site makes multiple calls to the database ser...more >>

I have a process that is trying to connect to the sql instance which resides at "local" or "localhost". Unfortunately for me, I need it to go to my SQL 2000 instance, not the "local" name which points to my SQL 7 server. Is there any way to "trick" the name "local" or "localhost" so it w...more >>

I manage several member servers (MS SQL Server 2000 SP3 / Windows 2000 SP4) in a large Windows 2000 domain. Yesterday, a domain admin renamed one of the servers to conform with our server naming policy. SQL Server is set up for both Windows Authentication and SQL logins. However, now remot...more >>

How can I connect to a SQL server that is on a different domain?. We have 1 NT and 1 Windows 2000 Domain Contollers both with SQL on. We used to dial in and connect, for replication purposes, which was fine but we now need to connect across a lan without re-configuring the domain serve...more >>

Hello, I have a server in house, I created my own database on the server, then added my computer name as an admin user with windows autenthication. Then on my workstation, I installed SQL Server, added the server name in client network utility, and after tried to register the serve...more >>

Hello, I am currently trying to connect from SQL Server standard 2000 to MSDE 7 using linked servers, but whenever I try to remotely execute a query, I get the error "SQL Server does not exist or access denied." I am using standard SQL logins on both machines, and I have checked and do...more >>

I changed the archive of a program in VB6 that used Access 97 Database via DAO USING JET 3.5 passing it to SQL server (sqloledb1 driver) and using ado 2.7 and with surprise (The file structure and data is not grown) I find now the program slower than before using access file?? It is possi...more >>

Hello: I need to be able to determine the name of the client machine running the session. The value in sysprocesses.hostname is client-supplied, so it may be not the real name of the client machine. The client can explicitly specify any host name in the ADO connection string. Is there a way to...more >>

Hi all, I am new to SQL, using an accounting package that runs mssql engine. I need to stop and start the engine thru my backup software. I am using Backup Exec 8.6 which allows me to type in a command before backup and then once after backup is run. My question is what is the dos comm...more >>

Hi, We have SQL 7 and 2000 servers and I create link server on each machine respectively. I use openquery to get data from each machine by creating a view. Somehow, I will get timeout frequently by query the view at SQL 7 (which use openquery to get data from SQL 2000). But, I don't ...more >>

Hello all, Can Yukon workbench be connected to any other version of SQL Server? Thanks Steve...more >>

Hi all SQL Gurus ! I'm trying to connect an Access 97 database using a Linked Server (on MS-SQL 2000). The Access database is stored on a file server. Here is the SQL Statement I used to create the Linked Server : sp_AddLinkedServer 'TEST', 'Access 97', 'Microsoft.Jet.OLEDB.4.0', '\\Serve...more >>

On my local machine running Win XP Pro, a sql server login fails: ][SQL Server]Login failed for user 'userid'. Reason: Not associated with a trusted SQL Server connection. The connection to sql server is specified in a web file called dataconnection.asp: Set objConn = Server.CreateObject("A...more >>

Hi, I keep getting a "Must use dbSeeChanges option with Open Connection Error", while connecting to a table that has an Identity field. I have also trying this line of code instead of the origionl (Listed below), but get the same error. Set TotalViewMURST = TotalViewMUDB.OpenRecordset...more >>

I'm receiving this error intermittently while performing an OPENQUERY on a link server to Viz FoxPro data. Does anyone know how to resolve this? tks, PH...more >>

(With thanks to previous contributors) I am trying to assign a variable to a Select Statement in a Stored procedure e.g. CREATE PROCEDURE Count_Records AS SELECT top 10 * FROM CustomerBufferData GO Where the 10 would be replaced by a quantity that I wish to pass from a VB app....more >>

Could someone please provide tell me how create a SQL Server 2000 linked server with Sybase adaptive server anywhere 8.0? I can create a ODBC System DSN, but I can create a linked server in Enterprise Manager. Thank you....more >>

hello my sqlserver is refusing to restart after i have displaced my data base files on another disk please help urgent...more >>

Dear all, I'm trying to configuring my MS_SQL Server 2000 to use linked server connecting my database password setup .mdb (not using workgroup admin) I always got error "'Microsoft.Jet.OLEDB.4.0' IDBInitialize::Initialize returned 0x80040e4d: Authentication failed" I have been checking o...more >>

When we connect to SQL server through a client over the network, is the login information (id /pwd) encrypted ? If so, what is the algorithm used ? Does the same apply for connection through ODBC drivers ? Please help. Regards, Shreesha....more >>

Hi All I am new to MS SQL Server.I am using MS SQL 2000.I have a problem in creating a table by using Select command.I have table called "test" and i want to create another table with the same structure and rows.I tried with the following comman create Table test1 as select * from test But it ...more >>

Is there a way to use Windows Task Scheduler to notify me via email if either the Server or Agent service stops. We have numerous support personnel that change the User password for the account that runs these services and then the services fail. If not, is there is another method not inv...more >>

We want to have a section of our web site for our clients to login to there own section and was wondering can a database be created in SQL and link to our web site so when clients log in, the SQL datbase will be updated?...more >>

I realize the problem has been around for a long time. Has any service pack or patch available that allows paged query to overcome the limit? Thanks. ...more >>

We've just installed two machines, both running Windows Server 2003. One is hosting a SQL Server, the other one is used as webserver. I try to make an ODBC-connection from a website to the SQL Server, but end up with the following error message: [Microsoft][ODBC SQL Server Driver][DBNETLIB]S...more >>

How can I assign a variable to quantity in a stored procedure ? e.g. 'select top @quantity * from tablename' doesn't work....more >>

I am running SQL Server 2000 (SP3a) on a Windows 2003 server. Within the same domain I am running a Windows 2003 server machine with IIS 6.0 on it. The web site I am working on makes numerous calls to the database server using an account set up in SQL. The problem is this; every few day...more >>

All setup and configurations are in normal status on Windows Server 2003 (Standard) with SQL Server 2000 SP2 (Standard Edition). The SQL Port is 1433 by default. But, I still cannot access SQL service by PC's Query Analyzer. I've tried to activate sqlxml and set IIS back to 5.0 isolatio...more >>

Is it possible to disable logging when performing an Update query with Query Analyzer? If not can it be done via bcp? The reason is I don't have enough disk space for a large update. -Craig ...more >>

*apologies for multipost Hey we have an SQL7 box (soon to be upgraded to SQL2k) we have in-house client software that connects to a db hosted on the box via ADO + SQLOLEDB. Our client software always specifies an "Application Name=" parameter in the OLEDB connection string. The applicatio...more >>

We've been trying to setup appropriate filters on our internal firewall to allow me to connect to our prod SQL 2000 clustered server which uses port 1433. However, when just allowing 1433, I can't connect using the native SQL tools (Ent mgr & Query Anal). The network folks "sniffed" my traffic...more >>

Is the following permitted? 1. the loading of the sql 2000 connectivity tools permitted on Win 95 2. can I connect from win 95 to a sql 2000 DB...more >>

Is it possible to assign more than one IP address to a=20 MSSQL server 2000, and if so how?=B4 Thanks Jan Mieziewski...more >>

I have set up an IPSec Filter on my local machine and some machines I'm setting up at an ISP. It sets protection on the SQL Server ports and it works fine. For a while. Then it plain refuses to connect. It's an IPSEC related issue because of I deassign the policy or change the rule t...more >>

Hi, I encounter this error 12031 ERROR_INTERNET_CONNECTION_RESET The connection with the server has been reset. Here is the details. The server which we are trying to connect has Win 2000 server OS installed. Basically we are trying to make a connection to the IIS running in that se...more >>

I have two (Server A & Server B)SQL Servers located in a different site and they are connected via DSL internet. I want to add the other server B to server A using New SQL Server Registration in server A. How should I do it? Both sides is using Firewall. Thanks a lot in advance!...more >>

My version says that (basically) i can only connect to a Access database. How frustrating is that?.. If I shell out more cash to buy Visual Studio.net Professional will it have the ability to connect to a SQL Server database?...more >>