Does anybody really know is it possible? We don't want to create a linked database, but we need to make some steps on the remote database, gather some data and then send this data to our main server via IP connection, setting the connection every time when the remote server wants to transfer the ...more >>

All~ I am currently running the most recent version of MSDE and using EM as a front end interface. In EM, I go to look at the databases I had previously created, but receive the message: The connection to SQL Server <server> has been broken. The connection to the SQL Server is broken. Do yo...more >>

Dear Support, I have a question is, if I exiting have a database are using oracle, and now I need do a new integration, and the new integration product is only support with MSSQL database, and exiting I still have same software is using the oracle database, so i cannot totally using MSSQ...more >>

Have a client that would like to convert and upgrade access 97 database over to sql or .net application and host on server at their location. Want to be able to input data from three locations over dsl connection. What would best recomendation be? What type of server would be required? ...more >>

Have a windows 2000 server DC (SP4) with SQL server 2000 (SP4). It already happened 3 times where the SQL service stops. What could be the cause? Below is a list on event viewer. 1. Source: MSSQLSERVER Category: (2) Time: 22:08 Type: Information EventID: 17055 Description: 8128:Using 'xplo...more >>

I have a VB.NET app using MSDE and the SQL-DMO to get a list of available server. I installed a copy of MSDE on the users' machine (this machine did not have MSDE previously so it was a new copy including latest SP3), then installed my app. When I start my app, the local computer name does not ...more >>

I'm trying to connect to a MSDE instance behind a firewall using TCP/IP. I configured the firewall to redirect the 1433 and 1434 ports to the MSDE server but it fails to connect. If I open de 135 and 445 ports it connects succesfully but it's quite risky to expose the server this way, could anyo...more >>

Hi all, Quick question about the ODBC API. Is there a function in the ODBC API that I can call to determine what parameters a particular driver requires? For instance, ODBC Administrator knows to allow you to select, create, repair or compact an MS Access Database; but for SQL Server it offe...more >>

I have a network of WinXP SP1 machines who all connect to SQL Server 2000 SP3 on a Win2k server. When running enterprise manager, most of the computers take at least 4 minutes to expand the database tree. Working on databases (retrieving properties etc) is also painfully slow. On two compu...more >>

Hi all, Running MDAC 2.71 SP 1 Refresh querying against a SQL Server 2K SP3a server and I get this error after the queries have run for about 2 hours (when these queries actually complete it normally takes about 4 hours). Has anyone encountered this error, and does anyone know what might caus...more >>

Hello, I have two issues, hoping someone can help. Issue 1. I have various DTS packages that copy data from Progress Database to Sql Data Warehouse. The ODBC Connection is stable and packages have been auto scheduled by creating a job that is managed by the SQL Agent service to run daily ...more >>

I am trying to create some tables on the pubs database using script and I am getting this error, "[Microsoft] [ODBC SQL Server Driver]Syntax error or access violation". Does anyone know what is causing this?...more >>

Each time a user tries to connect to an application, they keep getting the following error: Unable to create ADODB Connection - [DBNETLIB] [ConnectionOpen (connectionOpen()).]SQL Server does not exist or access denied. This has been happening for the last three days and each time this...more >>

Recently I've been seeing the following error when SQL Server Agent jobs are run. But this doesn't always happen, sometime the jobs run fine. The job failed. The owner () of job xxxxxxxxxxx does not have server access. Any thoughts?...more >>

I Have Three Server , Only One Can't Connect SQL Serve , Another Can Connect SQL Server I don't Know What Happen Who Can Tell Me what can I do?? ...more >>

I have an ASP form created in FrontPage on an XP client that connects to a "remote" SQL database hosted on a Win2003 server. Connection tests, field mapping etc. all indicate OK. When I fill out the form and submit, I get confirmation and no indication of problems, however data does not ap...more >>

Hi All, I encountered BUG# 364258 (SQL Server 8.0) http://support.microsoft.com/default.aspx?scid=kb;en-us;818550 and then followed the second workaround (i.e. backup existing database and restore it to another SQL 6.5 server on Windows 2000). But I can restore master database and msbc to t...more >>

