یک نگاهی هم به این بیانداز
حتما به دردت خواهد خورد
By default when you install SQL Server 2005 Express Edition, connections are only possible via the Shared Memory protocol on the same machine and only then by the new sqlcmd commandline tool ( the replacement for osql/isql). In order to connect from downlevel clients (such as Query Analyzer) or from another machine, you have to follow a number of steps detailed below. The walkthrough is for a default named instance called SQLEXPRESS.
- Goto Start>Programs>Microsoft SQL Server 2005>SQL Computer Manager
- Expand Server Network Configuration in the left pane
- Select Protocols for SQLEXPRESS in the left pane
- Right click on Np in the right pane and select Enable
- Right click on Tcp in the right pane and select Enable
- Restart the SQL Express service (MSSQL$SQLEXPRESS)
- Goto Start>Run and type in services.msc and hit Enter
- Locate the SQL Browser service in the list of services and start it