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 > december 2003 > threads for december 22 - 28, 2003

Filter by week: 1 2 3 4 5

Setting up SQL connection fails
Posted by Frank at 12/28/2003 8:16:59 AM
When attempting to configure an OleDbDataAdapter I get the following error message: [DBNETLIB][ConnectionOpen(Connect()).] SQL Server does not exist or access denied. Here is the detail I am evaluating Visual Studio.Net and I am new to the environment. In the process of evaluating VS...more >>


SQLServereAgent Failed
Posted by ayman at 12/28/2003 3:44:51 AM
hi, the sqlserveragent service start successfully and failed after 40 seconds. it use local system account. after that I use sysadmin account to start it,its work well but the jobs didnt work? if u can help plz do!...more >>

NET Compact Framework with Oracle Lite
Posted by sergei98 at 12/27/2003 3:53:52 PM
Please help!! I need to use NET Compact Framework and Oracle Lite. Does somebody know if there is a provider ADOCE to connect an application in NET Compact Framework with Oracle Lite? Thanks in advance. sergei98 ----------------------------------------------------------------------...more >>

connection problem...
Posted by lmc at 12/27/2003 8:37:18 AM
I have installed SQLEVAL and the service pach 3 on Windows XP Home edition.... now i can't use telnet/ftp connection because my port23 is closed and i can't uninstall SQL because there isn't an uninstallation file. I don't know what i have to do. thanks to much. lmc...more >>

Trusted SQL Connection. Try everything but nothing works!!!
Posted by Gonçalo Boléo at 12/26/2003 4:05:35 PM
I have a job that connects one SQL Server to another (both MSDE). Sometimes (most of the times) a got an error that says: "Login failed for user 'userID'. Reason: Not associated with a trusted SQL connection." I already have made all the things that i see in newsgroups to correct the problem ...more >>

problem with installation of sqlserver 2000
Posted by Giulia at 12/25/2003 3:54:33 AM
I have a problem with installation of sqlserver 2000. I have a pc at home, my pc is not in a network. The operative system installed is windows xp professional. When I try to install sqlserver I receive the following message: " sqlserver 2000 enterprise edition component is not supported ...more >>

Connection error
Posted by Nader Galal at 12/24/2003 12:22:11 PM
Hi All when i try to register an instance of SQL server sometimes it's registered successfully and sometimes not, giving me the error SQL server Error:17 SQL server does not exist or access denied. I installed service pack 3 and i still get error. Also when i try to add a Data source, i can do ...more >>

Connection error
Posted by Nader Galal at 12/24/2003 12:21:14 PM
Hi All when i try to register an instance of SQL server sometimes it's registered successfully and sometimes not, giving me the error SQL server Error:17 SQL server does not exist or access denied. I installed service pack 3 and i still get error. Also when i try to add a Data source, i can do ...more >>



Login failed for user 'userID'. Reason: Not associated with a trusted SQL Server
Posted by Alex at 12/24/2003 10:40:14 AM
Hi, I'm running WinXP Pro, when I try to connect to MSSQL Server via ASP.NET, I get an error with the message "Login failed for user 'userID'. Reason: Not associated with a trusted SQL." I set up a log-in, which is set to SQL Server Authentication, I tried enabling named pipes, and still a...more >>

Query Analyzer Connectivity Error
Posted by Luis at 12/24/2003 8:32:33 AM
When I try to connect to the SQL Server I get this error message: "Unable to connect to Server [SRVNAME] Server: Msg 17, Level 16, State 1 [Microsoft][ODBC SQL Server Driver][DBNETLIB] SQL Server does not exist or access denied" My computer is outside the network. It actually works with ...more >>

Cannot restore database...
Posted by Brandon at 12/24/2003 6:49:54 AM
I have to recover a database and redirect it to another server with the same database name. Every time I run the job, I get "Unable to attach to <servername>. A network connection to the device could not be established." What am I missing? How can I redirect a SQL restore to another serv...more >>

What is this error message meaning? Please help? SqlDumpExceptionHandler Process 196 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQ
Posted by ERKUT GOKSEL CINAR at 12/24/2003 4:06:05 AM
What is this error message meaning? Please help? SqlDumpExceptionHandler Process 196 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process....more >>

Error accepting connection request via Net-Library 'SSNETLIB'
Posted by Leonard at 12/23/2003 4:05:50 PM
Hi, I installed SP3 over SQL2K on NT Server SP6. The Server hangs on startup. This is after I did an upgrade installation of SQL 7 to SQL Server 2000 and applied SP3 over it. Everything runs fine for afew hours and then we get the message below and some of our servers lose the ability to ...more >>

Can't create a linked server when the servers are set up to replicate
Posted by SniperX at 12/23/2003 2:11:13 PM
I can't create a linked server when the same two servers are set up for replicatation. I get 'Error 15028: The server 'SERVERNAME' already exists.' when I try to add a linked server. And it does exist as a Remote Server because as I mentioned, the two servers are replicating data. There has to ...more >>

Specified SQL server not found: myServer1
Posted by DC Gringo at 12/23/2003 11:54:29 AM
I've been having trouble connecting to a 2nd instance of a SQL Server 2k with some VB.NET code from my WinXP Prof workstation. "System.Data.SqlClient.SqlException: Specified SQL server not found: my server" My application connects just fine from a Win2k machine with a like Client Network Ut...more >>

SQL Agent not starting after reboot.
Posted by Chris Whitehead at 12/23/2003 10:33:39 AM
On a server the SQL Agent service did not startup after reboot. There is definitely a tick in Auto-Start. I get the following error in the SQL Agent log:- [298] SQLServer Error: 1265, Cannot generate SSPI context [SQLSTATE HY000] [000] Unable to connect to server '2003SERV2\DEVIN1'; SQLServe...more >>

ADO/RDS Issues
Posted by Tim at 12/23/2003 9:35:23 AM
Does anyone know of any current ADO/RDS issues that could cause a connection to the database to fail? Any conflicts or problems with newer patches/service packs/updates? I have an application that has connectivity problems intermittently. It clears itself up after 3-5 minutes. The issue can...more >>

Access Denied from ASP.NET
Posted by Jan Bannsiter at 12/23/2003 4:01:47 AM
I've been workink with a WebService locally using a connection string with 'data source=(local)' for a number of weeks and I wanted to move my database onto our production server, Zeus. So i change the connection string to 'data source=Zeus'. When I Preview Data in Visual Studio .NET ever...more >>

Trusted Connection
Posted by Pete at 12/22/2003 12:43:15 PM
Hi All, I need to make a trusted connection for sql2000 but not sure how. I am using NT authentication. If possible I would like it to be Sql server login instead. Please give instructs. Thanks, Pete...more >>

no such interface supported
Posted by John C at 12/22/2003 11:39:46 AM
Need help with Sql access. I have an Office 2000 access project front end to an sql database. I normally use win98 with the sql connectivity client and have no problems. I built a new pc with xp and get the error "no such interface supported". I have office 2000 installed with all the ...more >>

sp_addlinkedsrvlogin HELP NEEDED!!1
Posted by tovineet007 NO[at]SPAM yahoo.com at 12/22/2003 11:35:03 AM
Hi All, I am really stuck with this thing and not able to thing of any good reason. Is there any body who can help me out!!! I am using sp_addlinkedserver to connect to a foxpro DB like this. And I am executing this stored proc on \\NU-CAPDE-01 (local machine) exec sp_addlinkedserver @s...more >>


DevelopmentNow Blog