Viewing 15 posts - 39,046 through 39,060 (of 39,510 total)
November 8, 2001 at 9:52 am
Can you connect via sql auth?
What versions of server/clients are you using?
In v6.5, you had to connect via named pipes for nt auth.
Check that your clients are all setup the...
November 8, 2001 at 9:51 am
DTS is the easiest. You could probably make BCP work, but not worth it.
You can "save as" from Query Analyzer in csv, but then would need to open in dbase...
November 8, 2001 at 9:50 am
sorry for the typo: map the port.
Let me get this straight: You have 3 SQL Servers, correct? You want to be able to administer them all remotely (externally through the...
November 8, 2001 at 9:48 am
Glad it worked, Jon.
One thing that I do: write out your sql using response.write. Then cut and paste into Query Analyzer to check for syntax errors.
Steve Jones
November 8, 2001 at 8:57 am
Thom,
you could most the port for the other servers (using Server Network Utility). Alternatively, you ought to be able to map 14331 externally and port that back to 1433 to...
November 8, 2001 at 8:55 am
yes. by default, SQL listens on port 1433, so you need to be able to get through this port.
I wouldn't "open this port" to everyone. Just your iis ip.
Steve Jones
November 8, 2001 at 8:53 am
Interesting. Never approached this limit (max about 5000 users). I think that above the 16k limit is where groups are stored.
I'll do some checking and try to get back to...
November 8, 2001 at 8:52 am
What type of workstations? For most newer systems, MS has gone to the MDAC which includes OLEDB rather than ODBC. Hoever, my v6.5 NT4 systems could connect to SQL 7...
November 8, 2001 at 8:50 am
There are always fixes in progress and hotfixes appear occassionaly, but I have found that by calling support, I sometimes get "unreleased" hot fixes. Usually these are later included in...
November 8, 2001 at 8:48 am
November 8, 2001 at 8:46 am
November 8, 2001 at 8:46 am
I like the time bomb.
Be sure you disclose some of this in your contract so your client is aware he cannot stop you from accessing the site. Just let him...
November 8, 2001 at 8:45 am
November 8, 2001 at 8:43 am
November 7, 2001 at 3:06 pm
Viewing 15 posts - 39,046 through 39,060 (of 39,510 total)