In the following sceanrio Web application uses Analysis Services to present data. Web App (IIS) is installed on a different server to the SQL Server instance. Web app uses Windows Integrated authentication. It appears that the authentication is not correctly passed to AS and that...more >>

The service did not start due to login failure. ...more >>

Hi, I'm in the process of moving the data of an access database to SQL Server, but it doesn't seem to work. I've set up a data source, and I'm able to select the tables to link, but instead of the data I only get "#deleted" in all columns. It works if I import the table instead of linkin...more >>

With Enterprise manager, I can see a remote sql 2000 sp3 instance. I can also see that port 1433 is open. But, when I try to connect to it, I get the connection could not be estiablished. sql server does not exist or access denied. I have pretty much all the port except for 1433 tcp and ...more >>

I resently purchased a Virtual Windows 2003 Standard Server and I installed SQL 2000 with Service Pack 3 on it to make sure it was up to date. I can ftp on this server and everthing but when it comes to making a Microsoft ODBC connection from my local computer to the virtual server I am not able...more >>

We have clustered IIS .asp pages that query our clustered SQL server. Thes pages work when IIS is running on node 1 with SQL on either node. If the web (IIS) is failed over to node 2 the .asp pages stop rendering and we get 404 errors. The .html pages work fine. On pages that have both .asp a...more >>

Hi, I've just installed Sql 2000 (and sp3a) on my Win 2003 server. But I have trouble connecting to it from my client machine. I keep getting this error when registering: "User login failed: Not associated with a trusted Sql Server connection". The client machine is running on XP Home. The us...more >>

Helo, I nstalled two instances of sqlserver2000 on an win server 2000. first problem: changing the default tcp port from one instance ,also changes the port of the other one. No way to have two different ports. The eventviewer indicates a problem with one of the two instances: cannot connect to...more >>

Here I go for last time, I promise. I uninstalled MS DTC (in an stupid attemp to avoid a distributed transaction to start), by doing : net stop MSDTC MSDTC - uninstall After some charitative aim told me what I wanted to do is not possible, I decided to reinstall : MSDTC -install ...more >>

On my client computer, I have MSDE and use SQL EM to connect to the local DB and the server's db (server is running sql2k sp3a). I installed XP sp2 on my client computer and now the QA and all programs ---can--- access the sql server just fine, but the EM cannot connect ... it gives general o...more >>

Hi, I have a linked server to an Oracle database, to which I am executing some packages that return a resultset. Now, I'm trying to get those results into a local table using : Insert Into LocalTable Execute sp_StoredThatCallsAnOraclePackage but I get the error "'MSDORA' was un...more >>

I'm having a problem when i try to delete a table...I have run dbcc newalloc DBCC checkdb on the database and the newalloc came back without errors...the checkdb just hangs without returning anything...this is a developement database with the live version off site, so whatever i need to d...more >>

I installed SQL 2000 on Windows Server 2003 and am trying to import data from a SQL 7 installed on an NT 4.0 Server. I get an error that reads: Failed to copy objects from MS SQL server to MS SQL server. Any thoughts? Thanks in advance....more >>

We have SQL 2000 on Windows 2000 it has flat hierchy ADS. we had our database frezze up four time this month. The only pattern seems it happnes one time per week. Other then taht no time or date pattern. I check the evnt logs no errors at all. I check the sql logs the only thing that seem...more >>

Hi, I had a similar post before, and got some good suggestions on this, but so far I'm still unable to retrieve my database. Unfortunately, I made the mistake of not detaching my database when I was having some problems, and it got physically moved instead. I have tried several differ...more >>

I'm having a problem when i try to delete a table...I have run dbcc newalloc DBCC checkdb on the database and the newalloc came back without errors...the checkdb just hangs without returning anything...this is a developement database with the live version off site, so whatever i need to d...more >>

Hi, I have commercial asp webspace hosting an application that connects to an SQL machine on my local network. THe machine has both SQL 7 and SQL 2k running on it. Webspace and SQL are both running on Win2k. The connection string I am using is as follows: Application("Application_Connecti...more >>