I am receiving General network error when I try to back up a SQL Server database on a computer that is running Windows Server 2000 I receive Following error when running DB maintenance job: [2] Database master: Database Backup... Destination: [\\LGA01\SysDbBackup_01\master_db_20050331144...more >>

Hi, It probably depends on the data transfer but is there a rule of thumb to determine the upload bandwidth required to query a remote sql server ? i.e I have IIS6 dedicated machine hosting a few sites. Each site hosts own asp pages and pulls back XML over ssl from relevant SQL server host...more >>

Hi there, I have a VB6 application working over a SQL Server 2000 database. since a long time ago, I am experiencing serious performance problems, that I still can't resolve. Normaly, the performance problems are related with database design, query design, application design an hardware. Th...more >>

How do I detect that my C# application has lost the connection to the SQL Server. The reason for the lost connection is that the network connection is down. Changing the "connection timeout" property in the connection string only helps when I have a connection to the server that the SQL s...more >>

I was under the impression that the Client Connectivity install was required for every machine on a LAN network that wanted to connect via OLEDB to an sql server database. However, I recently created an adp project in MS Access that seemed to connect without any problems, even though the Client ...more >>

Hi, We have a program the connects to the SQL 2000 database and the program runs on Windows Server 2003 Terminal Services, the issue that we are having is that multiple process ID have been created (in our case its 4 process ID) whenever the program connects to the database but when we conn...more >>

Hi there. I'm getting the following error when trying to connect to a Remote Server I've set up: Server 'Server_1' is not configured for DATA ACCESS. I know this option is available with Linked Servers but I dont know what to do here. I have RPC enabled and valid server and login names ...more >>

Hi, For some unknown reason, we are getting the following "Connection to Server Failed" error message when we attempt to register our local server using MS Analysis Services: "Errors occurred while connecting to '<localservername>'. Cannot open connection to Analysis server '<localserverna...more >>

It appears to be up and running, when you expand in Enterprise Manager on a client side, I am getting: A connection could not be established to "Name of the server". Reason: General network error. Check your network documentation. ConnectionOpen (PreLoginHandshake()).. Please verify SQL Se...more >>

Hi Group: Hope this is the right forum... Occasionally, when I write data to a linked Excel file from a varchar(50) field, it arrives with a preceding single apostrophe (') in Excel. Doesn't seem to have the tick in SQL when I view in QA. Any ideas why this would be, or how I can avoid t...more >>

I had two databases on my server, and I just deleted the one which SQL Server has identified as the default database. Now I can't connect to the server via SQL Enterprise Manager. How can I rectify this situation? The server itself is not having a problem, I'm just not able to connect remot...more >>

I have two SQL Server installed on a Server. One is using default port 1433, the other is using another port 1400. Due to virus infected, may I block the port 1434 and setting the alias for the non-default port 1400 at the SQL clients? Will there be any other impact ? Thx...more >>

I have a local mdb file and remote sql server 2000 database.. i know only my remote table user name and password... my mdb file and sql database are same... I tried to link my remote database I click link table and odbc from my mdb... i choose machine data source and new ... i cho...more >>

I have SQL 2000 SP3a EE on Compaq hardware. I have all user data and system data on SAN Drives. I am noticing that even though SQL Server is set up as automatic on start up still it doesn't stat the server automatically. I have to manually start SQL Server service after the machine is booted u...more >>

I have quite a few queries that I have written using Excel and MS query. I basically connect to an outside ORACLE 8i database and retrieve data for analysis using Excel tools. I have been very succesful using this method, but for some reason I am no longer able to 'Edit my queries' I can refr...more >>

We have a web service that accesses an SQLServer database. The database has hundreds of thousands of rows. We open a cursor in order to allow the user to page through output, but processing takes too long and the cursor consumes too much memory. I understand how to limit the return set by us...more >>

I am hoping this is the right place to post... I am trying to find out some information on .NET over wireless. Currently I have an application that makes sql querries to a sql database. The application works fine over a wired connection, how ever when taking the application wireless it ti...more >>

While we update our datawarehouse we don't want the users to be able to connect to the database and update their reports. So we want to block access during certain hours. What is the best way fix this? The users use a SqlServer login with permission to read data....more >>

Good day In my application ADO Connection’s Open() method is used to open connection to SQL Server. Using profiler I see the following for Audit Login event: -- network protocol: TCP/IP set quoted_identifier on set implicit_transactions off set cursor_close_on_commit off set ansi_warni...more >>

Hi, We have our SQL Server 2000 Ent. Ed. SP3 set up to use Windows authentication from a Windows Server 2003 domain controller running Active Directory in Windows 2000 compatibility mode. From the office, everything is hunky-dory. However, we have many employees that need to connect to th...more >>

I get the following error after trying to do update to an Oracle 9i table from SQL Server 2000. : The operation could not be performed because the OLE DB provider 'MSDAORA' was unable to begin a distributed transaction. Any ideas to solve this? ...more >>

Experts Please reply I am developing MDI parent with multiple child forms. All the child form would have only database records. So I need SQL Connection to connect the SQL Server 2000. Which is the best procedure to connect the database. Either connecting the SQL Server while starting the ...more >>

Is there anyway of connecting to a remote SQL Server other than via a VPN. The remote SQL Server has a connection to the internet via a firewall which has a static public IP Address. Thanks LC...more >>

for the past few days, SQL Server 2000 ( 8.0.0.936 ) has been using aup all the threads in the database. During the night when web traffic slows it releases some but not all of the threads. What causes SQL to keep grabbing threads at an alamring rate, then never release them? What ca...more >>

I need some help. I have to connect from external network to MSSQL server. There is no problem to conect to first (main) instance of SQL (just forwarded port 1433 on firewall). But another instance is using port 1033 to exchange data (I am guessing). I am trying to connect via MS ACCESS. Ho...more >>

Hello, How can I select IP address(es) for listening of MSSQL on server with two (or more) nics? Thank you for ideas. Pavel Balus ...more >>

Hi there I have a large union query that produces a "timeout expired" error. I've changed the timeout settings to 600 seconds but I still get the message. My query and underlying database are characterized as follows: a) two fairly large database tables (1.5m and 0.7m rows respectively) ...more >>

Hi, I'm having problem with a workstation connecting to the Server's SQL Server. The workstation can access the server's hard drive via share and TCP/IP seems to be working. But the workstation just can't access the server. how to tack it down? Thanks. ...more >>

Are there any standard things to check for when using SQLServer with JDBC and tomcat/java servlets? We have an application with an unreasonably large memory footprint. The java programmers swear it is an SQL Server memory leak. I can't see a similar problem when we use other methods to access ...more >>

Hello, I am using a front end VB application to connect to sql server desktop engine. Connecting to the (local) server work perfectly. However, I need to connect to a sql server on a machine on my network that is also running the sqlserver destop engine and access a database on that computer...more >>

Hi, I am struggling with what surely should be a very simple process. I am simply trying to establish a basic linked server connection to a number of foxpro dbf files. What is the required syntax within Enterprise Manager for both the ODBC version and the OLEDB version?. I have tried ...more >>

How does a File DSN locate the server specified in the file? I am trying to find out if it used DNS or WINS. As I am hoping it is DNS as I can then add an alias to redirect the cilents of an application, rather than having to change the dsn on all the client pc's....more >>

Hi all, heres my problem. I have written a C# ASP.NET app that uses SQL Server, everything works fine locally. To simulate a remote connection to SQL Server I tried the following connect string... myConnection = new SqlConnection ("data source=xxxx,xxxx,xxxx,xxxx,1433;Network=DBMSSOCN;In...more >>

Hi everybody, I'm a newbe on SQL Server; Here my problem is: In Server Explorer I create a Data Connection to Nortwind. After Creating the connection I can reach tables of this database. But: When I want to configure the dataAdapter the problem occurs: In the configure wizard "Data So...more >>

I am using a VB6 frontend to a SQL server 2000 backend. What is good coding and development practice with regards to when to open/close any database connections? I am using ADO. Do you always close the entire database link each time you close a recordset, or only at the end of the application...more >>

We encounter the 'Protocol Error in TDS Stream' error in Excel that connect to SQL Server 2000 (SP3) with MS Query. We later found that this occurs when the user select too many fields from the MS Query Designer. Interestingly, we later found that this can be fixed by enlarging the 'Networ...more >>

Hello, I'm trying to import a table from a MSDE database (databaseB) into a SQL server database (database A). Using to following sql statement: insert tableA select a.* from openrowset(sqloledb,'Provider=sqloledb;Password=pwd;User ID=usr;Initial Catalog=databaseA;Data Source=server', se...more >>

I can't use Enterprise Manager - I've got a cable connection and Comcast blocks port 1061 which EM uses. Anyone know a browser-based alternative to EM (preferably written in ASP)??? Thanks! -Bill. ...more >>

HI , My application is working fine with SQL Server 2000 ; but when I change the back end to Oracle 9i it gives an error "Invalid attribute/identifier" . Any help would be appreciated . Thanks , Sujay ...more >>

I have a Windows Server 2003 Standard that I have installed MSDE with SP3a on. This server is running only as a file server on a workgroup, no Active Directory, DNS, or DHCP servers are running. I can connect to SQL locally with no problem. When I tried to connect a Windows 2000 workstation at...more >>

Hi, I am using SQL Server 2000 on Windows 2000 server. Here is my problem: @String = 'word1word2word3word4word5' - This value is passed to Stored Procedure from the script. Column1 in a table1 has many rows with "words" . One row in this column1 will have 'word3'. Notice that this 'word3' i...more >>

Database: SQL Server 2000 Developer Edition SP3a Frontend: MS Access 2000 and Access 2003 A Custm-built Medical Records Database I am having a problem connecting to my SQL server with certain ODBC drivers (sqlsrv32.dll). But it only acts up on certain "forms" in the Database, in particular ...more >>

Plesae excuse if I make any howlers here, I am on the steep part of the curve. I have created a link in SQL to an AS400 but cannot create a view to it in Access ADP. The SQL that I am using is 'SELECT fieldname FROM as400sver..dbo.linkedTableNAme; the error that I get when I try to save/...more >>

Hello, I need help :-)) We use an SQL 2000 Server. in the Systemmanager one Prozess with PID is sleeping, no databese context, and I can not cancel the Prozess. When i try to update some Data, this Prozess ist Blocking all other. How can i cancel this job without reboot the server. T...more >>

Hello, I have sql server 2000 on a XP/SP2 machine.. with XP firewall active. But I cannot connect to sql server. I receive this message "Unable to connect to server xxxxxx: SQL Server does not exist or access denied"; or Login failed for user xxxxx. With QA same problem... I created the ...more >>

Hi, Can anyone help us in letting us know that while inserting records through VB to SQL server it takes very long time even to insert very few KB of data which previously was happening in seconds is now taking hours.!!!!!!!...more >>

When executing this from Query Analyzer on server1, where the target is located, restore database restoretest from disk = 'd:\backups\dottietest.bak' with move 'vam_system_data' to 'd:\vamdata\sample\vamsystemdata.mdf', move 'vam_user_data' to 'd:\vamdata\sample\vamuserdata.ndf', ...more >>

I have an ASP app I am trying to implement which is giving me some weird results. The environment is a Windows 2003 Domain. The IIS Server is Windows 2000 SP4, SQL 2000 is running on a Windows 2003 server. I have an ODBC connection setup to a database using SQL Authentication. If I log...more >>

Hi: I am getting this error when the .asp page tries to connect to the DB server. Microsoft OLE DB Provider for ODBC Drivers error '80004005' [Microsoft][ODBC SQL Server Driver]Timeout expired The web server is Windows 2000 Advanced Server, Dual CPU with Hyperthreading, P4 with 2 GB R...more >>

Is there a way to create the login id after the database backup with users was restored into this new SQL Server. The problem is that I am trying to create the login id for the user that owns practically all the database objects. So I can't drop that user to execute sp_grantdbaccess after cre...more >>