----------------------------------------------------------- New Message on BDOTNET
----------------------------------------------------------- From: Mahesh ChandraMouli Message 7 in Discussion Hi Shesha, The 1st step you need to do his try connecting SQL Server DB from Sql query Analyzer with these creditionals. Check whether it is logging into the system, if it is not going thru u might be running under windows user. u need to use trusted connection in the connection string. Regards Mahesh ChandraMouli Microsoft .NET MVP | MCAD (Charter Member) Global Microsoft Business Unit Wipro Technologies Bangalore -----Original Message----- From: Shesha [mailto:[EMAIL PROTECTED] Sent: Monday, October 27, 2003 12:06 PM To: BDOTNET Subject: Web Application : SQL Server does not exist or access denied New Message on BDOTNET Web Application : SQL Server does not exist or access denied Reply Reply to Sender Recommend Message 1 in Discussion From: Shesha Hi, I am getting the "SQL Server does not exist or access denied" error when I try to connect to SQL in "Web Application". I have pasted the exact error below. I have 2 databases. One in the local m/c and the other on the main server. I am unable to connect to any of the database. I am able to connect to the database using "Windows Application". I am using an SQL Connection Object and the connectio string is workstation id=SHESHA;packet size=4096;user id=sa;data source=SHESHA;persist security info=False;initial catalog=AIMS I am also pasting the WEB.CONFIG information at the bottom of this mail. An immediate help on this is highly appreciated. Thanks Shesha ERROR: ---------- System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.Data.SqlClient.SqlException: SQL Server does not exist or access denied. at System.Data.SqlClient.ConnectionPool.GetConnection(Boolean& isInTransaction) at System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString options, Boolean& isInTransaction) at System.Data.SqlClient.SqlConnection.Open() at System.Data.Common.DbDataAdapter.QuietOpen(IDbConnection connection, ConnectionState& originalState) at System.Data.Common.DbDataAdapter.FillFromCommand(Object data, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior) at System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable) at VBCarsWebService.Service1.GetAllUsers() in c:\inetpub\wwwroot\VBCarsWebService\Service1.asmx.vb:line 63 --- End of inner exception stack trace --- SuperSocket info: (SpnRegister) : Error 1355. WEB.CONFIG. ------------------- <?xml version="1.0" encoding="utf-8" ?> <configuration> <!-- <add key="ConnectionString" value="server=SHESHA;Trusted_Connection=true;database=AimsErp" /> <add key="CountryRegionsStore"value="OleDB" /> <add key="CountryRegionsStoreParameters" value="Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security Info=False;Initial Catalog=AimsErp;Data Source=AimsErp;" /> --> <system.web> <!-- DYNAMIC DEBUG COMPILATION Set compilation debug="true" to insert debugging symbols (.pdb information) into the compiled page. Because this creates a larger file that executes more slowly, you should set this value to true only when debugging and to false at all other times. For more information, refer to the documentation about debugging ASP.NET files. --> <compilation defaultLanguage="vb" debug="true" /> <!-- CUSTOM ERROR MESSAGES Set customErrors mode="On" or "RemoteOnly" to enable custom error messages, "Off" to disable. Add <error> tags foreach of the errors you want to handle. "On" Always display custom (friendly) messages. "Off" Always displaydetailed ASP.NET error information. "RemoteOnly" Displaycustom (friendly) messages only to users not running on the local Web server. This setting is recommended for security purposes, so that you do not display application detail information to remote clients. --> <customErrors mode="RemoteOnly" /> <!-- AUTHENTICATION This section sets the authentication policies of the application. Possible modes are "Windows", "Forms", "Passport" and "None" "None" No authentication is performed. "Windows" IIS performs authentication (Basic, Digest, or Integrated Windows) according to its settings for the application. Anonymous access must be disabled in IIS. "Forms" You provide a custom form (Web page) for users to enter their credentials, and then you authenticate them in your application. A user credential token is stored in a cookie. "Passport" Authentication is performed via a centralized authentication service provided by Microsoft that offers a single logon and core profile services for member sites. --> <authentication mode="Windows" /> <!-- AUTHORIZATION This section sets the authorization policies of the application. You can allow or deny access to application resources by user or role. Wildcards: "*" mean everyone, "?" means anonymous (unauthenticated) users. --> <authorization> <allow users="*" /> <!-- Allow all users --> <!-- <allow users="[comma separated list of users]" roles="[comma separated list of roles]"/> <deny users="[comma separated list of users]" roles="[comma separated list of roles]"/> --> </authorization> <!-- APPLICATION-LEVEL TRACE LOGGING Application-level tracing enables trace log output for every page within an application. Set trace enabled="true" to enable application trace logging. If pageOutput="true", the trace information will be displayed at the bottom of each page. Otherwise, you can view the application trace log by browsing the "trace.axd" page from your web application root. --> <trace enabled="false" requestLimit="10" pageOutput="false" traceMode="SortByTime" localOnly="true" /> <!-- SESSION STATE SETTINGS By default ASP.NET uses cookies to identify which requests belong to a particular session. If cookies are not available, a session can be tracked by adding a session identifier to the URL. To disable cookies, set sessionState cookieless="true". --> <sessionState mode="InProc" stateConnectionString="tcpip=127.0.0.1:42424" sqlConnectionString="data source=127.0.0.1;Trusted_Connection=yes" cookieless="false" timeout="20" /> <!-- GLOBALIZATION This section sets the globalization settings of the application. --> <globalization requestEncoding="utf-8" responseEncoding="utf-8" /> </system.web> </configuration> View other groups in this category. ----------------------------------------------------------- To stop getting this e-mail, or change how often it arrives, go to your E-mail Settings. http://groups.msn.com/bdotnet/_emailsettings.msnw Need help? If you've forgotten your password, please go to Passport Member Services. http://groups.msn.com/_passportredir.msnw?ppmprop=help For other questions or feedback, go to our Contact Us page. http://groups.msn.com/contact If you do not want to receive future e-mail from this MSN group, or if you received this message by mistake, please click the "Remove" link below. On the pre-addressed e-mail message that opens, simply click "Send". Your e-mail address will be deleted from this group's mailing list. mailto:[EMAIL PROTECTED]
