April 13, 2010 at 2:08 am
On my local I have :
Windows XP SP2, SQL server 2000 Developers edition.
SQL Server installation completed successfully, I can operate locally, but it is not allowing remote connections. The error message that they get is
"[Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied"
I have configured the Client network utility with TCP/IP (port 1433)and named pipes(sql\query).
All the services pertaining to SQL server are started. Below is the log when server starts:
2010-04-13 13:17:09.06 server Copyright (C) 1988-2000 Microsoft Corporation.
2010-04-13 13:17:09.06 server All rights reserved.
2010-04-13 13:17:09.06 server Server Process ID is 5972.
2010-04-13 13:17:09.06 server Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL$BASIC\log\ERRORLOG'.
2010-04-13 13:17:09.06 server SQL Server is starting at priority class 'normal'(2 CPUs detected).
2010-04-13 13:17:10.31 server SQL Server configured for thread mode processing.
2010-04-13 13:17:10.31 server Using dynamic lock allocation. [2500] Lock Blocks, [5000] Lock Owner Blocks.
2010-04-13 13:17:10.31 server Attempting to initialize Distributed Transaction Coordinator.
2010-04-13 13:17:12.42 spid2 Starting up database 'master'.
2010-04-13 13:17:12.62 server Using 'SSNETLIB.DLL' version '8.0.194'.
2010-04-13 13:17:12.62 spid5 Starting up database 'model'.
2010-04-13 13:17:12.64 server SQL server listening on Shared Memory, Named Pipes.--(NO TCP here)
2010-04-13 13:17:12.64 server SQL Server is ready for client connections
2010-04-13 13:17:12.67 spid2 Server name is 'DBASSO\BASIC'.
2010-04-13 13:17:12.67 spid8 Starting up database 'msdb'.
2010-04-13 13:17:12.67 spid9 Starting up database 'pubs'.
2010-04-13 13:17:12.67 spid10 Starting up database 'Northwind'.
2010-04-13 13:17:13.07 spid5 Clearing tempdb database.
2010-04-13 13:17:13.79 spid5 Starting up database 'tempdb'.
2010-04-13 13:17:13.82 spid2 Recovery complete.
2010-04-13 13:17:14.49 spid51 Using 'xpsqlbot.dll' version '2000.80.194' to execute extended stored procedure 'xp_qv'.
2010-04-13 13:18:37.29 spid51 Using 'xpstar.dll' version '2000.80.194' to execute extended stored procedure 'sp_MSgetversion'.
Please help me out of this.
April 13, 2010 at 2:50 am
After much struggle, I have found out the only thing missing, to configure the client server setup on my local, was SP4.
I installed and the log now shows
"2010-04-13 13:49:58.09 server SQL server listening on TCP, Shared Memory, Named Pipes."
**TCP was missing earlier
It is now working fine.
Just shoot me!!!!
April 16, 2010 at 3:40 am
This issue is resoleved ..Thanks for nothing
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply