Solved

How do I change the default log on user name for MS SQL Server 2008 in Windows7?

Posted on 2010-11-24
11
388 Views
Last Modified: 2012-05-10
I'm trying to log on my school SQL Server from home using a bat file which starts my MS SQL Server Management Studio that displays the Connect to Server dialog box. The Server type is Analysis Services and the Authentication is Windows Authentication.The problem is the user name displayed is incorrect but, the field is inactive so, I can't change it. I used the following run command rundll32.exe keymgr.dll, KRShowKeyMgr to add a new log on credential but the same user name was displayed when I ran the bat file to start MS SQL Server Management Studio again. I then went into the credential manager to verify the new user name was there and it was. How do I change the default user name for MS SQL Server 2008 in Windows7?
0
Comment
Question by:Barbara69
  • 7
  • 3
11 Comments
 
LVL 68

Expert Comment

by:Qlemo
ID: 34213713
"Windows Authentication" means that the current logged in user is transmitted to MSSQL. If you could fake that, all security would be void. To be able to provide a different user than the Windows user, you need to
allow for SQL Authentication on MSSQL Server
create an SQL user in MSSQL
allow that user access to a particular or all databases
use that SQL User and password with the authentication
0
 
LVL 15

Expert Comment

by:jorge_toriz
ID: 34214998
Qlemo, it is important to note that SQL Server Analysis Services do not accept SQL Authentication, only Windows Authentication.

Use the class attached to impersonate the user you want and then run your batch.
ImpersonationUtility.txt
0
 
LVL 68

Expert Comment

by:Qlemo
ID: 34216351
Good to know that.
Since this should run in a batch file, I think a "impersonate" using the  runas   command is more appropriate. It will ask for the password, then start Mgmt Studio.
runas /user:XYZ "%ProgramFiles%\Microsoft SQL Server\100\Tools\Binn\VSShell\Common7\IDE\Ssms.exe"

Open in new window

0
 

Author Comment

by:Barbara69
ID: 34227117
I just wanted to let you know I'm having problems with my laptop which is where I'm trying to correct this issue so, I'm unable to try your solution.
0
 

Author Comment

by:Barbara69
ID: 34257285
I had to wind up reinstalling Windows 7 but, now when I try to reinstall Server 2008 it wants to install Windows. Do you know why and what to do?
0
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
LVL 68

Expert Comment

by:Qlemo
ID: 34257528
What do you mean with "wants to install Windows"?
0
 

Author Comment

by:Barbara69
ID: 34258922
Shortly after I click on the install now button, I get a screen that has as a default to custom install windows with no other option available.
0
 

Author Comment

by:Barbara69
ID: 34260161
I ran program compatibility and it returned that the server was made for windows xp sp2 so, I ran the program from the compatibility window but eventually still got the screen about custom installing windows.
0
 

Author Comment

by:Barbara69
ID: 34264016
I just tried installing Server 2008 again but, this time on my computer that has Windows XP SP3. The attachment is a print screen of what I was referring to during the installation process asking  which type of installation do I want and custom is the only option to select.

Doc1.docx
0
 

Accepted Solution

by:
Barbara69 earned 0 total points
ID: 34366564
Thanks for your assistance. Installed the develop version.
0
 

Author Closing Comment

by:Barbara69
ID: 34391871
Found solution on my own. Was unable to try recommended solution because I couldn't get the software installed.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Sql user function 7 32
Delete Trigger in SQL Server2008R2 5 20
select over clause 1 40
SQL Query Conversion of IIF statement into CASE - Syntax issue 17 33
Experts-Exchange users below are the steps you can follow to upgrade your Lync server to latest CU's or cumulative updates. Note: Perform it during non-production hours.   Step 1: Backup your lync and SQL server database. Follow below article: h…
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.
Internet Business Fax to Email Made Easy - With  eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, f…
With the power of JIRA, there's an unlimited number of ways you can customize it, use it and benefit from it. With that in mind, there's bound to be things that I wasn't able to cover in this course. With this summary we'll look at some places to go…

920 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

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now