none
Trouble Connecting to Remote SQL Server RRS feed

  • Question

  • I have been developing a Windows application using VS2005 that I have loaded on 2 side-by-side servers (one for development, one for testing) connected through my local network.   Each server also contained seperate copies of SQL Server 2000 before SQL Server Express 2005 was also loaded via the install of VS2005.

     

    Using SQL Server 2000 Enterprise manager I can use SQL Server authentication and connect from the development machine to the test machine and open and examine the necessary database.

     

    When I select New Connection from the Data Source Configuration Wizard I can get the testing server to show up in the Server Name list.   However, this is where the good news ends.   Using the same SQL Server authentication information as I used to connect in SQL Server Enterprise Manager, I cannot connect to the desired Database.

     

    Need help!   Thanks in advance to anyone who can shed some light on this problem.

     

    Thursday, September 27, 2007 10:33 PM

Answers

  • You have two options download and install the Express Management studio or uninstall Express and download and install Express Advanced it is like the developer edition without SQL Server Agent.  Then you need to configure SQL Server Express to use mixed authentication and remote connection.  when you configure SQL Server to use mixed authentication you still need to enable the sa account because when you install with Windows authentication the sa account is disabled.  I have covered configuring SQL Server for remote connection in the thread below and you can download the file you need from the link below.  Hope this helps.


    http://msdn2.microsoft.com/en-us/express/bb410792.aspx

     

    http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2121028&SiteID=1

     

    Thursday, October 4, 2007 3:44 PM