An MSDN Universal subscription comes with SQL Server in both Enterprise and Developer edition. Does it mean I get 2 licenses and can install one Enterprise and one Developer server? Eliyahu ...more >>

I was trying to install an application on a client workstation running XP-Pro but couldn't connect to another machine within same LAN running SQL 2000 server (2000 Small Business Server). I tried same thing with another user running Windows 2000 professional and I was able to connect to t...more >>

I CAN connect to SQL from IIS in all ways but one! IIS box to remote SQL Server box (Member Server on Domain) This doesn't work when IIS Iusr is created on the "Domain" then added to the member server's SQL Server! Isn't there some issue with Kerberos not passing the token to the member ser...more >>

Hi, SQl server 7 when i go to services and start the sql server im getting a message "cannot start sql server as it is in use". when i click on to service manager i am getting message "unable to find bin folder". Pls help me as this is production server TIA...more >>

Hi, When i run a stored procedure i am getting the following error in sql server 2000. Server: Msg 7391, Level 16, State 1, Line 2 The operation could not be performed because the OLE DB provider 'SQLOLEDB' was unable to begin a distributed transaction. [OLE/DB provider returned messag...more >>

Hi! I'm trying to access my SQL Server through a firewall. The SQL Server is on the inside. I've opened up port 1433 in the firewall, so I should be able to connect. It's SQL Server 7.0. The problem is, that I get a timeout message, when trying to connect. I used Network Monitor on the serv...more >>

Hi, I installed an eval copy of Sql Server 2000 on a Windows XP machine. I can connect to the server in Enterprise manager using 127.0.0.1\DEV, but not 127.0.0.1 alone. Not a problem, except I am also using JDBC on the same machine to access the server. If I set the host to 127.0.0.1, I...more >>

I have a job that simply deletes data from a few tables then inserts data from a linked server into those tables. I run the code from the job in query analyzer and it works fine. However, when the job runs it thows this error everytime. Msg 7399, Sev 16: OLE DB provider 'SQLOLEDB' repor...more >>

It looks as if query analyzer on my win2k client uses the ODBC SQL Server Driver as its commection provider... Is there a way to change this to use the OLEDB provider? TIA! JJ ...more >>

I am trying to set up a connection to SQL Sever 2000 on a Win2000 Server from an NT workstation. I get an SSL encryption error when I try to connect. The setup is exactly the same as on my previous workstation. We have previously fixed this problem by running the Client Network Utility and ens...more >>

Configuration: SQL Server 7 (developers edition) database on WinNT sp6. Access 97 database on WinXP with link tables to SQL database. Access 97 database on Win2K with link tables to SQL database. Problem 1: Opening 10 or more link tables from the Win2K box gives a "Cannot Connect ... ODBC" e...more >>

the sql server 6.5 , which I am trying to connect. I have sql 2000 client. I got this error message. please help. C:\>osql -S 205.252.180.215 -U sa Password: The ODBC catalog stored procedures installed on server version 6.50.193; version 07.00.0523 or later is requir operation. Please con...more >>

Hi, I have to import a database in SQL 7.0 Service Pack 4 from which I have the *.mdf and *.ldf files in a new server. The problem I get when I do "sp_attach_db" is: "Server: mesagge 1816, level 16, state 1, line 1 Cannot attach db due to the difference in Character Set, Sort Order or Un...more >>

I just installed SQL Server 2000 Developer Edition on a WinXP machine. I cannot login/connect to the local db The error I receive is 1069 the service did not start due to a login failure Then another dialog box pops up with Reason:SQL server does not exist or access denied. I can connect ...more >>

My previous posts on this subject was a bit vague so I will try again. When I run qry with a four part name against a linked I get the following error. Note openquery works fine. Qry I run select top 10 * from nibbler.seveneleven.dbo.pip_composed_of_bom Error I get Server: ...more >>

I am running Sql Server 7 on a windows 2000 professional machine at service pack 4. I am getting the error as follows. Connection failed: SQlState: '01000' SQL Server Error: 11001 [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets] ConnectionOpen (gethostbyname()()). Connection failed:...more >>

Hi Folks, Did anyone ever come across this ? Go to register a new server in enterprise manager, input the details and get the above message. Same server can be contacted using query analyser and can be pinged so it is contactable ok. Just can't connect to it (or any other server) in this install...more >>

Hi, I need to transfer all the linked servers present in the remote sql server to a local sql server. How can i do it? Regards, Anand...more >>

SQL Server 2000 will not start. In the ERROR LOG file it states that the database model is undergoing a restore. Is there a way to stop the restore and start the SQL server ??? Here is the error log file: 2003-12-09 12:35:20.94 server Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 1...more >>

Hi, I'm getting 'Login failed for user '(null)', Reason: Not associated with a trusted SQL server connection' error when I try to access the SQL server 7 database using windows authentication. I am trying to access it from a W2K Client. I can logon to other pc's that are configured th...more >>

The following statement joins two tables in databases on different servers (n.b. rose is the 'linked' server): select top 10 hhid, c.s21_cust_num from rose.customer.dbo.customer rc join customer c on rc.s21_cust_num = c.s21_cust_num where c.store_num = 232 When I run it interactively f...more >>

I am having issues connecting to a SQL server using XPs managed passwords. Here is the configuration: SQL 2000 server/Windows 2000 Cluster located behind a fire wall in a DMZ. SQL is installed on virtual server FOO with instance name BAR in domain FLUF. XP client is installed in domain FUZZ. ...more >>

Hello, I am just about ready to deploy a Winforms .NET app I created. It connects to SQL 2K and I am noticing that upto 4 connections are created for each client the connections are mostly in the "sleeping" status and Awaiting a command. Is this normal and is this a problem? Thanks, Da...more >>

Is it possible to terminate any SQL connection to a specific database? I have a program which gives me an error when I try to connect to the db saying that some "other application is accesing, please close the application first and try again"....more >>

Hello, I was hoping someone would be able to help me with a problem I have run into. I have a C++ application (a service actually) running on an NT 4 server that connects to a local MSDE 2000 database using OLEDB. The application was running perfectly until an administrator disabled t...more >>

Is there a programatic way (in a vb.net app) to return a list of available SQL Server instances under a specific domain or within a network? My Install application for a database utility needs this capability. Right now I'm only able to iterate through the instances in the registry...more >>

None of the proposed work-arounds will work for me and I have been unable to get the patch/instructions from MS. Does anyone have the file and instructions for this article?...more >>

I'm trying to connect from PHP 4.3.3 on a WinXP Pro workstation using IIS to a remote Microsoft SQL Server. According to the docs, I should able to do this: <?php $myServer = "servername"; $myUser = "username"; $myPass = "password"; $myDB = "Northwind"; $s = mssql_connect($myServer, $myU...more >>

I wrote a Visual Studio 2000 C# Windows application. The application works fine on my local PC running Windows 2000 Pro, and it also works fine running on a server with Windows 2000 Server. But when I ported the C# application to a new Server running Windows 2003 Server, I get this error...more >>

Hi, I’m getting ‘Login failed for user ‘(null)’, Reason: Not associated with a trusted SQL server connection’ error when I try to access the SQL server 2000 database using windows authentication and I was accessing this database until very recently and this problem started all of a sudden. ...more >>

Old Environment: Workstation: Win 2000 SQL Server 2000 running on Win 2000 Server New Environment: Workstation: Win 2000 SQL Server: 2000 running on Win 2003 Server In the New Environment - the only way we can access the linked server (AS400) tables is if we log in as "sa". Anything...more >>