Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

mixedmode option with 'sa' blank password. Expand / Collapse
Author
Message
Posted Monday, October 27, 2008 10:52 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, August 19, 2014 7:00 AM
Points: 1,054, Visits: 2,974
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
Posted Tuesday, October 28, 2008 12:17 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, August 19, 2014 7:00 AM
Points: 1,054, Visits: 2,974
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
Posted Tuesday, October 28, 2008 2:39 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Yesterday @ 9:36 AM
Points: 42,765, Visits: 35,863
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
Posted Tuesday, October 28, 2008 3:39 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, August 19, 2014 7:00 AM
Points: 1,054, Visits: 2,974
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
Posted Tuesday, October 28, 2008 3:48 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Yesterday @ 9:36 AM
Points: 42,765, Visits: 35,863
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
Posted Tuesday, October 28, 2008 4:01 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, August 19, 2014 7:00 AM
Points: 1,054, Visits: 2,974
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
Posted Tuesday, October 28, 2008 4:12 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Yesterday @ 9:36 AM
Points: 42,765, Visits: 35,863
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
Posted Tuesday, October 28, 2008 4:27 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, August 19, 2014 7:00 AM
Points: 1,054, Visits: 2,974
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
Posted Tuesday, October 28, 2008 6:36 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Yesterday @ 9:36 AM
Points: 42,765, Visits: 35,863
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 »

Add to briefcase

Permissions Expand / Collapse