Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Utpal
Posting Yak Master
179 Posts |
 Posted - 2007-02-27 : 04:22:37
|
| Hi everybody,Our client is facing a problem after upgrading from SQL Server 7.0 to SQL Server 2000 SP4. They are not able to connect to SQL Server from their workstations. The OS on the server is Windows 2000 Server and that on the workstations is Windows XP.Following is the the error message displayed on running ODBCPING.EXE on a workstation:---------------------------------------------------------------------COULD NOT CONNECT TO SQL SERVERSQLState: 08001 Native Error: 6Info. Message: [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]Specified SQL server not found.SQLState: 01000 Native Error: 11001Info. Message: [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets]ConnectionOpen (Connect()).---------------------------------------------------------------------We suspected that this problem could be occuring due to the presence of the inbuilt firewall in Windows XP and so we made them disable the same. But still the problem persists.Please help us out. |
|
|
jhnegrao
Yak Posting Veteran
81 Posts |
Posted - 2007-02-28 : 15:04:43
|
| Hello, Let's isolate the problem.The first thing to trace is the connectivity with the SQL SErver. First, try to ping the server usingping <servername>If the server respond, let's check the connectivity using the application layer. Open a ODBC and configure the server to connect to a specific Database on it. If you have problem, try to update your MDAC to a new version.Check if you get access using OLEDB, using a specific language code or a application that use OLEDB to connect to your SQL Server.Check if you get access from the Server, using Query Analyzer, ODBCPING, ODBC, OLEDB and soon. |
 |
|
|
Utpal
Posting Yak Master
179 Posts |
Posted - 2007-03-02 : 04:03:10
|
| We were able to ping the server. However, we could not create a DSN and got an error message. On running ODBCPING.EXE, we received the error message as mentioned in my first post for this thread.We have asked them to install the latest version of MDAC and waiting for their feedback on the same. |
|
|
|
rlaubert
Yak Posting Veteran
96 Posts |
Posted - 2007-03-02 : 08:02:30
|
| With the DSN, at what point did you get the error message, selecting a server, selecting a database? What security method was used? What was the error message?Raymond LaubertMCDBA, MCITP:Administration, MCT |
|
|
|
|
|
|
|
|
Unable to log into SQL Server from workstation