I get the following error when trying to connect to SQL Server SQL Server does not exist or access denied. ConnectionOpen (Connect()). Scenario: The application connects to SQL Server very frequently (million+ times per day). It fails with this error message about 100 times. The failu...more >>

I'm trying to execute a procedure through linked server using 4 part names. The Linked server is configured for PRC and RPCout . Still I get this message... What Am I Missing... Could not execute procedure on remote server because SQL Server is not configured for remote access. Ask you...more >>

Hi !! I would like to connect to a SQL Server (MSDE edition) that's in Internet, using Enterprise Manager either Query Analizer. For these I've configured the client tool as: Server Alias: INET_SERVER Net: TCP/IP Connection parameters: Server name: [DNS_NAME]\[REMOTE...more >>

Hi I'm loged on Workstation as a user EUR\zzzz1 and i use different user EUR\abc123 to map a drive on remote server SERVER2, SERVER2 is a domain controler . It works. On SERVER2 i have SQL Server 2000 with mixed mode authentication. I have a user abc123 added in Active directory on SERVER2: ...more >>

Hi, I have 2 servers, both with Windows 2003 Standard edition. Servers are NOT in a domain. The second server has SQL 2000, the first has IIS 6.0 Through OBDC (System DSN) I created a connection to the SQL db. Then on my laptop I opened up frontpage to create a page to view the db results. ...more >>

I've been having a problem connecting to my sql 2000 server database. The error reads... Server Error in '/ASP' Application. Login failed for user 'NT AUTHORITY\NETWORK SERVICE'. Description: An unhandled exception occurred during the execution of the current web request. Please review the s...more >>

Hi, I get this error when i insert a record from my local server to a remote server. Server: Msg 7391, Level 16, State 1, Procedure usp_insSO2NavAppV2, Line 14 The operation could not be performed because the OLE DB provider 'SQLOLEDB' was unable to begin a distributed transaction. [OLE...more >>

I have all the symptoms of KB article 839279: "When you run a distributed transaction against an instance of SQL Server, you may receive an error message that is similar to the following: Server: Msg 7391, Level 16, State 1, Line 1 The operation could not be performed because the OLE DB pro...more >>

Hi! I have a late requirement from de Security Department. This is the situation: the apps must connect to SQL Server 2000 through OLE DB using a generic user, but the developers will not know its credentials (at least the password) Unfortunatelly, like I said, this is a late requirement becaus...more >>

In this post I am going to try to simply a question that I posted earlier. Can I use VFP to access a SQL Database? If so what is the command? What is the best software for creating applications to work with SQL? I am just getting my feet wet with SQL so please take it easy on a rookie. ...more >>

At my workplace our ERP software in on a VFP database. I have learned quite a bit about extracting data with the select statements from the VFP database. We are in the talks of converting the the SQL version of our ERP and I have some very basic questions since I am extremely new to the SQL wo...more >>

Dear all, I want to take backup of my Sql server 2000 databases on network drive = but I am unable to find the network drive only local drive are seen in = Enterprise Manager of my Sql server. Actually I have tried both by, = maping my network drive thru Domain/Administrator password as well a...more >>

I am trying to pass two parameters to a stored procedure that works fine when I use the code, for example: param_user.Value = "blahblah@com" The problem is the value I need is in a variable, but when I use: param_user.Value = variable name I get no records returned. I cant seem to ...more >>

Yes, I opened the ports 1433 and 1434 in Windows Firewall and SQL server is set to windows or sql authentication. I believe I opened them with the correct TCP/UDP combination. I also told windows firewall about sqlserver.exe, however I suspect that is more for outbound connections. I understan...more >>

Hi, I have a windows service that I built in c#. I am trying to connect to a sql server database with trusted authentication but I get login keeps on failing. So I am assuming that I need to supply different login credentials since its not accepting my windows nt login that I use for log...more >>

My variation of this problem is as follows: the server has the Windows authentication mode, I'am aware of it so I make sure I comply with it in my connection attempt (through Enterprise Manager). I attempt to connect from another PC. Both the client PC and the server have the same range of u...more >>

Hi all, My problem is : I have ASP.NET 1.1 app that must connect to existing DBF data files. I tried to do this with existing ODBC for DBF but I have following problem : Either if DBF file had appropriate index NTX file, the unknown exception occured or if index didn't exist than the q...more >>

Win 2000, sqlServer 2000 Personal edition Trying ot connect using .asp Vb Script 1. Sql server set to use Windows Authentication 2. Log onto Windows 2000 as Jim Bunton {no password) 3 Server 'Study' running ok 4. sql query analyser i. "SELECT User_Name > dbo ii. [using database No...more >>

Im still looking for assistance on this matter which was posted in another thread of same title. My latest discovery is as follows: I have just worked out that I the machine that I can connect to has no SQL Server service pack installed and the one that I cannot connect to from my application...more >>

I am trying to connect to a sql server database that is in another domain from a vb script (not within ASP, just .vbs file). I am getting error: Microsoft OLE DB Provider for ODBC Drivers: [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user '(null)'. Reason: Not associated w...more >>

Hello, We have an instance of oracle on linux and another with sqlserver on windows. We need an odbc driver for the linux box to connect to the sql server. Does anybody have suggestions on what odbc drivers there are out there for linux in order for us to connect these two boxes? Tha...more >>

I have installed two SQL Server 2005. One on Windows XP SP2 and another on Windows Server 2003 SP1. I have shut down the firewall on both machine, but I still failed to coonect each other. Both of them can connect to SQL Server 2000. Does anyone know what wrong? ...more >>

One connection is using a few store proc to do some transactions. It takes a long time to complete. I want to know if it's possible to show the particular SQL statement when the connection is running, e.g. the statement "select * from staff" is bottleneck as it consumes the most effort. Th...more >>

We get this meesage if we try to connect to the database from a client computer. It works fine if we connect locally on the 2003 server. The MSDE was installed from another maker and we have changed it to use mixed mode. We log on using SQL server auth. We have used svrnetcn.exe and added TCP/...more >>

All, Can't figure out why I am getting this message in my event log... Event Type: Error Event Source: MSSQL$SQLSERVER2005 Event Category: (4) Event ID: 17830 Date: 9/14/2005 Time: 7:06:03 AM User: N/A Computer: ADDVMFM12 Description: A network error occurred while establishing a con...more >>

Hello I am having a SQL connectivity issue (Query Analyzer or Enterprise Manager connection) - from specifically one server to another. Lets just call them ServerA and ServerB. I cannot connect from ServerA to ServerB in either QA or EM. BUT, I can be on any other SQL server box and connec...more >>

Using Query Analyser, I cannot log in using the SQL 'sa' user name and password. I get an error saying "connection failed... not associated with a trusted SQL Server connection" When and where can the 'sa' credential be used without creating this error? thanks, Keith ...more >>

Hi, I have a problem with insert temp table with linked server. I have a sql 2000 with sp4 and I have a dozen linked servers. All of them work except one which is running on windows 2003. I didn't get any error message and the transaction just open and never stop. I have to kill it manual...more >>

Hi, Experts! I very new to SQL server. I made a stupid movement by mistakenly change the security of property of local(windows NT) from log in using this account to system account. After the machine restarted, i can't no longer start up SQL server. When I click local (window NT) in enterprise...more >>

I am trying to connect to a SQL server that is on a remote network, using Enterprise Manager. However, I am getting server not found errors. Here is my setup: My PC, connects to the internet via a PDC, which has a cisco router attached. Web Server has SQL installed on it, I have TCP/IP co...more >>

Hi, A problem since few weeks, all my SQL servers located on the LAN (clients too) don't respond to the broadcast request (255.255.255.255:1434), so my clients must set manually the TCP/IP port of their named instance. No firewall are placed between servers and clients. Any help appreciated...more >>

Hi I have been using SQL server with the web matrix project whilst I learn ASP.net. (I am new to both). At some point this week the SQL server stopped working (It may be linked to my computer crashing whilst another program was running). It now will not run from the web matrix or the SQL se...more >>

I have a asp.net application that connects to a SQL Server DB. I have been connecting to SQL Server on local machine and now Im trying to test connecting to another test server. I have setup my connection string in my web.config file as follows <appSettings> <add key="DB:CSA"...more >>

Hello, I have an issue with a number of the Windows XP workstations on my network not wanting to talk to my SQL server. I have traced the problem down to the appropriate protocols not being enabled on those machines (which I can fix using CLICONFG). What I am now trying to find out is how...more >>

hi all. got a question - wondered if you guys have come across this. I have an application that acts as a database "server" where it captures requests for information from many clients (1-100+ but 30 is typical) where it then interrogates a SQL server database on their behalf, and then re...more >>

Microsoft OLE DB Provider for ODBC Drivers error '80040e31' [Microsoft][ODBC SQL Server Driver]Timeout expired /include/poetsworkshop/common/functions.asp, line 516 What does this mean and is there anything I can do about it. Thanks For helping!...more >>

ENVIRONMENT: Microsoft SQL Server Management Studio 9.00.1116.00 Microsoft Analysis Services Client Tools 2000.090.1116.00 Microsoft Data Access Components (MDAC) 2000.085.1117.00 (xpsp_sp2_rtm.040803-2158) Microsoft MSXML 2.6 3.0 4.0 5.0 6.0 Microsoft Internet Explorer ...more >>

Hi, I've since a long time this error message on a windows xp sp2. The ODBC resource DLL (c:\windows\system\odbcint.dll) is a different version than the ODBC setup dll (c:\windows\system\odbccp32.dll). I've read this page http://support.microsoft.com/kb/170769/EN-US but, I'can't reinstall...more >>