We recently have this problem. When the linked server provider is set to recognize windows authentication only, and the client creates a linked server without userid mapping, when trying to connect to the linked server, I got "Error 18456: Login failed for user'NT AUTHORITY\ANONYMOUS ...more >>

SQL Server does not exist or access denied ------------------------------------------ Hello, We came accross a major problem in one of our latest projects... This is the situation: We have SQL server 2000 (standard edition + SP3) running on a windows server 2003 machine (standard e...more >>

Hi, I've set up "Force protocol encryption" on MSDE site and remote clients can connect to this DB correctly. But I'm curious if it is really working so I'd like to verify it so is there any other way to check it except capturing every packet and examining its content? Regards Silmar ...more >>

I have a SQL server that is hosting 5 databases, when I try and use Enterprise Manager running it from the server its self and connect to one specific database I get A runtime Error has occurred Do you wish to debug? Line 306 Error: Unspecified error it only does it for one specific da...more >>

I use sp_addlinkedserver create a link to Foxpro files by using the lastest VFPOLEDB driver. If I use QA to query the table, it works fine. But if I put that query into scheduled job in SQL Server Agent, I get this error message: Executed as user: domainName\domainAccount. Could not init...more >>

I have two SQL servers set up on a computer. One of the SQL servers is the 'local' or default SQL servers installed. The default server is setup by the installation application. Then I installed another SQL Server called 'TEST'. I didn't change any security settings on any of the SQL S...more >>

Ok.......... I'm new to this so please bare with me. I'm trying to connect to a SQL database via a SqlDataAdapter. I have a Load button that should be loading the info onto a DataGrid. I can preview the information view the Data Adapter Preview but I can't load it onto my Datagrid when I run ...more >>

Firstly, apologies for the long post, but I though it best to outline everything I've done rather then waste anyone's time. I have a web app that uses both ASP and ASP.Net with a SQL server 2000 backend. I was running IIS & SQL server on the same box and recently decided to move SQL server to ...more >>

I have a VB.NET app which accesses several SQL Server desktop databases using SQLDMO. I need to give the user the ability to change the active database. To do this, I must detach and attach a database using SQLDMO. I cannot detach while a connection is open. Pooling "holds" the connect...more >>

Hi, I could not connect to sql server 2000 running on windows server 2003, when I connect from other servers (Running on windows 2000). Even I couldn't create ODBC connection. Any suggestions ? Thanks RamS...more >>

I have recently downloaded sql2kdesksp3.exe and installed it onto my Windows XP home computer. I need the utilities, particularly Enterprise Manager, to see what I have. How do I get this? Alan Weinberg ...more >>

On the remote computer there are several instances of SQL-Server. I can connect to the "sql1" instance by referring to it like this: sql1.host.com The other instances of SQL-Server on the remote computer have names like this: "sql1\test". I try to connect like this: sql1\test.host.com but it ...more >>

I am planning on purchasing an VB imaging application which runs on SQL. Since the application logs into the database and only uses to usernames and my users log into the application only have been told I only need to purchase a 5 user SQL license even though I will have 15 to 20 users logging in...more >>

I am looking to purchase an imaging application which runs on SQL server. I have been told that since the application logs into the database and my users log into the application that I will only need to buy a 5 user SQL server license. I will have 15 to 20 users in this application at time. Wi...more >>

I am running SQL Server 2000 on a Compaq that is running Windows 2000 with a 1.8 pIII and a 120 gig HD. The server has hit the brakes and is running slower then my TI-80 calculator. There has been no harware, sofware, or sex changes. Any Ideas?...more >>

I have SP3 for SQL installed on my server. When connect over a VPN and then try to find the computer that is connected, I get Sql server does not exist or access is denied error. Now, I read that there is a known issue with VPNs connecting after the SQL service has been started and they ...more >>

What i've tried so far... in ODBC system administrator, i've set a SYSTEM DSN with name: "io7" pointing to "(local)", using windows NT authenticity, -- test data source -- completed successfully in asp... i wrote... <% dim oConn, strConn Set oConn = Server.CreateObject("ADODB.Connec...more >>

Hi , pls help ! I need connet to SQL Server Through a MS Proxy 2.0 The computer running SQL Server is located on an internal network and has an IP address of 168.55.1.101. (W2K Server + SQL 7.0) The Proxy Server computer has two network adapters. One network adapter is connected to the i...more >>

Background info: I am a Windows 2k administrator and have been asked to add a second SQL 7 database on a a different machine. What we are tyring accomplish is to migrate the old data to a faster machine that is running windows 2000. The other machine is a old HP Kayak machine running NT4. ...more >>

I have a Windows 2003 Server running SQL Server 2000 with SP3. I am able to launch Enterprise Manager and Query analyzer from the local server but cannot connect to the SQL server from any other box. The Windows firewall is not turned on and the SQL network IP configuration is set to the...more >>

The following error displays every few minutes: Unable to load sql server oledb provider resource DLL. the application cannot continue. I am running Great Plains accounting software on a standalone laptop with MSQL2000 server. the above error occurs when SQL services are stopped and ir...more >>

Hi, I am investigating the possibility of doing a nightly copy of a couple of tables from SQL Server 2000 to DB2 using DTS. I know that it is possible to do this, the question is what do I need to make this export to DB2 work in terms of software? I think Windows has its own built in DB2 driv...more >>

We are having a server connectivity problem and looking for SQL Server expert's advice. I have tested the server everything is looking good for me and it's connecting the server but after some time it is stop working for no reason. I was not able to figure it out the problem. I have been t...more >>

Hi to all, I've question here hoping someone can answer. Our current legacy data is on IBM AS400 DB2 environment. I need to upload data into our SQL server for further usage. How can this be done ? Thnks Jess ...more >>

We're just getting our feet wet migrating a Access database to an Access project with a SQL Server 2000 back-end. We have the connection to our back-end data (which resides on a separate server) functional. We can generate views that bring data back ... however when we try to open a table via the ...more >>

We wrote a little MS Access application that extracts information from a couple of Excel spreadsheets, formats it then appends the information into a SQL table. When a member of any admininstrator's group runs it it works great. If the primary user (not an admin or sa) uses it, we get a ...more >>

I use asp to connect sqlserver 2000 But I got this error msg: ADODB.Recordset(0x800A0E7A) Provider can not be found. It may not be properly installed. Any help? Thx...more >>

Hi. I have an issue with locks caused by MsQuery... Basically, I have user's that connect to SQL through an app and through Excel using msQuery. When the query using excel (just to view data) S and IS locks are created. This is causing other user's trying to update tables through the app t...more >>