Solved

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

Posted on 2012-03-20
5
224 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

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

I am showing a way to read/import the excel data in table using SQL server 2005... Suppose there is an Excel file "Book1" at location "C:\temp" with column "First Name" and "Last Name". Now to import this Excel data into the table, we will use…
When writing XML code a very difficult part is when we like to remove all the elements or attributes from the XML that have no data. I would like to share a set of recursive MSSQL stored procedures that I have made to remove those elements from …
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

860 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