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 |
|
ZarrinPour
Yak Posting Veteran
66 Posts |
 Posted - 2008-01-07 : 08:28:20
|
| Hi allI have problem with making Connection between two computer through SQLServer and ODBC.I have two computers which are members of a WorkGroup network with WindowsXP(sp2) installed.on one computer i have installed SQL Server 2000 Enterprise edition with MIX Authentication mode enabled. Also i have created a LOGIN (Sql Server Authentication) with System Administrator ROLE (SYSADMIN).in that sql server environment .But in another computer when i want to create an ODBC connection (ControlPanel\Administrative Tools\Data Sources (ODBC)) to connect to mentioned Computer with Sql server,I receive the following Error: Access Denied...Sql Server doesn't exist.I have disabled Windows-XP firewall on both computers but still problem persists.By the way these two computer have one Administrator Account with DEFFERENT Passwords.Could anyone help me.? Any help greately would be appreciated.Kind Regards. |
|
|
sqlsquirrel
Starting Member
21 Posts |
Posted - 2008-01-07 : 18:26:36
|
| I would try 2 things:1. Setup your SQL Server in the Client Network Utility corresponding to the correct IP address and port number.2. If that doesn't work try to reference your servers by IP Address, Port Number instead of the NetBios name.Good Luck!Brett DavisSenior SQL Server DBAFor more helpful tips checkout my blog at: http://www.lockergnome.com/sqlsquirrel/ |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-01-07 : 21:55:44
|
| Ensure sql instance name is correct and sql login used exists. |
|
|
|
|
|
|
I can't connect to Server through ODBC....