Viewing 15 posts - 2,116 through 2,130 (of 6,105 total)
Have you gone into SQL Server Configuration Manager (Start | All Programs | Microsoft SQL Server 2005 | Configuration Tools | SLQ Server Configuration Manager) and enabled the protocols you...
May 30, 2006 at 3:26 pm
Also, if that is the real server name, user, and password, please change your password immediately. Keep in mind you just posted it to a public forum which gets indexed...
May 30, 2006 at 3:23 pm
Removing BUILTIN\Administrators from the system administration role will take away "sa rights" but will still allow members of the local Administrators group to connect to SQL Server. Steve's suggestion, to...
May 30, 2006 at 3:21 pm
Are you able to see any of the databases other than master (such as tempdb)? Also, are you able to log on to SQL Server as said user with another...
May 30, 2006 at 3:16 pm
It's passed by the client and as a result is not guaranteed to be reliable. It's fairly easy to spoof:
May 30, 2006 at 3:12 pm
It is possible to run both SQL Server 7.0 and 2000 on the same machine. It is also possible to run SQL Server 2000 and 2005 on the same machine....
May 29, 2006 at 2:26 pm
ALTER LOGIN is for SQL Server 2005... Enterprise Manager is used to manage SQL Server 2000 (and 7.0, since it supported those). SQL Server 2000 uses sp_password, and that requires...
May 26, 2006 at 7:27 am
and the wan link is down, there are procedures in place that a designated person at the facility can be guided through by a DBA
Nope, you got it. That's what...
May 25, 2006 at 9:37 am
Before going to uninstall route, which will take several hours, have you tried contacting Microsoft Support? If it's a genuine bug, you most likely won't be charged. If it isn't...
May 25, 2006 at 8:49 am
Actually it's relevant from an information disclosure issue. EM is an easy tool to see all the databases and users that exist on a SQL Server. So even though you...
May 25, 2006 at 8:47 am
How are you handling network outages?
May 25, 2006 at 8:41 am
Performance also depends on what type of virtual technology you are using. For instance, VMware ESX server has tweaks not available in GSX or in Microsoft's Virtual Server. However, as...
May 24, 2006 at 9:08 am
Strictly speaking, it is not necessary for DBAs to be administrators of the systems themselves. It tends to make the job easier for everyone around, and so some organizations consider...
May 22, 2006 at 9:50 pm
There are several issues with encryption at the database level:
1) If I get access to the views, I can see the unencypted data anyway.
2) if I am a sysadmin and...
May 22, 2006 at 9:44 pm
Are you able to log on as the service account and send email normally (though Outlook, not SQL Server)? If so, are you able to do so through Outlook on...
May 22, 2006 at 9:37 pm
Viewing 15 posts - 2,116 through 2,130 (of 6,105 total)