cant connect to my databse in lan

[dotnetgal]

Hi all!

I am using MSSQL 2005 and asp.net .I have made a web application that needs to be run in LAN.The authentication used is windows authentication. The problem is that when in LAN I cannot connect to the database The sqlexception error shows that the connection is closed.Is there any thing that i am missing?Any configurations i need to make??Is this the issue of remote connections?? Please help!!I am new and dont knw much abt it .Thanks!!

[ck9663]

Hi all!

I am using MSSQL 2005 and asp.net .I have made a web application that needs to be run in LAN.The authentication used is windows authentication. The problem is that when in LAN I cannot connect to the database The sqlexception error shows that the connection is closed.Is there any thing that i am missing?Any configurations i need to make??Is this the issue of remote connections?? Please help!!I am new and dont knw much abt it .Thanks!!

yes you have to setup the Security of SQL Server to accept Mix Authentication

[dotnetgal]

yes you have to setup the Security of SQL Server to accept Mix Authentication

hello !!

Thanks for the reply.But how am i to set it up to accept Mix Authentication?

[ck9663]

hello !!

Thanks for the reply.But how am i to set it up to accept Mix Authentication?

open enterprise manager. right click on your server. choose properties. a dialog box will appear. choose Securtiy. on Server Authentication, choose SQL Server and Windows authentication mode

[dotnetgal]

open enterprise manager. right click on your server. choose properties. a dialog box will appear. choose Securtiy. on Server Authentication, choose SQL Server and Windows authentication mode

thanks!!I did it but dtill the problem persists!!Any idea?