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

window for searching a new login is not opening up in SSMS Expand / Collapse
Author
Message
Posted Tuesday, October 16, 2012 1:44 PM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, June 17, 2014 3:54 PM
Points: 211, Visits: 520
This is on a Microsoft SQL Server 2005 - 9.00.5057.00 (X64) Mar 25 2011 13:33:31 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2)

on the client end, where SSMS is installed and when the user is trying to search and add a new login it erroring out instead of opening a new window, with the following error messgae:

The program cannot open the required dialog box because it cannot determine whether the computer named "SERVERNAME" is joined to a domain. Close this message, and try again.


any ideas ?

is this some how related to http://support.microsoft.com/kb/816818 ?



Today is the tomorrow you worried about yesterday
Post #1373502
Posted Wednesday, October 17, 2012 9:49 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, June 17, 2014 3:54 PM
Points: 211, Visits: 520
any ideas ?


Today is the tomorrow you worried about yesterday
Post #1373914
Posted Friday, October 19, 2012 5:26 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, July 21, 2014 11:35 PM
Points: 168, Visits: 733
hey Hi,

can u refer below the links and once again,can u explain your question briefly.

http://answers.microsoft.com/en-us/windows/forum/windows_7-networking/this-program-cannot-open-the-required-dialog-box/d3bf5394-182c-4464-9d38-5e13680f1138

please check the name resolution - make sure that you can resolve the server name from the client - and vice versa

I would also suggest you disabling the firewall completely .

Ensure that the account you are using on the server is a local one (rather than domain based).

Thanks,


SQL server DBA
Post #1374746
Posted Friday, October 19, 2012 5:33 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 12:15 AM
Points: 2,837, Visits: 3,957
kranthi.india123 (10/19/2012)
Ensure that the account you are using on the server is a local one (rather than domain based).Thanks,
i didnt get this point


-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done
Post #1374750
Posted Friday, October 19, 2012 5:43 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, July 21, 2014 11:35 PM
Points: 168, Visits: 733
Hi,

nothing but,rather than domain based.


Thanks


SQL server DBA
Post #1374759
Posted Friday, October 19, 2012 5:47 AM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 12:15 AM
Points: 2,837, Visits: 3,957
kranthi.india123 (10/19/2012)
nothing but,rather than domain based.
but why you want to avoid domain based account ?


-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done
Post #1374764
Posted Friday, October 19, 2012 6:02 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, July 21, 2014 11:35 PM
Points: 168, Visits: 733
Bhuvnesh (10/19/2012)
kranthi.india123 (10/19/2012)
nothing but,rather than domain based.
but why you want to avoid domain based account ?



hey Hi Bhuvnesh,

temporarily i said,i.e.,- to rule it out as the root cause...thats it....i
Based on the current situation, I'd like to confirm some information? okay.. If there is anything that I can do for you, Please do not hesitate to let me know in case you have additional questions or concerns as I will be more than happy to help..

Thanks in advance.


SQL server DBA
Post #1374773
Posted Friday, October 19, 2012 7:17 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, June 17, 2014 3:54 PM
Points: 211, Visits: 520
kranthi.india123 (10/19/2012)
hey Hi,

can u refer below the links and once again,can u explain your question briefly.

http://answers.microsoft.com/en-us/windows/forum/windows_7-networking/this-program-cannot-open-the-required-dialog-box/d3bf5394-182c-4464-9d38-5e13680f1138

please check the name resolution - make sure that you can resolve the server name from the client - and vice versa

I would also suggest you disabling the firewall completely .

Ensure that the account you are using on the server is a local one (rather than domain based).

Thanks,



Again my problem is I have one of the database users connecting to my DB server from his local machine using management studio and when they want to add a new login to the DB server they go to security-->New Login --> Search (to pull a list of logins) so when they click the error message which I posted in my original message.

Verifying DNS resolution makes sense to me, I'm in the process and will let you know. But I dont understand disabling firewall rules, how can they make a connection to a remote server at all if there is no firewall rule in the first place ?

Thanks



Today is the tomorrow you worried about yesterday
Post #1374810
Posted Friday, March 29, 2013 1:02 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, June 27, 2013 2:44 PM
Points: 32, Visits: 134
I'm getting this error opening a user pickder dialog box while connecting to SQL 2012 on Server 2012 from SSMS on a Win 7 client. I noticed when I disable the firewall on the server the dialog box opens fine. I do have ports 1433 and 2383 open so i'm not sure how to resolve this.

Thanks!
Post #1437060
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse