Cannot login to SQL Server 2008
-
guys, i just did a clean installation of sql server 2008 on windows 7 ultimate, i know the password, but i cant open the sql server (look at the pics)
any1 can help me pls, i already search at other sites about different solutions, but no use.
-
Have you enabled Mixed Mode Authentication (SQL Server and Windows Authentication mode) in Security?
-
Please don't crosspost. It wastes peoples time and fragments replies.
Original thread with replies can be found here:
http://www.sqlservercentral.com/Forums/Topic1057921-391-1.aspx
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP -
how do i do this??
"Have you enabled Mixed Mode Authentication (SQL Server and Windows Authentication mode) in Security?"
-
Hi mate.....I am new in this area but I have been studying this from past 6 months. However, I'll try my best to help u out from this situation. U can try this
1 . A4TECH-PC is u r computer/ Host name
2 . If u have installed two instance then
a) Default instance
ex: in my computer Server name is " (local) " -try this with brackets
b) named instance
It would be u r computer name and the named instance
A4Tech-PC\A4tech
Note: Its compulsory to have 1 default instance when u install sql server
3 . U can also give it a try to change properties
SQL SErver 2008 > Configuration tool> SQL Server Configuration Manager > Sql Server service > Select u r instance and right click. try to change to win authentication mode.
I just tried my best to give u solution............I hope it helps
kind regards
Azzu
Jr. DBA
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply