Hi, My machine is unable to establish a connection for the purposes of making distributed transactions. The problem appears to be that my machine is blocking the machine to which I am trying to connect from establishing RPC Binding with my machine. Here's a message from my Event Viewer: M...more >>

H I have an application that uses an ADOConnection named CONNECTION1 and an ADODataset.The dataset fetches a record for editing it.This dataset has no ConnectionString and its connection is the CONNECTION1.After opening the dataset and editing record (befor posting it) I execute a Stord Procedure t...more >>

Hi All I am running a website on one server and need to be able to connect to SQL 2000 on another server. When I try to connect to the SQL server in an asp.net application I get the following error: Login failed for user 'Domain\Server$' How do I configure SQL to allow the other IIS serv...more >>

Hi, I'm new to the SQL development stuff, but I have managed to get a great book ASP.NET databases using VB.NET by Wrox Press I'm following the examples, but when trying to establish a connection to my local db I get the following error msg: Login Failed for user 'NT Authority\Network Ser...more >>

Hello, I have created a connection string to a siebel database and have been able to connect and retrieve records using ADODB and the dbeng50.exe. This works pretty good but it will not let me update any data from my .NET Application. I am using the administrator password and have tried the use...more >>

I linked to paradox table from MSSQL 2000 enterprise server and I saw all the table name but my question is how can I make a select statment to see the data? ...more >>

What is involved in connecting a SQL Server 2000 to Active Directory. My need is not to register SQL Server but to exchange data. ...more >>

I have the following connectivity issues when querying a linked server: Base Server[s]: SQL Server 2000 (32 and 64-bit) sp3 SQL instances listening on port 1433 Windows Server 2000 and 2003 (32 and 64-bit) (clustered and stand-alone configurations) Reside on same subnet Linked Server:...more >>

When using ADO I create a connection object and then run several select only queries against that connection object. The queries are executed simultaneoulsy and with async. Behind the scenes, and a simple SELECT @@spid query verfies what I am saying, further connections are opened having differing s...more >>

Could you provide explanation of the following error message, and what I need to do to rectify it? Connection failed: SQL State: '01000' SQL Server Error: 10061 [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets] ConnectionOpen (Connect()). Connection failed: SQLState: '08001...more >>

WHILE STARTING MS SQL SERVER 7.0 SERVICES, SYSTEM IS GENERATING ERROR 1067 AND UNABLE TO START. PLS. ADVISE. REGARDS, SANJEEV GARG...more >>

hi im started to get the following error message while executeing query saying that- "Unable to load SQL Server OLEDB provider resource dll" Imusing Win2K Professional and SQL 2K SP4. I intalled MDAC 2.8 also but problem persist.application was working fine previously.. Can any one give me ...more >>

Hi, I have a web application which is taking a fair bit of traffic. It involves a registration process, and then a series of questions which must be answered. The SQL server receives upwards of 1,000,000 queries a day. Unfortunately on a small number of these queries (~500 a day), the ASP ...more >>

Hello, Since couple of weeks, we got this error in event viewer and it make the sql server not accept anymore connection after 2 or 3 days. We need to stop and restart the sql service. Error: Event ID 17052: Error: 17825, Severity: 18, State: 4 Could not close Net-Library ''. Eve...more >>

