Click here to Skip to main content
15,070,282 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hi,

First of all I'm new to MSSql. I want to use MSSql 2008 on my system.

I have installed SQLEXPR_x64_ENU and then SQLManagementStudio_x64_ENU

Windows-7, 64 bit.

I'm unable to login using Management Studio (MS). While installing these 2 softwares it nowhere asked these details. Please help.
Posted

1 solution

Select Windows Authentication from Authentication dropdownlist and click Connect. Now you should be connected to the server.
During installation it must have asked you for authentication type for login such as Windows Authentication, which is default and SQL Server Authentication.
If you have missed this step, nothing to worry , go through the following link
Unable to login to SQL Server + SQL Server Authentication + Error: 18456
[^]

Hope that helps !
In case it doesn't resolve your problem, please let me know :)
   
Comments
amaansworld 27-Apr-15 4:40am
   
I tried it but its not working.. What servername you suggest.

AS
Suvendu Shekhar Giri 27-Apr-15 5:24am
   
Typically Server name is same as your computer name.
Try finding the server name by cliking on Browse for more.. from Server Name dropdownlist. You should be able to find your server name under Database Engine
Note: If you are using Express version then you may find your server name as appended with "SQLExpress" or something at the end.
amaansworld 27-Apr-15 6:47am
   
I did both but its still now connecting.

amaansworld 27-Apr-15 6:49am
   
can u pls tell the softwares to be downloaded to run Management studio.
Suvendu Shekhar Giri 27-Apr-15 7:18am
   
No additional softwares required for SSMS(SQL Server Management Studio). Are you able to view the login screen of SSMS?
amaansworld 27-Apr-15 7:28am
   
yes I can. It is opening. As I mentioned in my post I have installed two softwares..
Suvendu Shekhar Giri 27-Apr-15 7:40am
   
Right. Then, you are saying you are unable to find the server name and other details?
Server Name: Launch the SQL Server Configuration Manager. To do this, go to Start > Programs > Microsoft SQL Server > Configuration Tools.
Locate the running MS SQL Server instance name (see image)
If it doesn't work, try adding your computer name before it. for example : COMPUTER_NAME\SQLExpress
Then select windows authentication and then click login
amaansworld 27-Apr-15 8:08am
   
perfect it work. Can u pls tell what login and pwd I should enter if I want to use it using "Sqlserver Authentication"..
Suvendu Shekhar Giri 27-Apr-15 8:23am
   
Great !
As of now, your sql authentication will be in disabled mode. You need to enable that and set the password too.
Follow these steps:
1. Login with windows authentication
2. Right click on the server instance in the object explorer (typically placed at LHS of the window)
3. Click on "Properties"
4. It will open Server Properties popup. Select "Security" from the list of pages under "Select a page"
5. Check the radio button "SQL Server and Windows Authentication Mode"
6. Press "OK"
7. Find "Security" folder under the server instance in the Object Explorer window. Expand it.
8. Expand "Logins"
9. Right click on "sa" and click properties
10. Change the password as you want and click OK
11. Now, right click on the server instance in object explorer and click on "restart"
12. Now, you should be able to login with user name "sa" and your password.

In case any difficulty, please let me know :)
amaansworld 27-Apr-15 9:06am
   
I tried but I think it requires another server name.. Please confirm?
Suvendu Shekhar Giri 27-Apr-15 9:08am
   
No, it's the same Server Name.
amaansworld 27-Apr-15 9:30am
   
I tried but it shows this msg

TITLE: Connect to Server
------------------------------

Cannot connect to hp-HP\SQLEXPRESS.

------------------------------
ADDITIONAL INFORMATION:

Login failed for user 'sa'. (Microsoft SQL Server, Error: 18456)
amaansworld 27-Apr-15 9:38am
   
I have restarted and it works. Thank you very much. You are genius...
Suvendu Shekhar Giri 27-Apr-15 9:42am
   
Glad to know that it helped :)

Please mark it as answer if it helped you resolving your problem so that anybody else having same problem get the benefit too.
Thanks !
amaansworld 30-Apr-15 0:11am
   
I don't find any option to mark it as answered.

Thanks
amaansworld 30-Apr-15 0:14am
   
I read your comments. I think you should explain it more like how to add credentials for "Sql Server Authentication", like you explained me.. How to find servername..

Does this makes sense?
amaansworld 28-May-15 7:25am
   
Hello Dear,

Are you available now. I need your help..
amaansworld 31-Jul-15 1:00am
   
Hello Mate,

I have installed MSSql 2012 and facing same problem.. I really appreciate if you can help me..
Suvendu Shekhar Giri 31-Jul-15 1:02am
   
Sure. Can you share the problem?

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900