local server

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 General Discussion » local server

local server

Rate Topic

Display Mode

Topic Options

Author

Message

solus

Posted Friday, June 05, 2009 2:16 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, November 13, 2012 3:17 AM
Points: 133, Visits: 244

i need to use my local database server for development but its not available in the local server selection list (only sql server express)
How do I install it ?

Post #729470

Eswin

Posted Friday, June 05, 2009 2:30 AM

SSCommitted

Group: General Forum Members
Last Login: 2 days ago @ 4:19 AM
Points: 1,593, Visits: 1,025

Check weather named pipes are enabled.

Tanx BigGrin

Post #729476

solus

Posted Friday, June 05, 2009 2:41 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, November 13, 2012 3:17 AM
Points: 133, Visits: 244

how do i do that ?

Post #729481

Florian Reischl

Posted Friday, June 05, 2009 9:11 AM

SSCrazy

Group: General Forum Members
Last Login: Sunday, November 04, 2012 12:23 PM
Points: 2,087, Visits: 3,932

First
Start -> Programs -> Microsoft SQL Server 2005 -> Configuration Tools -> SQL Server Configuration Tools
Then
SQL Server Network Configuration -> Protocols for MSSQLSERVER

Restart the SQL Server Service. If you are using Express Edition you need to use your SQL Server as:
(local)\SQLExpress
or
.\SQLExpress
or
localhost\SQLExpress
or
YourComputerName\SQLExpress

Greets
Flo

The more I learn, the more I know what I do not know
Blog: Things about Software Architecture, .NET development and T-SQL

How to Post Data/Code to get the best Help How to Post Performance Problems

Post #729820

« Prev Topic | Next Topic »

Permissions