I am using odbc to connect to SQL Server 2000, wondering if there is any SQL statement which can check the live status of the SQL Server Thx Grace...more >>

I have MSDE server installed on a pc at work. This PC runs Windows XP and runs as a VPN server as well. I have SQL Server Enterpise Manager on my laptop, and need to be able to manage the MSDE server when connected to work from home, using a VPN. When I try to add the server in Enterprise Ma...more >>

Hi, I've SQL 2000 Server installed in a Windows 2000 Server. On the Server When I try to connect to the instance it gives me the error "invalid identifier". I've tried to reconfigure the connection but it never works. On the WorkStations where I've installed the client tools i can con...more >>

hi, I'm connecting to my server in another machine through analysis services. i'm using SQL server enterprise edition with analysis services and sp3 and sp3a. while connecting to the datasource in food mart in the server machine , i'm getting an error that connection to the datasource i...more >>

I need to know where an alias is stored. I am new to SQL and need to be sure I am able to recover from a server failure with all components and jobs intact. Thanks, John...more >>

In order to protect from 'slammer' kind of virus, we are planning to block UDP Port 1434 on all gateways. Named instances seem to rely on UDP Port 1434. Since TCP port the sql instance is listening on can be re-assigned, Can we reassign the UDP port 1434 as well? Any input will be apprecia...more >>

Hi, I'm using MS SQL Server 2000 from long time and its amazing i got stuck this time. Here is a scenario: 1. I have a client and i used to connect from VPN to login their network and i can do then whatever i want except i can connect to their MS SQL Server from my Enterprise Manager as wel...more >>

Hello, Can anyone tell me where I can find info on how to do this? Thanks. ...more >>

Hi all, I have the Windows 2003 Server in my company and the MSDE SP3 install with an instance for a program. But the program can't access the database, I have tried to create a new data source to SQL Server in ODBC and it tells me SQL Server Error: 11004 (Connection failed) and SQL Server...more >>

First, may I say that I truly appreciate the time people spend on these forums to help others out; it's a wonderful community. Second, I'm afraid that my problem has been answered many times in the plethora of material I've researched and referenced trying to solve my particular problem. How...more >>

When I connect to my MSSQL 2000 host with Enterprise Manager using my own private username/password, I still get a listing of all the other databases (owned by all the other users). It is not bad incredibly bad for security as you can only view that the databases exists, but the problem i...more >>

Hello, I'm working on one database in Oracle and I have to get data from MS SQL Server which is located on other server in other domain. Does any one knows how to connect MS SQL 2000 using Windows Authentication bur from other domain. Which solution I should use to solveing this problem with...more >>

Hi, I have SQL Server 2000 default instance and have recently created a named instance of the developer version. Afterwards, I could still access the default instance but now I am having connection problems. Please advise thanks...more >>

Please bear with me as you read this description. I am trying to finish up and productize some code that I inherited from a contract programmer that allegedly knew what he was doing. I know that I don't know what I am doing. I have an application that is written in C# for .net. It has a clien...more >>

I have a several tables in a SQLServer database, all of which have primary keys defined. When manually linking to three of those tables with MS Access, I get prompted to provide a Unique Record Identifier as if there was no primary key defined. Arrrrgggg! I am trying to automate a process to rebuild...more >>

Hi. I have a dbf file that has about 1.2 million lines of data. That file is produced by another system's proecesses. I'm wondering if there's a way for me to link my SQL Server database to that file? Any suggestions would be great. Thanks! dbf file is: M:\Data\Shipped.dbf ...more >>

I run a website on a dual proc. W2003 box with a clean setup running iis 6.0. The site does a ton of data access using PROVIDER=SQLOLEDB against a SQL 2000 server with all the latest stuff. When I put load on it it starts to process requests and perfmon counters look as expected but efter a mi...more >>

Anyone heard of this error when attempting to Register a SQL Server from Enterprise Manager Standard 2000 client. Invalid attribute/Option Identifier. If so, how have you resolved it?...more >>

Hi all, I have installed SQL Server 2000 personal edition on Windows XP. When I run 'Return all rows' from Enterprise Manager/Databases/<Any database table>, a small SQL Server Login window comes forward. I have checked ODBC settings all is OK. What change I need to do so that this small windo...more >>

Understand I am not a DBA. I am just the guy who has to work with this stuff. We have client software that uses SQL 7 as a database. Winpak is a door access software made by Northern. It stores proxy card info, access levels, historys, etc. in a SQL 7 database. I know the databases...more >>

We have a sql server loaded on a workstation. Our Asp.Net application can pull data from that workstation, however when it tries to connect to the Production database in the same domain it gets the following error.. Source Error: An unhandled exception was generated during the execution of the ...more >>

The object name 'dbServer.pubs.dbo.authors' contains more than the maximum number of prefixes. The maximum is 2. when i tried selecting data from a linked server i get this. Thanks!...more >>

The current setup: -2 different non-trusted domains(NARC and HOT). -The connection is VPN and NARC domain has the VPN server. -2 SQL server are installed upon 2 Application Server in each domains(SQL11Server & SQL22Server). -In each domain SQL server/agent starts up with a common local pass-thr...more >>

Hi In our offsite, the users always experiences the timeout problem. Can I set it longer?...more >>

