SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-29-2008, 02:38 AM
| ||||
| ||||
 SQL Web Services I Need help with accessing an SQL server from a web method. Trying to connect from localhost to ms sql server 2000 sp1 and get the error: 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.Get PooledConnection(SqlConnectionString options, Boolean& isInTransaction) at System.Data.SqlClient.SqlConnection.Open() at WebService2.Service1.GetPass(String name) in c:\inetpub\wwwroot\webservice2\service1.asmx.cs:li ne 65 Using windows authentication. CONFUSED!!!! Help pls!      |
|
02-29-2008, 02:38 AM
| ||||
| ||||
| Re: SQL Web Services "sqlnerd" <mattscott45@hotmail.com> wrote in message news:4f39fde3.0404280512.64440a89@posting.google.c om... > I Need help with accessing an SQL server from a web method. > > Trying to connect from localhost to ms sql server 2000 sp1 and get the > error: > 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.Get PooledConnection(SqlConnec tionString > options, Boolean& isInTransaction) > at System.Data.SqlClient.SqlConnection.Open() > at WebService2.Service1.GetPass(String name) in > c:\inetpub\wwwroot\webservice2\service1.asmx.cs:li ne 65 > > Using windows authentication. > CONFUSED!!!! > Help pls! It's not clear from your post if the web service and MSSQL are on the same server or not, but you can check the MSSQL error log to see if there is a failed login from your web service account (assuming you have enabled this logging). If so, then the problem is probably that the web service account has not been granted login rights in MSSQL, or perhaps that the password is incorrect. If there is no failed login attempt in the log, then you should look at name resolution, and if the web service is connecting with the correct protocol and/or to the correct port. You can use osql.exe to check basic connectivity. Simon |
 |
« Can I carry my existing DB users to a new server and restore???
|
User ID limit per database, Msg 15065 »
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
All times are GMT. The time now is 07:55 PM.
