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 >>