Hi I am trying to get a message (#18453 - Login succeeded for use '%ls%'. Connection: Trusted) to the windows event log. It's severity is 14 and it is already checked off as a logged event, but it is not being logged. Is this a bug or is there something else I need to configure Regard ...more >>

My application is installed on one win2003 server machine and i am trying to connect sql server 2000 which installed on another win2003 server machine, and i am getting error 'SQL Server does not exist or access denied.' if i connect to sql2000 server which installed on win2000 server mac...more >>

I have an application database on SQL Server 2K and we've got an NT domain. I want the users to type in their login and password, but I'd like to validate that password against the windows NT Domain. Can this be done? Jared Hoffman ...more >>

Salut, Toujours le même problème non résolu et de + en + frustrant... Je vais finir par revenir à bon bon vieux 2000 Server... Je n'arrive pas à inscrire un serveur SQL Serveur 2000 situé sur Internet dans mon entreprise manager de dev, égalemement situé sur un 2003 server. Personne ne po...more >>

We have SQL 2000 SP3a installed on a Windows 2003 server We are trying to add an Oracle 8.1.7 linked server On W2003, the error message below appears when trying to view tables with the exact same connection parameters work on several servers that are running SQL 2000 on Windows 2000. Paramete...more >>

I have an xp professional with a user "mysuser" defined in a workgroup(administaror) I have w2000 with user "myuser" (the same) defined If i try to connect with the window autentication the system answer that user "guest" is not allowed to connect. Is there any way in a workgroup in xp prof ...more >>

We have a chain store which using text file to ftp and update the sql server. But above error will happen average 2 to 3 hours, and it will cause the server not running. What we will do is first check the ftp connection and ensure no connectivity and restart the server. // if we check the se...more >>

I'm running sql server on a NT 4.0 box. every once in a while the service stops. I can restart it no problem, but eventually it will stop. It starts automatically in services. I don't know why it stops. Is there any way to either find out or just configure it to no longer stop? Or do...more >>

I have scouted the net a bit and I see nothing that says that MS SQL (any version) either works or does not work in an IPV6 only environment. I presume not, but does anyone know for sure? ...more >>

After I successful ran the snapshot agent and create the snapshot for a Published Northwind database, the merge agent still not run with the error shown below. How do I fix this problem and get the merge agent to start merge replication with subscriber? Please list the steps to take. ERROR MES...more >>

hello, is there anybody here who can tell me how to create linked server in microsoft sql server 2000 to microsoft access database (microsoft.jet.oledb.4.0); but access database have own workgroup file; i don't know where to place a path to this mdw file while creating linked server; and may...more >>

Hi everyone. I have a problem with connectivity in one IIS Server and one instance of SQL Server in Cluster mode, a tray to connecto to request data trhougth DNS with ASP, and i get this error: [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'NT AUTHORITY\ANONYMOUS L...more >>

hi i am trying to use "Generate SQL Script" to script out ONLY the indexes and keys defaults and contraints, i do NOT want to generate anything else as these already exist in the destination database that im going to run the script on. what options will i need to tick on the "general" tab in orde...more >>

Does anyone know who to translate the column net_address from master..sysprocess into it's corresponding ip address? Thanks, David....more >>

I am attempting to trouble shoot a SQL server connection problem for one of our DB admins. The server is located at a remote site and all firewall rule sets have had all restrictions removed. We are able to connect when sitting local to the server but remotely we see this error... Err...more >>

I am testing an ADO OLEDB SQL Server 2K connection just by setting up an UDL first and have the following questions : 1. To which physical directory should the virtual directory within IIS refer ? 2. Should this physical directory contain any necessary files ? 3. How should the servername bee...more >>

I need to show a list of detected SQL Server 2000 instances installed on a LAN. I would like to know if anyone knows how to list the servers, similar to what Enterprise Manager does with its Server Registration Wizard Thanks...more >>

I am trying to have a ADO OLEDB connection by the UDL tool. However, it still reports that there is no SQL server or no permission to access the server. How can I test whether there was no contact at all or was it a permission issue ? I also use a forward URL which is routed by the DNS to the ...more >>

Where is the Wizard for IIS Virtual directory configuration located ? The books online mentions this wizard, but I couldn't find it anywhere. ...more >>

I want to establish a ADO OLEDB connection to a SQL Server 2K at a webserver with a reference to the server name instead of IP-adress. Just like : db.Properties("Data Source").Value = "http://testserver.com" Do I need to specify the standard port '1433' ( as is the case with IP adressing) ...more >>

Hello all, I am cross-posting this message bacause I'm not sure which group is more appropriate for my question. Here is my question. We have several desktop applications written in dotnet. Beacuse many of our user are remote and connect using a VPN, we have to use sql server authentica...more >>

Hi, We are using Windows 2003, SQL server 200 with Service Pack 3 and IIS 6. We use just the TCP/IP Network Library in SQL. We have ASP webpages that gather info from a database in SQL. Every some time we start getting the error: Microsoft OLE DB Provider for SQL Server error '80040e31' ...more >>

Hi i use sql2000 in win 2000 server with Mdac 2.8 i'm connecting with provider : sqloledb from Asp pages, thru ADO calling stored procedures the question is that time to time there is an error 800a01fb in : 1) set cmd.activeConnection= cnx either in 2) cmd.execute then, doing a SP_WHO ...more >>

My SQL server was just upgraded from 7.0 to 2000. It was having memory leak problems before, so it was upgrade to 2000 by the agency that over sees our databases. Now the access time to the database is pretty slow when trying to pull up information. Our custom client software loads fine and conn...more >>

Below is an email I wrote to a friend earlier, and it explains the problem I am having. The issue is that while I am now able to register the server, I can only do it after running "net use \\yourservername\ipc$" from the command prompt. And even after a user name and password works successfully i...more >>

Hi all Please find included an example of 4 packets that was captured during a SQL client connection attempt as reference. I need an explanation of the various bytes located in the packets. I know that some of them are pointers to the starting byte of various data fields located within the p...more >>