tags:

views:

39

answers:

3
Q: 

SQL Server 2005 - What is the "Server Name"?

Hello all,

I just finished installing the SQL Server 2005 Developer Edition on Windows 7. Here is the question, when I first load SQL Server Management Studio, what is the server name I have to use?

Server Type: Database Engine
Server Name:
Authentication: Windows Authentication
Username: Linda-HP\Linda

So what server name should I use?

thank you

A: 

Most likely localhost or . or you computer name works for the server name if you didn't specify the name of the instance during the installation.

A_Nablsi  2010-10-30 23:40:48
I have tried localhost and the computer name. Neither of them works for me. -- thank you
q0987  2010-10-31 00:06:42
A: 

Server name would be Linda-HP or (local)

Andrew Barber  2010-10-30 23:42:21
I have tried Linda-HP and lcoal, neight of them works for me. I didn't install IIS Feature requirement and ASP.net version registration requirement. I don't know whether that causes the problem. --thank you
q0987  2010-10-31 00:07:44
@q0987: you need to specify `(local)` (**including** the parenthesis) - not just `local` - for this to work - does that work??
marc_s  2010-10-31 07:15:43
A: 

Run sp_helpserver to know the instance name.

anivas  2010-10-31 12:46:37

related questions

SQL Server, convert a named instance to default instance?
Natural (human alpha-numeric) sort in Microsoft SQL 2005
In MS SQL Server 2005, is there a way to export, the complete maintenance plan of a database as a SQL Script?
Does ReadUncommitted imply NoLock
Query to list all tables that contain a specific column with SQL Server 2005.
Can I maintain state between calls to a SQL Server UDF?
What are the benefits of using partitions with the Enterprise edition of SQL 2005
Upgrading Sharepoint 3.0 to SQL 2005 Backend?
What's the simplest way to execute a query in Visual C++
Can you perform an AND search of keywords using FREETEXT() on SQL Server 2005?
Create a database from another database?
What's the fastest way to bulk insert a lot of data in SQL Server (C# client)
SQL 2005 Book For Optimization Techniques
How do I create a mapping table in SQL Server Management Studio?
Cannot Add a Sql Server Login
SQL Server 2005 - Export table programatically (run a .sql file to rebuild it)
Diagnosing Deadlocks in SQL Server 2005
SQL2005: Linking a table to multiple tables and retaining Ref Integrity?
How to create a new instance of Sql Server 2005
SQL Server 2008 vs 2005 Linq integration
How do you kill all current connections to a SQL Server 2005 database?
Conditional Visibility and Page Breaks with SQL Server 2005 Reporting Services
SQL Server 2005 and 2008 on same developer machine?
Paging SQL Server 2005 Results
SQL 2005 For XML Explicit - Need help formatting