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.
searchsanjaysharmaAsked:
Who is Participating?
 
sjurusCommented:
look there
http://blogs.msdn.com/b/sql_protocols/archive/2006/02/21/536201.aspx

maybe your user don't have permission
0
 
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
 
searchsanjaysharmaAuthor Commented:
ok
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.