Hi. I am getting started using SQL. My primary objective is to be able to write ANSI SQL statements at a high level, outside of a certain platform. I am using the book SQL A Beginner's Guide by Forrest Houlette. To get started, I downloaded the Microsoft SQL Server 2000 Desktop E...more >>

After doing an disaster recovery test the sql services aren't running. When i open the enterprise manager the instance is there but no databases. All databases are recovered from tape How can i solve this in proper way? THX...more >>

I have a WinXP Pro system with Visual Studio .NET 2003 installed, with MSSQLServer running. Events log contains various successful messages but also a warning message: event ID 19011, description 'Supersocket info: (SpnRegister): Error 1355'. The Help and Support Center has no further info...more >>

I have a Developer copy of Sql Server on my XP workstation, which I use to access the Domain server's Sql Data and a local (name of my workstation) set of practice data in a seperate sql server registration. If I change my password on the domain, I can no longer connect to the local server. ...more >>

Hello, I am getting the following errors when I try to connect to SQL from a SQL server: Connection Failed. SQL State '01000' SQL Server Error:10061 [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets] ConnectionOpen(COnnect()). Connection Failed. SQL State '08001' SQL Server Error:17...more >>

hi I am trying to connect from win2000 server to xp machine after 6 to 7 seconds prompting timeout.can any one help. Pardhi -- Message posted via http://www.sqlmonster.com...more >>

Hi, I met a problem in linked server is that I have 2 sql servers A & B, I create linked servers from A to B and from B to A. When accessing in A, I can retrieve records from B through linked server, but when reverse, cannot access. The error returned is just like that the query is looking ...more >>

I'm a newbie to SQL server. I've got my development environment up an running just fine. I'm creating a web application that accesses some of my own web services to interact with the SQL Server database. Everything works fine "WHEN" I have my laptop hooked up to the internet. If I don't h...more >>

We have a multiple clients that do have all cients of different clients. We would like to connect to SQL Server running on a WIndows 2003 Server. We use Windows Authentication. According to Microsoft: "SQL Server clients running on Windows Millennium Edition, Windows 98, or Windows 95 comp...more >>

Hi We have an access app (both front & back ends are in access) that runs over win server networks. There are now more and more users who would like to take away a copy of app with them, work offline, and when they come back expect the client copy to sync (both ways) with the server copy. Seem...more >>

Hello, is ther a way to connect to the command line for MSDE. I want to export data from the MSDE database with a command line script! How can I accomplish that??? Thanx, M.J. ...more >>

I am performance testing some batch processing engines. These are written in ..NET and SQL Server and are typically concerned with generating XML files out of data retrieved from the database. I have two machines one running IIS Server and the other SQL Server. Problem Description: One...more >>

Hi there, I got the follwoing Setup: Server: Windows 2000 Server (SP4) with SQL 2000 SP3a Clients Winows 2000 Prof. and Office 2000 (all have the latest MDAC installed) I try to open a table in Access 2000, I get an error message (I have german versions, so I hope I got them right ): ODBC...more >>

I have a VB.NET application which connects to SQL Server using ADO. The problem I have is that I need the application to detect if SQL Server has not yet been installed on the local machine and if so give the user the option to run the MSDE installation. When connecting I get get the "SQL Se...more >>

I was going thru Enterprise Manager and can't see connection count, I can see User connected, but that doesn't give me an actual connection count. Is there a way to determine my connection pool count from Enterprise Manager and/or some other tool? Thanks, Rob. ...more >>

We have an application that uses the BDE from borland to connect to a SQL 7 server using TCP/IP. Becuase of changes in the SQL 2000 client driver that are incompatible with the BDE, we have not beeen able to upgrade to SQL 2000. We are considering upgrading the server and leaving the clients usin...more >>

Hi, Could you help me modify the SELECT statement below that would accomplish my final goal. SELECT col1, col2 FROM table1 WHERE col3 < @V In col1 rows have many duplicates col2 has unique values col3 can have 5 possible values: 5, 10, 15, 20, 25 Variable @V can be equal to 5 or 10 or 15 o...more >>

