Question about Microsoft Visual Studio 2005 Professional Edition

1 Answer

How to configure the sql server 2005 - Microsoft Visual Studio 2005 Professional Edition

Posted by on

1 Answer

  • Level 1:

    An expert who has achieved level 1.

    Corporal:

    An expert that hasĀ over 10 points.

    Mayor:

    An expert whose answer gotĀ voted for 2 times.

    Problem Solver:

    An expert who has answered 5 questions.

  • Contributor
  • 16 Answers

Enable remote connections for SQL Server 2005 Express or SQL Server 2005 Developer Edition loadTOCNode(2, 'moreinformation'); You must enable remote connections for each instance of SQL Server 2005 that you want to connect to from a remote computer. To do this, follow these steps:

  1. Click Start, point to Programs, point to Microsoft SQL Server 2005, point to Configuration Tools, and then click SQL Server Surface Area Configuration.
  2. On the SQL Server 2005 Surface Area Configuration page, click Surface Area Configuration for Services and Connections.
  3. On the Surface Area Configuration for Services and Connections page, expand Database Engine, click Remote Connections, click Local and remote connections, click the appropriate protocol to enable for your environment, and then click Apply.

    Note Click OK when you receive the following message:Changes to Connection Settings will not take effect until you restart the Database Engine service.
  4. On the Surface Area Configuration for Services and Connections page, expand Database Engine, click Service, click Stop, wait until the MSSQLSERVER service stops, and then click Start to restart the MSSQLSERVER service.

Posted on Feb 28, 2009

  • rajinder Feb 03, 2013

    thnx! i use the same seeting as you said of databse engine->remote connections - but when i want to stop it i got error message...that means the service cannot stop so what should now do help!

  • rajinder Feb 03, 2013

    secondly i set it for local connection only. but there i got a error as i attached a image with it........

×

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

4 Answers

Some requirement for SQL server repair


Read this blog at the following link: http://recoverymaster.livejournal.com and know helpful details about MS SQL server database recovery wizard. You can download this software: http://www.sqlrecovery.org

Jun 10, 2014 | Microsoft Database Software A5K-02817 SQL...

14 Answers

How can I repair a corrupted MDF files and SQL server?


Similar question has been answered here: http://www.fixya.com/support/t24364927-sql_repair_recovery_process_very

Before asking any question in the forum, first you need to search your problem.

May 12, 2014 | Microsoft Database Software A5K-02817 SQL...

8 Answers

I forgot my sql server password, and i need to get the sql sa password back, how can i retrieve my sql sa password? its SQL server 2005. Any advice is ok, i dont want to reinstall the SQL server, Thanks in...


Lost or forgot your administrator/user password for Microsoft SQL Server?
If so, turn to help from AnyPasskey SQL Password Recovery, which is a professional program enables you reset administrator or user password for Microsoft SQL Server instantly regardless of the length, complexity, language and encoding of the password set before. As long as you got AnyPasskey SQL Password Recovery and master.mdf file, you could reset SA password on any authorized PC in minutes without the installation of Microsoft SQL Server. What's more, this featured-in tool supports all versions of Microsoft SQL Server and Microsoft SQL Server Express perfectly. 6_21_2012_1_55_07_am.jpg

Sep 15, 2010 | Compilers & Programming Tools

5 Answers

Need Help to backup SQL database in safe mode


kindly choose the option safe mode with networking and then try.

Sep 10, 2009 | Microsoft Compilers & Programming Tools

1 Answer

Unable to create database from within VWD 2005 Express


try to complete uninstall .net framework and install it again or get the latest copy of .net framework to install 3.5 latest version already available for download

Dec 01, 2008 | Compilers & Programming Tools

1 Answer

I want to install SQL server2000 free!


you cant get sql server 2000 free, but you can get sql 2005 express edition free. http://www.microsoft.com/downloads/details.aspx?familyid=220549b5-0b07-4448-8848-dcc397514b41&displaylang=en this is the link to download SQL 2005 express edition. This is same as SQL 2000 if you just want to work on queries.

Oct 19, 2008 | Microsoft MS SQL SERVER (810-01567-3-1)...

1 Answer

SQL Server 2005


All versions support Vista.

Feb 18, 2008 | Compilers & Programming Tools

Not finding what you are looking for?
Microsoft Visual Studio 2005 Professional Edition Logo

Related Topics:

237 people viewed this question

Ask a Question

Usually answered in minutes!

Top Microsoft Compilers & Programming Tools Experts

Fred Block
Fred Block

Level 2 Expert

289 Answers

Robin Hill
Robin Hill

Level 3 Expert

1251 Answers

Brian Sullivan
Brian Sullivan

Level 3 Expert

27725 Answers

Are you a Microsoft Compiler and Programming Tool Expert? Answer questions, earn points and help others

Answer questions

Manuals & User Guides

Loading...