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 |
|
mmmundhra
Starting Member
4 Posts |
 Posted - 2008-07-23 : 05:27:58
|
| Hello,OS : Win 2003DB : SQL Server 2000 Enterprise with All Service PacksI want to make sure no user connect to sql server 2000 in machine 'abcd' using 'windows authentication'. To do that i first revoked access to 'BuiltIn\Administrator' account. This way no one can access sql server using 'windows authentication'. After that i set user 'sa' password to 'cfindia'. Now sql connection is ok in machine 'abcd'. But when i connect to same sql server (using user 'sa' and password 'cfindia') through other network computers using LAN. Following error occures :-'SQL server doesnot exists or access denied ...'How to solve above error.Above error also occures when i try to connect same sql server using admin tools > data sourrce (odbc)Thanks,manmohanmanmohan@indusnet.co.in |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-07-23 : 22:56:40
|
| Did you enable tcp/ip or named pipes on the server? Check that in server network utility. |
 |
|
|
mmmundhra
Starting Member
4 Posts |
Posted - 2008-07-24 : 03:28:03
|
| In 'sql server network utility' both items a enabled. As both are come under enabled protocols list (right side). |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-07-24 : 13:13:55
|
| Then check sql server log to ensure sql is listening on those protocols. By the way, did you specify correct sql instance name when connect to it? Is sql oprt open on your network? Which port is used? |
|
|
|
mmmundhra
Starting Member
4 Posts |
Posted - 2008-07-28 : 06:36:41
|
| In 'sql server network utility' default port is 0 which i changed to 1433. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-07-28 : 22:10:34
|
| Working now? |
|
|
|
|
|
|
SQL Server Database Network Access