database connection through web services

tofuyan

Member
Joined
Mar 16, 2005
Messages
8
Programming Experience
Beginner
When i debug my web services ad run it in the internet explorer.

And i click one of the function link,the following message error appear. i try the connest it's prompt "Test successfully".

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)
at WebService3.Service1.ShowAlert() in c:\inetpub\wwwroot\webservice3\service1.asmx.cs:line 79


Why???

Can anyone help me solve???
Thanks
 

gripusa

Well-known member
Joined
Apr 29, 2005
Messages
73
Location
Lahore Pakistan
Programming Experience
1-3
u r using the ASP.NET user to logon to SQL server which dont have rights to it by default .
and why it is working normally because in such case you either go through windows user or sa etc
 
Top Bottom