Wierd connection problem
- From: Stephan Rose <ker-spam-mos@xxxxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Mon, 09 Jan 2006 13:45:35 +0100
Having an issue connecting to one of my SQL Servers that I just cannot
explain.
I have two applications running on the same server that SQL is running
on. One is a C# Service that runs as my server software and currently
uses a remote SQL Database with no problems. The other is a new
ASP.Net webpage I am adding for configuration purposes and viewing log
data, etc. To reduce lag and traffic I wanted to make both the ASP.Net
site and my Service start using the local SQL database, and stop using
my remote SQL Database that is running somewhere else.
Here is the problem however...
Using the identical connection string, my ASP.Net page can connect to
the local database, no problem. My service however will not connect to
the local database. Keep getting SQL Server not found or invalid login
errors. I just cannot explain this as all are running from the same
computer and use the exact same connection string.
The only difference I can see is that the service runs with the .Net
1.1 framework, and the ASP.Net page runs with the 2.0 framework.
Anyone have any ideas?
Thanks,
--
Stephan
2001 Yamaha YZF-R6 <--- Stolen
.
- Prev by Date: Sql Agent Service will not start
- Next by Date: FoxPro Linked Server not working in 2005
- Previous by thread: Sql Agent Service will not start
- Next by thread: FoxPro Linked Server not working in 2005
- Index(es):
Relevant Pages
|
