Hello, I have a VB6 application that connects to an SQL2000 database on another machine. I'd like to be able to determine if the connection is still good without having to close and re-open the database and check the error status of the open command. The state property of the connection o...more >>

Hi all, When I accessed query analyzer I got the following error: [ODBC SQL Server Driver][TCP/IP Sockets] SQL server does not exist or access denied I had been able to access this feature with no problems until now. This occurs at my local instance so I do not know why it is happening...more >>

Is only Help disabled or there are other problems??? -- Cristian Marchi Anildo CEO - Ticinum Consulting srl...more >>

executing dimension process, the system return an error : - Cannot generate SSPI context" I'm not understand where is the problem.....all config parameters are correct.... What could be the reason of this? my system configuration Win XP SP2 Pro Ed. SQL 2005 Beta 2...more >>

Hi I have users in domain group who use application which uses sqlserve, they have rights to insert, update, delete. I want some of the members of this domain group to connect directly to the database using query analyzer but with right only to read and they still of course can use application...more >>

Hi, I am using SQLServer on my development laptop, and it's running without any problems since at least 6 or 7 months. Suddenly, since yesterday, when I start the Entreprise Manager, it takes absolute AGES (minutes, with a very intensive disk activity) until it shows the console root, and...more >>

I'm getting Error 5123 "Cannot Open file because file is being used by another process" when I try re-attaching a DB (.mdf) I had just detached. I'm afraid I issued a DBCC command (which may be locking the file) right before I detached the Database: DBCC OPENTRAN (oldoaiapp) Does anyone k...more >>

My client has installed e scanner program wich is suposed til run on a MSDE database. The program has to run on a reasently installed SBS 2003 server. The server is installed with only standard features, the isa server is not installed. Clients are running in a standard 2003 domain. The progr...more >>

Hi All I have following questions regarding C# Assembly and Threading. Let me know the precise answer or lead me to the proper materials. 1. Is memory leakeage possible in .Net Manager Code ? 2. Is memory leakage possible in .Net Unmanaged Code ? 3. How can I find the what % of memory i...more >>

I am able to run queries using the query analyzer. I have Enterprise Manager but the SQL Server Group does not hold the SQL Server I need to connect to - when I try to register the server, I am still unable to see the server in the list of available servers - can somebody help? Thank you, Sh...more >>

Scenario - On a standalone installation i.e client and SQL server are on same machine, if network connection is lost while preparing SQL server connection through client application, then SQL connection could not be established. This was detected only on few machines. The configuration details ...more >>

I'm having trouble troubleshooting a remote query using OPENROWSET. For some reason I can get OPENDATASOURCE to work with a given connection string but using OPENROWSET with the same connection string fails. I'm a bit baffled. It seems like it should work basically the same way using either me...more >>

hi, can someone tell me how to raise the number of Named Pipes on SQL 2000 SP3, please? i am aware of http://support.microsoft.com/?id=165189 and the hereby mentioned registry key, which is for SQL 6.0/65. but no one can tell me what to use in case of sql server 2000, beside of pointing me ...more >>

I detached a database and moved it to another folder. I am trying to re-attach the database and am getting 'Error 5123: CREATE FILE encountered operating system error 32(The process cannot access the file because it is being used by another process.) while attempting to open or create the p...more >>

Hi All Having 'Google-ised' I've found that there does appear to be a problem connecting to an MSDE 2000 DB from a remote machine (either LAN or WAN), but I haven't found what the concrete solution is. It definitely appears to be a Windows inflicted problem, as I can connect to the DB no pr...more >>

I've got a SQL2000 server that I need to connect to from a small number of development boxes. If the dev box is running Windows 2000 SP5, I have no problem establishing an ODBC connection. If I follow the exact same steps in trying to establish an ODBC connection on a Windows XP SP2 box, I get:...more >>

Hi, This is regarding a distributed .NET application implememented with (.NET Framework 1.1) ASP.NET and .NET Remoting. Both web and app tiers run on IIS 6.0 (W2K3) and are configured for network load balancing (NLB). The web tier connects to SQLServer to access Session State database and ...more >>

I recently moved my Access BE tables to SQL Server 2000. I re-worked my Access front end .mdb to link to these tables through a DSN file. I got daring and expiremented with .adb Access Project format. It worked great except for when I tried to share it off a shared draft with other users. ...more >>

Hi, If I give a user name or password having special character (mainly semi-colon) then I cannot connect to the SQL Server. Following is the error: Login failed for user 'a`~!@#$%^&*()_+|-=[]'. TCP Provider: An existing connection was forcibly closed by the remote host....more >>

We have many SQL 2000 server, that is not setup as a distributor or a publisher. It is not involved in replication. we we have been seeing a bunch of connections on the server from user NT AUTHORITY/SYSTEM application SQLDMO executing exec sp_helpdistpublisher @check_user = 1 a number of time...more >>

