August 29, 2011 at 12:45 am
Hi All,
I installed SQL server 2008 Evaluation edition in my office laptop.
Installed it using my user id which is NOT Local administrator.
OS is Window 7. There were some compatibility issue while installing
and it suggested me to install the latest SP after completing the installation.
Had set it to mixed mode and 'SA' pwd was given. Installed SP3 as well.
Now the problem is that I am not able to connect the SQL server.
Neither Windows login nor 'SA' is working.
Error msg is "Windows login failed, SQL Server Error 18456"
I tried by right clicking on SSMS icon and opened as "Run as Administrator", but didn't work.
What could be the reason .? How can I resolve this issue.?
Note :- I don't think my ID will be given "Local Administrator" rights.
Thanks,
Smith.
August 29, 2011 at 1:13 am
August 29, 2011 at 1:30 am
Jayanth_Kurup (8/29/2011)
could you try creating a udl file (rename a text file to extn .udl) and then connecting thru it.how about sqlcmd ?
Thanks for the quick response.
Forgot to try with UDL. Will try.
By the way how to check the same with SQLCMD..? Pls guide.
Thanks again.
August 29, 2011 at 1:48 pm
Try checking out this blog post, http://blogs.msdn.com/b/sql_protocols/archive/2006/02/21/536201.aspx, to help troubleshoot the error.
You can also look at this blog post, http://weblogs.sqlteam.com/markc/archive/2011/07/11/regaining-sysadmin-access-after-a-lockout.aspx, and the links it contains to learn how to get a connection.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
August 29, 2011 at 2:48 pm
I have never installed express edition but I know that other versions of SQL Server 2008 have a window during the install wizard where you identify people/groups that are going to be a part of the sysadmin role.
If you cannot get in then you can always startup the instance in single-user mode. To do this however your account must be a part of the local admin group. What you could do is temporarily add your user account to the local admin group, start up the server in single-user mode, ensure that your account is a part of the sysadmin role and then take your account out of the local admin group.
Take a look at these BOL articles. They may help.
Troubleshooting: Connecting to SQL Server When System Administrators Are Locked Out
Starting SQL Server in Single-User Mode
Joie Andrew
"Since 1982"
August 29, 2011 at 11:57 pm
Thanks all. Will try with all the solutions and see.
I have never installed express edition but I know that other versions of SQL Server 2008 have a window during the install wizard where you identify people/groups that are going to be a part of the sysadmin role.
It's NOT Express edition, It's SQL Server 2008 Enterprise Evaluation Edition.
Thanks again,
Smith.
August 31, 2011 at 1:57 am
could you try creating a udl file (rename a text file to extn .udl) and then connecting thru it.
how about sqlcmd ?
Hi,
No even UDL is not working. Infact 'servername' itself does not appear in the dropdown list. In SSMS I was able to select the servername. But in UDL that's also not possible. Again, My OS is windows 7. Do I need to do anything else.?
Thanks.
August 31, 2011 at 7:22 am
Looking over the thread again I notice you installed and then applied SP3. Did you not have to supply sa/sysadmin credentials to apply the service pack?
Have you verified that the SQL Server service is running?
Have you looked at and tried all the suggestions in the links provided by those who replied?
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 8 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply