Reply to thread

Message

<blockquote data-quote="c50cnameless" data-source="post: 217660" data-attributes="member: 52085">HiI can only assume this is a sql express problem, because I have install MS Sql Server Management Studio Express on another machine, and when you Browse for server name it finds the server (TVSERVER\SQLEXPRESS), but then when i connect (using sa and the password i specified) I gives the following error:An error has occurred while establishing a connection to the server.&nbsp; When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1)Is this enlightning for anyone.&nbsp; All I can find is:Make sure sqlbrowse is running (it is and I assume the fact that MSSqlSMSE can find it proves that), check firewall open (i have disabled firewall and restarted).&nbsp; Not sure what else to try?&nbsp; I can post more on TVServer3 / Mediaportal if neccessary, but I feel that perhaps this is where the problem is</blockquote>

[QUOTE="c50cnameless, post: 217660, member: 52085"] Hi I can only assume this is a sql express problem, because I have install MS Sql Server Management Studio Express on another machine, and when you Browse for server name it finds the server (TVSERVER\SQLEXPRESS), but then when i connect (using sa and the password i specified) I gives the following error: An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (Microsoft SQL Server, Error: -1) Is this enlightning for anyone. All I can find is: Make sure sqlbrowse is running (it is and I assume the fact that MSSqlSMSE can find it proves that), check firewall open (i have disabled firewall and restarted). Not sure what else to try? I can post more on TVServer3 / Mediaportal if neccessary, but I feel that perhaps this is where the problem is [/QUOTE]

Verification