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 |
|
bobbabuoy
Starting Member
33 Posts |
 Posted - 2004-07-16 : 10:38:59
|
| I have a sql server db that works fine when I connect via the internet and from the network, but when I try to connect after disconnecting from the network it doesn't find the database (even though the sql server db is on the machine I am using after disconnecting, of course).Is there something wrong with my connection string? Could it be the Windows/SQL Server/Mixed Authentication mode?Maybe the best question I could ask is, if I want to run sql server as a web back-end, as a network utility, and as a local db for a windows app, how should I have it set up from a security/authentication standpoint?Thanks! |
|
|
rdugre
Starting Member
32 Posts |
Posted - 2004-07-16 : 10:58:42
|
| It is probably an issue with the connection string. You may be using a server name that must be DNS resolved and you cannot get to your DNS server, so it cannot find the SQL Server. Try using "(local)" (without quotes) as the server name within your connection string.If you still have issues, please post the connection string (without the real User ID and Password) so we can check it out. Also, let us know the technology you are accessing the server with (ASP, ASP.NET, etc.) |
 |
|
|
bobbabuoy
Starting Member
33 Posts |
Posted - 2004-07-16 : 12:03:01
|
| I just realized something! I am not using the same database-just a replicated version of it-when I try to connect remotely. I CAN connect to the original db in stand-alone mode (if I disconnect the machine that houses it from the network). I am running into trouble when I try to connect to the replicated version on the other machine, even though I change the Data Source to the new db name or to (local). So it seems to me that my problem is with how the replicated db (or the sql srvr that houses it) is set up. WOuld you agree?I am still puzzled as to just how I should have it set up in terms of security and authentication in this kind of an environment (asp/ado as well as vb/ado). Any help on this would be much appreciated!Thanks! |
|
|
|
|
|
|
|
|
Stand Alone Connection Issue