all groups > sql server connect > january 2005 > threads for january 1 - 7, 2005
Filter by week: 1 2 3 4 5
How to access SQL Server on another domain with Windows authentica
Posted by CyberDigger at 1/7/2005 2:51:02 PM
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 install... more >>
Can't connect to SQL 2005
Posted by Scott McNair at 1/7/2005 2:49:36 PM
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 m... more >>
Problem Transact-SQL Statement
Posted by Allen Yu at 1/7/2005 12:36:32 AM
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 u... more >>
Unusual AS400 Linked Query problem
Posted by Simon Prince at 1/6/2005 11:46:09 AM
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)
... more >>
installiation error help plz
Posted by Wouter at 1/5/2005 12:15:45 PM
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 ... more >>
Microsoft JDBC Driver Performance Degradation
Posted by Brian Luo at 1/4/2005 5:07:05 PM
We have been using Microsoft SQL Server JDBC Driver 2.2.0040 in our products
to connect to SQL Server 2000 Standard Edition SP3 (8.00.760). Our
functional testing went fine but we have run into serious performance
degradation under simulated heavy loads.
Our server crashed with OutOfMemor... more >>
Connect not working from one machine
Posted by murphy NO[at]SPAM murphysw.com at 1/4/2005 2:32:56 PM
I'm trying to create an ODBC DSN from client A to server B via the
control panel applet. I receive the "Server does not exist or access
denied".
>From A I can connect to other database servers in the office.
Other clients in the office can connect to server B.
I've reinstalled MDAC 2.7 s... more >>
Connect through NAT router
Posted by Bill Todd at 1/4/2005 10:31:18 AM
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... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Error 1069
Posted by ryan at 1/2/2005 7:59:05 AM
I am getting this error when I try to start my service in win xp pro. any
suggestions on how to reslove this?... more >>
|