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 >>
Don't see what you're looking for? Search DevelopmentNow.com.
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 >>
|