Sql Connection Open Problem

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • KalariaNitya
    New Member
    • Apr 2008
    • 34

    Sql Connection Open Problem

    Hello, all

    i need ur help..

    i want to coonect remote server

    my connection string is:----(web.config)

    <add key="connString " value="server=9 8.130.0.149;Ini tial Catalog=angels0 _mrsbpl;User ID=angels0_mrsb plcontra;Passwo rd=mrs21;connec t timeout=200;poo ling=true;max pool size=200"/>


    when i press on Login Button & when debugger came to cn.open
    i got below error:


    System.Data.Sql Client.SqlExcep tion: SQL Server does not exist or access denied. at System.Data.Sql Client.Connecti onPool.GetConne ction(Boolean& isInTransaction ) at System.Data.Sql Client.SqlConne ctionPoolManage r.GetPooledConn ection(SqlConne ctionString options, Boolean& isInTransaction ) at System.Data.Sql Client.SqlConne ction.Open() at digitalcontract .WebForm1.btnlo gin_Click(Objec t sender, EventArgs e) in c:\inetpub\wwwr oot\digitalcont ract\login.aspx .vb:line 96

    my server side code's 96 line is
    cn.Open()

    can any body help me?
    thanking u in advanced..
  • r035198x
    MVP
    • Sep 2006
    • 13225

    #2
    Don't you need a port for the connection?
    Do you also have rights to access that machine?

    Comment

    Working...