Solved

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

Posted on 2012-03-20
5
222 Views
Last Modified: 2012-03-21
I have installed sql server 2005 but it doesnt show server name during login. How to configure that.
0
Comment
Question by:searchsanjaysharma
  • 2
  • 2
5 Comments
 
LVL 2

Expert Comment

by:ven16
ID: 37745903
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
 
LVL 3

Expert Comment

by:sjurus
ID: 37745960
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
 

Author Comment

by:searchsanjaysharma
ID: 37746506
My sql server is showing server name as san-pc and on click of connect, its giving 18456 error
0
 
LVL 3

Accepted Solution

by:
sjurus earned 500 total points
ID: 37746516
look there
http://blogs.msdn.com/b/sql_protocols/archive/2006/02/21/536201.aspx

maybe your user don't have permission
0
 

Author Closing Comment

by:searchsanjaysharma
ID: 37750739
ok
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Dataset not reading table data 12 46
Group by correlation 4 55
How to print the sql query 18 51
execute a MS SQL script as a schedule SQL job 72 123
Recently, when I was asked to create a new SQL 2005 cluster, Microsoft released a new service pack for MS SQL 2005 what is Service Pack 3. When I finished the installation of MS SQL 2005 I found myself troubled why the installation of SP3 failed …
In SQL Server, when rows are selected from a table, does it retrieve data in the order in which it is inserted?  Many believe this is the case. Let us try to examine for ourselves with an example. To get started, use the following script, wh…
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …
Hi friends,  in this video  I'll show you how new windows 10 user can learn the using of windows 10. Thank you.

895 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now