Can''t connect to ''Local'' or server name via QA

Question

Can''t connect to ''Local'' or server name via QA

AVB

SSChampion

Points: 11418
More actions
March 25, 2005 at 2:19 pm

#87877

We found out that when we run @@servername that it returned null so I sp_addserver 'ourservername' and restarted SQL. I now relize I should have used the local option with sp_addserver but now I can't connect to my server via QA at all. I have tried local,'servername',IP address and it doesn't work. The server is running and I can access it via EM but not QA so I can rerun sp_addserver. Any ideas? Thanks!

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

AVB SSChampion Points: 11418 More actions · Answer 1

I take back that I can connect via EM, I just tried it and it doesn't work. It says the connection is broken. Is there somewhere in the registry that you can specify the name?

DCPeterson SSCoach Points: 15266 More actions · Answer 2

Try using the ip address.

/*****************

If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek

*****************/

AVB SSChampion Points: 11418 More actions · Answer 3

I already tried that and stated I did in the first post. I can however connect to this server via QA from other servers.

DCPeterson SSCoach Points: 15266 More actions · Answer 4

Oops, I missed that. Have you tried setting up an alias in the client network utility? You might try setting up one to use named pipes...

I remember having a similar problem several years ago, and I think that was the direction we took that finally resolved the problem, but I can't swear by it.

/*****************

If most people are not willing to see the difficulty, this is mainly because, consciously or unconsciously, they assume that it will be they who will settle these questions for the others, and because they are convinced of their own capacity to do this. -Friedrich August von Hayek

*****************/

AVB SSChampion Points: 11418 More actions · Answer 5

Sorry for taking so long to reply, the holiday weekend slowed me down

I ended up re-adding the server with "local" specified: sp_addserver 'servername' ,local and that seemed to take care of it. I always thought that that SQL just took the computer name as the server name, guess not. Thanks for the posts dcpeterson it was much appreciated. Have a good one!