| Author |
Topic |
|
drh3010
Starting Member
18 Posts |
 Posted - 2008-01-05 : 18:02:04
|
| The SQL Server Express connection string wants a DOMAIN\INSTANCENAME, if I use "LSC-HOMEROOM-FOO" as the domain I cannot connect. However, if I change the domain to "BOB", I can connect. Is it the dashes that cause the problem? If so, how I do I fix it? |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-01-05 : 21:29:52
|
| Are you talking about instance name or login id? Instance name should be host\instancename. |
 |
|
|
drh3010
Starting Member
18 Posts |
Posted - 2008-01-06 : 09:39:20
|
quote:
Originally posted by rmiao
Are you talking about instance name or login id? Instance name should be host\instancename.
Instance name. ABC-COMPUTER-SW1\MYINSTANCE causes a connection string error (-1) while BOB\MYINSTANCE doesn't. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-01-06 : 15:00:23
|
| Did you get correct instance name? Don't need instance name in the string for default instance, just host name. By the way, we use ABC-COMPUTER-SW1\MYINSTANCE format in asp connection string and works fine. |
|
|
|
drh3010
Starting Member
18 Posts |
Posted - 2008-01-07 : 16:56:42
|
| *scratching my head*Doing Windows Updates fixes the problem. Our IT department shuts off automatic updates for whatever reason. But after updating the remote computer I can connect to it. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-01-07 : 21:57:58
|
| Sounds mdac version mismatch then. |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2008-01-08 : 02:20:23
|
Use brackets?[ABC-COMPUTER-SW1]\MYINSTANCE
E 12°55'05.25"N 56°04'39.16" |
|
|
|
drh3010
Starting Member
18 Posts |
Posted - 2008-01-08 : 03:35:01
|
| Thanks, I will try the brackets... not really sure why that's necessary, but I have nothing to lose. |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2008-01-08 : 03:41:07
|
| or try[ABC-COMPUTER-SW1\MYINSTANCE]MadhivananFailing to plan is Planning to fail |
|
|
|
drh3010
Starting Member
18 Posts |
Posted - 2008-01-08 : 13:49:55
|
| Ok, our Windows 2000 machine is getting this error...[url]http://support.microsoft.com/kb/555332[/url]I have verified that SQL Server is in Mixed Mode (2).The ODBC error is 14 state: 1 |
|
|
|
|
Connection String Problem