A SQL server 2000 job does not seem to be able to access a drive resource on a Novell server. I suspect it is a security related issue. What is required to make this connection possible. (Job seems to run fine if initiated from a user login with Novell authentication.)...more >>

Hi, We are having two Public Servers A,B I am trying to access from Server B Query Analyzer to Server A Sql Server and getting the Sql Server Does not exist or Access Denied. At the A end, the TCP Port 1433 and UDP Port 1434 are enabled. In fact we tried by enabling all the ports ...more >>

I'm trying to set up a subscription from a transactional publication. The publication works find but when I try to push or pull a subscription to another server I get the following message: Login failed for user 'NT AUTHORITY\ANONYMOUS LOGON'. I can set up a subscription on the publishi...more >>

The following error shows up in the SQL log: I/O error (Bad Page ID) detected during read of BUF pointer= What are the steps to repair the database? Paul Sedor V.P. & C.T.O. SecureMed Corporation psedor@securemed.com ...more >>

Can SQL Server 2000 manage the contacts in Exchange? Is there any connectivity between SQL Server and Outlook XP? Furthermore, can SQL Server 2000 sorta replace Exchange, i.e. can it communicate DIRECTLY with MS Outlook? I know MS Outlook XP can use mail merge functions utilizing a SQL Server ...more >>

I am trying to find a message board to ask questions about how Windows Server 2003 will work with other Windows 2000 products such as Exchange 2000 and Sql Server 2000. Does anyone know of the best message board to use or does anyone have ideas on this topic? I am intalling a network for a...more >>

I am using SQL Server 2000 Developers Edition SP3. I am using a cable internet connection. I have Log-In timeout set to 15 seconds. I connected to my webhost's sqlserver using the Client Network Utility and TCP/IP entered their IP address. I can see my database and the tables fine. Wh...more >>

We have setup a large SQL server running servaral instances, Going through a Firewall we are also using Nat so that the firewall rules alow tcp 1433 to an ip. One app works but a .net frame app does not . Please help...more >>

I'm trying to create a linked server connection from a SQL 7.0 (SQL70) server on DomainA to a SQL 2000 (SQL2K) server on DomainB. I belong to a global group in DomainA that is in the local admin group of the server in DomainB hosting SQL2K, and therefore am also in SQL2K's BUILTIN\Adminis...more >>

I am using crystal reports. I have created crystal dictionary using some odbc dsn name . when users use this dictionary to create report . they get the login dialog box prompting to enter database username / password. Is there any way to avoid it. Such that all information is embeded in th...more >>

My application uses an NT authentification login via a Windows group, as recommended by Microsoft. I've a linked server (Oracle), the link works fine. I want to map the Windows group with one Oracle login (in Linked server properties). But, the combo box shows only the windows users and the...more >>

Does anybody know of a method to link exchnage server 2000 with an msde databse, such as that used in sharepoint team services. e.g. exchanging data between sharepoint discussion boards and newsgroups or between document libraries and public folders. This would allow my users to access...more >>

i have some questions about using a sql server database with a software program written in COBOL. How can i use SQL Server with cobol ? Actually i use Adabas D from Software AG. The database is installed on a Unix Server and i use the environment to connect to this base with SQL language. ...more >>

I am using Sql server 7.0 along with a Windows 2000 server.This server is a domain controller of my office.My problem is SQL Server service is not starting.While i am starting sql server service it shows an error message "An error 1069.The service didn't start due to a logon failure occur...more >>

I HAVE DEVELOPED AN APPLICAITON USING VB6 AND SQL 2000. I DONT HAVE ADMIN ROLE IN THE SEVER BUT I AM A OWNER OF DATABASE IN THE SERVER (DBO). THE APPLICATION WHICH I CREATED RUNS PERFECTLY IN MY P.C. BUT ON CLEINT PC I AM GETTING THE FOLLOWING ERROR IN ONE OF THE COMBO BOX INVALID OBJECT N...more >>

Is there currently a way to cleanup the tempdb? Tried dbcc shrinkfile , but no luck. Can't restart the server ,because it's on production. What makes tempDB big ? and tempDB is in Simple mode , but not truncating it . Thanks ...more >>

I have C applications used in a SQL Server / DB2 batch processing scenario that use dblib through SNA Server and an unsupported application from Sybase called MDI Gateway. I would like to know if anyone has been able to use dblib to connect to IBM DB2 on AS400 without using SNA server or ...more >>

Somebody please help. I set up a linked server and wrote a stored procedure that queries the linked server and then insert the results into tables on my local server. When I go to save the stored procedure this is the error message I get. Error 7405: Heterogeneous queries require the A...more >>