all groups > sql server connect > july 2004 > threads for july 15 - 21, 2004
Filter by week: 1 2 3 4 5
Cannot register SQL Server 2000SP3 from client computer
Posted by grahamhil NO[at]SPAM yahoo.com at 7/21/2004 6:34:05 PM
I have a sql server residing on a win2k3 box. It is a new installation
and there is no data in the server at all besides default data. I have
my workstation that I have installed client tools on. I am attempting
to log into the sql server via the enterprise manager. I decided to
use the sql acco... more >>
Local SQL Server Connection times out during network outage
Posted by anonymous NO[at]SPAM discussions.microsoft.com at 7/21/2004 1:34:16 PM
Hi,
we just upgraded to active directory from nt 4 domain.
In our HQ office we have 2 SQL servers for various
applications. We have a DNS/DC/GC server located at this
location and a DNS/DC/GC server located at a remote site.
During the last couple months after the upgrade we have
had a... more >>
WMI for SQL on WIndows XP
Posted by BC at 7/21/2004 1:23:26 PM
Hi,
I am trying to run some vbscripts on my computer, but I always get the
following failure.
Can anybody suggest a way out of this problem?
TIA
Bob
The Error popup contains
Script: small.vbs
Line: 4
Char: 1
Error: 0x80041002
Code: 80041002
Source: null
I am running ... more >>
Cannot Connect to SQL Server 2000 using Windows XP Pro account login info
Posted by patel NO[at]SPAM cs.utk.edu at 7/21/2004 11:03:26 AM
When I try to create a System DSN connection to our SQL Server 2000
database that is installed on a Windows 2000 machine, I keep on
getting the following error:
Connection failed:
SQLState: '28000'
SQL Server Error: 18452
[Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user
... more >>
Restrict Access Suddenly Active
Posted by Tim Gowen at 7/21/2004 7:08:26 AM
I got called in on Monday because people couldn't get into
our SQL Server application. It's SQL Server 2000. After
talking to someone (I'm new to the application) I found
that the 'Single user' option for the database in
Enterprise Manager had been checked. Now I can't think
that anyone... more >>
Backup to Location over VPN
Posted by SqlJunkies User at 7/21/2004 4:38:01 AM
Hi,
I am having problems with creating a backup onto a machine that is connected to the domain via a VPN connection.
When i do the back up it does not recognize the directory that I have specified, yet when i use Windows explorer I can copy and paste to my hearts content.
I was just wondering... more >>
HowTo: Force the use of a certain IP address for Server-to_Server communication
Posted by Mike at 7/20/2004 11:31:52 AM
Hello.
We have two SQL Server 2000 (SP3a) servers, running replication.
Each machine has two network cards.
Up to just now only the first card in each machine was being used
(192.168.1.*), which put. each machine on our entire internal network.
Therefore communication betweeen these two s... more >>
Database Link supported with Oracle 9i?
Posted by Ken McClaren at 7/20/2004 9:51:56 AM
I'm getting ready to link my SQL Server 2000 database to my legacy Oracle 9i
database via linked server and I was wondering if Microsoft supported such a
configuration.
tks
kmcclare@hotmail.com
... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Fail to connect to cluster server
Posted by Mikael Horner at 7/20/2004 4:43:29 AM
I have a win 2000 cluster server with a sql 2000 instance=20
whitch is configured only with tcp/ip, and when it=20
restarted i=B4m unable to connect to the server.
The error log gives the error message "Bind failed on tcp=20
port 1434".
I can=B4t connect to the server in Entrprise manager, ... more >>
Enterprise manager and remote connection
Posted by Jonathan S at 7/20/2004 2:31:02 AM
Hi,
I am trying to connect to two different SQL Servers using my broadband internet connection.
Both servers are connected to a network which has one "visible" IP address.
Using the Enterprise Manager, I can connect successfully to one SQL Server, but cannot access the SQL Server on another... more >>
Q: Named pipes and Windows (integrated) authentication
Posted by Lou_Arnold NO[at]SPAM nospam.com at 7/19/2004 6:25:02 PM
Does Windows Authentication require Named Pipes to be enabled?
In an older MS Press book "Deploying MS SQL Server 7.0: Notes from the
Field" (page 161) it states that integrated security mode uses Windows
NT athentication to validate logins. But it laso states that "Only
trusted (multi-protoco... more >>
server not found
Posted by PF at 7/19/2004 6:46:33 AM
Hi,
I am trying to connect to a sql server on a win2000 machine
I am on a win 98 machine and i get the following error message
Unable to connect to server \\serveur\mssql
Server: Msg 6 Level 16, state 1
Microsoft odbc sql server driver tcpip socket
Specified sql server not found
The s... more >>
Timeout error in SQL Server Enterprise Manager
Posted by Brett Martin at 7/19/2004 5:57:37 AM
Hi
I get the following error message using Enterprise Manager
from my PC to run a query on a LAN based SQL Server 2000:
[Microsoft][ODBC SQL Server Driver]Timeout expired.
The query will run fine in the EM on the server and I can
connect through ODBC to return the dataset to Excel.
W... more >>
Windows 2003 and SQL2000
Posted by Tony Schliesser at 7/19/2004 5:56:01 AM
Hi.
I an Wink2k3 server running MS SQL server 2000. It appears to be configured to accept requests on its default tcp/ip port, however a netstat -an does not show anything listening on that port.
Could someone walk me through the steps to enabling this? I don't know if its a 2k3 issue or sql ... more >>
SQL Server 2000 periodically running slowly
Posted by Gary Broughton at 7/19/2004 4:33:25 AM
Hi all
We are having intermittent problems with SQL Server 2000
SP3 on a Windows 2000 SP4 server. A couple of times a
day the CPU will rise to at least 70% usage and all
connections to it will become REALLY slow i.e. three or
four minutes apiece.
We've run the Profiler several times. ... more >>
Unable to connect to sql server remotely
Posted by SqlJunkies User at 7/18/2004 10:21:10 PM
please help me in following matter
iam facing the same problem when i try to connect to sql remotely i.e.
Unable to connect to server (name of server)
Server: Msg 17, Level 16, State 1
[Microsoft][ODBC SQL Server Driver][DBNETLIB] SQL Server
does not exist or access denied.
but p... more >>
Unable to connect to server
Posted by SqlJunkies User at 7/18/2004 10:20:21 PM
Dear Kevin
please help me in following matter
iam facing the same problem when i try to connect to sql remotely i.e.
Unable to connect to server (name of server)
Server: Msg 17, Level 16, State 1
[Microsoft][ODBC SQL Server Driver][DBNETLIB] SQL Server
does not exist or access deni... more >>
Connectivity fails to remote Oracle linked server
Posted by Javed at 7/18/2004 9:59:55 PM
I have linked an oracle remote database from MS SQL server 2000, connecting
an Oracle 8.1.7 database. The linked worked fine for a few days but fails
now with a message 'Error 7399:OLE DB provider 'MSDAORA' reported an error.
OLE DB error trace [OLE DB Provider 'MSDAORA' DBInitialize::Initialized... more >>
Remote connection to Windows 2003
Posted by andrew.jocelyn NO[at]SPAM orbnet.co.uk at 7/18/2004 2:19:57 PM
Hi
I can't connect across the Internet using any client tools to named
instances of MSDE. I have 2 named instances of MSDE installed on a
Windows 2003 server. They are set to mixed mode security and I can
connect locally using e.g.
osql -U sa -P password -S 192.168.1.1\INST1
But remotly ... more >>
Data Lost?
Posted by BB3 at 7/18/2004 12:52:07 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 >>
Q: Windows Authentication
Posted by Lou_Arnold NO[at]SPAM nospam.com at 7/18/2004 3:53:19 AM
Is Windows Authentication possible without a domain controller?
I am running a testbed with two Win2K machines without firewalls. One
computer contains the MSDE 2000A, set for Windows Authentication
only. Running MS Access on the other computer under the Administrator
account causes a connec... more >>
confused connection-SQL7
Posted by PatO at 7/17/2004 6:38:01 AM
I just had a very strange (and scary) experience; on my test machine I have one ODBC set up to connect to my test SQL server. I just realized that some of the tables I have linked to this SQL server in an Access database are actually linked to the SQL server on the production database. How can thi... more >>
SQL connection thrue internet
Posted by Drago at 7/16/2004 3:33:34 PM
Hi
I want to connect to SQL server thrue internet, but i have no idea how to do
this. How to configure SQL server that i will see it from another location.
How to connect to server (Data Source = IP?) and do i have to open some
ports on firewall. I have SQL server 2000 on Win XP.
im kind of... more >>
SQL Server does not exist or acess denied
Posted by Andreas Lindahl at 7/16/2004 1:27:35 PM
I've been having this problem for a couple of months now. When I try to
connect to an SQL Server on a remote network I get an error message saying
"SQL Server does not exist or access denied". I think - but I'm not sure -
that this problem appeared after my hosting provider moved the database
se... more >>
Connection fails during unit test
Posted by Graham Pengelly at 7/16/2004 9:20:11 AM
Hi
I am having trouble with a connection within our local network. A
development machine needs to connect to the main dev db server. Visual
Studio and Enterprise Manager on the dev machine connect fine. The
application under development connects fine when it is run with the
connection str... more >>
VPN SQLServer
Posted by Viktor Zadro at 7/15/2004 8:32:47 PM
How connect SQLServer with VPN from remote location?
... more >>
Failed Windows Login On SQL Server 2K
Posted by David N at 7/15/2004 5:01:32 PM
We have just set up a new SQL Server 2000 instance on
Windows 2000 Server. Some workstations need to be added to
the domain. However, those that are, get the error message
Login failed for user (null) Nopt associated with a
trusted SQL Server connection.
All the users have domain accounts an... more >>
Connection string with sa password
Posted by bulat NO[at]SPAM asuxxivek.spb.ru at 7/15/2004 8:31:14 AM
My application designed with VB6.0 is connected to MS SQL Server 7.0.
Server has password for sa login. The VB code for connection is next:
Dim Conn As ADODB.Connection
Set Conn = New ADODB.Connection
Conn.ConnectionTimeout = 30
Conn.ConnectionString = Provider=SQLOLEDB.1;Persist Security
In... more >>
Serious Win 2003, IIS 6, and SQL Server 2000 problem
Posted by Psilo666 at 7/15/2004 5:58:46 AM
After migrating to Windows Server 2003 with a MS SQL Server 200
installation, I've tried numerous variations to connect to the SQ
Server throug the IIS via ASP scripting in VB, but unfortunatel
without any luck.
On the former server running Windows Server 2000 with MS SQL Serve
2000, I was a... more >>
|