Viewing 15 posts - 2,641 through 2,655 (of 6,105 total)
First, scrub your post to erase the password. Second, verify the sa account password is what you think it is. With that done, if they're all in the same workgroup...
December 9, 2005 at 10:54 am
Clustering is a feature of the operating system which allows you to use redundant hardware (more than one server) to provide services. SQL Server's supports failover clustering. What that means...
December 9, 2005 at 10:52 am
Check out Chris Kempster's e-books on backup, recovery, and troubleshooting. They are offered free by Quest Software. You can find more information at Chris' site:
December 9, 2005 at 10:44 am
Since the machines are in a workgroup, there is no trust between any of the machines. Therefore, Windows accounts cannot be verified. Ensure that the username/password combination you're logging in...
December 9, 2005 at 10:40 am
Echoing earlier comments... without modifying sp_password in SQL Server 2000 and earlier, no (which brings the SQL Server into an unsupported configuration). SQL Server 2005 can if it's running on...
December 9, 2005 at 10:37 am
In development, is the SSRS installed on the same server as SQL Server? What about production?
December 9, 2005 at 3:38 am
Stability depended a lot on apps and hardware (specifically the drivers). Yes, 98 and ME let vendors get away with things they shouldn't have. Hence a lot of the stability...
December 8, 2005 at 3:03 pm
System administrators manage the server the SQL Server runs on and, in smaller organizations, the workstations which the apps run on that connect to the database servers. DBAs manage the...
December 8, 2005 at 2:05 pm
No. Consider them separate input statements. For instance, if driverid 5 drives cars with carid 7 and 11, you've got two rows in your join table.
INSERT INTO DriverCar (DriverID, CarID) VALUES (5, 7)
INSERT...
December 8, 2005 at 6:10 am
Create Table can be granted without the use of db_ddladmin. The db_ddladmin can modify any object in a database and set a different owner (to include dbo). So if you...
December 7, 2005 at 9:48 pm
Please do not cross post. See my reply in Administration at http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=5&messageid=242628.
December 7, 2005 at 7:24 pm
Unless I'm mistaken, this information isn't stored in the collaboration database. I'm not a Sharepoint or Sharepoint Services expert, so take what I'm about to say with a grain of...
December 7, 2005 at 7:22 pm
Insert the drivers that make sense. Then insert the cars that make sense. Do a query against both tables and find out what the values are for the driverid and...
December 7, 2005 at 7:15 pm
When you do a net user <username> /domain from the command prompt the user shows up in both groups? Are you talking domain accounts/groups or local ones?
December 7, 2005 at 7:12 pm
Do you have the ability to run a SQL trace? Turn on logon success auditing before making the change? You may not be able to get everyone, but you should...
December 7, 2005 at 8:56 am
Viewing 15 posts - 2,641 through 2,655 (of 6,105 total)