Viewing 15 posts - 976 through 990 (of 6,105 total)
Alvin Ramard (8/1/2008)
If you have separate tables for each product, what happens if they add a product? Someone needs to add at least one...
August 1, 2008 at 4:31 pm
I believe Access has the ability to cache the password. However, this would mean anyone with the ability to start up the Access front end would be able to execute...
August 1, 2008 at 3:33 pm
What are you using to schedule and run the SSIS packages? Are they being run manually?
August 1, 2008 at 3:31 pm
For Windows 2000 and 2003, yes.
August 1, 2008 at 2:55 pm
To piggy-back on what Gail has said, you can use any login which is a member of the sysadmin fixed server role (such as SA, but also your Windows account...
August 1, 2008 at 1:54 pm
On Windows 2000/2003, SQL Server 2000 and 2005 installs will add the BUILTIN\Administrators group to SQL Server as a sysadmin during the SQL Server installation. You do not have to...
August 1, 2008 at 1:52 pm
Any errors in the application or system event log upon failover?
August 1, 2008 at 10:54 am
That may indicate a networking issue if the only systems affected during a failover (which kicks to a different physical port) are the DMZ servers. Not likely, but maybe worth...
August 1, 2008 at 9:27 am
Logins in general can be associated with certificates. When you check the compatibility mode of the database itself, what does it say? Does it say 80 or 90?
July 31, 2008 at 9:42 pm
When you fail-over the node, can you connect as that user from a system not in the DMZ?
July 31, 2008 at 9:38 pm
Are you making the K:\ and L:\ drives a dependency for the S:\ drive or for the SQL Server resource? Your description sounds like the former.
July 31, 2008 at 9:35 pm
I'm sure Steve is going to chime in soon, but I have the advantage of being on the east coast of the US while he's in Denver. 😉
Gail (Gila Monster)...
July 30, 2008 at 8:01 am
It also means dealing with the fact that you'll have to do the manual configuration for every connection string... Depending on how tightly these things are controlled and whether or...
July 28, 2008 at 2:18 pm
You mean 1433, right?
1434, using the UDP protocol, is used to locate the port, named pipe, etc. for a named instance. The port a default instance of SQL Server listens...
July 28, 2008 at 12:55 pm
Yelena Varshal (7/25/2008)
The app uses sp_executesql, this is from the profiler that I just ran for the PW change. The password I submitted to the app was completely different.
execute sp_executesql...
July 25, 2008 at 11:32 am
Viewing 15 posts - 976 through 990 (of 6,105 total)