Cannot connect to SQL - SQL Server Forums

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

SQL Server 2000 Forums

SQL Server Administration (2000)

Cannot connect to SQL

Author

Topic

TRACEYSQL
Aged Yak Warrior

594 Posts

Posted - 2007-07-11 : 05:45:06

We have Cluster 1 and Cluster 2 and two instances of sql running
I cannot connect to SQL2 but not SQL1 using EM

I can get into our application which uses ODBC but in EM it just says cannot connect.

Would this be a DNS issue.
Thanks

b.veenings
Yak Posting Veteran

96 Posts

Posted - 2007-07-11 : 05:52:56

Do you use trusted connections or by an sqluser?

what kind of error do you get, try connection through osql.

Need an SQLDB consultant?
check www.veeningsengineering.nl

TRACEYSQL
Aged Yak Warrior

594 Posts

Posted - 2007-07-11 : 06:11:54

Access denied using NT and tried the sa

I tried
osql -E -S SQLINSTANCENAME -Q am i missing parameters
Get DBNETLIB SQL Server not exists

Using EM get access denied

TRACEYSQL
Aged Yak Warrior

594 Posts

Posted - 2007-07-11 : 06:17:09

The osql works on all other sql servers except the one i need.

b.veenings
Yak Posting Veteran

96 Posts

Posted - 2007-07-11 : 06:21:16

are you shure the service is still running?? try connecting to the ip address

Need an SQLDB consultant?
check www.veeningsengineering.nl

TRACEYSQL
Aged Yak Warrior

594 Posts

Posted - 2007-07-11 : 06:23:08

All services are running as i cannot connect to the database using our application which uses the ODBC.

Kind of odd i cannot get osql or EM to work.

I can ping each of the machines.

b.veenings
Yak Posting Veteran

96 Posts

Posted - 2007-07-11 : 06:24:20

try register it using the ip address

Need an SQLDB consultant?
check www.veeningsengineering.nl

TRACEYSQL
Aged Yak Warrior

594 Posts

Posted - 2007-07-11 : 06:31:13

Interesting i am on my machine and i see every other SQL except the SQL1......i have 5 different machiens all working.'

So i goes on to another machine remotes into this and then registers the SQL1 and viola it works.

I am not sure i understand that......

But its up.

Thanks for the tip on osql i put that in my test paths.

b.veenings
Yak Posting Veteran

96 Posts

Posted - 2007-07-11 : 06:38:48

u can try on your sql1 server edit the following file
c:\windows or winnt\system32\drivers\etc hosts file

put in there

127.0.0.1 name of your server

or

name of your server 127.0.0.1

Need an SQLDB consultant?
check www.veeningsengineering.nl

TRACEYSQL
Aged Yak Warrior

594 Posts

Posted - 2007-07-11 : 06:45:55

Would i go to the Cluster Machine and do it.
We have the Virtual (XXX.141) and Physical (this is the instance) XXX.143

cluster is SQLCL1 and SQL Instance is SQL1\SQL1

Thanks

b.veenings
Yak Posting Veteran

96 Posts

Posted - 2007-07-11 : 07:10:10

you need to do it on both joined physical servers.
this is only for connecting to this instance from the same machine where its on.

Need an SQLDB consultant?
check www.veeningsengineering.nl

TRACEYSQL
Aged Yak Warrior

594 Posts

Posted - 2007-07-11 : 07:52:40

So i go onto the physical machine not cluster and do the wins part.
Let me try that.

Thanks a look have a great day

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-07-11 : 14:21:13

Create an alias to sql1 with ip address xxx.141 and correct port number on your pc.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources