sql server does not exist - urgent

Tech-Archive recommends: Speed Up your PC by fixing your registry

I have a sql server in the local network.I am able to connect to this
server through my .net windows application using both dsnless and dsn
connection.But using the same code in my web application it is not
connecting to this server.In this case while using dsn-less connection,
error message is
"SQL server does not exist or access denied"

and for dsn connection error message is
"ERROR [08001] [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server
does not exist or access denied. ERROR [01000] [Microsoft][ODBC SQL
Server Driver][DBNETLIB]ConnectionOpen (Connect()). ERROR [01S00]
[Microsoft][ODBC SQL Server Driver]Invalid connection string attribute
"

I can connect to the same server from EM and query analyzer.Is there
anythig to do with security rights?

Please help.


Thanks in advance,
Jaiganesh

.

Relevant Pages

  • Re: Classic ASP connectionstring to SQL Server 2005
    ... So this connection string is in the VB6 dll? ... What is the error message? ... Provider cannot be found. ... can you ping the sql server? ...
    (microsoft.public.inetserver.asp.db)
  • Re: Problem upgrading Microsoft Office Accounting Professional from 2008 to 2009 using SQL Express 2
    ... I tried adding the TCP but then I get a error message "Microsoft Office Accounting cannot open the company because of a connection error." ... I assume that's why trying to force a TCP connection doesn't work. ... Rick Byham, SQL Server Books Online ... Since the problem appears to involve some sort of interaction between Microsoft Office Accounting Professionaland SQL Express 2008 hopefully someone in this forum will understand the error message I'm receiving and can suggest some possible solutions for me to try. ...
    (microsoft.public.sqlserver.connect)
  • Re: Cant connect to SQL Server 2008
    ... The error occurs on opening a connection. ... I can connect to SQL Server 2008 using sqlcmd from the same machine which ... VS solution cannot connect to the SQL Server. ... Error Message: ...
    (microsoft.public.sqlserver.connect)
  • Re: connecting to sql server from asp page
    ... In your DSN, if you include the login and password, then you are specifying ... Connectivity client application are always ignored by SQL Server ... You have two choices - either supply the uid and pwd in the connection open ... to used both Windows and Sql Server authentication. ...
    (microsoft.public.sqlserver.connect)
  • Re: Trusted connection to SQL Server 2000
    ... As the error message says, the user ASPNET could not logon. ... I do not have either SQL Server or the ... > Roslyn L. ... >> If you can use a trusted connection to connect to SQL Server ...
    (microsoft.public.sqlserver.security)