Code Runs Fine On 1 Machine But On Other It Gives Error

Hi,

I am using Sql database in my asp.net application. the code runs fine on the machine where i m developing but when I try to run the code on other machine it gives following error--

error is related to access to database.(sql personal server is installed on local machine) I m giving the following connection string---


"Server=localhost;UID=sa;PWD=mypassword;Database=try1"

I have reinstalled the sql server  using mixed mode authentication and  the same sa password but still problem continues..

THE ERROR IT GIVES IS---

Server Error in '/try1' Application.


SQL Server does not exist or access denied. Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: SQL Server does not exist or access denied.

Source Error:





Line 49: SqlCommand cmdSelect;
Line 50: cmdSelect = new SqlCommand("select * FROM Departments", sqlConn);
Line 51: sqlConn.Open();
Line 52: return cmdSelect.ExecuteReader(CommandBehavior.CloseConnection);
Line 53: }
Source File: c:inetpubwwwroot ry1DataAccessCode.cs    Line: 51

Stack Trace:





[SqlException: SQL Server does not exist or access denied.]
System.Data.SqlClient.ConnectionPool.GetConnection(Boolean& isInTransaction)
System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString options, Boolean& isInTransaction)
System.Data.SqlClient.SqlConnection.Open()
try1.DataAccessCode.getDept() in c:inetpubwwwroot ry1DataAccessCode.cs:51
try1.WebForm1.Page_Load(Object sender, EventArgs e) in c:inetpubwwwroot ry1Login.aspx.cs:35
System.Web.UI.Control.OnLoad(EventArgs e)
System.Web.UI.Control.LoadRecursive()
System.Web.UI.Page.ProcessRequestMain()



Version Information: Microsoft .NET Framework Version:1.1.4322.573; ASP.NET Version:1.1.4322.573