1.Your Sql Server Config,TCP/IP and sa access 2.Your Sql Server UserName and Password
On 8月25日, 下午4时50分, Wyrm <[email protected]> wrote: > I'll add that your quotes can be confusing for the sql driver. > You could either remove them or encase the servername only. > > Either > private string conns = "Data Source = MOI-PC\SQLEXPRESS; Initial > Catalog = Project; User ID = sa; Password = madurai; Connect Timeout = > 60;"; > or > private string conns = "Data Source = 'MOI-PC\SQLEXPRESS'; > Initial Catalog = Project; User ID = sa; Password = madurai; Connect > Timeout = 60;"; > should work. > > On 24 août, 19:51, stanlei <[email protected]> wrote: > > > > > i've been trying this for days and i just dont know what the problem > > is ... > > > im using: > > > private string conns = "Data Source = 'MOI-PC/SQLEXPRESS;Initial > > Catalog = Project; User ID = sa; Password = madurai'; Connect Timeout > > = 60;"; > > > SqlConnection conn = new SqlConnection(conns); > > conn.ConnectionString = conns; > > > try > > { > > conn.Open(); > > } > > catch (Exception ex) > > { > > > MessageBox.Show("ERROR \n"+ex.Message); > > } > > > All i get is .. > > > A network-related or instance-specific error occurred while > > establishing a connection to SQL Server. The server was not found or > > was not accessible. Verify that the instance name is correct and that > > SQL Server is configured to allow remote connections. (provider: Named > > Pipes Provider, error: 40 - Could not open a connection to SQL Server) > > > I use Windows Vista Ultimate SP2, SQL server 2005 SP3 and Visual > > Studio 2005 > > sql server is configured to accept remote connections .... both tcp/ip > > n named pipes > > my sql browser is running .... > > > any help would be greatly appreciated!!