My clients are reporting they cannot connect to the msde database using my application - generic failed to connect message. My software application installs the MSDE. Their computer is a brand new machine with XP-sp2 installed. The sp2 is not an upgrade. We have only seen this phenomena wi...more >>

Hi guys, I've been searching the archives for the answer but I have found none, so I've decided to post. I've written a vb.net app that: 1. creates a SQLConnection object. 2. opens a connection via this object. 3. execute a query 4. closes the connection via the SQLConnection object. 5. d...more >>

Hello, I have an application that use SQL server 2000, (the conexion is not by nt autentification) I need to know what is the current windows user. Any help will be appreciates. Thanks Diego ...more >>

I have a SQL server running on a Win2k Domain Controller set for Windows Authentication only. I have a Windows 2003 Web Edition server that is a member of the domain. When permissions are correct I can open and update databases on the server from the Web Edition server. I want to allow anyone...more >>

In Microsoft access , Im using local tables or report tables to create a repor that I manipulate from the Main database which is a Access database also, how I can make a report for SQL Server database...more >>

Help!! I am attending a college course and attempting to install SQL Server 2000. I keep getting this error: Snap-in failed to initialize. Microsoft SQL Enterprise Manager CLSID 00100100-1816-11D0-8EF5-00AA0062C58F I am not trying to log on to any server. I need to setup this program on...more >>

Hi I have SQL 2000 server Sp3 on my network, i want know if is possible obtain major information from log file, i.e. if a user loggin to db i want know the time/date to login, operation excute etc. Can help me please Tia Pupo ...more >>

I am running MSSql 2000. I have two different databases on two different SQL Servers. I am in SQL Query Analyzer. Is it possible to Query data from the two servers / databases? If so, In SQL what is the correct syntax. Jim ...more >>

Hi, My problem is I have an app that uses MSDE 2000. After the install, it asks for the name of the local database instance where you would like to install the app. It only gives me one option, 'localhost'. I can use an OLEDB provider to specify the actual server name but I cannot connect...more >>

Hi Folks! I am trying to use 1 computer running XP home networked to a machine using XP Proand SQL Server (Desktop Edition from Developer) on 1 other computer. My MSACESS ADP refuses to see the SQL server even though I can do file shares/printer shares between the two. Is XP home or Desktop SQ...more >>

Is it possible to load out an older version of MDAC i.e., 2.6 sp 2 on an XP box which has 2.7 or 2.8? Can the two co-exist? ...more >>

I am new to the forum and have a question. I would like to monitor the SQL Server 2000 to make sure that it is running fine. Sometimes our server couldn't be connected even the server is running. I have to re-start the SQL Server in order to solve the problem. I am not sure why does this h...more >>

Hi all, I am running SQL Server 2000 desktop edition with SP3 installed, XP PRO with SP2 installed. I am attempting to install the ASP.NET Commerce Database from the MS ASP.NET start kit. The only database server instance in the dropdown is localhost and the test connection fails. ...more >>

SQL Experts, 1. I have two Windows 2003 Standard Server boxes. 2. Both host MS/SQL Server Standard 2000. 3. Server#2 is linked to Server#1 using SQL/Enterprised Link Server applet. 4. Both servers have Win2k3 Service Pack#1 installed. 5. Both server enable firewall via SCW (Security Config. W...more >>

If I understand correctly, the TIME_WAIT Status when you do a NETSTAT on the server indicates that the connection has been closed, and it is waiting to clear. Is that right? If so, we have a lot of SQL Server connections that are in TIME_WAIT status mode. We may have well over 100 or so of ...more >>

I receive the following error when I try to query an Exchange database. Server: Msg 7403, Level 16, State 1, Line 1 Could not locate registry entry for OLE DB provider 'exoledb.DataSource.1'. OLE DB error trace [Non-interface error: Provider not registered.]. How do I registry the OLE p...more >>

