SQL Server does not exist or access denied [modified]
-
My colleague is not able to access the sql server that resides in my local system from the asp.net application in her pc even though my sql server is running. She is able to access my sql server using her query analyser. The code in web.config add key="ConnectionString" value="Data Source=Myservername;User Id=mysqlservername; Password=mysqlserverpassword;Initial Catalog=mydatabasename;Connection Lifetime=30" I have used the same code in my web.config and i am able to access my sql server. Do tell if i have to give some rights for her to access my sql server through asp.net application -- modified at 6:59 Tuesday 23rd May, 2006
-
My colleague is not able to access the sql server that resides in my local system from the asp.net application in her pc even though my sql server is running. She is able to access my sql server using her query analyser. The code in web.config add key="ConnectionString" value="Data Source=Myservername;User Id=mysqlservername; Password=mysqlserverpassword;Initial Catalog=mydatabasename;Connection Lifetime=30" I have used the same code in my web.config and i am able to access my sql server. Do tell if i have to give some rights for her to access my sql server through asp.net application -- modified at 6:59 Tuesday 23rd May, 2006
-
Check sql server authentication mode in your Enterprise manager. Try changing it to work in both windows and sql server mode.
Thanks for the reply. The authentication mode is SQL Server and Windows.