mixedmode option with 'sa' blank password.

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » Administration » mixedmode option with 'sa' blank password.

mixedmode option with 'sa' blank password.

Rate Topic

Display Mode

Topic Options

Author

Message

ananda.murugesan

Posted Monday, October 27, 2008 10:52 PM

SSC Eights!

Group: General Forum Members
Last Login: Wednesday, May 22, 2013 11:19 PM
Points: 823, Visits: 2,405

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

Post #592620

ananda.murugesan

Posted Tuesday, October 28, 2008 12:17 AM

SSC Eights!

Group: General Forum Members
Last Login: Wednesday, May 22, 2013 11:19 PM
Points: 823, Visits: 2,405

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.

Post #592638

GilaMonster

Posted Tuesday, October 28, 2008 2:39 AM

SSC-Dedicated

Group: General Forum Members
Last Login: Yesterday @ 3:18 PM
Points: 37,744, Visits: 30,025

When you say registration, what exactly do you mean?

Blank sa password? That's rather dangerous.

Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
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

Post #592675

ananda.murugesan

Posted Tuesday, October 28, 2008 3:39 AM

SSC Eights!

Group: General Forum Members
Last Login: Wednesday, May 22, 2013 11:19 PM
Points: 823, Visits: 2,405

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

Post #592699

GilaMonster

Posted Tuesday, October 28, 2008 3:48 AM

SSC-Dedicated

Group: General Forum Members
Last Login: Yesterday @ 3:18 PM
Points: 37,744, Visits: 30,025

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 2008, MVP
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

Post #592702

ananda.murugesan

Posted Tuesday, October 28, 2008 4:01 AM

SSC Eights!

Group: General Forum Members
Last Login: Wednesday, May 22, 2013 11:19 PM
Points: 823, Visits: 2,405

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

Post #592709

GilaMonster

Posted Tuesday, October 28, 2008 4:12 AM

SSC-Dedicated

Group: General Forum Members
Last Login: Yesterday @ 3:18 PM
Points: 37,744, Visits: 30,025

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 2008, MVP
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

Post #592714

ananda.murugesan

Posted Tuesday, October 28, 2008 4:27 AM

SSC Eights!

Group: General Forum Members
Last Login: Wednesday, May 22, 2013 11:19 PM
Points: 823, Visits: 2,405

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.

Post #592723

GilaMonster

Posted Tuesday, October 28, 2008 6:36 AM

SSC-Dedicated

Group: General Forum Members
Last Login: Yesterday @ 3:18 PM
Points: 37,744, Visits: 30,025

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 2008, MVP
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

Post #592803

« Prev Topic | Next Topic »

Permissions