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