I need to put SQL server 2005 on our 2003 IIS server. The server is
accessible to the public. My question is, what do I need to do to
secure the sql server? The windows 2003 server has SP2 and is fully
patched, and I intend to install all the latest patches for the SQL as
well.
Is there a good tutorial/how-to article. I don't want to "just
install" the sql then put it in production, unless that is ok...
RE: SBS 2003 SP1 Upgrade - MSDE 2000 Service Pack 4 did not instal ... The DSRestore Filter failed to connect to local SAM server.... registry keys of the Microsoft SQL server and mail to me for analyze. ... This newsgroup only focuses on SBS technical issues. ... SBS 2003 SP1 Upgrade - MSDE 2000 Service Pack 4 did not install... (microsoft.public.windows.server.sbs)
RE: How do I get back to base SQL server on my SBS 2003 server? ... Can I reinstall the files from another SBS2003 server I manage? ... On my install of SLQ2005, I told it to upgrade all instances. ...Installing SQL Server 2005 WorkGroup Edition in Windows Small Business ... <The server-based applications that were running fine are: McAFee EPO,... (microsoft.public.windows.server.sbs)
Re: Installed VS 2005 want to Manage SQL 2005 Server ... I Guess I didn't copy it to the Install Source on the Server.... To change an existing instance of Microsoft SQL Server 2005 to a different edition of SQL Server 2005, you must run SQL Server 2005 Setup from the command prompt and include the SKUUPGRADE=1 parameter. ... The Following Components that you chose to install are already installed onthe machine. ... (microsoft.public.sqlserver.setup)
Re: Clearer version of my earlier question re sp_grantlogin and sp_grantdbaccess ... > Server, doesn't have the right to grant DB access to Domain Groups. ... I didn't know that an SQL Server login as ... > I did the install about a month ago as Domain Admin (default install - mixed ... > site where they let me login as Domain Admin.... (microsoft.public.sqlserver.msde)
Re: 4 patches wont install - 835732, 840987, 828035, 824105 ... running Win 2003 Standard, joined to domain but not a DC, ... Did find on another post though that if you install kb840315 and kb841533 ... our two servers were upgraded from Windows 2000 Server ... I've been able to install all patches but 4: ... (microsoft.public.windows.server.general)
