Hi, i have several questions, because i'm quite new to SQL-Server and Access Projects. Till now i only worked with Access.MDB's i created a new access project and have my database on SQL-Server. I see all tables in my access-project and can work with them. Now i need data from 1 excel file ...more >>

Hi all, Something that should have been straightforward turned out to be rather problematic. Thankfully this is only a test machine. SQL Server 2000 Dev Edition on XP Pro. I detached a [BLAH] database file with Enterprise Manager, deleted the corresponding BLAH.MDF/.LDF files, copied newe...more >>

I have recently installed a MSDE 2000 (unfortunately with no service pack yet) on a Standard Windows 2003 server. I have used the srvntcn.exe utility to make the MSDE server listen on TCP/IP port 1433. But it will not listen on that port! Or any other TCP/IP port!! There is no information in the ERR...more >>

I am trying to connect to MSDE 2000a server over the internet. I have check and open the ports on my router pointing it to my server (1433 & 1434). But I am still not able to connect. (Check log and port is 1433 Does anyone know what I can try or do to resolve this problem (I have all the latest p...more >>

Can somebody please send me a link or reference on how to configure a website using IIS 6.0 to connect to a SQL on the backend? Thank you....more >>

i have just been informed we are running MSDE, not the full SQL server. i am running the OSQL service that comes with it, and looking through the information i have found so far. still if anyone knows what i should be doing it would be greatly appriciated as i have spent too long on this ...more >>

I am running SQL on our network to use a program called BSquared: Connecting Steps. this program stores information on a database on the server and uses SQL to access it. when running the program on an administrators profile everything works fine, however when i attempt to run the progr...more >>

I have installed MSDE 2000 on an XP Prof. box. I am able to connet to this instance locally from the server, but when i try to connect to it from other machines, i get an error stating Server does not exist or access denied I have traced this problem to msde not listening on port 1433 on my ...more >>

When running a job under SQLAgent we have intermittently received the following message: ConnectionCheckForData (CheckforData()). [SQLSTATE 01000] (Message 10054) General network error. Check your network documentation. [SQLSTATE 08S01] (Error 11). The step failed. The job had been r...more >>

Hi, I have a 24Gb database with half a dozen indexes against various tables which is failing during the reindexing task (as part of the maintenance plan) at least 80% of the time. The error given in the logs is: "[Microsoft SQL-DMO (ODBC SQLState: 01000)] Error 0: This server has been di...more >>

Hi, I want to know what is the name of the manager used in MSSQL Server 2000 that queries a database through a proxy. The name of that manager in Oracle is Connection manager....more >>

Succesfully created a MSDE 2000 rel A backend on 2003 server. I can connect a MS Access project frontend to it from an XP client on the same LAN segment. I can connect the same frontend over the internet to this server when set out in the firewall's DMZ. And now for my next trick! When I...more >>

We have an application that requires bi-directional data transfer between 2 SQL servers. To ensure the data transfer is encrypted, we are considering to use SQL server SSL encryption. However, the problem is for this case, each machine is acting as both client and server for SSL encryption. So i...more >>

Hi all! I have a serious problem....(Who doesn´t...;) I have a SQL Server 2000 and a Oracle 8.1.7 Database. I have set up a number of views in SQL Server that are populated via a linked server connection. In almost all cases this works great, but for one view. The view displays OK, BUT one ...more >>

hello all.....i'm got a little problem here...i hope youu guys can help me... ok...first, i'm using asp.net for my web application. when i run it in my own server, it's ok....got nothing problem with connection to my database(in the same server) but...when i'm bring it to my web server wi...more >>

My connection from a web page to my SQL Server was working when my connection string is: ....Trusted Connection=no; uid=sa; pwd=sapassword;" It stopped working when I change it to: ....Trusted Connection=yes;" I get this error message: Microsoft OLE DB Provider for SQL Server error '80040...more >>

When running .Net apps against a local SQL Server (2000, SP3) I get the following error Connection failed ConnectionOpen (PreLoginHandshake() Connection faile Encryption not supported on SQL Serve Any help will be greatly appreciated Thanks...more >>

I have a project with two SQL servers on two seperate subnet, following distribute query will run on B server. update [xxx.xxx.xxx.xxx].[abce].[dbo].[abcede] set uploadstatus='InProgress' If I include this statement in Transaction Like this way: Begin Tran update [xxx.xxx.xxx.xxx].[ab...more >>

We were having problems with our SQL Server so we rebooted it and when it came back up it was listening on a different port. Does anyone have any idea on how this could happen? Thanks Kris Bilou...more >>

I am have a problem which has only just started happening while trying to connect (locally) to MSDE 2000 (SP3a) which also prevents me from using VS.NET Server Explorer. When I try OSQL -E -S mimpc\NetSDK (this use to work) I get the following error [Named Pipes]SQL Server does not exist...more >>

We are writing a setup program for a customer that requires a MSDE installation. Using the following flags for the MSDE setup.exe: SAPWD = "password" SECURITYMODE=SQL The setup complete successfully, we are restarting the installed machine (SQL services restarts as well) But we cannot connect ...more >>

Getting error "msde log file is full, back up the transaction file for the database." I do not know how to clear out the log file for msde? Any help is greatly appreciated. Thank you very much...more >>

I just added an xpclient to our network. There is a Win 2000 server running win 2000 sql server on the network. All client machines access the server for database access, to a Visual Foxpro Application. When i try to connect to the application i keep getting the following error: Unable to...more >>

Hi, Can anyone offer any advice on exactly what I need to do to make a remote MS SQL Server connect to and view the contents of my Active Directory?? I've tried pretty much everything: MS SQL Analysis Services 3rd Party Pluggin's ADSI etc All with no success so any furth...more >>

When I opened em this morning, I immediate got an "A connection could not be established to (local). Reason: cannot open user default database. Login failed. Please verify that your sql server is running and check the properties ..." dialog box Yes, its running, and no, I cant check the properties...more >>

This is when using SA account trying the SQL Query Analyzer. I get the error Msg 17, Level 16, State 1. I can locally connect fine on the server itself using SQL Query Analyzer. I'm using SQL Authentication. When trying to connect I get: Unable to connect to server (name of server) ...more >>

It is now 3 months that we are trying to connect ASP.NET to a SQLServer located on another system However we act,we get a fatal error We need someone to explain the way of connecting to SQLServer step by step from either VisualStudio.NET or FrontPage 2003 Our goal is to retrieve records from SQLS...more >>

Hi, I have setup a linked server to a text file uing the MS Jet ODBC driver. Users that are not sysadmins and local admins on the server that the file resides get an Jet Initialize error message. What are the permissions required for SQL Server users to gain access to this file? Thanks. ...more >>

I have a VB application that uses SQL 2000 SP3 as its DB. The problem I am having is the remote connection using VB apps running on a XP SP1 Pro. The only way I have been able to get the VB app to connect to the SQL remotely is to create a local account on the XP system with no password....more >>

Hi I am running Win2k Server on an XP machine. I have two databases which I can run programs on with no problem. I can connect and run queries through Query Analyzer with no problem, but when i open Enterprise Manager to access the Databases, the DB service stops and then I get the mess...more >>

I have SQL Server 2000 running on a Windows 2000 Server. I have Outlook (from Office 2000) installed on the server and set a mapi profile for using SQL mail. This configuration is running ok. I once tried to install Outlook XP but since it was not a mapi-compliant client that configuration didn't...more >>

don't know if this is the right place, but anyway... trying to connect remotely to a mysql database hosted on windows 2003 remote server. Can connect locally but not remotely. Excluding db server setup is there anything on the server that could be blocking? How would I check to ensure po...more >>

Hi I'm trying to establish a connection to Sql Server from an asp page using a System DSN I setup the System DSN to use Sql Server authentication; the userid and passwor were stored with the ODBC configuration utility. Sql Server is configured to used both Windows and Sql Server authentication ...more >>

Hello, I try to register a remote SQL Server 2000 installed in a W2003, but it doesn't work. Afer about 5 or 6 seconds, it says: Timeout expired. In that network , there is not any firewall and port 1433 is open in the router. What it really surpises me, is that I can connect via ODBC to a...more >>

All error message is: SqlDumpExceptionHandler: Process 26 generated fatal exception c0000005 EXCEPTION_ACCESS_VIOLATION. SQL Server is terminating this process. It seldom happened before, but always appeared these days. Can anybody explain why? Any suggestion will be welcome, thank you! -...more >>

I am getting the error "General network error. Check your network documentation. It occurrs when I write/update to MSDE 2000 using ADO.NET's SqlClient classes. It only occurrs when the record reaches a certain size (around 10K, or so) and only occurs in certain environments. Some XP and som...more >>

Hi Everybod How to find about the connected users to the SQL Server....more >>

We connect to a SQL 6.5 server (IP for example 202.64.213.11) on WIN NT using ODBC DSN and / or SQL Client (DB-LIB). Everthing was working fine then the some XP client machines (192.168.0.1 and 192.168.0.3) started giving problems. All TCP/IP connections go thru the WIN 2000 multihomed machine ...more >>

Hello everybody! I've created a DSN from a WIN2K Pro client to connect to a SQL Server 7.0 running on a WIN2K Server with domain controller. The SQL Server authentication mode on the server machine is "Mixed mode" Inside the client DSN configuration I've specified that the Authentication Mode...more >>

We have an ASP.NET 2003 app that accesses a MS SQL 2000 Std. database. = Randomly it returns this error: Internal connection fatal error.=20 Description: An unhandled exception occurred during the execution of the = current web request. Please review the stack trace for more information = ab...more >>

Greetings, My customer is in the process of changing from Oracle 8.0.5 to 9.2.0. In one of there tables there is a field that is defined as a number with no precision, and no scale. When I look at the data in the field I find digits on both sides on the decimal point. The databases usi...more >>

Hallo: Trying to connect to database using OLE DB. Gave the following code: con.ConnectionString="Provider=sqloledb;"&_ "Data Source=ServerName;Initial Catalog=DatabaseName;"&_ "Integrated Security=sspi;Trusted_Connection=yes;" con.Open Getting error message: Microsoft OLEDB Povider ...more >>

Hi, I have SQL Server 2000 running on server (Windows 2003 server). I am trying to connect with ASP.Net Web service which is on my development machine, to which the server responds with "SQL Server does not exist or access denied". The same connectionstring works fine for a windows form ap...more >>

Hi, We linked 2 sql servers and executing stored procedures between the two servers. We can able to execute sql statements with 4 part key from sqlserver1 to sqlserver2 on some databases and cannot able to do on other databases. All settings and users are same in all databases. For ...more >>

I trying to connect to a SQL DB SP 3 using cisco client VPN v.4.01. The VPN is connecting to a Cisco PIX515 with MS IAS as its AAA. On a remote PC running Win XP SP1 logging in with the local builtin administrator account, I can connect to the SQL after I VPN in. With everything remaini...more >>

Hello all, I have this really really strange problem with one of the application we support in Latin America, this is a 3rd party software for accounting that uses SQL Server for it's DB handling, we are using SQL Server Client Network Utility to connect to the SQL, but this morning, the ...more >>

I have a weird situation here... I have a website with asp pages running on windows 2003 server that updates a database running on a sql 2000 server.(The web site was developed using visual interdev and has DTCs) The site works fine when browsed using windows 2000/xp machine. But, when i br...more >>

I am connecting to my database using PROVIDER=SQLOLEDB; I am gettting the error of "Requested Operation Requires an OLE DB Session Object, which is not supported by the current provider" I have MDAC 2.8 and SQL 2000. Has anyone come across this error? Thanks....more >>

I am trying to connect to my SQL server but I keep getting this message: RDS Failed to execute SQL="SELECT * From Users WHERE UserID Like "name"', err=-214012889, Desc="Internet Client Error: Cannot to Server./nRetry? Can someone help me decipher this and give a solution Pleae!...more >>

Hi, I'm using 'sp_addlinkedsrvlogin' in a stored procedure that pulls data from Oracle into SQLserver2K. BOL states that only members of the sysadmin and securityadmin fixed server roles can execute sp_addlinkedsrvlogin. How can I get around this such that non-sysadmin users can use...more >>