I am facing the following problem: Error Type: Microsoft OLE DB Provider for SQL Server (0x80004005) [DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied. I am using SQL Server2000 (SP3) on Win2000 (SP4). Any help would be appreciated. ...more >>

Does anyone have this hot fix and if so, are you willing to share it with us? Thanks, Mary Clark SQL Server DBA ...more >>

is connection pooling something that can be used after moving tables from mdb file to sql server 2000 and just relinking the tables via ODBC in the front end file? Or is this something that must be setup in code? ...more >>

We have a problem on a SQL Server 2000 with SP3a and latest security patch running on Windows 2003. We have several other SQL-servers aswell but this one seems to have problems with Windows Authentication. It worked properly first but then when we changed to Windows authentication and the...more >>

We are having a problem with our services (mainly SQL server) in that they loose/forget their passwords. So, even though the service is set to start automatically, it can't do to a logon failure. We must type over the password and then are able to start the service. This is happening on multiple ...more >>

Seems like there are so many different variations and flavors of connect issues, surely there is a FAQ or a KB that documents all (or most) of them? ...more >>

i'm the first time to use sql server 2000 to develop my final year project.....since i never create any database using sql server 2000 before....my "sql server group" is empty.......when i register a server.....a message prompted out as folling "SqlConnection()is failed or access denied"....more >>

Hello, I am trying to create an OLE DB connection to MS-SQLSERVER 2000. I have set the security settings inside Enterprise Manager to allow logins for both SQL Server and Windows. Does anybody have any ideas as to what is causing this error? Regards Grant Reid ...more >>

Is there a way to create a brand new database on the server? Someone gave me the asp code below, but I haven't gotten it to work yet. Thanks for any help. <% Dim strSQL Dim cnnTest strSQL = strSQL & "CREATE TABLE tblTest " & vbCrLf strSQL = strSQL & "(" & vbCrLf strSQL = strSQL & "ID...more >>

Trying to make connection from Visual Basic.net to remote SQL database via XP Client without success. Varying flags...from can't locate server to access denied. Various logons created on SQL server and all fail. I can access/logon to server via Remote Access but can't connect from Visual B...more >>

Hello I am doing some development for a client who has an IIS server runnin webmail on the same box as the SQL server 2000 sp3 install. I am trying to connect t this box but do not know how to set it up to connect. The IIS for SQL serve tool lets me add a virtual directory just fine but will no...more >>

Hi, I installed SQL2K SP3a on Windows 2003 server. During the install I changed the SQL port number 1433 to 14330. Everything finished successfully. But when the clients are trying to build the ODBC to connect to SQL server, they cann't connect if they leave the Dynamically determine port ch...more >>

Can the QueryTimeout property be set in a connection string We are using SharePoint 2002, and when going through the Wizard to setup a connect, there is no prompt for QueryTimeout, but we are able to contruct our own Connection String So, I was hoping that we could use the querytimeout in the co...more >>

Hi Im very new to SQL server so forgive me if this is a basic question. Im running SQL server on a windows 2000 machine and when I run Analysis Services it picks up the server (my local computer name) perfectly. However, when I try and register the server in Enterprise Manager it cant fi...more >>

I have looked through all the posts and I have seen similar problems bu nothing that answers my issue so I am trying not to ask the sam question as everyone else. Here is the configuration: Distributor and Publisher: Windows 2000 Advanced Server Clustered Sql Server 2000 Sp3a Clustered Ac...more >>

I (running SQL 7 client only) cannot connect to the server via my machine, but CAN connect (after installing client) to the server from ANY other machine on the LAN. My SysAdmin and I have been workin on this for days but have come up empty, any ideas? Could it be some other software I'm...more >>

I'm sure this has been beat to death but I'm not finding the solution......... I've got a server running either Windows 2000 Pro or XP Pro, that has SQL Server 2000 on it. With databases and all the normal junk. I have a normal PC running XP Pro with Enterprise manager and standard junk on ...more >>

Anyone have an idea why a program that compiles in developer will give a 'not responding' message when being compiled to create an executable?...more >>

I installed a SQL 2000 (with service pack 3a) on a Windows 2003 server , but Windows 2003 server still automatically close down TCP/IP listening for SQL ; I reinstalled both 2003 server and SQL server with sp3a again , But I am still not able to open that listening , any idea ? ...more >>

We have windows xp pro running on a laptop. I can connect to the server and our databases but when I try to open a table I get the following message "[Microsoft][ODBC Driver manager] Only SQL_DRIVER_NOPROMPT is allowed when connection pooling is enabled" Does anybody know why this is ...more >>

Hi, I have defined a DTS package which establishes VPN connection with my client's server. When I execute this package thru SQL Enterprise Manager (SEM) it works fine, but when I schedule it as a job or try to execute thru SQL Query Analyzer using 'xp_cmdShell' stored proc, it doesn't establi...more >>

Can anyone tell me if Microsoft has set a release date for MDAC 2.7 SP1 yet Please email me at joeydba@yahoo.com - thanks....more >>

I am experiencing a problem whereby a 3rd party application is performing data transfers between tables in a database and they are taking enormous amounts of time I have no way of knowing what it is actually doing but when I examine the current activity, the RUNNABLE process shows NETWORKIO in the...more >>

Our users use a third party app that connects to a SQL database on a windows 2003 member server. The app works if the user has a windows 2003 user account local on the server. 1. All of our user accounts are in a Novell Netware Domain. 2. We have purchased a processor license for t...more >>

Hi frnds, New problems evryday .. we had migrated our intranet website(in asp) frm win 2k t win 2k3 last week , for 2 days all went ok but then the trouble(s) started ... frm yest we are getting an error time in and again "Microsoft Ole DB provider for ODBC Drivers error '80040e31'" I ha...more >>

Hello everybody I have a VB6 app using Trusted Connection to a SQL Server 2000. This application can also run when creating a VPN Connection and using a TCP/IP Connectionstring I upgrade my MDAC installation (2.8) and now when I tried to run my app over VPN, I obtain: "cannot generate S...more >>

Connected to SQL database via network but now I have copied database onto laptop to work from home, I got SQL 2000 Server Edition on laptop but I cannot seem to connect to local database on laptop, it comes up with errors saying no database found or access denied. Tried to tell it to look ...more >>

i asked this question yesturday and got an answer from John Bell (thanks by the way) and i want to clarify what i need is there any document that say for each hardware the number of connections the sql can tolerate and still working fine i have 2 processores (1.4 ghz) computer with 2 gb ram and st...more >>

I have two nics on my sql box. The first being a gig nic for internal networking which works fine. The second nic however is not doing so well. It works great for a couple of hours then all of a sudden it starts sending packets out at a alarming rate. This behavior will eventually hose our entire i...more >>

hello everybody does anyone knows the max connections the sql server can work with. i need to know about the sql server capability according to hardware limits ( for exe:how many connection can the sql manege on 2 cpu's computer with 2.gb ram, etc' thank Ruby...more >>

I am trying to connect with enterprise manager, but i am gettin the error; --- A connection could not be established to BWSI. Reason: Login failed for user 'sa, SQLService, (null), etc'. Reason: Not associated with a trusted SQL Server connection.. Please verify SQL Server is running a...more >>

I am receiving this error when trying to establish a connection to SQL Server 2000 sp3a running on a Windows 2003 server. I am able to make a connection to the SQL server from the phyiscal machine it resides on, but not from other machines. The complete error message is listed below. I have also a...more >>

Hello, On the SQL Server Properties Page under the security tab I changed the authentication to Windows only then changed it back. When I did that it asked for a password, I put in a password. Now I have an ASP page that is used to login and modify data on the database. That page will no...more >>

Hello!! Please help me!! I want to know, if SQL server has a table where I can find how many connections ar in this moment, or a command. Or beteer,I what to know how many computers ar login to SQL server ( USER ID or Network card ID) in this moment. Thank you, ...more >>

I'm having difficulty connecting to SQL server 2000 using tcp, as below. Server A : (W2k3) SQL2K server using Windows Authenication Only. (stand-alone server - i.e. no domain controller) all users/clients have (windows) user name all using same Group. Group is used in SQL server security. note...more >>

Server: Msg 8985, Level 16, State 1, Line 2 Could not locate file 'wslogdb62_log' in sysfiles. DBCC execution completed. If DBCC printed error messages, contact your system administrator. ...more >>