Problem in networking the windows 7 PC with SQL Express 2008 R2 where OS Windows 7.
The solution is as follows.
You have to configure the Network options that are disabled by default.
>
> 1. In the Start Menu, open Programs > Microsoft SQL Server 2008 >
> Configuration Tools > SQL Server Surface Area Configuration
> 2. In the Surface Area Configuration utility, click the link "SQL Server
> Configuration Manager"
> 3. Expand "SQL Server Network Configuration" and select Protocols.
> 4. Enable TCP/IP. If you need Named Pipes, then you can enable them here as
> well.
> 5. Close the SQL Server Configuration Manager.
>
> When you have completed all of these steps, you will need to restart the SQL
> Server and SQL Browser services to complete the process. If you still have
> problems, you may need to restart your server.
>
> 1. In the Start Menu, open Programs > Microsoft SQL Server 2008 >
> Configuration Tools > SQL Server Surface Area Configuration
> 2. In the Surface Area Configuration utility, click the link "SQL Server
> Configuration Manager"
> 3. Expand "SQL Server Network Configuration" and select Protocols.
> 4. Enable TCP/IP. If you need Named Pipes, then you can enable them here as
> well.
> 5. Close the SQL Server Configuration Manager.
>
> When you have completed all of these steps, you will need to restart the SQL
> Server and SQL Browser services to complete the process. If you still have
> problems, you may need to restart your server.
No comments:
Post a Comment