Archived Months
June 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
August 2008


all groups > sql server connect > july 2004 > threads for july 22 - 28, 2004

Filter by week: 1 2 3 4 5

Enterprise Manager runs slow on some computers
Posted by G. Sutherland at 7/28/2004 8:23:36 AM
I have a network of WinXP SP1 machines who all connect to SQL Server 2000 SP3 on a Win2k server. When running enterprise manager, most of the computers take at least 4 minutes to expand the database tree. Working on databases (retrieving properties etc) is also painfully slow. On two compu...more >>

ODBC SQL Server Driver Failed (communication link failure)
Posted by Michael C at 7/28/2004 3:07:01 AM
Hi all, Running MDAC 2.71 SP 1 Refresh querying against a SQL Server 2K SP3a server and I get this error after the queries have run for about 2 hours (when these queries actually complete it normally takes about 4 hours). Has anyone encountered this error, and does anyone know what might caus...more >>

Job Scheduler fails and Managing Tempdb
Posted by babalwa NO[at]SPAM hotmail.com at 7/28/2004 2:28:09 AM
Hello, I have two issues, hoping someone can help. Issue 1. I have various DTS packages that copy data from Progress Database to Sql Data Warehouse. The ODBC Connection is stable and packages have been auto scheduled by creating a job that is managed by the SQL Agent service to run daily ...more >>

Syntax error or access violation
Posted by russsage at 7/27/2004 3:06:20 PM
I am trying to create some tables on the pubs database using script and I am getting this error, "[Microsoft] [ODBC SQL Server Driver]Syntax error or access violation". Does anyone know what is causing this?...more >>

Connection Problems
Posted by Yinka at 7/27/2004 2:28:03 AM
Each time a user tries to connect to an application, they keep getting the following error: Unable to create ADODB Connection - [DBNETLIB] [ConnectionOpen (connectionOpen()).]SQL Server does not exist or access denied. This has been happening for the last three days and each time this...more >>

Job failed with owner ()
Posted by austin_graeme NO[at]SPAM hotmail.com at 7/26/2004 7:37:48 AM
Recently I've been seeing the following error when SQL Server Agent jobs are run. But this doesn't always happen, sometime the jobs run fine. The job failed. The owner () of job xxxxxxxxxxx does not have server access. Any thoughts?...more >>

Can't Connect SQL Server
Posted by ¦ó°¶ºÓ at 7/25/2004 7:05:52 PM
I Have Three Server , Only One Can't Connect SQL Serve , Another Can Connect SQL Server I don't Know What Happen Who Can Tell Me what can I do?? ...more >>

Data Lost
Posted by BB3 at 7/25/2004 1:23:25 PM
I have an ASP form created in FrontPage on an XP client that connects to a "remote" SQL database hosted on a Win2003 server. Connection tests, field mapping etc. all indicate OK. When I fill out the form and submit, I get confirmation and no indication of problems, however data does not ap...more >>



Upgrade SQL6.5 -> SQL2000
Posted by Eric Lam at 7/24/2004 12:39:44 AM
Hi All, I encountered BUG# 364258 (SQL Server 8.0) http://support.microsoft.com/default.aspx?scid=kb;en-us;818550 and then followed the second workaround (i.e. backup existing database and restore it to another SQL 6.5 server on Windows 2000). But I can restore master database and msbc to t...more >>

Server: Msg 7399
Posted by Richard at 7/23/2004 11:37:42 AM
I get the following error when I try to do a query accross a linked server. I am trying a select * from [server name].master.dbo.sysobjects. Server: Msg 7399, Level 16, State 1, Line 1 OLE DB provider 'SQLOLEDB' reported an error. The provider did not give any information about the error. ...more >>

Error connecting
Posted by Viktor Zadro at 7/23/2004 10:28:02 AM
Cannot open database requested in login <DatabaseName>. Login fails. Login failed for user <DOMAINNAME\User>. Please help. ...more >>

Connection refused, connecting to SQL server through web
Posted by Tom Kamps at 7/23/2004 3:11:17 AM
Hi, I'm trying to connect to an SQL server from an asp.net page. Both servers are in the same domain. The setting on the SQL server are set to accept both Windows and SQL users. The users of the webserver log in with windows authentication. First I tried to connect to the SQL serve...more >>

Pubic Chat: SQL Server 2005 Beta 2, What's New
Posted by Stephen Dybing [MSFT] at 7/22/2004 11:19:59 AM
Join members of the Microsoft development team as they chat about what's new in SQL Server 2005 Beta 2. One major new feature that's been announced in Beta 2 is data encryption. Come chat about other new features and changes that exist in this highly anticipated beta of the next version of SQL...more >>

Connecting to AS 400
Posted by Vijay at 7/22/2004 9:50:56 AM
Hi, How can I connect to AS400 from SQL Server 2000. Client prefers NO DSN. Thanks Vijay I will persist till I win....more >>

COM+ Application server has problems with SQL2000 both Win2003
Posted by Dietmar Craul at 7/22/2004 8:41:57 AM
Hi, I want to run the following scenario: 1 server with COM+ components do DTC transactions against a SQL-2000 database. While this runs perfectly under Windows 2000, this does not work at all under Windows 2003. I have checked all MSDN stuff, run the DTCTESTER utilitly and came to the result...more >>

Alias in the DNS.
Posted by Pierre at 7/22/2004 6:29:12 AM
Hi, I have two different server with the same SQL instance with the same databases on SERVER1\NODE1 and SERVER2\NODE1, the goal is to be able to switch from SERVER1 to SERVER2 without causing users problems. We thought to add in the DNS server the IP adresses of the server1 and giv...more >>

an error of login "sa" with Error 18456 Level 14
Posted by Li at 7/22/2004 12:16:55 AM
I got an error of login "sa" with Error 18456 Level 14 . Server A is the MSSQL Server where the database sit and the other Server B is just with MSSQL Server tool which act as a Terminal Service and have the Accounting applications.The Accounting application unable to perform its database ...more >>


DevelopmentNow Blog