|
Is it possible to rename the sa account or otherwise disable it?
It'd be nice to get rid of it like you can 'Administrator' in Wiidows ...
Wed, 27 Oct 2004 02:07:26 GMT
|
SQL Express setup -- what's my username - from a Newbie
This may be a simple question, but without an answer, i'm stuck at
first base.
i've installed sql express and am trying to set it up... apparently
(see: http://www.aspfree.com/c/a/MS-SQL-Server/Configuring-SQL-Server-Express-2005/
> EXEC sp_grantlogin '[machineName]\[userName]'
> GO
)
i need a [usern ...
26 Oct 2004 11:26:25 -0700
|
Remote access
Hello,
I am running SQL 2000 on a Win2k server and would like to know if there is
an easy way to give access to our SQL app. to an outside user over the
internet.
Thank you.
Eric.
...
Tue, 26 Oct 2004 14:15:16 -0400
|
Remote access
Hello,
I am running SQL 2000 on a Win2k server and would like to know if there is
an easy way to give access to our SQL app. to an outside user over the
internet.
Thank you.
Eric.
...
Tue, 26 Oct 2004 14:14:53 -0400
|
analysis services setup
Hello,
No sure if this is the correct group to post this.
I got a request to install sql server 2k standard ed
together with the analysis services on a WIN2003 standard
server.
Do you have any docs on how to properly install and
configure the analysis services?
Thanks
...
Tue, 26 Oct 2004 10:38:58 -0700
|
7.0 And Small Business 2003 (Urgent!!)
Hello All,
I am a consultant, and I have walked into a mess. The new client I have had
a company that had no idea what they were doing. They set them up with a
Small Business 2003 Standard Server. When they realized the company needed
SQL for thier accounting sft, they installed a boot leg copy of SQL 7. N ...
Tue, 26 Oct 2004 06:29:01 -0700
|
SSL won't work under Domain User account. MS Fix buletin does not help at all. Please Help!!
Hi,
I have set up an Active Directory, Certificate Services on Windows 2003
Server. I am running SQL 2000 Server. AD and Certificate Services were
installed correctly.
My goal is to be abl ...
Mon, 25 Oct 2004 15:27:04 -0700
|
Transaction log restore problem
I backup a database nightly using:
BACKUP DATABASE myDatabase TO DISK='backupyyyy-mm-dd.bak'
I backup the transaction logs hourly using:
BACKUP LOG myDatabase TO DISK='translog-hh.trn'
I try to use the following restore statement:
RESTORE DATABASE myDatabase FROM DISK='backup2004-10-25.bak' WITH NORECOVERY ...
Mon, 25 Oct 2004 10:51:03 -0700
|
Set up a linked server
Hi,
My company has one Development Server (TXDEV) and one Production Server
(TXLIVE) and both are using Windows Authentication
I am trying to add a linked server under Enterprise Manager.
All I did was key in TXLIVE under linked server and I chose SQL Server under
Server Type, then I went to the Securi ...
Mon, 25 Oct 2004 08:27:06 -0700
|
Memory config - SQL Enterprise running on Windows 2003 Standard Se
I have a new server that came with 6GB of memory. The OS is Windows 2003
Standard which only supports 4GB of memory. Currently, I have SQL 2000
Standard installed which only supports 2GB of memory. If I upgrade to SQL
2000 Enterprise, will I be able to configure SQL to use 5GB of memory leaving
1 GB of memo ...
Mon, 25 Oct 2004 06:49:10 -0700
|
Sql Server service packs
Hi
Got a problem with a SQL 2000 Server (standard) that is currently on version
8.00.194
I am try to apply the service packs, both sp2 and sp3 and when I run either
of them they come back and tell me 'MSSQLSERVER has a newer version of
Service Pack installed'
Can't find anything on the knowledgebase
...
Mon, 25 Oct 2004 03:01:02 -0700
|
SSL forced encription will not work under a Domain User account
Hi,
I have set up an Active Directory, Certificate Services on Windows 2003
Server. I am running SQL 2000 Server. AD and Certificate Services were
installed correctly.
My goal is to be able to use SSL when connecting to SQL Server via Query
Analyzer. I also want to keep the SQL Server installation under a ...
Fri, 22 Oct 2004 14:52:25 -0700
|
Paging Storm Caused by Sql Server 2000???
I have inherited a Sql Server 2000 Dell PC. The pc has 2gig of ram. When the
paging storm (PS) started happening I reconfiged Sql Server to max at 1.8
Gig, 200meg below the previous limit, thinking the PS would go away. After
all, Sql Server was almost idle. It did not help. Sql Server seems happy
enoug ...
Fri, 22 Oct 2004 11:39:04 -0700
|
MSDE install fails without rollback!!!!
I have a MSDE installation that fails in a new place for me. The log
file ends as follows below, with the installer frozen at the same
place in the progress bar every time. The installer simply freezes,
there is no rollback nor error messages. I have let it run all day
just to be sure. I have tried upgradin ...
22 Oct 2004 09:28:37 -0700
|
Sorry for the Multiple Posts Regarding Service Manager
Sorry for posting the same question/problem concerning Service Manager
repeatedly, but I kept getting posting errors and thought that my question
was not going through.
Ron Sochanski ...
Thu, 21 Oct 2004 10:53:02 -0700
|