Groups | Blog | Home


Archived Months
June 2003
July 2003
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
April 2004
May 2004
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
August 2008
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 >>



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 >>


DevelopmentNow Blog