|
How to access SQL Server on another domain with Windows authentica
I have two computers, client and server. The client is running Windows 2000
Professional and is in a workgroup, say "MyWorkgroup". The server is running
Windows Server 2003 Standard Edition and is in a domain, say "MyDomain".
The server has SQL Server 2000 Standard Edition with SP3a installed and is
usin ...
Fri, 7 Jan 2005 14:51:02 -0800
|
Can't connect to SQL 2005
Hi,
I just installed MSDE 2005 (or, rather, whatever it's called now) on my
machine. I'm trying to connect to it using Enterprise Manager, but I
keep getting Unable to connect/connection refused messages.
I've tried giving it my machine name, the word (local), localhost,
127.0.0.1, my machine's IP... n ...
Fri, 07 Jan 2005 14:49:36 -0800
|
SSL Security Error SECDoClientHandshake()
Here is my situation: Two SQL Server 2000's connected between two offices via
an IPSEC tunnel over the local broadband provider's links. The servers
eventually need to participate in replication but I can't even get
connectivity. One SQL Server ("main") sees the other ("secondary") fine and
odbcping is ha ...
Thu, 6 Jan 2005 22:17:02 -0800
|
Problem Transact-SQL Statement
I've come across a Transact-SQL statement as follows:
-- Statements start here
select 'EXECUTE sp_changeobjectowner ''' + name + ''', ''dbo''' from
sysobjects where type = 'U'
-- end here
Questions:
(1) How should the 'select' statement be interpreted?
(2) What are the rules for using the quotati ...
Fri, 7 Jan 2005 00:36:32 +0800
|
OleDbConnection to SQL Server?
I'm having trouble getting my web application to connecto to a SQL 2000
database when the database is on another computer on the network. I can
connect to a local SQL db, a local Oracle db and an Oracle db on another
computer. But, when I try to connect to a SQL db on another computer, the
OleDbConnection ...
Thu, 6 Jan 2005 05:47:06 -0800
|
Unusual AS400 Linked Query problem
Hi,
I hope someone may be able to shed some light on my problem...
I am using as AS400 as a Linked Server from SQL 2000, and have been for 2
years or so, with good success, but I came across an issue this morning I
just can't solve.
I am querying a table using the syntax (simplified)
SELECT * FROM O ...
Thu, 6 Jan 2005 11:46:09 -0000
|
installiation error help plz
when i start to install SQL and followed this guide:
Run SQL Setup
Select "SQL Server 2000 Components"
1. Click "Install Database Server"
2. Click Next
3. Select "Local Computer" and click Next
4. Select "Create a new instance of SQL Server,or install Client Tools" and
click next
5. Put name and company ...
Wed, 5 Jan 2005 12:15:45 +0100
|
Connect through NAT router
I need to connect to SQL Server 2000 across the Internet. SQL Server is
behind a NAT router. What port(s) do I need to forward to be able to
connect with Enterprise Manager and ADO?
--
Bill Todd ...
Tue, 04 Jan 2005 10:31:18 -0800
|
Managing SQL Connections
Hi,
I've a question regarding how SQL shares connections among different users
connecting from an Access .adp front end.
My preferred solution is to create a SQL user-account for each real-world
person using the system, and allow them to log in an out of the database
using SQL security (the server is no ...
Tue, 4 Jan 2005 01:45:04 -0800
|
MS SQL Server 2000 and MS JDBC SQL Server driver problems. (Connection timed out, followed by Error establishing socket)
I have downloaded the MS SQL Server 2000 Enterprise Evaluation edition, and
the MS SQL 2000 Server JDBC driver.
I have installed and configured the MS SQL Server 2000 onto two computers,
which reside on the same network. (In fact, these two computers comprise
the entire network).
The network server (compu ...
Sun, 02 Jan 2005 18:14:29 GMT
|
Error 1069
I am getting this error when I try to start my service in win xp pro. any
suggestions on how to reslove this? ...
Sun, 2 Jan 2005 07:59:05 -0800
|
Select db_name() returns null
I'm using vb6 (sp5) and sql server 2000 (sp2). The statement "select
db_name()" returns the correct database name except on newly installed
machines running xp pro (sp1) where it returns null for a database name.
After a period of time (days to weeks) the problem seems to correct itself.
I've loaded
md ...
Thu, 30 Dec 2004 12:29:01 -0800
|
Scheduling job contact to remote server issue
Hi,
I need loading data to a server, actually those data extract from linked
server user-defined database. Current server and linked server depend on
different domain. So my loading scheduling job got error message as follow:
Executed as user: domain1\_sql_svc_crpx-iws1. Access to the remote server is
de ...
Thu, 30 Dec 2004 10:37:04 -0800
|
Error 7317 when Accessing Linked Oracle Server
I have a linked server to an Oracle 8i database. When I attempt to query the
Oracle tables I get the following error:
Server: Msg 7317, Level 16, State 1, Line 1
OLE DB provider 'MSDAORA' returned an invalid schema definition.
OLE DB error trace [Non-interface error: OLE/DB provider returned an
invalid s ...
Wed, 29 Dec 2004 10:31:03 -0800
|
Connection.Command.Text length
Is there a way to set the length of my command text? I have a very large
script I am trying to pass through the adodb.connection object, and it keeps
getting truncated. ...
Wed, 29 Dec 2004 12:01:05 -0800
|