Hi I wonder if someone could help me out. Sporadically, I keep getting the following error on my ASPX pages which connect to SQL Server... "An error has occured while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that ...more >>

I installed a copy of SQL 2005 Express on another computer here using the automatic download and install from Microsoft supported by the setup toolkit. I can't access this server from another machine on the LAN using SQL Management Studio Express. I can 'see' the server but cannot connect. Bot...more >>

Hello, I am experiencing issues where it appears that SQL Server 2000 is dropping connections when meta-data is requested from a Cold Fusion 7 server. We have attempted to troubleshoot this error on the application side and have exhausted all possible scenarios (different drivers, settings...more >>

We have built an application (VB 6 with a SQL 2000 backend database) in-house and from time to time, we get the dbnetlib error message. This error message seems to happen when the machine is just idle and is driving me nuts. The error message doesnt seem to have the issue while the user is a...more >>

Hi all, I am working one application that is using OLAP Server for reports. I am rendering HTML tables for reports. This application is using Windows based authentication. Connection String for OLAP is placed into Registry. I am not passing user id and pwd into that string. If i run this...more >>

I am not sure exactly which newsgroup to post this to so I will ask here with the hopes that someone either can answer or at least point me to a better newsgroup to pose the question. We have a single SQL Server 2000 server machine. We are increasingly adding more and more db's and applicat...more >>

I have developed on application that connects to a sql database using tcp/ip Sometimes the connection may get broken, for example with laptop users. What is the most efficient way of detecting when this happens, instead of the string of sql errors that we get. ...more >>

Issue: [Microsoft][ODBC SQL Server Driver][DBNETLIB]ConnectionRead (recv()). Server: Msg 11, Level 16, State 1, Line 0 General network error. Check your network documentation. Connection Broken above error is recieved during a heavy SQL query from Query Analyzer & a OLEDB application clie...more >>

I set up my SQLExpress server using Windows Authentication only. Now when I try to create a user account using Username and Password, the connection returns the error: Not a trusted connection. Does this have something to do with my previous server setup or is there a general setting somewhere...more >>

I am using Win2k server(sp4) and Sql 2000(sp4). When register from enterprise manager by using windows authentication , it was showing 'cannot generate sspi context'. When I use FQDN to register, it work fine Regards, George....more >>

Hi ALL, I have an issue with connecting to a clustered sql 2005 instance from an XP box using Kerberos: wondering if some one can help me to get to the bottom of the issue; this is what happens; Say if I log on to the domain; at 8 am yesterday, I get Kerberos tickets with start time = 2007...more >>

Hi, Sql throws the error 'cannot generate sspi context' The envronment as follows. Win2k Server with SP4 Sql 2000 with SP4 Logging to the server with domain account which have admin privilage. It throws the error, when we register by windows authentication in Enterprise managerin th...more >>

Hi! I have an Access db that I need to link to a SQL Server table. I'd like to do that through code, does anyknow how to do that? (I'd like it run from several clients and I don't want do create a ODBC-connection on every client.) Thx! /e ...more >>

Hi, I have SQL Server 2000 installed on a computer running Windows 2000 Advanced Server. I'm using enterprise Manager from the Windows 2000 server to try to connect to another SQL Server 2000 installed on Windows 2003 server . Whenever I tried to make the connection , I get the following e...more >>

If I remote on to sql05 and open management studio and select * from sql2000.dbo.tablename Where sql2000 is a link from sql server05 to sql server 2000 it works Same thing happens if I just try Test Connection under Linked Servers on my local machine. If on my desktop in ManagementSt...more >>

We have a .NET web service running on one of our servers connecting all our application users to a SQL Server 2000 database with service pack 4. Every now and then we experince a NETWORKIO wait type which then causes all our application users to receive a "Object reference not set to an instan...more >>

We currently have the SQL Server Service Manager Version 8.00.760 running on Windows 2000. Some programs are not working ie. Timberline Office. When we attempt to open the progrma a SQL Server Error appears. The SQL Server was located in the Add/Remove Programs section of the computer and w...more >>

Hi all, A customer have a strange issue: He connects .Net applications and Access db's to a SQL Server 2000 SP3. Whenever a user connects using Access, another connection appears (sp_who, sysprocesses) with the same hostprocess and another hostname. Sometimes the hostname is the one of a machi...more >>

Hi all, I am using OdbcConnection for coonectivity with SQL Server db. My code is working fine with windows application but in ASP.NET or in webservice its raising following exception - "ERROR [08001] [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied. E...more >>

I'm trying to run an install on Vista (the install runs fine on every other platform) I have a Custom Action to run the sqlncli.msi install from within our install. If I try to run sqlncli.msi on its own then it run correctly. I am running our install using the option "Run as administrato...more >>

Hi all. Iam developing an application, where i need to send email on regular intervel (say for evry day.) from SQL Server 2000 .But i dont want to use SQL mail. I need to do without using SQL mail... Please any body suggest me regarding this. its quit urgent I will be waiting for the re...more >>

I'm trying to install Microsoft SQL Server 2005 Developer Edition and each time I attempt to I get the error message: "Failed to install and configure assemblies C:\Program Files\Microsoft SQL Server\90\NotificationServices\9.0.242\Bin\microsoft.sqlserver.notificationservices.dll in the COM+ ...more >>

Hello, I have a MS Windows 2003 server with SQLEXPRESS 2005 running on it. I can work with the SQL management studio on that machine in my database but not with a remote desktop. On that server there's also a website www.abc.com Where can I find enough info to make a connection from within ...more >>

Hi all, We've got a product which is three tier, using a .NET Client -> .NET Server which in turn connects to a Sql Server 2005 Instance. On top of this we also have a Windows Service which runs nightly processes also written in .NET and connects directly to the SQL Server instance. It's al...more >>

Dear all, I have different .NET library which request a connection to an SQL server database. As far as I understoo authentication methode for SQL, as long as we have windows oprating system everywhere we can select SSI authentication methode for the database connection string. But in case...more >>

I get the following message: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: Named Pipes Provider, error:...more >>

I've got a SQL Server that has been up and running for months. I got in this morning and nothing can connect to it. I get "Login failed for user 'sa'. Reason: not associated with a trusted SQL server connection". I can't login with any account nor can I get in using Windows authentication. ...more >>

I need to backup a database daily. The commands are as follows, osql -E 1> backup database mydata to disk = "c:\mydata.bak" 2> go 1> quit Is there a way to automate this daily? Thanks Danny...more >>

I have both apps running on a fully updated Win XP box. Default installs of both Express apps. I can access my database through SQL Server Management Studio Express, OR through the VB Express interface, but I cannot do both at the same time. When it's already open through VB Express and a...more >>

I have a similar probem to what was poseted here, however I can't register the sharepoint sql database with the sql enterprise manager. None of my share point sites work after a side by side install of sharepoint 3 next to sharepoint 2. I had a patrialy sucessful install of sharepoint services...more >>

I would like to know if there is a comparable tool in SQL Server 2005 to the ORacle Connection Manager (link provided to Overview below) http://www.oracle.com/technology/products/oraclenet/htdocs/cman_overview.htm...more >>

I am running sql server 2005 developper edition on a Windows XP Sp2 machine that is part of a domain. I am getting the cannot generate SSPI context error when I am trying to connect via integrated security. I can connect using username and password. I looked at the docs but found that the ...more >>

Hello. I've an application that has to do a bunch of "SELECT" and INSERT into a couple of tables. On my machine everything works fine, but if I try to deploy the app on a VM for a test i have many probs. The most common is "(Named Pipes Provider, error: 40 - Could not open a connection to SQ...more >>

Hi I have an AS400 linked server in SQL Server 2000. Using IBM's iSeries Access ODBC Driver (filename : CWBODBC.DLL, Ver 9.00.08.00). When I run a query in query analyser it does not return all of the records. I am getting "Error converting data type DBTYPE_DBTIMESTAMP to datetime." It defini...more >>

Hallo, Maybe some hints are avialable. System: Vista Business SQL-Server: 2005 Express SP2 UserStatus: Admin Connect via Management Studio 05 Error: 5120 bzw. 5123 - access declined. Datenfile is local with full access any ideas? regards akko...more >>