Viewing 15 posts - 1,411 through 1,425 (of 1,425 total)
From my understanding, Kerberos is tried first, then if it fails, fallback is to NTLM.
You need to set up SPN's to register the services, which are slightly different on SQL...
July 27, 2007 at 11:32 am
For x64 bit machines, you can install a 32 bit version. I don't think they have done any 64 bit versions yet.This was on our disk for x64 bit.
July 12, 2007 at 6:45 am
Windows Update identifies only Windows Patches. If they use Microsoft Update, you should see other patches i.e. Office, SQL Server (or Express), etc.
You might want to check this out.
July 12, 2007 at 6:36 am
The stored pocedure gives all the info you may need. I assume you would be interested that SQL Server is 64 bit if running on x64 bit platform. Someone could...
June 13, 2007 at 7:29 am
I don't know how many records are involved, but NOT EXISTS might offer some advantages.
FROM V_RPT_TRANS2 WHERE INTNL_PF_NUM NOT IN (SELECT INTNL_PF_NUM FROM V_RPT_TRANS1)
Gail is right - looking at the...
June 13, 2007 at 7:06 am
Try saving to MSDB letting it use server security. Default (I think) package is saved with sensitive information encrypted with user key.
How you are scheduling / launching the package...
May 15, 2007 at 1:43 pm
Just create a data source on your machine to the SQL Express instance, then go to File, Get External Data, Link Tables. You should be able to use this...
December 18, 2006 at 6:51 am
Try going into Configuration Tools (under the Start menu, Microsoft SQL Server 2005), and using the Reporting Services Configuration.
These tools should be granting the needed permissions as you make account...
December 18, 2006 at 6:42 am
I assume you have an ID which has admin privileges.
In SQL Server Management Studio, go to Security, then Logins.
Double click on the sa account to bring up the properties sheet.
November 6, 2006 at 6:52 am
I like x64 bit. No switches needed. Don't know if your server is capable, but might be an option.
November 1, 2006 at 7:46 am
Verify if the firewall is on or off. Then test with it off.
There's also a log file for this, which may be helpful.
How you are connecting?
October 10, 2006 at 7:19 am
Scroll down this page and see if this is what you're looking for.
Microsoft OLEDB Provider for DB2
September 20, 2006 at 7:59 am
If you use the temporary table to delete existing, then do an insert, you should be able to avoid row by row logic.
If something is deleted out of the Excel...
August 30, 2006 at 7:10 am
I'm not much of a programmer, but I'd make sure you are closing your connections. I assume you're runnning SQL on the machine you're rebooting.
I few more details - like...
August 18, 2006 at 8:45 am
Try creating a linked server.
If the data is important enough to be used in SQL server, I'd consider getting it moved into SQL for the back end. You could...
March 1, 2006 at 7:27 am