Suddenly,Program Interface cant access sql sever

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.

All Forums

Old Forums

CLOSED - General SQL Server

Suddenly,Program Interface cant access sql sever

Author

Topic

sa
Yak Posting Veteran

77 Posts

Posted - 2005-03-22 : 13:45:57

everyday we are using this program interface which
i think is created in VB6, until yesterday as we
open the program and make use of it, message says
"sql server doesnt exist or access was denied"

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2005-03-22 : 13:49:35

now that's what i call descriptive

my guess is someone stopped or paused the sql server.
start it up again.

Go with the flow & have fun! Else fight the flow

sa
Yak Posting Veteran

77 Posts

Posted - 2005-03-22 : 14:02:11

thanks, it wasnt paused or
stopped. ive found something, we can run the program
interface with no problem in server where sql server resides.
we're just having problem on client side.

X002548
Not Just a Number

15586 Posts

Posted - 2005-03-22 : 14:03:59

I bet the id used to make the connection had it's password changed...

Does the app connect with sa?

Brett

8-)

sa
Yak Posting Veteran

77 Posts

Posted - 2005-03-22 : 14:05:37

hi brett, yes!

sa
Yak Posting Veteran

77 Posts

Posted - 2005-03-22 : 14:12:28

the application uses the "sa" account. but i dont think if
the password had changed, i can still log in using tha sa account
with blank password.

sa
Yak Posting Veteran

77 Posts

Posted - 2005-03-22 : 14:14:17

application on client side cant get access to sql server.

sa
Yak Posting Veteran

77 Posts

Posted - 2005-03-22 : 14:19:09

ive consulted the books on-line i came across with
the "revealing sql server on a network." but am not
sure if this is related to my problem. is it?

sa
Yak Posting Veteran

77 Posts

Posted - 2005-03-22 : 14:42:04

i discovered another thing, on server workstation when I tried to open
query analyzer, it did opened with the normal parameters “Server Name”,
log in ID “sa” blank password. On client workstation ive tried the same
thing and it did’nt work. Ive changed the server name to IP address of the server
and it did run with no errors.

X002548
Not Just a Number

15586 Posts

Posted - 2005-03-22 : 15:05:37

Too bad it's not halloween....

It's probably a problem with DNS

http://www.dns.net/dnsrd/docs/whatis.html

But there's just so much to discuss here......

Brett

8-)

jen
Master Smack Fu Yak Hacker

4110 Posts

Posted - 2005-03-22 : 23:46:12

another possible cause,

the client workstation do not have permission to access/connect to the server, possible firewall issue, port number in server changed.

try to ping the server from the client workstation

--------------------
keeping it simple...

sa
Yak Posting Veteran

77 Posts

Posted - 2005-03-23 : 02:27:11

hi to all, sorry for the delayed reply.
below are the actions taken so far:

-already pinged the server from workstation,
it did reply.
-already checked sql server service manager, it was played(all 4 services)
-restart,shutdown the server for luck, hoping it will change something.

sa
Yak Posting Veteran

77 Posts

Posted - 2005-03-23 : 02:34:52

just wanna say thanks to all for the moment.
i noticed that we can access server just because it was maped.
but when i try to open My network places and try to look at
the networkid of the server, it wasnt there. can someone here
have an idea about ms sql server network configuration standard.

mr_mist
Grunnio

1870 Posts

Posted - 2005-03-23 : 04:29:33

Since noone else has said it, I will put my 0.02 UKP in and say, when you've sorted this out, apply a password to your SA account.

-------
Moo. :)

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2005-03-23 : 13:58:24

What grunnio said...and my 2 cents, don't use sa in any application!

Tara

jason
Posting Yak Master

164 Posts

Posted - 2005-03-23 : 14:38:08

quote:
Originally posted by sa

just wanna say thanks to all for the moment.
i noticed that we can access server just because it was maped.
but when i try to open My network places and try to look at
the networkid of the server, it wasnt there. can someone here
have an idea about ms sql server network configuration standard.

Huh? Accessed from where, the workstation?

Look at X002458's reply. SQL server uses reverse DNS for security purposes. Also, check the workstations IP config. Is it pointing to the appropriate DNS server(s)? Do you use WINS? What OS are you running on server? workstation?

sa
Yak Posting Veteran

77 Posts

Posted - 2005-03-27 : 23:08:52

hi to all,

OS: WINDOWS 2000 SERVER
so sad..... most of the applications here use the sa account.
ill take a look and study DNS.

thanks again.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources