C
ChiWhiteSox
Hi
created a web app using the asp:Login component in machine A. SQL and VS2005
is also in machine A. I copied the entire project source to machine B and
modified
the machine B's web.config into
<connectionStrings>
<remove name="LocalSqlServer"/>
<add name="SQLConn" connectionString="data source=machineA;Initial
Catalog=automobile;User ID=sa;Password=secret"
providerName="System.Data.SqlClient"/>
</connectionStrings>
after runnning the project at machine B and logging in, i get this sql error:
[SqlException (0x80131904): 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)]
any ideas??
created a web app using the asp:Login component in machine A. SQL and VS2005
is also in machine A. I copied the entire project source to machine B and
modified
the machine B's web.config into
<connectionStrings>
<remove name="LocalSqlServer"/>
<add name="SQLConn" connectionString="data source=machineA;Initial
Catalog=automobile;User ID=sa;Password=secret"
providerName="System.Data.SqlClient"/>
</connectionStrings>
after runnning the project at machine B and logging in, i get this sql error:
[SqlException (0x80131904): 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)]
any ideas??