Solved

User name grayed out in SQL Server 2005 Server Management Studio

Posted on 2010-09-18
18
506 Views
Last Modified: 2012-05-10
I installed sql client administration tools on a workgroup Win7 computer, and like to connect to a SQL server thru SQL Server 2005 Server Management Studio, the user/pass is grayed out. I googled around, someone mentioned about runas, but how can I use runas from a stand alone computer? any ideas?

thanks,
jerry
0
Comment
Question by:JerryJay
  • 7
  • 5
  • 4
18 Comments
 
LVL 57

Expert Comment

by:Raja Jegan R
ID: 33708275
>> and like to connect to a SQL server thru SQL Server 2005 Server Management Studio, the user/pass is grayed out.

In Authentication, Choose SQL Server Authentication in order to provide SQL User name and password.
If Windows Authentication is choosen, then you can't supply username and password.
Kindly confirm..
0
 
LVL 59

Expert Comment

by:Kevin Cross
ID: 33708394
As rrjegan17 has stated.  If you are logged in as one Windows user, but want to launch SSMS using another you can the runas command to specify another user on the local machine or domain.
0
 
LVL 59

Expert Comment

by:Kevin Cross
ID: 33708400
At least that is the theory.  I recall having problems with that actual working in practice, but I have used a couple of other tools like ApexSQL and may have been one of those that didn't work.  It is worth a try though.
0
Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

 
LVL 59

Expert Comment

by:Kevin Cross
ID: 33708442
Okay, just confirmed it works with SSMS, so that is where I used it in the past.  You can use RunAs from the command line

runas /noprofile /netonly /user:{domain|machine}\{username} "{path to sql binn and ssms}\Ssms.exe"

Or Shift+Right-Click on SSMS menu item and then select Run as different user, then supply the appropriate credentials.
0
 
LVL 57

Expert Comment

by:Raja Jegan R
ID: 33709700
>> If you are logged in as one Windows user, but want to launch SSMS using another you can the runas command to specify another user on the local machine or domain.

Adding more details to avoid confusion:

If you are logged in as one Windows user, but want to launch SSMS using another Windows login then you can the runas command to specify another user on the local machine or domain.

And thanks Kevin for more details..
0
 

Author Comment

by:JerryJay
ID: 33709914
thank you all, my workstation running SSMS is not part of the domain, it's a workgroup computer. How can I specify a domain user/pass from that computer? I actually tried it by running RUNAS /user:domain\administrator "SSMS command", but it didn't work. what was wrong in this command? any ideas?

thanks
Jerry
0
 
LVL 57

Expert Comment

by:Raja Jegan R
ID: 33710325
Kindly confirm the below things:

1. Whether you (your windows login) is able to connect to SQL Server
2. You are able to ping SQL Server machine
3. connect to SQL Server machine via telnet (in command prompt)

telnet sqlserver_machine_ip 1433

which should open up a blank screen where 1433 is the port on which sql server listens.

4. If Mixed mode Authentication is enabled, check whether SQL Login is able to connect from your machine.
0
 

Author Comment

by:JerryJay
ID: 33710739
here are answers to your question:
1: my windows login is NOT able to connect to SQL Server (I am using a laptop which is not even part of the corp domain), but it's within a same routable network;

2: Yes, I am able to ping SQL server machine;

3: I tried the telnet access from my laptop and from sqlserver itself, it failed, also tried portqry utility, showing: "TCP port 1433 (ms-sql-s service): NOT LISTENING"

4: Mixed mode Authentication is not enabled. (Note: I am able to access the SQL server thru SSMS from any other windows domain machines. My question is just how to access from my workgroup-mode laptop?
0
 
LVL 59

Expert Comment

by:Kevin Cross
ID: 33711359
0
 
LVL 57

Accepted Solution

by:
Raja Jegan R earned 250 total points
ID: 33711439
One important pointer to note over Workgroup access, User in both machines should have the same password..

>> "TCP port 1433 (ms-sql-s service): NOT LISTENING"

Is port 1433 excluded in Windows Firewall, if not exclude it or the port on which SQL Server is configured to listen.
0
 

Author Comment

by:JerryJay
ID: 33713505
I changed the user password to the same as the one in sql server, it works!!! thanks rrjegan17

re the second issue about port 1433:
I cannot even portqry/telnet the tcp port 1433 by running "telnet localhost 1433" from the sql server machine, which is a Windows 2003 Server. doesn't that mean it's not a firewall issue?

btw, can anyone recommend some good MS SQL self-learning materials to me? for SQL, I am just a beginner.

thanks,
0
 
LVL 57

Expert Comment

by:Raja Jegan R
ID: 33717237
If port 1433 is excluded in Windows Firewall, ideally you should be able to telnet to it..

>> btw, can anyone recommend some good MS SQL self-learning materials to me? for SQL, I am just a beginner.

These books can help you out:

http://www.amazon.com/Beginning-SQL-Server-2005-Administration/dp/0470047046
http://www.amazon.com/Beginning-Server-2005-Programming-Programmer/dp/0764584332
0
 

Author Comment

by:JerryJay
ID: 33726071
Thanks rrjegan17, very helpful

Jerry
0
 
LVL 57

Expert Comment

by:Raja Jegan R
ID: 33730938
JerryJay,

It should have been fair if you have splitted points across the actual posts which suggested the change instead of accepting your own solution..
0
 
LVL 57

Expert Comment

by:Raja Jegan R
ID: 33731561
modus_operandi,

I would recommend

Accept http:#a33711439
0
 

Author Closing Comment

by:JerryJay
ID: 33763486
this worked
0

Featured Post

Microsoft Certification Exam 74-409

VeeamĀ® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Query Optimization 14 44
SqlServer no dupes 25 34
SQL - Update field defined as Text 6 16
Create snapshot on MSSQL 2012 3 18
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question