I get the following error when I try to do a query accross a linked server. I am trying a select * from [server name].master.dbo.sysobjects. Server: Msg 7399, Level 16, State 1, Line 1 OLE DB provider 'SQLOLEDB' reported an error. The provider did not give any information about the error. ...more >>

Cannot open database requested in login <DatabaseName>. Login fails. Login failed for user <DOMAINNAME\User>. Please help. ...more >>

Hi, I'm trying to connect to an SQL server from an asp.net page. Both servers are in the same domain. The setting on the SQL server are set to accept both Windows and SQL users. The users of the webserver log in with windows authentication. First I tried to connect to the SQL serve...more >>

Join members of the Microsoft development team as they chat about what's new in SQL Server 2005 Beta 2. One major new feature that's been announced in Beta 2 is data encryption. Come chat about other new features and changes that exist in this highly anticipated beta of the next version of SQL...more >>

Hi, How can I connect to AS400 from SQL Server 2000. Client prefers NO DSN. Thanks Vijay I will persist till I win....more >>

Hi, I want to run the following scenario: 1 server with COM+ components do DTC transactions against a SQL-2000 database. While this runs perfectly under Windows 2000, this does not work at all under Windows 2003. I have checked all MSDN stuff, run the DTCTESTER utilitly and came to the result...more >>

Hi, I have two different server with the same SQL instance with the same databases on SERVER1\NODE1 and SERVER2\NODE1, the goal is to be able to switch from SERVER1 to SERVER2 without causing users problems. We thought to add in the DNS server the IP adresses of the server1 and giv...more >>

I got an error of login "sa" with Error 18456 Level 14 . Server A is the MSSQL Server where the database sit and the other Server B is just with MSSQL Server tool which act as a Terminal Service and have the Accounting applications.The Accounting application unable to perform its database ...more >>

I have a sql server residing on a win2k3 box. It is a new installation and there is no data in the server at all besides default data. I have my workstation that I have installed client tools on. I am attempting to log into the sql server via the enterprise manager. I decided to use the sql acco...more >>

Hi, we just upgraded to active directory from nt 4 domain. In our HQ office we have 2 SQL servers for various applications. We have a DNS/DC/GC server located at this location and a DNS/DC/GC server located at a remote site. During the last couple months after the upgrade we have had a...more >>

Hi, I am trying to run some vbscripts on my computer, but I always get the following failure. Can anybody suggest a way out of this problem? TIA Bob The Error popup contains Script: small.vbs Line: 4 Char: 1 Error: 0x80041002 Code: 80041002 Source: null I am running ...more >>

When I try to create a System DSN connection to our SQL Server 2000 database that is installed on a Windows 2000 machine, I keep on getting the following error: Connection failed: SQLState: '28000' SQL Server Error: 18452 [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user ...more >>

I got called in on Monday because people couldn't get into our SQL Server application. It's SQL Server 2000. After talking to someone (I'm new to the application) I found that the 'Single user' option for the database in Enterprise Manager had been checked. Now I can't think that anyone...more >>

Hi, I am having problems with creating a backup onto a machine that is connected to the domain via a VPN connection. When i do the back up it does not recognize the directory that I have specified, yet when i use Windows explorer I can copy and paste to my hearts content. I was just wondering...more >>

Hello. We have two SQL Server 2000 (SP3a) servers, running replication. Each machine has two network cards. Up to just now only the first card in each machine was being used (192.168.1.*), which put. each machine on our entire internal network. Therefore communication betweeen these two s...more >>

I'm getting ready to link my SQL Server 2000 database to my legacy Oracle 9i database via linked server and I was wondering if Microsoft supported such a configuration. tks kmcclare@hotmail.com ...more >>

I have a win 2000 cluster server with a sql 2000 instance=20 whitch is configured only with tcp/ip, and when it=20 restarted i=B4m unable to connect to the server. The error log gives the error message "Bind failed on tcp=20 port 1434". I can=B4t connect to the server in Entrprise manager, ...more >>

Hi, I am trying to connect to two different SQL Servers using my broadband internet connection. Both servers are connected to a network which has one "visible" IP address. Using the Enterprise Manager, I can connect successfully to one SQL Server, but cannot access the SQL Server on another...more >>

Does Windows Authentication require Named Pipes to be enabled? In an older MS Press book "Deploying MS SQL Server 7.0: Notes from the Field" (page 161) it states that integrated security mode uses Windows NT athentication to validate logins. But it laso states that "Only trusted (multi-protoco...more >>

Hi, I am trying to connect to a sql server on a win2000 machine I am on a win 98 machine and i get the following error message Unable to connect to server \\serveur\mssql Server: Msg 6 Level 16, state 1 Microsoft odbc sql server driver tcpip socket Specified sql server not found The s...more >>

Hi I get the following error message using Enterprise Manager from my PC to run a query on a LAN based SQL Server 2000: [Microsoft][ODBC SQL Server Driver]Timeout expired. The query will run fine in the EM on the server and I can connect through ODBC to return the dataset to Excel. W...more >>

Hi. I an Wink2k3 server running MS SQL server 2000. It appears to be configured to accept requests on its default tcp/ip port, however a netstat -an does not show anything listening on that port. Could someone walk me through the steps to enabling this? I don't know if its a 2k3 issue or sql ...more >>

Hi all We are having intermittent problems with SQL Server 2000 SP3 on a Windows 2000 SP4 server. A couple of times a day the CPU will rise to at least 70% usage and all connections to it will become REALLY slow i.e. three or four minutes apiece. We've run the Profiler several times. ...more >>

please help me in following matter iam facing the same problem when i try to connect to sql remotely i.e. Unable to connect to server (name of server) Server: Msg 17, Level 16, State 1 [Microsoft][ODBC SQL Server Driver][DBNETLIB] SQL Server does not exist or access denied. but p...more >>

Dear Kevin please help me in following matter iam facing the same problem when i try to connect to sql remotely i.e. Unable to connect to server (name of server) Server: Msg 17, Level 16, State 1 [Microsoft][ODBC SQL Server Driver][DBNETLIB] SQL Server does not exist or access deni...more >>

I have linked an oracle remote database from MS SQL server 2000, connecting an Oracle 8.1.7 database. The linked worked fine for a few days but fails now with a message 'Error 7399:OLE DB provider 'MSDAORA' reported an error. OLE DB error trace [OLE DB Provider 'MSDAORA' DBInitialize::Initialized...more >>

Hi I can't connect across the Internet using any client tools to named instances of MSDE. I have 2 named instances of MSDE installed on a Windows 2003 server. They are set to mixed mode security and I can connect locally using e.g. osql -U sa -P password -S 192.168.1.1\INST1 But remotly ...more >>

I have an ASP form created in FrontPage on an XP client that connects to a "remote" SQL database hosted on a Win2003 server. Connection tests, field mapping etc. all indicate OK. When I fill out the form and submit, I get confirmation and no indication of problems, however data does not ap...more >>

Is Windows Authentication possible without a domain controller? I am running a testbed with two Win2K machines without firewalls. One computer contains the MSDE 2000A, set for Windows Authentication only. Running MS Access on the other computer under the Administrator account causes a connec...more >>

I just had a very strange (and scary) experience; on my test machine I have one ODBC set up to connect to my test SQL server. I just realized that some of the tables I have linked to this SQL server in an Access database are actually linked to the SQL server on the production database. How can thi...more >>

Hi I want to connect to SQL server thrue internet, but i have no idea how to do this. How to configure SQL server that i will see it from another location. How to connect to server (Data Source = IP?) and do i have to open some ports on firewall. I have SQL server 2000 on Win XP. im kind of...more >>

I've been having this problem for a couple of months now. When I try to connect to an SQL Server on a remote network I get an error message saying "SQL Server does not exist or access denied". I think - but I'm not sure - that this problem appeared after my hosting provider moved the database se...more >>

Hi I am having trouble with a connection within our local network. A development machine needs to connect to the main dev db server. Visual Studio and Enterprise Manager on the dev machine connect fine. The application under development connects fine when it is run with the connection str...more >>