Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Rock_query
Yak Posting Veteran
55 Posts |
 Posted - 2014-12-26 : 22:05:21
|
| I downloaded SSMS 2014. How do I log in? From what I can tell, I don't have a server name. Not sure why.Should I use "Windows Authentication" or "SQL Server Authentication?" What is the difference?It's hard to find information on this. I used SSMS 2008 a while ago. But overall, I am new to all of this stuff. I don't know any of this. |
|
|
Rock_query
Yak Posting Veteran
55 Posts |
Posted - 2014-12-27 : 00:24:03
|
| I downloaded SSMS 2014 and then the AdventureWorks database. Through research, I checked the Configuration Manager and click SQL Server Services on the upper left to see what instances and server names I have. This window pane is blank.Why is this blank when I already downloaded SSMS and the AdventureWorks database?I am trying to find the server name and instance so I can log in. |
 |
|
|
desperadomar
Starting Member
3 Posts |
Posted - 2015-01-07 : 04:42:26
|
quote:
Originally posted by Rock_query
I downloaded SSMS 2014 and then the AdventureWorks database. Through research, I checked the Configuration Manager and click SQL Server Services on the upper left to see what instances and server names I have. This window pane is blank.Why is this blank when I already downloaded SSMS and the AdventureWorks database?I am trying to find the server name and instance so I can log in.
It seems that you have only installed the SQL Server management studio(IDE), no database engine is installed on your system (since it's not showing in the SQL Server Services in configuration manager).So you have to download the database engine from here(http://www.microsoft.com/en-us/server-cloud/products/sql-server-editions/sql-server-express.aspx) and install it show the sql server instance in configuration manager.Also you can see this link http://www.mssqltips.com/sqlservertip/3244/quick-guide-to-installing-sql-server-2014/which shows step by step procedure for installing sql serverHTH |
|
|
|
|
|
|
Logging in to SQL SMS 2014