Reply to thread

Message

<blockquote data-quote="Rhys.Goodwin" data-source="post: 109418" data-attributes="member: 27017">Just need sql server xpress on server not client. As mentioned make sure broowser service is running and also check your sql server config. Go to SQL Server Surface Area Configuration. &gt; SQL Server 2005 Surface&nbsp; Configuration for services and Connections &gt; SQLEXPRESS&gt;Database Engine&gt;Remote Connections Select &quot;Local and remote connections&quot;&nbsp; and &quot;Using TCP/IP Only&quot; You can test the sql server from remote client by going to Control panel&gt;Administrative Tools&gt;ODBC Datasources&gt;Add select SQl Server(Bottom of list)&gt;FinishEnter server for name and server&gt;Nextselect SQL Authentication tick Connect to SQl Server.....enter sa username and password &gt;Next&gt;Next&gt;Next&gt;Test Data SourceIf all is working then test will be sucessful. SQL server is now working from network client.</blockquote>

[QUOTE="Rhys.Goodwin, post: 109418, member: 27017"] Just need sql server xpress on server not client. As mentioned make sure broowser service is running and also check your sql server config. Go to [B]SQL Server Surface Area Configuration[/B]. > [B]SQL Server 2005 Surface Configuration for services and Connections[/B] > [B]SQLEXPRESS[/B]>[B]Database Engine[/B]>[B]Remote Connections[/B] Select [B]"Local and remote connections"[/B] and [B]"Using TCP/IP Only"[/B] You can test the sql server from remote client by going to [B]Control panel[/B]>[B]Administrative Tools[/B]>[B]ODBC Datasources[/B]>[B]Add[/B] select [B]SQl Server(Bottom of list)[/B]>[B]Finish[/B]Enter server for [B]name[/B] and [B]server[/B]>[B]Next[/B]select [B]SQL Authentication[/B] tick [B]Connect to SQl Server.....[/B]enter sa username and password >[B]Next[/B]>[B]Next[/B]>[B]Next[/B]>[B]Test Data Source[/B] If all is working then test will be sucessful. SQL server is now working from network client. [/QUOTE]

Verification