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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-11-15 : 07:58:14
|
| Remco writes "We have developed an application in .NET, which can run on an SQL server. Since my job is to demonstrate the application, I have installed SQL Server locally. I direct the application to localhost (127.0.0.1) to connect to the database. When I am 'plugged' into our network, everything runs just fine. However, when I am on the road and not connected to a network, I get the following error message "SQL server does not exist or access denied', though the local server IS running and databases can be viewed by means of e.g. the Enterprise Manager. We have looked at the Server Network Utility, to see which protocols are enabled (in this case Named Pipes and TCP/IP).I am running:Windows XP Home Edition (5.1.2600 Service Pack 2 Build 2600)Processor: x86 Family 15 Model 2 Stepping 7 GenuineIntel ~2399 MhzPhysical memory: 512,00 MBMS SQL Server 8.00.194SQL DMO 8.00.02ODBC 03.52.0000Please help us out.Thnx in advance!" |
|
|
elwoos
Master Smack Fu Yak Hacker
2052 Posts |
Posted - 2004-11-15 : 10:49:52
|
| I didn't think you could run SQL Server on XP Home!Have you tried using the instance name rather than localhost. I think that may fix your problem. I have SQL Server running on a laptop and that's how it works for mesteveTo alcohol ! The cause of - and solution to - all of life's problems |
 |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2004-11-16 : 00:28:59
|
| how did you install the server?are you using the same login when you're "plugged" and "unplugged"?if yes, check the account that runs the sql services, change it to local system account instead.--------------------keeping it simple... |
|
|
|
saglamtimur
Yak Posting Veteran
91 Posts |
Posted - 2004-11-16 : 00:37:02
|
| in connection string use (local) as servername like server=(local);uid=someuser;pwd=123456;database=dbname. |
|
|
|
RemcoV
Starting Member
1 Post |
Posted - 2004-11-17 : 05:39:59
|
Thnx guys. The solution was with the (local) as servername! Thumbs up |
|
|
|
elwoos
Master Smack Fu Yak Hacker
2052 Posts |
Posted - 2004-11-17 : 08:16:39
|
| Does anyone know why sometimes Localhost works and sometimes it needs to be local?steveTo alcohol ! The cause of - and solution to - all of life's problems |
|
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2004-11-17 : 21:37:23
|
quote:
Originally posted by elwoos
Does anyone know why sometimes Localhost works and sometimes it needs to be local?steveTo alcohol ! The cause of - and solution to - all of life's problems
i believe it's standard that if you're part of a domain (lan), then you need to specify the instance especially if you need to access other resources, otherwise local will be enough.--------------------keeping it simple... |
|
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2004-11-17 : 21:49:12
|
| It's safe to say that (local) will always work unless SQL Server is not running. Also, (local) helps distinguish between a SQL Server and web server "localhost" running on the same machine. |
|
|
|
|
|
|
|
|
Local running SQL Server unreachable when 'unplugged' network cable