all groups > sql server connect > january 2006 > threads for january 8 - 14, 2006
Filter by week: 1 2 3 4 5
How to connect SQL Server to an Oracle database
Posted by N.Ordiers at 1/13/2006 9:31:39 AM
I need to connect to an Oracle database (8i) running in a UNIX box, with SQL
Server running in AD.
If anyone has done it, kindly let me know since this is new territory for me.
Thanks,
Neil... more >>
Possible to Use Windows Authentication on Peer to Peer Network?
Posted by Robert Scarborough at 1/12/2006 4:35:26 AM
Is there a way to use Windows Authentication to log on to an SQL server
instance accross a peer to peer network without a Domain?
... more >>
How to determine if a linked server is available
Posted by Armin Jacobs at 1/12/2006 1:52:01 AM
Hello all,
I need to write data from one SQL server in to a linked server running on an
other machine. How can i check with T-SQL commands if this server is
available?
If it is not available the stored procedure directly quits with an error.
But this procedure should continue in differt w... more >>
remote connnect MSSQL 2005 express
Posted by Goh at 1/11/2006 6:18:49 PM
Can we remote connect MSSQL 2005 express with IP address?
If can how to done it?
With regards,
Goh
... more >>
[DBNetLib] ConnectionOpen error
Posted by Jim Bob at 1/11/2006 2:40:42 PM
I have a working SQL Server 2000. I use Citrix to run Terminal Server
Apps which work Fine. If I use RDP instead of ICA (Citrix) using the
same app and the same user, I get
an error as follows:
"[DBNetLib] ConnectionOpen(Connect) SQL Server does not exist or access
is denied."
As I sai... more >>
SQL 2005 - Can't make a new database project
Posted by Federico Caselli at 1/11/2006 3:15:02 AM
Hi,
Trying to make a new database project using VS2005 pro and SQL2005 dev (in
my local machine), I get the following error and the project can't be made:
"An error has occurred while establishing a connection to the server. When
connecting to SQL Server 2005, this failure may be caused by... more >>
SQL Agent cannot start
Posted by Somchai at 1/10/2006 7:17:05 AM
I have a Window 2003 SBS with SQL installed (SQL 2000 includet in SBS).
Everything worked fine for a long time, but now the SQL server starts but the
SQL agent doesn't start even manually. When I try to start the agent it is
trying to connect but it doesn't. In the log it says that it start... more >>
Errors in connecting Visual Fox Pro as linked server in 2005 - HEL
Posted by djh at 1/9/2006 8:52:02 PM
I can set up a linked server to a FoxPro DB in SQL 2000 but it fails when
trying to set up the linked server in 2005. I know the MS site says something
about leaking memory with the linked server but I don't even get a link that
works.
Here is what happens in a Win2003Server, SQLServer2005... more >>
Don't see what you're looking for? Search DevelopmentNow.com.
Trigger running Insert on a Linked Server - HELP
Posted by PG at 1/9/2006 6:50:05 PM
Hi everybody,
I have two DataBases on different SQL2000servers, I have linked them both,
and what I want is, when a record is created on one DB it must create the
same record on the other DB. If the DB's are on the same server the trigger
works fine, but when they are on different servers(c... more >>
Log Shipping - Error
Posted by Gabe Matteson at 1/9/2006 3:26:37 PM
I have two servers, the sql agent service on both servers are running under
a domain account - rrg-sqlagent which is an administrator on both servers.
The initialization of the database works but 15 minutes later when the the
log shipping starts to occur i recieve the following errors. does an... more >>
SQL 2005 client connectivity - Framework
Posted by Clarkie at 1/9/2006 11:44:47 AM
Hello!
Does a client that connect to an SQL 2005 analysis services always need .NET
framework 2.0 installed?
Regards
Clarkie
... more >>
Slow connection to SQL2005 on just one machine
Posted by p3t3r at 1/9/2006 11:26:03 AM
I have 2 SQL Server 2005 machines each with a .NET2 web app.
Machine #1 is Windows XP
Machine #2 is Windows 2003
When I use EM on Machine #1 to connect to both instances everything is fine
(and fast).
When I use EM on Machine #2 to connect to both instances, the server on
machine #1 is v... more >>
MSDTC
Posted by Hartco at 1/9/2006 8:34:04 AM
We just upgraded from SQL 2000 to SQL 2005. To do so we had to uninstall SQL
and install 2005 from scratch.
The problem now is we get this error:
Msg 3910, Level 16, State 2, Line 1
Transaction context in use by another session.
When trying to Exececute a SP on a remote server where that S... more >>
SS2005 connection problem
Posted by Dino Hsu at 1/8/2006 3:50:31 AM
Dear all,
I am new to SQL server 2005.
I have a connection problem when I connect from home client to office
server through VPN.
Firstly, I can connect from office client to office server, both
datbase engine and analysis server, with Windows authentication. I log
in the office client box with... more >>
|