SQL - Slow with IP, Fast with LOCALHOST
We have developed an application that use .NET 2.0 and in the same
server are installed the SQL server.
The problem is that when i use "LOCALHOST" on the application
everething works fine, but when i chage it to the IP number the
application works VERY SLOOOW.
Why? It must work both way...
Please help me
.
Relevant Pages
- RE: Starter kit will not install no localhost connection
... there should be no any SQL Server Service running on your machine. ... telnet localhost 1433 ... In the command prompt, ... osql -S localhost -E (If this works, you installation will be OK) ... (microsoft.public.sqlserver.setup) - SQL.NET connection error in Active Directory
... SQL Server does not exist or ... enabled identity impersonation to true... ... up getting that SQL connection error unless... ... Obviously I can't log onto localhost every minute as it will time ... (microsoft.public.dotnet.framework.aspnet) - SQL.NET connection error in Active Directory
... SQL Server does not exist or ... enabled identity impersonation to true... ... up getting that SQL connection error unless... ... Obviously I can't log onto localhost every minute as it will time ... (microsoft.public.dotnet.framework.aspnet) - Re: Using SQL on Development Machine
... Note that (localhost) worked on my other computer and I see localhost used in several examples. ... If I right-click on the database in the Server Explorer and select the Modify Connection command, I see 'Use Windows Authentication' is selected, for which I obviously have correct authentication. ... SQL Server 2005 Services ... TCP/IP = Disabled ... (microsoft.public.dotnet.framework.adonet) - Re: Error: SQL Server does not exist or access denied
... > I'm accessing the server using LOCALHOST as suggested by ASPFAQ. ... If you are running SQL Server or MSDE on the same machine as your ASP pages, ... Did you try 127.0.0.1, the local network name,, ., the local IP ... (microsoft.public.inetserver.asp.db) |
|