I am running SQL 2000 on Windows 2003 Server. Right now it is on a stand alone laptop and I keep getting "Connection failed" when I try to telnet to it. Here is all that I know. SQL Server is set to listen on 1433 clidnfg shows it set to 1433 server config shows it set to 1433 netst...more >>

When trying to connect to 2 of my SQL Servers I am getting General Network Error. I have run Portqry against both of my servers and they both return that ms-sql-s Sevice is listening on port 1433. When I try running ODBCPing I get the following results: COULD NOT CONNECT TO SQL SERVER ...more >>

Im getting this error when starting the Mssql server 2000 SuperSocket Info: Bind failed on TCP port 1433. please advise also note thta it is only MSDE not the whole SQL Sever -- Posted using the http://www.dbforumz.com interface, at author's request Articles individually checked for conf...more >>

Hello All, I apology for posting to many groups but I wasn't sure which group would be best targeted with my question. I have inherited an ASP.Net application that requires some maintenance & bug fixes. I have been asked to also download a copy of the remote SQL Server database that it ...more >>

Hi, I have to gain exclusive access to a MS SQL Server 2000 Database from a VB application through ADO for a very short period of time in order to do special processing (data historization and computation) and preventing that others users can connect at the same time. Which is the best meth...more >>

I have an installation of SQL 2000 on a Windows 2003 Server, and another server with Oracle 9i. I've not been able to successfully make an OLEDB connection to the Oracle database from SQl 2000, either with a DTS package, or using <OPENROWSET('MSDAORA', etc.> in a stored procedure. I have dozens...more >>

Hi, Using VB .NET is there a way to return/track the reason why a connection has failed to open. I want to be able to track the following reasons for failure: 1. User doesn't have the correct permissions set to open the database 2. Unable to open the connection because the user setting are...more >>

The following is being attempted from the SQL Server itself via Remote Desktop. If I try to set up a linked server via ODBC to data that is on another server, I get an error stating that the server is unable to open the DBC file. However, if I try to simply execute a DSN-less query against th...more >>

Every time I start up Enterprise Manager which has several SQL 2k registrations, I get a series of entries like this in my Event | Security log: Any ideas? Event Type: Failure Audit Event Source: Security Event Category: Detailed Tracking Event ID: 599 Date: 2/3/2005 Time: 9:22:43 AM ...more >>

OpenDataSource gives "Unspecified Error" when connecting to local Excel spreadsheet file with account not in local administrators group, on Microsoft Windows 2003 / Microsoft SQL Server 2000 sp3a. I am having a permissions problem using the OpenDataSource command to open an Excel spreadsheet l...more >>

hi guys, how can you determine/find out the port number of your sql server instance on a sql 2000 server? I can figure out how to set the port number in 'client network utility', but can't figure out how to view it. many thanks. JJ...more >>

Hi - I have two computers, one running Xp Pro and one Xp Home. I created a windows user account on both machines with the same password. I added those accounts to SQL Server on both machines and I want to be able to connect to each other using a trusted connection. If I try to remot...more >>

Is there any way to identify which records in a SQL database were 'read' and by whom? Thanks. -- Message posted via http://www.sqlmonster.com...more >>

Hello, I have a laboratory server with SBS 2003 (Sql Server 2003), and I have 3 PC's linked to that server. PC 1 and PC 2 has Sql Server 7.0 Personal Edition with SP4, the query to link is: exec sp_dropserver 'Server2003' go exec sp_addlinkedserver 'Server2003', 'Sql server' go exec sp_...more >>

When I try to connect to SQL server that is running in the local machine (through data environment in VB), I get the following message microsoft data link error [DBNETLIB][connection open (connect()).] SQL server does not exist or access denied. But, when I use an ODBC connection through ...more >>