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!!
Quote:
Originally Posted by 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!!
yes you have to setup the Security of SQL Server to accept Mix Authentication|||
Quote:
Originally Posted by ck9663
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?|||
Quote:
Originally Posted by dotnetgal
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|||
Quote:
Originally Posted by ck9663
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?
No comments:
Post a Comment