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 >>
Don't see what you're looking for? Search DevelopmentNow.com.
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 >>
|