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 > september 2006 > threads for september 15 - 21, 2006

Filter by week: 1 2 3 4 5

Connection Problem
Posted by sara at 9/21/2006 9:58:12 PM
Hi All, I can not connect to sql serve 2005 using SQL Serve Management Studio, I got these error in ERROR.LOG file. Any help is really appreciated. Thanks. 2006-09-21 12:48:21.53 Server Microsoft SQL Server 2005 - 9.00.2047.00 (Intel X86) Apr 14 2006 01:12:25 Copyrigh...more >>

sql server 2005 can't see or connect locally
Posted by spitapps at 9/21/2006 4:23:20 PM
I have just started using SQL Server 2005(last night). I currently have an internal network with my client machine(development) and a server machine(sql server 2005). The SQl Server install has all the default settings, and I turned on remote connections. But when I go to connect to the serve...more >>

Error: Heterogeneous queries require the ANSI_NULLS and ANSI_WARNINGS options
Posted by Jim Fox at 9/21/2006 2:58:30 PM
Hi, SQLServer 2000, using an OPENDATASOURCE command within a stored = procedure to access data on another Server running 2000. I get the = following error, when I exececute the Stored Procedure in Query = Analyzer: Heterogeneous queries require the ANSI_NULLS and ANSI_WARNINGS options = t...more >>

SQLDMO connects to wrong sql server instance
Posted by aromani NO[at]SPAM gmail.com at 9/21/2006 1:19:10 AM
I have a small utility that is used to run sql script files from command line. It's created in c#. This utility uses sqldmo objects to connect to server and run script. I have two SQl server instances installed - 2005 and 2000. I'm using 2005 as a default instance and 2000 as .\sql2000 named ins...more >>

Need Help! Connection Count to Linked DB2 Server Reaches limit (SQL1040N) when execute dynamic generated OPENQUERY T-SQL
Posted by alingsjtu NO[at]SPAM gmail.com at 9/20/2006 10:23:45 PM
Need Help! Connection Count to Linked DB2 Server Reaches limit (SQL1040N) when execute dynamic generated OPENQUERY T-SQL Hello, every body. I created a linked server to DB2 8.1 database which called GRR_DB2Server. In my stored procedure p_FetchRawData, I need to read some data from this lin...more >>

Can I manage SQL Server 2000 with Mangement Studio Express 2005?
Posted by Ken C at 9/20/2006 12:33:16 AM
Hi Folks, I'm new to the MS SQL Server world. Couple quick questions: 1) Can I use the current version of Mangement Studio Express (MSE) to create/update/delete fields/tables on an existing SQL Server 2000? 2) How do I get connected over the 'Net? I have created an ODBC syst...more >>

ASP.NET 2.0 and SQL Server 2000 connection issue
Posted by sreedhardasi NO[at]SPAM gmail.com at 9/19/2006 9:12:03 AM
Hi, I am developing an ASP.NET 2.0 application and SQL Server 2000 as back-end. The connection to DB works fine if I connect to my local or our dev databases. It is giving me the error when I try to connect to Test database. However, I am able to connect to the same database through Enterpris...more >>

Supersocket Unable to bind to 1433
Posted by Macinslaw at 9/18/2006 7:51:02 AM
We are running a cluster with SQL Server 8 on Windows 2000 advanced server. Recently, we changed the IP address of just the virtual server, for the cluster. Not long after we were unable to connect to port 1433. I checked in the regestry and the cluster setting is pointing to the old IP a...more >>



MS SQL server login failed
Posted by Djordje Lekovic at 9/18/2006 7:44:02 AM
I have MS SQL server desktop version installed localy and I have been using it till last time I had to change my windows XP password. After that I could not start service and I am getting an error message: "The service did not start due to a logon failure", and "An error 1069 - The service did...more >>

Cannot Generate SSPI Context
Posted by Gunady at 9/17/2006 9:52:18 PM
I know there is quite a lot of posting before for this error. And I quite confused with long explanation at Microsoft Support. My problem is quite weird, I can connect normally to SQL Server (running Windows Server 2003) from my PC (running Windows XP SP2) for around half to one hour. I develop ...more >>

Timeout when connecting to SQL server
Posted by reidarT at 9/16/2006 7:08:59 PM
I have an application (winform vb.net 2005) installed on some computers. There is a connection to an sql server on the companys server. This works OK on all machines except one, where I get the message 'TimeOut on trying to connect to sql server.' ( A combobox with data from a table on the sql s...more >>

RE: Connection Issue : SQL Server 2005 install on XPpro when connecting from a XPpro machine
Posted by Daryl at 9/15/2006 12:00:00 AM
I have installed SQL Server 2005 (Developer Edition) as a default instance onto a Windows XPpro (SP2) machine and I am trying to connect to it from another Windows XPpro (SP2) machine using Microsoft's DataLink connection tool. I have installed using Windows Authentication only for the default ...more >>


DevelopmentNow Blog