• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 232
  • Last Modified:

I have installed sql server 2005 but it doesnt show server name during login.

I have installed sql server 2005 but it doesnt show server name during login. How to configure that.
0
searchsanjaysharma
Asked:
searchsanjaysharma
  • 2
  • 2
1 Solution
 
ven16Commented:
where you are checking the server name?
did you install management console, most of the people forgot to select management console during the installation.
0
 
sjurusCommented:
If this instance is default it name_instance is the same as the server name or rather than write the server name you write "."

When you dont have install SSMS you can connect by typing in command lines:

sqlcmd -S server_name

or

sqlcmd -S .

but if this instance is named you mast write server_name\instance_name

sqlcmd -S server_name\instance_name
0
 
searchsanjaysharmaAuthor Commented:
My sql server is showing server name as san-pc and on click of connect, its giving 18456 error
0
 
sjurusCommented:
look there
http://blogs.msdn.com/b/sql_protocols/archive/2006/02/21/536201.aspx

maybe your user don't have permission
0
 
searchsanjaysharmaAuthor Commented:
ok
0

Featured Post

[Webinar On Demand] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now