We are running Windows 2003 and MS SQL 2000 w/sp3. Contractors came in and installed SQL and databases on a RAID 1 disk volume. We want to move the all the databases (about 4) to a RAID 5 disk volume. Can someone tell me how to do that. Will there be any downtime while moving the DB? Any ...more >>

We are having an intermittent connection problems with some DTS packages. We get the following error about 1 out of every 15 days Login failed for user '(null)'. Reason: Not associated One DTS package connects to remote SQL servers with a linked server, another package uses a OLE DB provide...more >>

Hi, My name's Arnaldo and I'm from Brazil (so please forgive me for the poor english). We use Windows 2000 Server (SP4) with SQL Server 2000 (no SP). We've been facing a problem for some time now: on January 28th, our system stopped responding for some reason. When we passed the mouse over the...more >>

Hi, I am trying to connect a web service to an SQL Server 2000 database. SQL Server is installed and started and the database appears on the Enterprise MAnager window but it does not appear in the Server Explorer in VS2003.NET IDE window.It gives the error "Server does not exist or access i...more >>

when trying to open server group...sql is not known to be running would you like to connect? error how do i configure that error? -- chunky...more >>

I am running SQL server 2000 service pack 3 on a windows XP professional service pack 2 machine. There are four developers using the same configuration. All of us have missing connections in the DTS designer. All that is available are the following: Microsoft OLEDB provider for sql server ...more >>

Do you guys have any idea if web hosting companies usually give access to SQL Server databases through Enterprise Manager? I used to have have access to my DB through EE with my previous provider and now the more I am looking into offers on the net the less I can see this feature specified. ...more >>

Login Problem: Trying to log into a 2000K SQL Server using a windows user account when not logged into the domain. Is this possible? Example: Domain Account is : aaa Password is: password Domain is: domain1 On the Server Box1 have a windows user account called : \domain1\aaa w...more >>

"The unforgiveable sins this earth must confront and overcome are Nationalism, capitalism, and hoarding. The idea of every nation should be forgot, price should be struck from the commons, and princes should be seen for the devils they are. The sins include our church, secret societies...more >>

I have a SQL server running on a Windows 2000 Server SP 4 and I am having problems connecting to it. When I attempt to connect to the server using integrated security as a user in the local Administrators group on the server I can connect just fine. When I attempt to connect to SQL server us...more >>

Hello; I tried almost everything I can, give permission to ASPNET to the folder application, start and restart ASPNET, SQL$Server, checked my sqlstring connections in the global.axp.vb and still cannot connect to the database. I am using MSDE (Free engine from microsoft), Can someone please he...more >>

my sql server is not in local network.. it is in remote network... and its ip , username and password is true... coz i can access it from enterprise manager from my local sql server... i looked at my permissions.. from users in my database ... in my dbo public and db_owner permit checked......more >>

i tried link to sql server db from access and i failed.... (What is my fault.. I think It doenst ask me catalog -database name so it doesnt accept my username and password..It cant find my username and password which database has it ..) i follewed these steps... 1.right click and link ta...more >>

I'm trying to track down why some workstations are have performance problems. Both the "good" and "bad" workstations are running the same EXEs and using the same MDAC rev. We're connecting with ADO to SQL Server 2000. Both are connecting with Windows Authentication. Looking at the networ...more >>

I keep receiving an SQL error. Not everytime but frequently. Does anyone know what to problem could be? This is the error i recieve: Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and ...more >>

I am trying to upload data to my sql database via a web service installed on the same machine as sql server. When my upload takes more than about 2 minutes I get a timeout error message from my web service and the data tranfer was not completed. Transfers taking less time complete satisfac...more >>

I have four instances of SQL server running on my Server 2K3 Small Business Server, they are the default instance, SBSMONITORING, SHAREPOINT, and SANDBOX. I am able to connect to the default instance and the SBSMONITORING instance from a remote computer. When I try to connect to the SHAREPOI...more >>