sql server login password
Question
Answers
-
Could you try using Server Name: localhost and Authentication: Windows Authentication.
User name would be your domain by default. (Ignore what given in below)
-Vaibhav Chaudhari
- Proposed as answer by pituachMVP Thursday, January 29, 2015 1:18 PM
- Marked as answer by Lydia ZhangMicrosoft contingent staff Monday, February 9, 2015 1:55 AM
-
It is all depends on when you were installing SQL Server what you have chosen.
Best Wishes, Arbi; Please vote if you find this posting was helpful or Mark it as answered.
- Proposed as answer by pituachMVP Thursday, January 29, 2015 1:19 PM
- Marked as answer by Lydia ZhangMicrosoft contingent staff Monday, February 9, 2015 1:55 AM
-
Good day sunkoju.chandu :-)
First I want to use this platform for short comment to all new users, PLEASE remember that if you put question in the forum, then you are in charge for the thread, until you close it! don't forget to come back as soon as can, in order to check responses, every time that you can. People here helping voluntary and it is a bad behavior not to response to those who came to help you.
* and for all users, first have fun, but please remember that this is a public forum, with people from all over the world and with different metallic sometimes. Please do not use the abusive marked without a very very very... very good reason. people come here to learn and to support, therefore we always need to take into consideration that maybe, we did not understand what the responser meant, therefore there is a chance it was not abusive but "bad wording".
Now regarding the question sunkoju.chandu :-)
The question is very short and not clear :-(
My guessing is that you do not know, how to connect the server after installation. Probably used Windows Authentication during installation, therefore you did not insert password during the installation.Now once you open the SSMS, you do not know what to put as password/user.
If this is the case then both Vaibhav Chaudhari and Arbi Baghdanian gave you the answer, and I just want to organize it a bit.
1. Connection to the server can be done using windows Authentication or SQL Server Authentication. In your case you should try to use windows Authentication, so you do not need to use any user name and password (assuming your windows user have the permission, therefore you should use Administrator).
2. in the server name you have 2 options again: if you chose the server as default connection, or using instance name.
first try to use localhost
If this not working then you should use server name + instance name. During the installation you have option to change the default name. check this tutorial, step 9 in the installation: http://social.technet.microsoft.com/wiki/contents/articles/23878.installing-sql-server-2014-step-by-step-tutorial.aspx
Since you probably do not remember the name now, we can check it :-)
go to start --> run --> Services.msc
this will open the services list in your machine.
look for a service name "sql server", the instance name is in the brackets (in my case you can see in the image that I have 2 instances: SQL2014, and SQLEXPRESS).
Now you can connect to the server using this name as you can see in the link above on the last step of the tutorial :-)
I hope that this is useful and that you (sunkoju.chandu) will come back to c our responses :-)
please remember to close the thread, by marking the answer/s and you can vote for all useful responses as well
Ronen Ariely
[Personal Site] [Blog] [Facebook]- Edited by pituachMVP Thursday, January 29, 2015 1:21 PM
- Marked as answer by Lydia ZhangMicrosoft contingent staff Monday, February 9, 2015 1:55 AM
All replies
-
Could you try using Server Name: localhost and Authentication: Windows Authentication.
User name would be your domain by default. (Ignore what given in below)-Vaibhav Chaudhari
- Proposed as answer by pituachMVP Thursday, January 29, 2015 1:18 PM
- Marked as answer by Lydia ZhangMicrosoft contingent staff Monday, February 9, 2015 1:55 AM
-
It is all depends on when you were installing SQL Server what you have chosen.
Best Wishes, Arbi; Please vote if you find this posting was helpful or Mark it as answered.
- Proposed as answer by pituachMVP Thursday, January 29, 2015 1:19 PM
- Marked as answer by Lydia ZhangMicrosoft contingent staff Monday, February 9, 2015 1:55 AM
-
Good day sunkoju.chandu :-)
First I want to use this platform for short comment to all new users, PLEASE remember that if you put question in the forum, then you are in charge for the thread, until you close it! don't forget to come back as soon as can, in order to check responses, every time that you can. People here helping voluntary and it is a bad behavior not to response to those who came to help you.
* and for all users, first have fun, but please remember that this is a public forum, with people from all over the world and with different metallic sometimes. Please do not use the abusive marked without a very very very... very good reason. people come here to learn and to support, therefore we always need to take into consideration that maybe, we did not understand what the responser meant, therefore there is a chance it was not abusive but "bad wording".
Now regarding the question sunkoju.chandu :-)
The question is very short and not clear :-(
My guessing is that you do not know, how to connect the server after installation. Probably used Windows Authentication during installation, therefore you did not insert password during the installation.Now once you open the SSMS, you do not know what to put as password/user.
If this is the case then both Vaibhav Chaudhari and Arbi Baghdanian gave you the answer, and I just want to organize it a bit.
1. Connection to the server can be done using windows Authentication or SQL Server Authentication. In your case you should try to use windows Authentication, so you do not need to use any user name and password (assuming your windows user have the permission, therefore you should use Administrator).
2. in the server name you have 2 options again: if you chose the server as default connection, or using instance name.
first try to use localhost
If this not working then you should use server name + instance name. During the installation you have option to change the default name. check this tutorial, step 9 in the installation: http://social.technet.microsoft.com/wiki/contents/articles/23878.installing-sql-server-2014-step-by-step-tutorial.aspx
Since you probably do not remember the name now, we can check it :-)
go to start --> run --> Services.msc
this will open the services list in your machine.
look for a service name "sql server", the instance name is in the brackets (in my case you can see in the image that I have 2 instances: SQL2014, and SQLEXPRESS).
Now you can connect to the server using this name as you can see in the link above on the last step of the tutorial :-)
I hope that this is useful and that you (sunkoju.chandu) will come back to c our responses :-)
please remember to close the thread, by marking the answer/s and you can vote for all useful responses as well
Ronen Ariely
[Personal Site] [Blog] [Facebook]- Edited by pituachMVP Thursday, January 29, 2015 1:21 PM
- Marked as answer by Lydia ZhangMicrosoft contingent staff Monday, February 9, 2015 1:55 AM
