Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!
Solved
SQL Server 2008 R2 SA Password
Posted on 2011-09-20
I just finished installing Small Business Server 2011, and I'm trying to login to the local database using windows authentication and it won't work. Does anyone know how to enable the SA account or what I should be using to login using the management studio?
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
-
5
4
10 Comments
May be the windows user doesnt have a local admin rights.if your'e in a domain then check the domain user permissions.
if neither doesnt work reinstall with mixed mode authentication and will be able to connect with a valid login.
if neither doesnt work reinstall with mixed mode authentication and will be able to connect with a valid login.
I'm logged in with a user that has domain admin, enterprise admin, schema admin permissions. I'd rather not reinstall as sharepoint, and other services are using the instance
There is a new feature in Windows Server 2008 called User Account Control (UAC). This feature causes a user, whether administrator or not, to provide credentials when opening applications that may affect the system as a whole. A possible reason your administrative login is not working to login to the SQL Server is because you are not opening SQL Server Management Studio as administrator. To get around this you will need to right click on SQL Server Management Studio and select "Run as administrator" each time you open the application. After doing so, you should be able to use Windows Authentication to login to the SQL instance.
UAC settings can be adjusted, or even completely disabled, if you feel that it is not needed. You can read more about Windows Server 2008 and UAC here: http://technet.microsoft.com/en-us/library/cc772207.aspx.
UAC settings can be adjusted, or even completely disabled, if you feel that it is not needed. You can read more about Windows Server 2008 and UAC here: http://technet.microsoft.com/en-us/library/cc772207.aspx.
UAC is disabled on the server, and tried it again with right click as admin and I still get the same error.
I just looked through the services, and noticed there are instances installed for sharepoint etc.. however; I don't see a default instance which I can connect to. Do I need to install another instance using SQL Server 2008 R2 express, and manage it that way?
If someone has some SBS 2008/2011 experience with SQL that would be great
I just looked through the services, and noticed there are instances installed for sharepoint etc.. however; I don't see a default instance which I can connect to. Do I need to install another instance using SQL Server 2008 R2 express, and manage it that way?
If someone has some SBS 2008/2011 experience with SQL that would be great
Featured Post
Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Because virtualization becomes more and more common, and, with Microsoft Hyper-V included in Windows Server at no additional costs, and, most server hardware nowadays is more than capable of running a physical Small Business Server (SBS) 2008 or 201…
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.
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Suggested Courses
Course of the Month4 days, 23 hours left to enroll
670 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.