Connection of ASP.Net App. to sql 2005

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

Connection of ASP.Net App. to sql 2005

Author

Topic

tariq_erp
Starting Member

9 Posts

Posted - 2008-02-13 : 05:00:42

Hi All

I connect to my SQL server 2005 using SQL server management console quite nicely but when ever my asp.net 1.1 applicaiton tries to connect to it, it throughs following exception :

System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.ApplicationException: Unexpected error occured in signonAgent.getUser(). ---> System.ApplicationException: Unexpected general error in signonDataAgent.getUser(). ---> System.ArgumentException: Keyword not supported: 'isplws09\isplws092005;database'. at System.Data.Common.DBConnectionString.ParseInternal(Char[] connectionString, UdlSupport checkForUdl, NameValuePair& keychain) at System.Data.Common.DBConnectionString..ctor(String connectionString, UdlSupport checkForUdl) at System.Data.SqlClient.SqlConnectionString..ctor(String connectionString) at System.Data.SqlClient.SqlConnectionString.ParseString(String connectionString) at System.Data.SqlClient.SqlConnection.set_ConnectionString(String value) at System.Data.SqlClient.SqlConnection..ctor(String connectionString) at Myoasis.DatabaseHelper.ExecuteReader(SqlCommand cmd) at Myoasis.signonws.signonDataAgent.getUser(String userEmail, String passWord, String iP, Int32& errorCode) --- End of inner exception stack trace --- at Myoasis.signonws.signonDataAgent.getUser(String userEmail, String passWord, String iP, Int32& errorCode) at Myoasis.signonws.signonAgent.getUser(String userEmail, String passWord, String iP, Int32& errorCode) --- End of inner exception stack trace --- at Myoasis.signonws.signonAgent.getUser(String userEmail, String passWord, String iP, Int32& errorCode) at Myoasis.signonws.User.AuthenticateUser() at Myoasis.signonws.signonAuthenticator.AuthenticateUser(String UID, String PWD, String UserAgent, String IP) --- End of inner exception stack trace ---

Can any one sugest me a solution?

tprupsis
Yak Posting Veteran

88 Posts

Posted - 2008-02-13 : 10:32:56

Looks like your connection string isn't setup right? Check out http://connectionstrings.com/ to get the right string setup.

Dilipv
Starting Member

4 Posts

Posted - 2008-02-18 : 05:11:39

quote:
Originally posted by tariq_erp

Hi All

I connect to my SQL server 2005 using SQL server management console quite nicely but when ever my asp.net 1.1 applicaiton tries to connect to it, it throughs following exception :

System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.ApplicationException: Unexpected error occured in signonAgent.getUser(). ---> System.ApplicationException: Unexpected general error in signonDataAgent.getUser(). ---> System.ArgumentException: Keyword not supported: 'isplws09\isplws092005;database'. at System.Data.Common.DBConnectionString.ParseInternal(Char[] connectionString, UdlSupport checkForUdl, NameValuePair& keychain) at System.Data.Common.DBConnectionString..ctor(String connectionString, UdlSupport checkForUdl) at System.Data.SqlClient.SqlConnectionString..ctor(String connectionString) at System.Data.SqlClient.SqlConnectionString.ParseString(String connectionString) at System.Data.SqlClient.SqlConnection.set_ConnectionString(String value) at System.Data.SqlClient.SqlConnection..ctor(String connectionString) at Myoasis.DatabaseHelper.ExecuteReader(SqlCommand cmd) at Myoasis.signonws.signonDataAgent.getUser(String userEmail, String passWord, String iP, Int32& errorCode) --- End of inner exception stack trace --- at Myoasis.signonws.signonDataAgent.getUser(String userEmail, String passWord, String iP, Int32& errorCode) at Myoasis.signonws.signonAgent.getUser(String userEmail, String passWord, String iP, Int32& errorCode) --- End of inner exception stack trace --- at Myoasis.signonws.signonAgent.getUser(String userEmail, String passWord, String iP, Int32& errorCode) at Myoasis.signonws.User.AuthenticateUser() at Myoasis.signonws.signonAuthenticator.AuthenticateUser(String UID, String PWD, String UserAgent, String IP) --- End of inner exception stack trace ---

Can any one sugest me a solution?

[url=http://www.intelcs.com/].Net Consulting[/url]

Dilipv
Starting Member

4 Posts

Posted - 2008-02-18 : 06:28:11

quote:
Originally posted by tariq_erp

Hi All

I connect to my SQL server 2005 using SQL server management console quite nicely but when ever my asp.net 1.1 applicaiton tries to connect to it, it throughs following exception :

System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> System.ApplicationException: Unexpected error occured in signonAgent.getUser(). ---> System.ApplicationException: Unexpected general error in signonDataAgent.getUser(). ---> System.ArgumentException: Keyword not supported: 'isplws09\isplws092005;database'. at System.Data.Common.DBConnectionString.ParseInternal(Char[] connectionString, UdlSupport checkForUdl, NameValuePair& keychain) at System.Data.Common.DBConnectionString..ctor(String connectionString, UdlSupport checkForUdl) at System.Data.SqlClient.SqlConnectionString..ctor(String connectionString) at System.Data.SqlClient.SqlConnectionString.ParseString(String connectionString) at System.Data.SqlClient.SqlConnection.set_ConnectionString(String value) at System.Data.SqlClient.SqlConnection..ctor(String connectionString) at Myoasis.DatabaseHelper.ExecuteReader(SqlCommand cmd) at Myoasis.signonws.signonDataAgent.getUser(String userEmail, String passWord, String iP, Int32& errorCode) --- End of inner exception stack trace --- at Myoasis.signonws.signonDataAgent.getUser(String userEmail, String passWord, String iP, Int32& errorCode) at Myoasis.signonws.signonAgent.getUser(String userEmail, String passWord, String iP, Int32& errorCode) --- End of inner exception stack trace --- at Myoasis.signonws.signonAgent.getUser(String userEmail, String passWord, String iP, Int32& errorCode) at Myoasis.signonws.User.AuthenticateUser() at Myoasis.signonws.signonAuthenticator.AuthenticateUser(String UID, String PWD, String UserAgent, String IP) --- End of inner exception stack trace ---

Can any one sugest me a solution?

hi tariq,

i was your post.i think u had not passed the connection string properly.just try the following code, just check did u mentioned the namespace System.data.Sql

<connectionStrings>
<add name="NorthindConnectionString"
connectionString=" Server=MyDataServer;Integrated Security=SSPI;Database=Northwind;"
providerName="System.Data.SqlClient" />
</connectionStrings>

Hope this will help you out.

Jitesh
programmer
[url=http://www.intelcs.com/].Net Consulting[/url]

[url=http://www.intelcs.com/].Net Consulting[/url]

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources