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 > november 2005 > threads for november 15 - 21, 2005

Filter by week: 1 2 3 4 5

test
Posted by Capt America at 11/21/2005 8:22:37 PM


SQL Server does not exist or access denied.
Posted by pujarpatel at 11/20/2005 5:50:06 PM
am trying to run a simple .net code thro visual studio in which i just want to display table data into datagrid from sql server running on my local pc. i.e off localhost. but am getting run time error as below. Do i have create a new asp.net user in sql server ? or what ? i have searched ...more >>

More on that login problem - found the logs -
Posted by Barrett Bonden at 11/19/2005 12:59:16 PM
2005-11-18 12:50:12.09 logon Login failed for user 'sa'. 2005-11-18 12:50:36.85 logon Login succeeded for user 'NT AUTHORITY\SYSTEM'. Connection: Trusted. and some more that might be useful - 2005-11-18 12:50:40.92 logon Login succeeded for user 'NT AUTHORITY\SYSTEM'. Connection: T...more >>

all of sudden cant connect with SQL server authentication
Posted by Barrett Bonden at 11/19/2005 12:29:01 PM
Can connect with Windows NT authentication, but not with SQL server auth. So all my code has stopped working ... When I try to make a new SQL Server registration I get server does not exist or access denied... ...more >>

HELP:SQL Port lost or never set on new install
Posted by jlopes151 at 11/18/2005 8:37:12 PM
I just installed SQL Server on XP (SP2) attempted to access the Server through JDBC and got a error abut the socket connect. After much searching I find that the port is not active even though all app that would set the port have port 1433 set. If you follow. I ran netstat -ano and tasklist /s...more >>

LinkServer Available?
Posted by Mick Kowitz at 11/18/2005 12:00:00 AM
Hello, Does anyone know an easy way to detect whether a LinkedServer is running without waiting for the TSQL statement to timeout? In otherwords, is there some secret stored proc or exe or some library that will allow me to write code to detect whether the LinkedServer is up and running wit...more >>

Can not connect to non-default instance from remote computer
Posted by Alexey Rokhin at 11/17/2005 12:15:34 PM
I installed SQL2005 as default instance. After that I installed SQL2000 with instance name "SQL2K". Then I installed SP4. I can'not connect to SQL2K instance from remote machine. But if I log on at machine on which SQL Server installed I can connect to instance. And I can connect to defau...more >>

How to Connect to SQL Server 2005 enterprise version
Posted by Willy Verbiest at 11/17/2005 12:00:00 AM
I've just installed sql server 2005 enterprise on my Windows XP Professional SP2 machine. I can't find a way to connect with it. I'm totaly new to SQL Server and have installed it to learn about it. I can' t even find out if it is running or not. When I do a c:>netstat -a I can't find the po...more >>



Connection Bombs Out at 3900+ records
Posted by Ginny at 11/16/2005 8:33:07 AM
I have a customer who's running an application that's using an OLE DB connection to the database and when retrieving records a counter shows on the screen. As soon as the count reaches somewhere between 3900 and 4000 the counting stops and the grid never fills. The message received is as follo...more >>

Trusted Connection
Posted by Andrew Chalk at 11/16/2005 4:53:17 AM
On Windows XP running SQL Server, how do I create a user who will be considered a "trusted connection? I currently have SQL server set up for Windows Authentication? Do I have to change this? Perhaps someone could list the steps to create a trusted connection. Many thanks, ...more >>

ASPNET User
Posted by Andrew Chalk at 11/16/2005 3:54:04 AM
My application attempts to connect to an SQL Server database as name ASPNET and Login Name SERVERNAME/ASPNET in response to these commands: SqlConnection myConnection = new SqlConnection("Data Source=(local);Initial Catalog=MCSCRE;Integrated Security=SSPI"); myConnection.Open(); However, ...more >>

cannot connect using tcp/ip
Posted by Leo Deserio at 11/15/2005 1:17:12 PM
Hi, I'm using SQL Server 2000 and I'm trying to connect via TCP/IP. When I test it using telnet in port 1433, nothing happends. I need to connect to this server via Internet. How can I do? Leo- ...more >>

Oracle Linked Server on SQL Server 2005 64-bit
Posted by imp at 11/15/2005 12:28:04 PM
Hello, we are trying to migrate from SQL Server 2000 to SQL Server 2005. On an 64 bit Windows 2003 SP1 Server we have installed an SQL Server 2000 Enterprise Edition and an SQL Server Enterprise Edition 2005 (64bit), both as named instances. On both SQL Servers we have configured Ora...more >>

Linked Server: set up same on different servers, but different res
Posted by smoss at 11/15/2005 9:19:02 AM
We have a linked server set up the same on 2 servers, but a query from one server executes different on the remote database. A Query from one server executes quickly, while the other causes table scans on the remote server, per Profiler. I couldn't see any differences on the query received on...more >>


DevelopmentNow Blog