I recently had to upgrade my WIN-XP SP2 OS harddrive. I am now getting the following error message when I attemp to start MSSQL 2000 Developer edition through Enterprise Manager or Query Analyzer: "A connection could not be established to (LOCAL) Reason:SQL Server does not exist or access deni...more >>

I've just dropped a new Windows 2003 SP1 server with SQL Server 2000 SP4 in my hosted center. That server replaces an older Windows 2000 based server running SQL Server 2000 SP3. I have a firewall-firewall VPN setup between my office network and the data centre. I also have two seperate dom...more >>

I'm trying to write an activex script to read in all the named ranges that end with a $ in an Excel workbook from a DTS package. I've gotten as far as grabbing the filename of the excel file. I've been trying to find an answer without much luck, does anyone have any suggestions? -- ...more >>

We have written a thread to monitor whether the database connection is still alive or not. This monitoring thread executes a stored procedure, sp_TestDB, with ADO _CommandPtr every 3 seconds. Most of the time we have no problems executing it. However, we receive the following error rand...more >>

I have an intranet application running on IIS 6. It accesses SQL Server 2000 data and the SQL Server is on the same server. I know that it's not great to use IIS on the SQL Server, but we're behind a firewall, have a pretty small user base, and everything's been working fine for over a year....more >>

Hey All, More fun and games with SQL Server 2005. Mike: thanks for your help before on the Beta. I was able to uninstall and regain connectivity. I didn't have to wipe the box, but came close!! Here is a new twist: Previous situation: - One data server - 2 instances: SQL Serve...more >>

While i think this is a pretty common error, i'm pulling my hair out to try and figure out how to get around it / fix it...i believe this is what is stopping Visual Studio.NET from connecting to SQL Server...but if it isn't it is still something that shouldn't be happening... I've tried remov...more >>

Has anyone seen similar behavior? The following error " Server: Msg 7391, Level 16, State 1, Line 1 The operation could not be performed because the OLE DB provider 'SQLOLEDB' was unable to begin a distributed transaction. [OLE/DB provider returned message: New transaction cannot enlist in th...more >>

In the MSDE Edition of Sql Server 2000 there is a limit of 25 connections. What is the definition of a "connection"? For example, if I create a connection pool of 5 connections in an application, does that count as 5 against the 25? -Thanks -Tom ...more >>

I have a new SQL Server 2000 64-bit with Windows 2003 DataCenter. I have loaded Oracle 9i client and the Oracle Provider for OLE DB on this server. I am trying to set up a SQL Server 2000 linked server with the Oracle Provider for OLE DB driver. Can SQL Server 2000 64-bit linked server be...more >>

Both are XP's (the one running Enterprise manager, and the one running SQL 2K) and the entire network only has a Workgroup (ANGELS)... thus everything is machine local accounts. Enterprise mgr complains that it can't access the foreign SQL Server because it can't get rights... obviously I can't...more >>

Hi all, I trying to use sp_addlinkedserver, after I added successfully a new linked server I do not know how to use the server... I did this to add the server: exec sp_addlinkedserver 'Server2','sqloledb','Northwind','myComputer','','','Region' Now, I want to do a simple SELECT state...more >>

Hi friends I installed sql2000 dev edition on XP professional.i created a login in sql.but whenver try to login to sql it says "this login is not associated with trusted connection" and i cant login!! am wondering how to fix that. Thanks Cheers -- cheers...more >>

Hi all, I have two servers in a network. one of these servers are in a workgroup and the other is in a domain when i run the following command in query analyzer of the domain server, i get an error indicating device not ready etc. backup database northwind to disk = '\\domain\d\northwind.ba...more >>

We have an OpenQuery to an Oracle linked server that was working fine in SQL 2000 SP3. After upgrading to SQL 2000 SP4 (MDAC 2.8), the query is failing with "Protocol error in TDS stream". It seems to be related to sending a very large query - when I reduce the size of the query, it seems to...more >>

I cannot connect to our SQL Server 2005 Beta 2 database server from my machine. This is the error I get: "A connection was successfully established with the server, but then an error occurred during the login process. (provider: TCP Provider, error: 0 - An existing connection was forcibl...more >>

I am writing an Active Server Page application that will get all of the databases that a user can access. Is there a way I can do this with Active Server Pages? I also will provide the users with the option to change records, table structure, etc with this application. I will also be developin...more >>

hi, i've just installed sql server2000 on my home pc, im using to connect to a sql server at my work. My query analyser works fine, but enterprise manger seems to freeze and ultimatly not respond when i try to open the data base folder, I downloaded that latsest server packs, but evey time i r...more >>