mixedmode option with 'sa' blank password.

Question

Post reply

mixedmode option with 'sa' blank password.

SQL Galaxy

One Orange Chip

Points: 29472
More actions
October 27, 2008 at 10:52 pm

#71377

hi friends,
we have two windows server 2003 enterprise edtion,
1. First server name jgsrvr28
2.Second server name WJMN0130136
Both server has running sql server 2000 with same account services name and same password (windows user via group membership). but while installing both sql server 2000 i given mixedmode option with 'sa' blank password.
I could not able to connect new registration from server jgsrvr28
to server WJMN0130136, i got error mesg like server does not exits.
please tell me what actual problem? and how to registration?
Thanks

Viewing 9 posts - 1 through 8 (of 8 total)

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

SQL Galaxy One Orange Chip Points: 29472 More actions · Answer 1

1. First server name jgsrvr28

2.Second server name WJMN0130136

Both windows 2003 server running same domain. pls tell me how to registration from server WJMN0130136 to jgsrvr28.

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 2

When you say registration, what exactly do you mean?

Blank sa password? That's rather dangerous.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

SQL Galaxy One Orange Chip Points: 29472 More actions · Answer 3

hi,

Thanks for reply.

I try to through register sql server wizard, and select the available server name, it was not successfully registered,

I got error msg like sql server server does not exist

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 4

Means that either the server isn't running, you've mistyped the name, or there's a firewall or similar preventing connections.

Can you ping the second server from there?

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

SQL Galaxy One Orange Chip Points: 29472 More actions · Answer 5

hi gail,

thanks for reply,

i have checked all the activity

1. windows firewall stoped.

2. select the second server name from the list, not typed.

3. N/W is getting reply.

But second sql server 2000 running thier own services account and account name is sqlmail with password,

First server is running system account with sa and password.

thanks

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 6

It doesn't make any difference what the server's service accounts are. As long as you're connecting with an account (windows or sql) that has login rights on the other server.

Windows firewall stopped doesn't mean there's no firewall. There may be a hardware firewall on the network.

Can you ping the other server from the one you're working on?

Is the SQL Service started on that other server?

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

SQL Galaxy One Orange Chip Points: 29472 More actions · Answer 7

hi Gail,

thanks for reply,

Both server n/w was getting reply,

agin i try to register second sever from server one. alternative i register first server to from second server.

same error display

error is - sql server does not exits or access denied connection open.

Could you tell, how to check the H/W firewall over the network or services name specified in H/W firewall.

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 8

Check the account you're using to connect. Make sure that the login name exists on the remote server and the password is correct.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass