We have a legacy Java application that we maintain in Visual J++; we are moving to SQL Server 2005 and would like to switch it from an old WebLogic JDBC driver to the new Microsoft SQL Server 2005 JDBC Driver. However, we're noticing strange behavior with regard to instantiating the "com.mi...more >>

I will try to describe my problem: I need 3 workstations to work with one, the same database file (*.mdf) at the same time. My idea is to install MS SQL Server 2005 Express engine on all 3 workstations and connect each of it to this file placed on linux server. Is it possible? I tried to c...more >>

Hi I am getting a VDI Error 80770004. Does anyone know what that error means? Thanks, -Steven Cook ...more >>

I have 2 instances on a remote machine: - SQL Server 2000 - default instance - SQL Server 2005 Standard - named instance called: SQL2005. I am able to connect to SQL2005 from within the remote machine itself (loopback). I am also able to connect to the SQL 2000 engine remotely (remember ...more >>

Hello, In SQL Server Query Analyzer how do I make a select from a table in Microsoft Access 2003 database. I want to insert into 1 table, data from tables in my SQLServer database and from tables in a Microsoft Access database. Thanks for any help on this question, Joao Rego ...more >>

We have designed a thick client accounting system using Microsoft Access 2003. The thick clients connect to MS SQL Server 2000 or 2005 via ODBC. This works well in a LAN environment. We have customers that want us to connect their many branches together now. These branch offices are located ...more >>

Hello all, I appologize in advance if I posted in too many, or the wrong newsgroup. A client of mine contacted me earlier regarding an issue they are having with their MS SQL server. They use SQL mostly for timeclock entry for employee's entering and leaving the building during the start ...more >>

Hello, within my network, one laptop get installed MSSQL2005, all services are activated, network configuration as follows: shared memory -- enabled named pipes -- disabled TCP/IP -- enabled VIA -- disabled For TCP/IP: Protocol: yes IP Adresses: ======== IP1 : enabled = yes ...more >>

The below works perfectly in SQL 2000. I have setup a Linked server to Navision 4.01 with a OLE DB provider for ODBC. I get below errors when I do the following: EXEC sp_addlinkedsrvlogin 'nav4', 'true' Select name from openquery(nav4, 'select navn from country') Msg 7399, Level 16, Sta...more >>

Hi, I'm unable to uninstall the SQL Server 2005 -Dev Ed. completely,tried removing from the Add/Remove Prgms.I've removed SQL Server supporting files,BOL,.Net Framework 2.0,and other SQL related programs from Add/Remove Prgms. But,the SQL Configuration tools->SQL Configuraion Mgr,SQL Surfa...more >>

What is the proper connection string for SQL Server 2005 Express on XP? I want to connect to the master database by VBScript as the following: Dim computer : computer = CreateObject("WScript.Network").ComputerName Dim connectionString:connectionString = "Provider=SQLOLEDB.1;Integrated Security...more >>

Good Afternoon, I Want to consult if is possible read the Log File (LDF), because I Need to Know What movements have had the DataBase is diferents Tables. Thak for you help Felipe Bolívar Restrepo ...more >>

Hello, I've been running a copy of SQL 2000 under Windows 2000 server. I have two admin's both running enterprise manager from their windows XP Prof workstations. One admin has no problem. The other admin's workstation, whenever sql enterprise manager is run, tries to log in to the w...more >>

I continue to get syntax errors. What is the command line for "List any titles that do not have a price assigned" and list each title with its current cost and with the projected cost increase of 15%"? ...more >>

Hi, The SQLEXP service is not running and when i try to start it,i get the following error, ERROR:The request failed or the service did not respond in a timely fashion.Consult the event log or other applicable error logs for details. Any help on this would be appriciated. Regards, S...more >>

This is my first venture into MS SQL Server hence the basic question. Can I use Windows Authentication in a Workgroup (i.e. XP Pro and Simple File Sharing)? When I try I get the infamous "Msg 18452, Level 14, State 1, Server RS02-2006, Line 1 Login failed for user ''. The user is not associate...more >>

Does anyone know how, if possible at all, to modify the application name that appears in the Activity Monitor(Sql2K5), Current Activity(Sql2K) or sysprocesses table. We have multiple C# applications connecting to the same db but it is becoming hard to determine which application is using wh...more >>

I have attempted to create a linked server on Server1 to an Access db on Server2. These servers are located on the same network. The account running the SQL Server services on Sever 1 is a domain admin account I can open the file via explorer across the network using the same services accou...more >>

We can only connect to only 1 instance, either the default localhost or the named instance from another client. For example on my computer the other client can connect to the localhost and the other instance name such as server\instancenames cannot be connected. On the other computer that ...more >>

Hello I have just got the trial dvd for Visual Studio 2005 Professional When trying to make a new sql server database, I get an error box:- ******************************************************************************************************** An error has occured while establishing a c...more >>

I just installed client tools and when I use the QA it will hook up to the Database just fine, but if I go to the file menu, it locks up. Any ideas? ...more >>

I have a situation that I hope someone can give me a good answer to. Please bear with me as I try to explain my needs. My goal is to have an Excel spreadsheet that pulls from a SQL database and the the query pulls from a variable in the Excel sheet. For example let's say I am pulling Sale...more >>

for some reason when i deploy my C# application on windows 2003 occasionaly rdr[0].ToString() hangs where rdr is a System.Data.SqlClient.SqlDataReader. Is there a fix for this? is my visual studio.net out dated? ...more >>

Sometimes when developers try to access to the SQL Server by Enterprise manager they get an error "A connection can not be stablished to (local) Reason: General network error. Check you network documentation. ConnectionWriter (WrapperWrite ()). Please verify SQL Server is running and chec...more >>

hi, I am having problems connecting to a new SQL Server 2000 server via IPX. in answer to the inevitable questions as to why we are using such an outdated protocol the application in question is running on industrial ruggidised handheld devices running DOS. as such we cannot use a tcp-ip clie...more >>

We are running automated tests that intentionally drop all the connections to the database and make them again. If the tests run quickly, we are disconnecting and connecting very frequently. We notice that after the connection is closed (this is through the JDBC driver, but I'm not sure that...more >>

I have MSSQL2K SP3 running as a back end for WSS. After rebooting the machine the server won't start with an log error below when I attempt to start the service. Please help! ========== 2006-03-20 17:07:07.12 server Microsoft SQL Server 2000 - 8.00.2039 (Intel X86) May 3 2005 23:18...more >>

Does anyone have any idea why it's impossible to create endpoints in 2005? I've tried this on 3 different installations of SQL Server 2005. No go. This is just a sample... copied from the MS virtual lab. Msg 7850, Level 16, State 1, Line 1 The user 'DEMO01\Admin' does not have permission ...more >>

I have a new install of SQL SERVER 2005 on a new machine. When I am using Visual Studio 2005 Server Explorer "Add connection" dialog or MS Access ADE Connection "Data Link Properties", there is no (local) entry in drop-down "server Name" list. However the actual server name is listed and I ...more >>

Hello, everyone, I am trying to connect to a SQL server db with a C# app and when I debug I get: Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection. Description: An unhandled exception occurred during the execution of the current web request. Ple...more >>

I have attempted to establish ODBC connections w/ the Microsoft SQL Native Client Version 09.00.1399 (from 2 different machines) and get the following error: Connection Failed: SQLState: '08001' SQL Server Error: 1326 [Microsoft][SQL Native Client]Named Pipes Provider: Could not op...more >>

Hello All, We use MSDE SP3a and are having a strange problem. We have an ADO-based application that fails depending on the domain that we use to login to the machine. It works if I login to DOMAIN_A but it fails to connect to the server if I am physically logged in into the DOMAIN_B. In b...more >>

I am trying to connect to a SQL 2005 Database from VB 6.0. If I use windows log on all works well. If I try to use SQL server logon I always get this error: (Login failed for user '<LoginName>'. Reason: Not associated with a trusted SQL Server connection) I have setup many users in the Serve...more >>

Good morning everyone, How can I connect set up a TCP/IP connection to a SQL Server 2000 without using MDAC?? Thank you Corinne ...more >>

Hi, I just started to used Sql Server 2005. The first thing I wanted to do was connect to a Sql Server 2000 database. I keep getting timeout errors. So my first question is - is it possible to have Sql Server 2005 talk to a 2000 database? If so, are there any tricks to making this connectio...more >>

where can i find resources on how to connect from C# 2003 to SQL Express 2005?...more >>

I have installed SQL 2005 and just done a normal install. I have opened Server Management Studio and try and connect but I get the error; ....this failure may be caused buy the face that under the default settings SQL server does not allow remote connections (provider: TCP Provider, error: ...more >>

Hello, We are fairly new to SQL Server and and hope someone can help us. From SQL Server we need to link to FoxPro tables in the accounting (SBT) system. We started to setup a Linked Server but didnt get very far. For example if we wanted to link to a FoxPro Product table called PROD we would ...more >>

In Query Analyzer I am creating a Select statement using temp tables. For a simple example: Select abc.def into #tmptable from ABCTable. If I make changes to the query and then rerun it, it tells me that the object (which is the temp table) already exist in the database. I have to clos...more >>

Strange thing. I have four windows XP clients that connect to a SQl server 2000 to use my programs. These are standalone applications that run in background (telephony stuff). All of a sudden they stop being able to use the sql server, I have a connection test button built in and they can't ...more >>

Hi, I am trying to connect a MS SSIS package to an AS400/DB2 database, and I experience problem when I hit the "Create Package" button in the "Data Link properties window". I have understood that the packages need to be created, before I can run any SQL on the DB2 base via SSIS(?). Here are the...more >>

Hello everybody! :-D I have a pretty basic standalone SQL 2000 SP4 and it is serving a CMS and an IIS on the same box. I can telnet my server on port tcp 1433 and the telnet window clears and the cursor is blinking in the top of the command window no matter where I try it. This leads me to ...more >>

Hi, I'm connecting some clients via Internet to a named instance of SQLServer (port 1433). All the clients conected to internet via DSL works just great, but all the clients connected to internet via an cable ISP, just can't find the server. I saw some of the cable ISPs block the 1433 and ...more >>

Hi, Sql 2000 SP3a, Windows 2000 Enterprise, SP4 I've extensively searched through most means (google, microsoft, newsgroups,etc) and really haven't found a definitive answer. There really isn't any real answers. I run an ASP and most clients on one of the production servers are experie...more >>

This code works fine with VS 2003, but when run in VS 2005 with SQLServer 2005 it reports error. Does anyone knows why??? Public Class BLL 'WSB Bussines Logic Layer Private mDAL As DAL.DAL Public Sub Init() mWsbDal = New DAL.DAL mWsbDal.Init() End Sub ...more >>

In a windows service (.NET) on unplugging network cable it use to loose connection to oracle database. Once the network connection was up it was found that the service was unable to restore its connection to oracle database. The conclusion that we drew after doing R&D was that, the connectio...more >>

Why I can't make change account from Log on tab in properties MSSQLSERVER service? Regardless of account, I gett this error: "Could not start the MSSQLSERVER service on Local Computer. Error 1096: The service did not start to a logon failure." SQL Server does work only with Local system acc...more >>

Dear All, I'm really confusing while reading the connections Issue in the support knowledge. Our Company website guest users can register themselves in my website. The data goes to the SQL Server database 2000 which also used by internal users of my company as Inhouse Database. So I wa...more >>

We are running into a strange problem here. We have a web application running under .NET 1.1 that connects to various SQL Server instances identified through a series of System ODBC DSNs set up on the web server. If the SQL Server is running on a regular standalone server, we can connect wi...more >>

Hi all, I have tried installing MS SQL server 2000 on windows 2003 many a times. I get an error - " Setup Failed to configure the server". The resolution mentioned in this url http://support.microsoft.com/default.aspx?scid=kb;en-us;816499 did not help. Please let me know what is the cause...more >>