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
all groups > sql server connect > october 2005 > threads for october 8 - 14, 2005

Filter by week: 1 2 3 4 5

SQL and VPN
Posted by Chip at 10/14/2005 11:12:57 PM
Hi, I am new to Networking and we have just put in a CISCO firewall so we can have VPN access to the SQL 2000 server (server 2000) but after getting the VPN in place we found that we do not have VPN access to the database. CISCO informed me that we need to set up the SQL server to have UNICAST t...more >>


Dropped connections, but open on the SQL Server...
Posted by Brett Wickard at 10/14/2005 3:54:10 PM
I have a frustrating issue that hopefully someone can help with. I have a few remote users that connect to the sql server through 1433 and sql authentication (the ISA firewall only allows their IP addresses to connect). They connect through an ODBC connection with no Idle timeout. These us...more >>

Database Authentication Error in FP
Posted by Slim at 10/14/2005 1:04:02 PM
Hi, I am trying to add a Data view to a sharepoint site. When I try to create a connection to the SQL database I get an Authentication error. I have tried both the Windows Authentication and a Username. I am a DB administrator and have full access to the database and its server. Thanks!...more >>

Error 7303 Could not initialize data source object of OLE DB provi
Posted by Linda Ibarra at 10/14/2005 8:22:11 AM
I am trying to link to an AS400 server. When I set up the link I am getting Error 7303 Could not initialize data source object of OLE DB provider. I know that there are problably parameters that I need to add to the connection but am not sure where to start. Can someone help me troubleshoot ...more >>

SQL Server 2k connect error with hostname
Posted by Microlong® at 10/13/2005 9:19:00 PM
I have an application developed by ASP. I use OLE DB to connect Product Server. I can connect product server with IP address, but failed with hostname. Win2k3 sp1 and sql server 2ksp3: error: Attempting Connection with Connection String: Provider=SQLOLEDB;Data Source=Hostname;Initial Catal...more >>

Windows Authentication without named pipe
Posted by Geof at 10/13/2005 8:42:29 AM
Hello, Can someone explain me if it is possible to do a windows authentification on a SQL Server without using named pipe, and just using a TCP/IP (port 1433) network access. Thanks, Geof ...more >>

Sept CTP 2005 Mange. Studio can't connect to MSOLAP "actively refu
Posted by Bob H. at 10/13/2005 8:28:07 AM
I'm sure this is a simple thing that I'm missing, like a setting in the Surface Area Configuration wizard or some such. Please read on... I have an x64 server (Windows 2003 Server) with a clean, named instance (there is no "default instance) install of the Sept. MSSQL 2005 CTP (9.0.1314) - ...more >>

deploying a database
Posted by Ido at 10/13/2005 3:43:03 AM
Hi, do you know how to deploy a database (along with all the tables and data in them etc.) from a development machine to the target machine? Can I just copy the dabase file??? (Assume the SQLServer application is already installed on the target machine) Thanks!...more >>



SQL Server 2000 not listening on TCP port
Posted by Aram at 10/12/2005 1:29:01 PM
Hello, I have a brand new install (with latest MDAC and SP) installed. In the SQL Server Network Utility both Names Pipes and TCP/IP are "enabled" I chose 1433 as the port for the TCP connection. However the SQL Server Log only shows Named Pipe: SQL Server is ready for client conne...more >>

Can't connect to SQL server after hibernating
Posted by Andy Rondeau at 10/12/2005 11:21:09 AM
Hi, I currently have a development SQL server running locally on my laptop. After my laptop comes out of hibernation, existing connections to the server, such as from Query Analyzer, work fine, but I can not make new connections to the server. I've tried restarting the server through the ...more >>

SQL & ODBC problems
Posted by Vickie at 10/11/2005 11:58:05 AM
All of a sudden one of our network workstations received the following message when trying to access a program Microsoft SQL Service Login -Connection Failed -SQL State: 'S1000" -SQL Server Error: 126 -[Microsoft] [ODBC SQL Server Driver] Unable to load communication module. Driver has n...more >>

Slow Connection using IP Address
Posted by Bill Sturdevant at 10/11/2005 6:52:08 AM
I have SQL Server 2000 running on a laptop on my small wireless network. It runs fine when I connect by using the servername while in SQL Query Analyzer. But if I use the IP address of the server machine, the connection speed goes from fractions of a second to many minutes. I need to use ...more >>

cant connect to sql server 2005,v9.001314
Posted by Shuch at 10/10/2005 1:27:23 AM
Hi all, i have the same problem with connecting to the sql server 2005 version 9.00.1314 .....i m trying from past two days now....i have installed sql management studio...but everytime i try to connect with it...using the server name as SHUCHI...it gives me error as: cannot connect to SHUCHI ...more >>

Can't connect to the sql server
Posted by zhenghong04 NO[at]SPAM yahoo.com at 10/9/2005 11:55:29 AM
I have machine A hosting SQL Server ASS, and B tries to access ASS. ASS use mixed authentication mode. A and B are in the same LAN and workgroup. B use Sql Server username and passoword to access the ASS sql server. In ADO.Net and Visual Studio .Net, if I first register the Server A on Visu...more >>


DevelopmentNow Blog