tags:

views:

15

answers:

1
Q: 

Unable to connect to SQL Server 2005

I am trying to connect to SQL Server 2005 express edition from SQL Server Management.

From the server configuration manager, I found the SQL Server Service to be running and within bracket, it's written(SQLEXPRESS). I understand SQLEXPRESS is the instance name, therefore I have to use following string for server name: \SQLEXPRESS.

I am using windows authentication. I am logged into an account that is non admin.

Can someone suggest me how I can establish the connection.

Thanks.

+1  A: 

Try .\SQLEXPRESS..

From here:

By default, SQL Server Express installs as an instance named "SQLEXPRESS," for example. You connect to a named instance by specifying the instance name with the server name in the connection string. That is why you normally specify ".\SQLEXPRESS" as the server name when connecting to a local SQL Server Express database. The dot means the local server and \SQLEXPRESS specifies the SQLEXPRESS named instance.

Steve Townsend  2010-10-28 16:08:55
do you mean IP.\SQLEXPRESS or just .\SQLEXPRESS
Gunner  2010-10-28 16:10:19
Cool, it worked with .\SQLEXPRESS. Just want to know, why it didn't work with IP?
Gunner  2010-10-28 16:11:08
`.` just means 'it's on the local server'. If you want to use IP address I imagine it would involve `127.0.0.1` or `localhost` somehow.
Steve Townsend  2010-10-28 16:12:29
What about directly using my IP address as registered in the system?
Gunner  2010-10-29 05:17:08
SQL Server defaults to TCP/IP so using the '.' as you are now doing already does this. See here - http://msdn.microsoft.com/en-us/library/ms191260.aspx. Are you talking now about connecting from another remote system?
Steve Townsend  2010-10-29 10:55:55

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